I tacked this onto an older thread but didn't receive a reply.... trying here...

I guess the first thing that I see in the errors is that p.products_id is not found, but the field exists and seems to be OK. Also, I see that the error message comes from adodb-errorhandler.inc.php ... how can I tell where the code is that actually generated the error?

---- Original post ----

Due to continuing problems getting the new version installed from scratch (mainly a mostly unresponsive ISP) and the need to get something back up and running, I am hoping someone here can help with the errors I am getting in v1.1.4d, likely due to MySQL upgrades or perhaps a corrupted file.(?) Might need to do some SQL query tweaks.

It is *almost* working but no products show in the store's user interface under categories. The products DO show in the admin interface. Here are the errors:


Go to main store (contains a categories sidebox):
NO ERRORS


Go to a category in main store's category sidebox (no products display within):
in /xyz/store.old/includes/classes/adodb/adodb-errorhandler.inc.php on line 139
PHP Fatal error: mysql error: [1054: Unknown column 'p.products_id' in 'on clause'] in EXECUTE("select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '56'")


Admin: going to Categories / Products - Top:
in /xyz/store.old/includes/classes/adodb/adodb-errorhandler.inc.php on line 139
where p.products_id = pd.products_id
from products p, products_description pd, products_to_categories p2c
p.products_quantity_order_max
p.product_is_free, p.product_is_call, p.products_quantity_mixed,
p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
p.products_status, p.products_model,
p.products_last_modified, p.products_date_available,
p.products_image, p.products_price, p.products_date_added,
PHP Fatal error: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 10' at line 13] in EXECUTE("select p.products_id, pd.products_name, p.products_quantity,
[yes, that is the end of this error message]


Admin: Going to same category as tried in Store (products display OK here):
NO ERROR


Admin: Going to product edit:
NO ERROR


Interesting how the store itself has an error when going *into* a category, but the admin interface has one when showing the categories top but not the products.


HELP appreciated, and I do have some SQL buddies that can help if we get on the right path.