Hi
I'm getting this extra when trying to install my extra:
Could not create table `modx_questions` SQL: CREATE TABLE `modx_questions` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT, `question` TEXT NOT NULL, `answer_correct` VARCHAR NOT NULL DEFAULT '', `alt_answer1` VARCHAR(255) NULL DEFAULT '', `alt_answer2` VARCHAR(255) NULL DEFAULT '', `alt_answer3` VARCHAR(255) NULL DEFAULT '', `questioner_id` INT(10) NOT NULL DEFAULT '0', `late_edited` TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, `datetime_added` TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, `difficulty` INT(3) NOT NULL DEFAULT '0', `tags` TEXT NOT NULL, `full_explanation` TEXT NOT NULL, `display` INT(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM ERROR: Array ( [0] => 42000 [1] => 1064 [2] => 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 'NOT NULL DEFAULT '', `alt_answer1` VARCHAR(255) NULL DEFAULT '', `alt_answer2` V' at line 1 )
I can't see what's wrong with my schema, any help appreciated. Thanks!
<?xml version="1.0" encoding="UTF-8"?>
<model package="questions" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM">
<object class="QuestionsSQL" table="questions" extends="xPDOSimpleObject">
<field key="question" dbtype="varchar" precision="255" phptype="string" default="" />
<field key="answer_correct" dbtype="varchar" precision="255" phptype="string" default="" />
<field key="alt_answer1" dbtype="varchar" precision="255" phptype="string" default="" />
<field key="alt_answer2" dbtype="varchar" precision="255" phptype="string" default="" />
<field key="alt_answer3" dbtype="varchar" precision="255" phptype="string" default="" />
<field key="questioner_id" dbtype="varchar" precision="10" phptype="string" default="" />
<field key="late_edited" dbtype="timestamp" phptype="timestamp" attributes="ON UPDATE CURRENT_TIMESTAMP" />
<field key="datetime_added" dbtype="timestamp" phptype="timestamp" attributes="ON UPDATE CURRENT_TIMESTAMP" />
<field key="difficulty" dbtype="varchar" precision="3" phptype="string" default="" />
<field key="tags" dbtype="varchar" precision="255" phptype="string" default="" />
<field key="full_explanation" dbtype="varchar" precision="255" phptype="string" default="" />
<field key="display" dbtype="varchar" precision="3" phptype="string" default="" />
</object>
</model>
