chrometweaks.org

I'm looking for a good free web hosting site besides iPage. Can you recommend anything?

Click Here To View All Answers...


Got a question... I'm looking for a good free web hosting site besides iPage. Can you recommend anything? Thanks for any response. 2nd question I got is.. I know this issue has been addressed, but I can't find a solution to my situation. I am still getting this error on the.

Product_info.php.

Page:.

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_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri.

Ce4_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 = '988' and pd.products_id = '988' and pd.language_id = '1'.

[TEP STOP].

I've searched the document for the 'left join', but it is not in there. Anyone know what I need to fix?..

Comments (6)

Hmm... I need to find out myself. I don't know what is the answer. I'll do some Googling and get back to you if I bump into an answer. You should email the people at iPage as they probably could give you an answer..

Comment #1

Mysql 5 error as posted in above comment..

With rc2 downlaods if YOu cek the assoicated doc s You will get some doc that tells what all ptatches needed for mysql5 upgrade..

Monica has stated those fixes..

Satish..

Comment #2

That's the one I've got in my sig block...

Comment #3

I have same issue, so just click on your link "My SQL5 compatability updates & other patches " and the read and follow the text to fix this issue? I see a bunch of stuff so not sure what I need to get/do to fix it. Do I do everything on this list? Or are there just a few for this 1054 error issue?.

My best seller links work fine on the main page just when I hit any of the Fashion items below I get the error: 1054 - Unknown column 'p.products_id' in 'on clause'.

Thanks..

Comment #4

Up to you which patches you apply..

I'd certainly do all the mysql5 patches..

You can always use the if it aint broke dont fix it approach for the rest or .......

Comment #5

Ok thanks. I am at the sql query part and using PHP Myadmin to do this. I goto Query and enter in the items you say to do and hit submit but get this error back..

You have to choose at least one column to display.

What am I missing here?.

Thanks..

Comment #6

Ok, I figured it out. Have a small issue where the quick find image is not displaying now. Ideas on why?..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.