CRE Loaded Community



Board index » CRE Loaded PCI 6.4 » CRE Loaded PCI 6.4 Support

All times are UTC - 5 hours




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: B2B 6.4.1: Critical Store Error...
PostPosted: Sat Mar 13, 2010 9:02 am 
Offline
CRE Newbie

Joined: Sat Sep 26, 2009 6:11 am
Posts: 13
Query Error reported on page /cvgshop-B2B/catalog/checkout_success.php
MySQL error: 1146 - Table 'cvgshop_B2B.TABLE_LIBRARY_PRODUCTS' doesn't exist
SELECT lp.library_id from TABLE_LIBRARY_PRODUCTS lp WHERE lp.products_id = '110'

It seems this table wasn't created in the database on install. I can create the table, but I need the parameters. If someone with B2B can give me the parameters for this table, I'd appreciate it. Thanks!


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Sat Mar 13, 2010 11:33 am 
Offline
CRE Addict

Joined: Sun Nov 29, 2009 10:57 am
Posts: 271
Looks more like the TABLE_LIBRARY_PRODUCTS is not defined rather than not installed..

What version of B2B are you using?

_________________
Italian Food - http://mdjl-demo.co.uk/mediterraneandirect
Demo Store - http://mdjl-demo.co.uk/demo


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Sat Mar 13, 2010 1:13 pm 
Offline
CRE Newbie

Joined: Sat Sep 26, 2009 6:11 am
Posts: 13
TheLango wrote:
Looks more like the TABLE_LIBRARY_PRODUCTS is not defined rather than not installed..

What version of B2B are you using?

Hi, TheLango. Version is 6.4.1a, as in my subject line. library_products is not in the table listing.


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Sat Mar 13, 2010 2:40 pm 
Offline
CRE Addict

Joined: Sun Nov 29, 2009 10:57 am
Posts: 271
lcorsa1 wrote:
Hi, TheLango. Version is 6.4.1a, as in my subject line. library_products is not in the table listing.


:oops: of course..

I may be wrong, but it seems you have appended all your DB tables with cvgshop_.

LIBRARY_PRODUCTS is part of the FDM system and these table are auto generated when you action the File Download System as part of runtime.

I'm assuming the error is caused as the runtime cannot add your cvgshop_ to the front end of the table.

You should have the tables in your includes\modules\addons\fdm.php file.

Just browse through this and check all the other tables have been created..

_________________
Italian Food - http://mdjl-demo.co.uk/mediterraneandirect
Demo Store - http://mdjl-demo.co.uk/demo


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Sat Mar 13, 2010 2:44 pm 
Offline
CRE Newbie

Joined: Sat Sep 26, 2009 6:11 am
Posts: 13
TheLango wrote:
lcorsa1 wrote:
Hi, TheLango. Version is 6.4.1a, as in my subject line. library_products is not in the table listing.


:oops: of course..

I may be wrong, but it seems you have appended all your DB tables with cvgshop_.

LIBRARY_PRODUCTS is part of the FDM system and these table are auto generated when you action the File Download System as part of runtime.

I'm assuming the error is caused as the runtime cannot add your cvgshop_ to the front end of the table.

You should have the tables in your includes\modules\addons\fdm.php file.

Just browse through this and check all the other tables have been created..

Hi, The Lango,
My hosting provider is set up to prefix any database I create with cvgshop, so I have no choice in the matter, other than renaming afterwards, I suppose. I never found a need to do that, perhaps until now. Thanks, and I will check the fdm.php file!


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Sat Mar 13, 2010 5:56 pm 
Offline
CRE Newbie

Joined: Sat Sep 26, 2009 6:11 am
Posts: 13
TheLongo, none of the tables listed in the fdm.php file exist in my database. I tried renaming the database without the cvgshop_, but I'm not allowed to do it. Any suggestions as to what to do? I can create the tables (the structure is given in the fdm.php file), but it seems to me the database will still not be found, so creating the tables alone may not work. What would you suggest as a course of action, given that I can't rename the database?


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Sat Mar 13, 2010 8:11 pm 
Offline
CRE Loaded Staff

Joined: Thu Jul 13, 2006 12:00 am
Posts: 612
goto admin>modules>add ons> fdms and click install

it will create the tables automatically

_________________
Regards,

------------------------------------------------------------------------
Kirk Osburne
Forums Administrator
Senior CRE Support Tech/Change Control Manager
CreLoaded.com | CreSecure.com | CreCommerce.com
------------------------------------------------------------------------


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Sat Mar 13, 2010 8:38 pm 
Offline
CRE Newbie

Joined: Sat Sep 26, 2009 6:11 am
Posts: 13
Kirk wrote:
goto admin>modules>add ons> fdms and click install

it will create the tables automatically

Very cool! That was easy enough - tables are now there!


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Fri Apr 16, 2010 12:55 pm 
Offline
CRE Newbie

Joined: Fri Apr 16, 2010 12:17 pm
Posts: 6
lcorsa1 wrote:
Kirk wrote:
goto admin>modules>add ons> fdms and click install

it will create the tables automatically

Very cool! That was easy enough - tables are now there!


On my admin under modules add ons there is no fdms...how could i solve this issue


Top
 Profile  
 
 Post subject: Re: B2B 6.4.1: Critical Store Error...
PostPosted: Sun Apr 18, 2010 6:34 am 
Offline
CRE Addict

Joined: Sun Nov 29, 2009 10:57 am
Posts: 271
Gyali wrote:

On my admin under modules add ons there is no fdms...how could i solve this issue


Are you using the CE version? if so its not available, you will need to upgrade

_________________
Italian Food - http://mdjl-demo.co.uk/mediterraneandirect
Demo Store - http://mdjl-demo.co.uk/demo


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

Board index » CRE Loaded PCI 6.4 » CRE Loaded PCI 6.4 Support

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
It is currently Fri Jul 30, 2010 12:05 pm
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

Login

Top Listing

1. Credit Card with CCV
    Category: Payment Modules
    
2. CC7333_ATS
    Category: Templates
    
3. Points & Rewards PLUS!...
    Category: Add-Ons
    
4. One Page Checkout...
    Category: Fixes
    
5. Configuration Server...
    Category: Fixes
    
Show more...

Follow Us on Twitter

@likeOMGitsFEDAY we do offer a wiki and other resources at www.creloaded.org
@smellgoodslady 6.2 is old code, we are at 6.4 now. come and get the latest.
@smellgoodslady what version/release are you running?
CRE Secure in the news: Payment News Article about Hosted Payment Pages reducing PCI friction - http://is.gd/ba0CH
@smellgoodslady yes it should work for 6.2 as well. let me know of you have any issues.

CRE Loaded Community Chat hosted by CRE Loaded.

Join now


Chat about what's on your mind. More about public chats.


© CRE Loaded is a product of Chain Reaction Ecommerce, Inc. Usage & Privacy Policy