Guest Posted January 31, 2007 Share Posted January 31, 2007 Hello, I am brand new to this forum and this is my first post. My webhosting company was experiencing database server issues yesterday and consequently, I had to restore my SQL database. I am now getting the following error message when I try to add a product to my 'shopping cart' or when I try to add or modify a product on the admin side of my website: 1054 - Unknown column 'p.products_dim_type' in 'field list' select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_tax_class_id from products p, products_description pd where p.products_id = '30' and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP] Any suggestions? Many Thanks, Catherine (sugoicath) Link to comment Share on other sites More sharing options...
Guest Posted January 31, 2007 Share Posted January 31, 2007 select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_tax_class_id from products p, products_description pd where p.products_id = '30' and pd.products_id = p.products_id and pd.language_id = '1' At some point you must've installed a contrib, or modified the db for some reason and you added a column in the products table called : products_dim_type and now it is not there. So - I guess first of all I would go insert that column into the products table - of course I have no idea what datatype it should be! lol. I'm pretty sure all these columns are not from a default osc install : products_weight_type, products_length, products_width, products_height, products_ready_to_ship, products_tax_class_id It looks to me like a shipping module. Perhaps Canada Post ? UPS ? FedEx ? Corrie Link to comment Share on other sites More sharing options...
Guest Posted January 31, 2007 Share Posted January 31, 2007 Thanks Corrie, That helped alot. I had installed the Canada Post Shipping Module, just prior to having to restore the database...and the restored database was missing the SQL install from the Canada Post Shipping Module. Now it is fixed and my headache is gone! Thanks again! Catherine At some point you must've installed a contrib, or modified the db for some reason and you added a column in the products table called : products_dim_typeand now it is not there. So - I guess first of all I would go insert that column into the products table - of course I have no idea what datatype it should be! lol. I'm pretty sure all these columns are not from a default osc install : products_weight_type, products_length, products_width, products_height, products_ready_to_ship, products_tax_class_id It looks to me like a shipping module. Perhaps Canada Post ? UPS ? FedEx ? Corrie Link to comment Share on other sites More sharing options...
Guest Posted January 31, 2007 Share Posted January 31, 2007 Thanks Corrie, That helped alot. I had installed the Canada Post Shipping Module, just prior to having to restore the database...and the restored database was missing the SQL install from the Canada Post Shipping Module. Now it is fixed and my headache is gone! Thanks again! No problem - just takes a fresh set of eyes! Corrina Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.