Forums / Setting Up Categories, Products, Attributes / Help Product Type Books (by Moku) broken

Help Product Type Books (by Moku) broken

Locked

Views: 1,539

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
30 Mar 2007, 12:59 AM
#1
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Help Product Type Books (by Moku) broken

1146 Table 'christia_zc1.TABLE_BOOKS_TO_BOOK_AUTHORS' doesn't exist
in:
[insert into TABLE_BOOKS_TO_BOOK_AUTHORS (products_id, book_authors_id) values ('7', '3')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Here is the error message I have tried reinstalling the table so that the name is TABLE_BOOKS_TO_BOOK_AUTHORS and it doesn't work made it lower case and it does work. The table is there and it won't enter the data. What is the name of the table really suppose to be in the script it is book_authors

I can not find the coding to change this to make it work and there is no line 1146 If that is an error number what does it mean??

C

31 Mar 2007, 2:19 AM
#2
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Help Product Type Books (by Moku) broken

That all-uppercase text is a language define. The books product type includes a file which defines all the tables. At runtime, "TABLE_BOOKS_TO_BOOK_AUTHORS" becomes the name of the table, and automatically appends a table prefix, if any.

Check the download and make sure you upload all the necessary files, and in the proper places.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com