SQL syntax error

Help
Henkka
2005-01-27
2013-04-10
  • Henkka
    Henkka
    2005-01-27

    Hi,

    I just tryed php4flicks an could not get it to work.
    First thing i got is this error:
    You have an error in your SQL syntax near 'DISTINCT CONCAT(cat,nr)as nr,movies_d.name,year,insertedby,medium,movies_d.id,fi' at line 1

    What could be wrong?

     
    • mr. fox
      mr. fox
      2005-01-28

      I guess you're using a mysql version prior to 4.x. while old versions of the script worked with mysql 3.x, as of 0.4 you need mysql >= 4