Guest Posted March 2, 2009 Share Posted March 2, 2009 Screen Reads....... 1054 - Unknown column 'p.products_id' in 'on clause' select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri ce4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_pri ce8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '1346' and pd.products_id = '1346' and pd.language_id = '1' [TEP STOP] Please can anyone help me. When my host upgraded the MySQL from 4 to 5 last Thursday it rendered my oscomeerce shop unusable. I have followed on screen instuctions available from Blackfoot Hosting, but as I am not a web programmer I am fairly limited. Please can anybody help me? The site is Prosound-DJ.com if anyone would like to take a look. Thanks. Link to comment Share on other sites More sharing options...
Giovanna Posted March 2, 2009 Share Posted March 2, 2009 I had that. Depending on what version of OSC you have installed you will need to update all the files. If you had MS2 you need to download the rc2 file and go to the extra folder and do all the changes in the update file, then the one for RC1 and then rc2. Loads of manual updating, am still in process of doing this. Link to comment Share on other sites More sharing options...
Guest Posted March 5, 2009 Share Posted March 5, 2009 New Error! I have been through my coding and sorted all the "left join" problems, I am now able to get to a product page & add an item to my cart however I permanently have this error showing throughout the site. Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/prosound/public_html/includes/functions/general.php:2537) in /home/prosound/public_html/includes/functions/sessions.php on line 67 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/prosound/public_html/includes/functions/general.php:2537) in /home/prosound/public_html/includes/functions/sessions.php on line 67 Can anybody help me sort this. Thanks in advance Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted March 5, 2009 Share Posted March 5, 2009 Try the knowledge base in the documentation on this site . Believe the answer is under common problems Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
MrPhil Posted March 5, 2009 Share Posted March 5, 2009 Your error message is telling you that some output is being sent to the browser unexpectedly early. osC is trying to send some custom HTTP "header" information, but some previous output has already caused the default headers to be sent. Do you have any error messages showing (before this one about the headers)? Otherwise, check all the files you edited to see if you left a blank line (or even a single blank character, or other stray character) in one of your PHP files, outside of the <?php ... ?> PHP section. If it's happening on every page, look in the PHP files (header, column_*, footer, etc.) that get used on every page. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.