6 replies to this topic

[JonathanH]

I use powweb.com as a host and osc 2.2ms2. Domain is superior-scientific.com. powweb upgraded to mysql5 and my site is no longer working.

I'm looking to pay someone to fix this. Any suggestions of what this might cost or where I can find someone to help.

Thanks.

[bruyndoncx]

apply the last osCommerce version RC1 that has the necessary fixes for compatibility with mysql5

[JonathanH]

How difficult is it to apply the latest update RC1 to my site? Several modifications have been done to the current site that I don't wish to lose. Are there people that would do the upgrade for me? Where would I find them?

Thanks.

[pubdomains.com]

Just checked your site - and caught the 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 = '134'

Good part is You can fix this yourself

Search for "left join"

left join manufacturers m on p.manufacturers_id = m.manufacturers_id

Modify it to make sure that first value after ON is equal to table reference in left join ie. instead of p.manufacturers_id switch values as

left join manufacturers m on m.manufacturers_id = p.manufacturers_id

so it reads like LEFT JOIN Table <Name> on <NAME>. ....

Similarly another left join in query above is

left join specials s on p.products_id = s.products_id

So the culprit here is specials s on p.products_id
Convert it as

specials s on s.products_id = p.products_id [interchange s and p or whichever is used... in your specific query]

and your site would be back to normal...
hope that helps,

Edited by pubdomains.com, 24 August 2007, 10:33.

[Monika in Germany]

products_to_categories p2c left join specials s on p.products_id = s.products_id

the p.=s. join will not work placed after the p2c table, it needs to be shifted right behing the p table

I could show you with original code, even better, follow the upgrade instructions that were published in the old version:
http://www.monikamathe.com/oscommerce/mysql5.txt

[pubdomains.com]

Thanks for correction !!!

Cheers,

[Monika in Germany]

np! as I learned coding with ms sql server & oracle, I never learned to make the "lax" joins that mysql4 allowed, so they jump into my face immediately ;-)