Error 1064, Whas_New.php

[nkshop]

HI All,

I'm brand new to OsCommerce and PHP. I have been working on getting this to run on a Windows XP Machine running MySql 5.0.22 and Php5

 

After running the install and loading the database (I had to use the format CP1251 as UTF8 that is the default for mysql5.0 would not work) I'm getting an error on the page.

 

Anyways moving on the error I'm getting states:

 

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

 

select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit

 

[TEP STOP]

 

This error can be seen on the top left corner of main page.

 

I have done a tone of searching on the forum, but have not been able to find a solution for this.

Please Help.

 

Cheers,

[nkshop]

I found the problem.

It was in the Whats_New.php file.

The SQL statement

 

if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' order by products_date_added desc limit")) {

 

did not seem to work.

 

I changed it by removing the word limit at the end of the statement.

 

if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' order by products_date_added desc")) {