Error 1054 After install "Tooltip Everywhere"

[mondobongo3]

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 = '47'

 

This is the error I got after installing Tooltip Everywhere

Before that I installed Featured Products, then 3 Images

 

It looks like I messed everything up (now I'm really happy because I made backups :rolleyes: ).

 

In fact, what i want:

 

1. to get rid of New Products of Month (done, as Featured Products worked... but i'm affraid that was some conflict with 3Images and/or Tooltip Everywhere)

 

2. to show other (different from thumbnail) image on mouse over as a tooltip product thumbnail (anywhere respective product thumbnail is situated: in featured, product list, special, new products...)

 

If anyone is willing to help me, i will be grateful. Please let me know !

[♥geoffreywalton]

Try following the link to

 

If your host has recently upgraded to mysql5 then you need to sort out LEFT JOINS

 

in my profile.

 

Cheers

 

G

[mondobongo3]

Try following the link to

 

If your host has recently upgraded to mysql5 then you need to sort out LEFT JOINS

 

in my profile.

 

Cheers

 

G

 

Thanks for reply ! :D Would you be more specific, as I don't really understand that error... it's my first time when I crush on php/mysql. How can I check mysql version? Just asking? And if is ver.5, what exactly should I do?

[♥geoffreywalton]

Server info in admin will tell you the version.

 

You should follow the instructions in the link.

 

G

[mondobongo3]

Server info in admin will tell you the version.

 

You should follow the instructions in the link.

 

G

 

Indeed, MySQL version 5.0.90-community-log

I'm sorry :D If you reffer to links from your signature, I just noticed them now. I surely will follow the link ! ^_^

As a adjacent question, do you know which add-on caused that? Because after rolling-back everything is fine.

[♥geoffreywalton]

No, I am not wearing my psychic hat today but I am sure when you have read up on it you will be able to spot the offending code you have put in and correct it.

 

BTW you could use the hints on searching in my profile, it may already have been answered.

 

If not maybe you could post the answer here to help others in the future.

 

G

[mondobongo3]

No, I am not wearing my psychic hat today

G

I didn't expected that you wear it :D .. In my first post I said what add-ons I did installed and i thought it might be a chance for you to know (i'm not sure if I used english right... i'm sorry for any mistake). As soon as i find the answer, I will put it here. Thanks.

[MrPhil]

If those instructions don't fix your problem, a comprehensive discussion is in http://www.oscommerce.com/forums/topic/335136-osc-and-mysql-5-1054-errors

[mondobongo3]

If those instructions don't fix your problem, a comprehensive discussion is in http://www.oscommerce.com/forums/topic/335136-osc-and-mysql-5-1054-errors

I think the error occures as a result of executing some of the sql files which come with one of that plugins, but now I'll let that debugging on a second place, because I try to find a way to integrate overLib in php code. For now it renders it in a chaotic way... I can't understand what is going on. See my post on overLib, for details.