2 Replies Latest reply on Apr 14, 2008 11:15 PM by (Laurence_Lewis)

    MYSQL ERROR

    (Laurence_Lewis)
      Hi Can anyone help point me in the right direction to solve the following error:

      Error:
      Internal error.
      Developer Details:
      tNG_fields.getFakeRecordset:
      SQL error: Error creating temporary table:
      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 'upDate TEXT, Company TEXT, Name TEXT, email TEXT, phone TEXT, NoFiles TEXT, file' at line 1
      SQL:
      CREATE TEMPORARY TABLE KT_fakeRS_20080415 (upDate TEXT, Company TEXT, Name TEXT, email TEXT, phone TEXT, NoFiles TEXT, file1 TEXT, file2 TEXT, file3 TEXT, file4 TEXT, file5 TEXT, Comments TEXT, delDate TEXT, id_cfls TEXT) (FIELDS_FAKE_RS_ERROR)

      Thanks

      Laurence