Another 1054 - Unknown column 'pd.products_spec' in 'field list' problem

[z0rr0]

After installin the "Products Tabs" contribution I get this error:

 

1054 - Unknown column 'pd.products_spec' in 'field list'

 

select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musthave, pd.products_extraimage, pd.products_manual, pd.products_extra1, pd.products_moreinfo, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '1' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

 

I know that this error is very "popular" but I am very new to all this so plase HELP

[z0rr0]

SOLVED USING phpMyadmin

[zion07]

SOLVED USING phpMyadmin

 

 

Hi

 

how do i solve this problem in php myadmin?

 

any help would be greatly appreciated!

 

karl

[usernamenone]

it is a php 4 and php 5 issue. Simply put you need to update the code in your oscommerce shop.

 

Download the latest version, find the update text file inside and update.......... Your shop will be safer for it.

[dotpower]

it is a php 4 and php 5 issue. Simply put you need to update the code in your oscommerce shop.

 

Download the latest version, find the update text file inside and update.......... Your shop will be safer for it.

 

I don't think so, i'm having same problem after installing "Quantity per attribute" and im running the latest version of oscommerce here

After installing it, when i click a product the error comes, some products i can add to basket, and some i can't

 

Any help would be very much appriciated

 

 

Greetz

-------> dotpower

[dotpower]

Nevermind, i fixed the problem... :)

 

Problem was that i replaced some files when installing the addon instead of editing them manually, and the files i used to replace with must have been from an earlier version of oscommerce i guess.

 

 

 

Greetz

--------> dotpower