Full service web hosting, great prices and support. Starts at $1.99/month!
Results 1 to 2 of 2

Thread: oscmax 1.7 does not work in newer mysql ?

  1. #1

    Default oscmax 1.7 does not work in newer mysql ?

    Hey guys, my hosting company is telling me that the errors I'm having on a fresh install of oscmax 1.7 is due to the fact that they are running newer versions of php (they are running version 4.4.1) and mysql (they are running 4.1.14-standard).

    The problem im having is going under the "reports" area causes an error. The error is:

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

    select p.products_id, pd.products_name, pd.products_viewed, l.name from
    products p, products_description pd, languages l where p.products_id =
    pd.products_id and l.languages_id = pd.language_id order by
    pd.products_viewed DESC limit -10, 10

    any one have any idea ? this is a totalt fresh install, no products no nothing.

    EDIT!! humm more data. I added a product, and i whent to the catalog area and viewed it. Now if i go under the admin area and go under most viewed i get stats, but if i go under the other two categories (most boght, or hehe forogt the other one) it still comes up with the error above. I dont rember that ever happening before, is there a probem with the way that codes works wiht the new mysql language ? any one hear of anything ?

  2. #2


    here is the fix !!! it does have ot do with the newer mysql version


Similar Threads

  1. Getting MVS to work with osCMax
    By earth-friendly in forum osCmax v2 Customization/Mods
    Replies: 2
    Last Post: 06-23-2007, 01:35 PM
  2. Do these mods work in the latest OSCMAX please
    By ozstar in forum osCmax v2 Installation issues
    Replies: 10
    Last Post: 04-17-2007, 10:11 AM
  3. how to work with dreamweaver and oscmax ?
    By doumawis in forum osCmax v1.7 Discussion
    Replies: 0
    Last Post: 06-16-2005, 02:56 PM
  4. MySQL? Please help!
    By extremenewb in forum osCommerce 2.2 Installation Help
    Replies: 3
    Last Post: 09-22-2004, 07:31 AM
  5. add a new mysql table
    By Dumb_Question in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 12-14-2003, 12:37 PM



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts