Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: need to change type=myISAM to engine=myISAM, but where?

need to change type=myISAM to engine=myISAM, but where? 3 years 9 months ago #86355

  • nawsadmin
  • nawsadmin's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
I am trying to activate a survey (running 1.92) and get the error below. I know what the fix is (change from type to engine), just not sure which file should the fix be done in, or what SQL query to run in PHP myAdmin.
The error is:

Survey could not be activated.

Main admin screen
DB Error:
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 'TYPE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 41
id I NOTNULL AUTO PRIMARY,
submitdate T,
startlanguage C(20) NOTNULL ,
`66269X111X553` C(5),
`66269X111X554` X,
`66269X111X555` C(5),
`66269X111X556` X,
`66269X111X5575a` F,
`66269X111X5575b` F,
`66269X111X558` X,
`66269X111X559` C(1),
`66269X111X560` C(5),
`66269X111X5619a` C(5),
`66269X111X5619b` C(5),
`66269X111X5619c` C(5),
`66269X111X5619d` C(5),
`66269X111X56210a` C(5),
`66269X111X56210b` C(5),
`66269X111X563` F,
`66269X111X564` X,
`66269X111X565` X,
`66269X111X566` X,
`66269X111X567` X,
`66269X111X568` F,
`66269X111X569` X,
`66269X111X570` C(1),
`66269X111X571` X,
`66269X111X572` C(1),
`66269X111X573` X,
`66269X111X574` C(1),
`66269X111X575` C(1),
`66269X111X576` C(1),
`66269X111X577` X,
`66269X111X578` C(1),
`66269X111X579` X,
`66269X111X580` C(1),
`66269X111X581` X,
`66269X111X582` X
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.219 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form