kroll Posted December 21, 2005 Posted December 21, 2005 Hi all, I'm a newbie to osCommerce and I have loaded it locally on my own PC to trial it. I am having problems displaying products that I have entered into the catalogue. I can enter new products OK however when I click on the category, I receive the following error: 1054 - Unknown column 'p.products_id' in 'on clause' 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 = '16' [TEP STOP] Also, when I select a product listed in the "new products" window, I receive the following error: 1406 - Data too long for column 'last_page_url' at row 1 update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '127.0.0.1', time_last_click = '1135143224', last_page_url = '/product_info.php?products_id=7&osCsid=75tln1u2pmebusd5nqo754ran3' where session_id = '75tln1u2pmebusd5nqo754ran3' [TEP STOP] I would appreciate any assistance any one can offer. Thanks in advance... Peter :)
Guest Posted December 21, 2005 Posted December 21, 2005 looks like mysql 5.x issues. Look at osc admin panel->Tools->Server Info and check the version of mysql Should be next to the databse or further down as client api. If it is 5.x goto www.oscommerce.com/solutions/downloads and install the latest version. (051113) Should take care of the errors.
zakhar7 Posted September 8, 2006 Posted September 8, 2006 Hi all, I'm a newbie to osCommerce and I have loaded it locally on my own PC to trial it. I am having problems displaying products that I have entered into the catalogue. I can enter new products OK however when I click on the category, I receive the following error: 1054 - Unknown column 'p.products_id' in 'on clause' 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 = '16' [TEP STOP] Also, when I select a product listed in the "new products" window, I receive the following error: 1406 - Data too long for column 'last_page_url' at row 1 update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '127.0.0.1', time_last_click = '1135143224', last_page_url = '/product_info.php?products_id=7&osCsid=75tln1u2pmebusd5nqo754ran3' where session_id = '75tln1u2pmebusd5nqo754ran3' [TEP STOP] I would appreciate any assistance any one can offer. Thanks in advance... Peter :) I had same problem with template downloaded from internet. Solution for ERROR 1054: It was problem with catalog/index.php Just replace php code from working version Oscommerce olution for ERROR 1406: Problem was with database table whos_online. SHould be last_page_url VARCHAR(255). In my case it was VARCHAR(64). It solved all the problems.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.