Author Topic: Marriage 1.1 Error  (Read 163 times)

Patti

  • Newbie
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Marriage 1.1 Error
« on: November 07, 2017, 08:43:15 pm »
Beim installieren der Modul erscheint folgende Error :


Code: [Select]
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=INNODB' at line 6
CREATE TABLE marriage_flirtpoints (
initiator int(11) unsigned NOT NULL ,
receiver int(11) unsigned NOT NULL ,
flirtpoints int(11) unsigned NOT NULL ,
PRIMARY KEY (initiator),
KEY receiver (receiver)) Type=INNODB
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=INNODB' at line 11
CREATE TABLE marriage_proposals (
initiator int(11) unsigned NOT NULL ,
proposed_to int(11) unsigned NOT NULL ,
ring int(4) unsigned NOT NULL default '0' ,
propose text NOT NULL ,
response text NOT NULL ,
accepted int(2) unsigned NOT NULL ,
date datetime NOT NULL default '0000-00-00 00:00:00' ,
responsedate datetime NOT NULL default '0000-00-00 00:00:00' ,
PRIMARY KEY (initiator,proposed_to,date),
KEY receiver (date)) Type=INNODB
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=INNODB' at line 13
CREATE TABLE marriage_actions (
id int(11) unsigned NOT NULL auto_increment,
initiator int(11) unsigned NOT NULL ,
receiver int(11) unsigned NOT NULL ,
message varchar(4000) NOT NULL ,
response varchar(4000) NOT NULL ,
successful tinyint(4) NOT NULL ,
date datetime NOT NULL default '0000-00-00 00:00:00' ,
responsedate datetime NOT NULL default '0000-00-00 00:00:00' ,
PRIMARY KEY (id),
KEY initiator (initiator),
KEY receiver (receiver),
KEY successful (successful)) Type=INNODB
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=INNODB' at line 3
CREATE TABLE marriage_optout (
acctid int(11) unsigned NOT NULL ,
PRIMARY KEY (acctid)) Type=INNODB
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=INNODB' at line 6
CREATE TABLE marriage_ignorelist (
player int(11) unsigned NOT NULL ,
target int(11) unsigned NOT NULL ,
reason varchar(1000) NOT NULL ,
date datetime NOT NULL default '0000-00-00 00:00:00' ,
PRIMARY KEY (player,target)) Type=INNODB