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!

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.

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!

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?

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

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