On my Shopping Cart homepage the page is not displaying correctly. I have this error message under my flash banner. Could someone please be of assistance?

Thanks,

Issue* 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 'MAX_DISPLAY_PRODUCTS_FIRST_PAGE' at line 1

select p.products_id, p.products_image,  p.products_tax_class_id, pd.products_name, 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,  products_description pd where p.products_status = '1' and p.products_id =  pd.products_id and pd.language_id = '1' order by p.products_date_added  desc limit MAX_DISPLAY_PRODUCTS_FIRST_PAGE

[TEP STOP]

limit has to be a number

I'm sorry I do not understand what you mean by limit needs to be a number? Can you further assist me?

Also where would I update this info?

Look at the query

limit expects a NUMERICAL VALUE

what is your value for limit?

I am currently testing... Thanks for the tip.

i resolved my issue. I did not install the template correctly so I reinstalled it.