2 Replies Latest reply on May 8, 2008 5:24 PM by (Purple_Edge)

    Any idea why I'm seeing problems at "tNG_insert.getFakeRecordset*"?

      Hi,

      I can't seem to work out how to resolve this - Google just takes me to other sites that are suffering the same problem.

      Is it a permissions error in SQL pertaining to creating temporary tables or not being able to drop them?

      The setting I'm using are pretty default. The exact message is below;

      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 ')' at line 1
      SQL:
      CREATE TEMPORARY TABLE KT_fakeRS_20070711 (uname TEXT, pword TEXT, key TEXT) (FIELDS_FAKE_RS_ERROR)
      tNG Execution Trace - VIEW
      tNG_insert.executeTransaction
      STARTER.Trigger_Default_Starter
      tNG_insert.getRecordset
      tNG_insert.getLocalRecordset
      tNG_insert.getFakeRecordset*

      Thanks in advance for any suggestions?