Featured-Products V1.3 Error

[drumminlogan]

I installed featured products v1.3 and it worked fine. Then I changed servers, and when I set it up, I get this error. Can someone help me out with it? Thanks

 

1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_FEATURED_PRODUCTS' at line 1

 

select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit MAX_DISPLAY_FEATURED_PRODUCTS

 

[TEP STOP]

[Guest]

Seems like when it calls featured products it doesnt find anything.

 

I would backup my database (not copied over the original file before the server transfer backup file), delete table featured and create a new table again.

 

Maybe table featured is corrupt with the server transfer.

 

DROP TABLE IF EXISTS featured;

CREATE TABLE featured (

 featured_id int(11) not null auto_increment,

 products_id int(11) default '0' not null ,

 featured_date_added datetime ,

 featured_last_modified datetime ,

 expires_date datetime ,

 date_status_change datetime ,

 status int(1) default '1' ,

 PRIMARY KEY (featured_id)

);

[drumminlogan]

I just tried that and still get the same error.

[Guest]

Hmmm how bout pretending its not installed and doing a reinstall?

[drumminlogan]

Well I am an idiot. I forgot to make the update in the new configure.php file. Thanks for the help.

[Guest]

Hehe i forget things too.

[sonictrip.net]

I also changed from windows to a linux server and im getting the following error when i try to click the "featured" link in the admin section:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12, 12' at line 1

 

select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -12, 12

 

[TEP STOP]

 

Anyone have any idea whats happening here? Thanks... :thumbsup: