Pablo
|
| Posted: 01/07/2003, 7:22 AM |
|
I have this in mysql+php bookstore sample in AdminEditorials.php:
"Database error: Invalid SQL: SELECT COUNT(*) FROM bs_editorial_categories INNER JOIN bs_editorials LEFT JOIN bs_items ON bs_editorials.item_id = bs_items.item_id ON bs_editorial_categories.editorial_cat_id = bs_editorials.editorial_cat_id
MySQL Error: 1064 (You have an error in your SQL syntax near 'LEFT JOIN bs_items ON bs_editorials.item_id = bs_items.item_id ON bs_editorial_c' at line 1)"
The rest of sample works OK. It was not modified at all - just install.
Does anyboby knows what is going on?
Thanks in advance
Pablo
|
|
|
 |
RonB
|
| Posted: 01/07/2003, 8:11 AM |
|
Check the table names in the database. I beleive there were som problems with changed table names not reflected in the CCS queries.
Ron
|
|
|
|
|
