5 Replies Latest reply on Mar 3, 2009 1:24 PM by Günter Schenk

    Help Critically Needed For User Registration Error

      Hello,

      I have tried insert record wizard for a recruitment form I am trying to do but it generated mysql: error creating fake recordset.

      I resorted to user registration, but same error persists. I recreated the table but still the errors occur. I have googled solutions for it but nothing helps. I checked the mysql reserved word lists and was sure there are no reserved words being used.

      Even the user priviledges had drop and create temporary tables permission granted. Can anyone please, please tell me what could be wrong?

      There error is:

      Error:
      Internal error.
      Developer Details:
      tNG_fields.getFakeRecordset:
      SQL error: Error creating fake recordset:
      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 '-nonlisted, '' AS current_employer_city, '' AS current_employer_phone, '' AS fcu' at line 1
      SQL:
      SELECT '' AS first_name, '' AS middle_name, '' AS last_name, '' AS app_sex, '' AS birth_year, '' AS applied_Position, '' AS position_Status, '' AS street_Address, '' AS email, '' AS app_City, '' AS app_state, '' AS password, '' AS app_phone, '' AS emer_conname, '01-03-2009 9:53:02 A' AS registration_date, '0' AS terms, '' AS app_education, '' AS education-nonlisted, '' AS current_employer_city, '' AS current_employer_phone, '' AS fcurrent_employment_month_start, '' AS current_employment_year_start, '' AS current_employment_month_end, '' AS current_employment_year_end, '' AS current_employment_position, '' AS current_employer_reason, '' AS username, '' AS pre_emp_name, '' AS pre_emp_city, '' AS pre_emp_phone, '' AS pre_emp_month_start, '' AS pre_emp_year_start, '' AS pre_emp_month_end, '' AS pre_emp_year_end, '' AS pre_emp_positon, '' AS pre_emp_reason, '' AS additional_info, 'N' AS sdl_ref, '' AS sdl_ref_name, '' AS sdl_learn, 'N' AS pre_employment, '' AS pre_employment_month, '' AS pre_employment_year, 'N' AS cur_employment, '' AS elig_month, '' AS elig_year, '' AS app_available, 'N' AS app_layoff, 'N' AS app_travel, 'N' AS app_visa, 'N' AS app_convicted, '' AS convicted_reason, '' AS exp_offshore, '' AS exp_oilfied, '' AS exp_craft, '' AS special_skills, '' AS id (FIELDS_FAKE_RS_ERROR)
      tNG Execution Trace - VIEW
      tNG_insert.executeTransaction
      STARTER.Trigger_Default_Starter
      tNG_insert.getRecordset
      tNG_insert.getLocalRecordset
      tNG_insert.getFakeRecordset*

      And the page code is: