Problem mit Quiz Mod

[belgier]

Hey Leute, ich wollte den Wuiz Mod in mein Forum einbauen, und alles funktionierte soweit, bis ich die install_quiz_hack.php startete, und es installieren wollte. Daraufhin kam diese Meldung:

Code: Alles auswählen

Fehler Liste:
SQL Error: 1067 Invalid default value for 'quiz_id'
SQL Query: CREATE TABLE klasse_quiz ( quiz_id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, question text NOT NULL, answer varchar(100) NOT NULL, answer2 varchar(100) NOT NULL, answer3 varchar(100) NOT NULL, answer4 varchar(100) NOT NULL, answer_explain text NOT NULL, quiz_points tinyint(2) DEFAULT '1' NOT NULL, quiz_type tinyint(1) DEFAULT '0' NOT NULL, quiz_status tinyint(1) DEFAULT '0' NOT NULL, quiz_from_user_id mediumint(8) DEFAULT '0' NOT NULL, quiz_topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL, quiz_bot_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL, answered_by_user_id mediumint(8) DEFAULT '0' NOT NULL, PRIMARY KEY (quiz_id), KEY quiz_status (quiz_status), KEY quiz_topic_id (quiz_topic_id) )

ich habe dann das ganze auch manuell in die MySQL Datenbank versucht einzugeben

• CREATE TABLE phpbb_quiz (
  quiz_id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
  question text NOT NULL,
  answer varchar(100) NOT NULL,
  answer2 varchar(100) NOT NULL,
  answer3 varchar(100) NOT NULL,
  answer4 varchar(100) NOT NULL,
  answer_explain text NOT NULL,
  quiz_points tinyint(2) DEFAULT '1' NOT NULL,
  quiz_type tinyint(1) DEFAULT '0' NOT NULL,
  quiz_status tinyint(1) DEFAULT '0' NOT NULL,
  quiz_from_user_id mediumint(8) DEFAULT '0' NOT NULL,
  quiz_topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  quiz_bot_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
  answered_by_user_id mediumint(8) DEFAULT '0' NOT NULL,
  PRIMARY KEY (quiz_id),
  KEY quiz_status (quiz_status),
  KEY quiz_topic_id (quiz_topic_id)

aber da gab es das selbe Problem... Ich verstehe das nicht, könnt ihr mir da helfen? Danke im voraus, euer Belgier!

[AmigaLink]

Hmmm - versuchs mal so:

Code: Alles auswählen

CREATE TABLE `phpbb_quiz` (
  `quiz_id` mediumint(8) unsigned NOT NULL auto_increment,
  `question` text NOT NULL,
  `answer` varchar(100) NOT NULL default '',
  `answer2` varchar(100) NOT NULL default '',
  `answer3` varchar(100) NOT NULL default '',
  `answer4` varchar(100) NOT NULL default '',
  `answer_explain` text NOT NULL,
  `quiz_points` tinyint(2) NOT NULL default '1',
  `quiz_type` tinyint(1) NOT NULL default '0',
  `quiz_status` tinyint(1) NOT NULL default '0',
  `quiz_from_user_id` mediumint(8) NOT NULL default '0',
  `quiz_topic_id` mediumint(8) unsigned NOT NULL default '0',
  `quiz_bot_post_id` mediumint(8) unsigned NOT NULL default '0',
  `answered_by_user_id` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`quiz_id`),
  KEY `quiz_status` (`quiz_status`),
  KEY `quiz_topic_id` (`quiz_topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=6857 ;

(Das ist ein dump meiner Tabellenstrucktur)

[belgier]

Danke, funktioniert jetzt!
Danke nochmal, super!