procomp65 Posted July 8, 2006 Posted July 8, 2006 Hi My host upgraded to a newer version of mysql and all hell broke loose. In the admin area i had the 1064 sql sysntax error, but managed to fix it with the bug report contribution. The following I can't get sorted out. Please help "1054 - Unknown column 'c.categories_level' in 'field list' select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.categories_level, c.date_added, c.last_modified from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name [TEP STOP]"
Warp Posted July 12, 2006 Posted July 12, 2006 Hi My host upgraded to a newer version of mysql and all hell broke loose. In the admin area i had the 1064 sql sysntax error, but managed to fix it with the bug report contribution. The following I can't get sorted out. Please help "1054 - Unknown column 'c.categories_level' in 'field list' select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.categories_level, c.date_added, c.last_modified from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name [TEP STOP]" yes yes.. same problem with me! host upgraded to mysql5 and php5 ! still looking for a solution! luke
procomp65 Posted July 12, 2006 Author Posted July 12, 2006 yes yes.. same problem with me! host upgraded to mysql5 and php5 ! still looking for a solution! I solved the problem on mine. I downloaded the latest version of oscommerce and replace the categories.php with the new version. It's working fine now
Guest Posted July 12, 2006 Posted July 12, 2006 yes yes.. same problem with me! host upgraded to mysql5 and php5 ! still looking for a solution! nothing to do with mysql or php versions. It's simply the column that is missing which implies whichever contribution/module you used for the categories levels was not installed properly.
vdospec Posted August 13, 2006 Posted August 13, 2006 I solved the problem on mine. I downloaded the latest version of oscommerce and replace the categories.php with the new version. It's working fine now does anyone know if there is a patch file to fix OSC for PHP5?, we upgraded our server to PHP5 and now the store does not work. I did a search and am getting conflicting solutions, one person said to just chnage 3 things in the php.ini file. Another says to downlaod teh latest version of osc ?, but what do you need to change or add without runing yuor store..? thanks for any help..need to get my store back up and running.. Michael Walker
Guest Posted August 13, 2006 Posted August 13, 2006 you keep a backup of your store's files and database. Then you apply the osc upgrade and also install the register globals off module. http://www.oscommerce.com/community/contributions,2097 Once you setup everything do a thourough test. If it's a problem to change your live store you can always setup the store in a local pc and do all mods there. finally upload the store to the live server.
darkside212 Posted August 13, 2006 Posted August 13, 2006 I'm getting a similar error, and I'm not sure what to do: 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 = '30' any help would be greatly appreciated!
vdospec Posted August 13, 2006 Posted August 13, 2006 I figured my problem out...thanks! Well why do you not share what you did?? Michael Walker
darkside212 Posted August 13, 2006 Posted August 13, 2006 sure.. I found a thread in relation to this in the bugs section: http://www.oscommerce.com/community/bugs,3259/search,error I did the modification recommended by Franck dated 3-1-06, and it was very easy and took care of my problem
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.