php code displaying in Reports

[iainlang]

In this, my first installation of oscommerce, I came across a problem in the Reports section of the Admin Suite.

Clicking on "Reports" and "Products viewed" is fine but when I go to "Products Purchased" or "Customer Orders" or "Total" I get the actual php code coming up. To double- (triple-)check, I installed the program in another two sites, trying them with and without inputting configuration values, only to get the same message.

A sample is -

 

"No. Products Purchased

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

 

select p.products_id, p.products_ordered... " etc etc.

 

Although I can't see how this would be a contributing factor, phpinfo() gives -

Database: MySQL 4.1.14-standard and

php v4.3.11

 

Every other element works fine, and I'm really rather impressed, but for this. Can anyone help, please?

[♥Vger]

Look below my name for the "1064" link.

 

Vger

[iainlang]

Look below my name for the "1064" link.

 

Vger

 

Thank you; you cracked it!

 

 

May your tribe increase!

 

Yoooors,

 

Iain.