Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

php code displaying in Reports


Recommended Posts

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?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...