database error

[moisea]

.hello there, i installed the master product contribution, matti's (or johnson's) last one on that subject. however, i am getting the following error messages

 

1054 - Unknown column 'p.products_listing_status' in 'where clause'

select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_listing_status = '1' order by p.products_date_added desc limit 9

[TEP STOP]

 

can someone please help me to sort this out?

[VectorSix]

.hello there, i installed the master product contribution, matti's (or johnson's) last one on that subject. however, i am getting the following error messages

 

1054 - Unknown column 'p.products_listing_status' in 'where clause'

select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_listing_status = '1' order by p.products_date_added desc limit 9

[TEP STOP]

 

can someone please help me to sort this out?

 

Did you run the master.sql script that is in the contribution? The error is telling you that there is no column named products_listing_status in the Products table, which leads me to believe that you did not run the SQL script.

 

Good Luck,

V6 :thumbsup:

[moisea]

Did you run the master.sql script that is in the contribution? The error is telling you that there is no column named products_listing_status in the Products table, which leads me to believe that you did not run the SQL script.

 

Good Luck,

V6 :thumbsup:

 

hi vectorsix,

i have i also tried to do it again and i am getting this type of error under phpmyadmin

Error

SQL-query:

INSERT INTO configuration_group
VALUES ( 16, 'Slave Products', 'Slave Product Listing - configuration options', 16, 1 )

MySQL said: Documentation
#1062 - Duplicate entry '16' for key 1

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-8\phpmyadmin\libraries\common.lib.php on line 685

 

any idea????????????????????????? :blush: