2 Replies Latest reply on Mar 2, 2008 5:43 AM by (Oriyomi_Shokunbi)

    update page gives error

    Level 1
      Hi
      I worked on my update page on uploading it gives error.
      The user logs in and calls to update his form. on submiting the update page it gives the error below please how do I go about it.
      Thanks.
      Yomi
      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 'CITY TEXT, SCHOOL STATE TEXT, SCHOOLPHONE TEXT, HOMEADD1 TEXT, HOMEADD2 TEXT, CI' at line 1
      SQL:
      CREATE TEMPORARY TABLE KT_fakeRS_20080228 (FIRST TEXT, LAST TEXT, NATIONALITY TEXT, STATE TEXT, BIRTHDATE TEXT, BMONTH TEXT, YEAR TEXT, GENDER TEXT, SCHOOL TEXT, SCHOOLADDRESS TEXT, SCHOOL CITY TEXT, SCHOOL STATE TEXT, SCHOOLPHONE TEXT, HOMEADD1 TEXT, HOMEADD2 TEXT, CITY TEXT, HOMESTATE TEXT, COUNTRY TEXT, PARENT TEXT, PARENTEMAIL TEXT, PARENTPHONE TEXT, ID TEXT, kt_pk_register TEXT) (FIELDS_FAKE_RS_ERROR)
      tNG Execution Trace - VIEW
      tNG_custom.executeTransaction
      STARTER.Trigger_Default_Starter
      tNG_update.executeTransaction
      STARTER.Trigger_Default_Starter
      tNG_update.doTransaction
      BEFORE.Trigger_Default_saveData
      tNG_update.saveData
      BEFORE.Trigger_Default_FormValidation*
      tNG_custom.getRecordset
      tNG_custom.getLocalRecordset
      tNG_custom.getFakeRecordset
      tNG_update.getRecordset
      tNG_update.getFakeRsArr
      tNG_update.getLocalRecordset
      tNG_update.getFakeRecordset*