Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

My SQL4 upgrade.


Guest

Recommended Posts

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

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...