5 Replies Latest reply on Jun 2, 2008 3:40 AM by (Oriyomi_Shokunbi)

    Error when creating a description field. MySQL syntax to use?

      I'm creating a form which has a description field in it. I created this form with many fields. However I then got an error and decided to limit the form to only 2 fields. These 2 fields (user and title) insert with no problem. However when I added the description field into the mix. I gat the same error I had previously gotten.

      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 'desc TEXT, job_id TEXT)' at line 1
      SQL:
      CREATE TEMPORARY TABLE KT_fakeRS_20080204 (client_id TEXT, name TEXT, desc TEXT, job_id TEXT) (FIELDS_FAKE_RS_ERROR)
      tNG Execution Trace - VIEW

      * tNG_insert.executeTransaction
      o STARTER.Trigger_Default_Starter
      * tNG_insert.getRecordset
      * tNG_insert.getLocalRecordset
      * tNG_insert.getFakeRecordset*

      I'm using the "Text" syntax for the field "desc" (description)

      What am I doing wrong? Do I need to define the table row in a different way?