Installation problem

[milton27]

Hello everyone,

 

I recently installed oscommerce. The installation went smooth and all the pages installed properly with no error messages on any of the pages.

 

Now after I entered my product info and uploaded the images, I click to view my site, and I get the following syntax error message on my main index.php page:

 

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.

 

I used my admin area to change the settings and did not manipulate any of the php code manually.

 

Please advise on where the error could be coming from and the solution.

 

Thanks,

Milton

[♥Vger]

I cannot find that exact code in either osCommerce RC2a or in 2.2 MS2 versions. It is similar to code found in includes/modules/new_products.php

 

Hopefully you did not use the osCommerce File Manager to edit any files.

 

Vger