Author Topic: Marriage 1.1 Error  (Read 648 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

Nightborn

  • Administrator
  • Sr. Member
  • *****
  • Posts: 320
  • Karma: +20/-0
    • View Profile
    • Shinobilegends
Re: Marriage 1.1 Error
« Reply #1 on: January 08, 2018, 12:40:58 am »
Soooorry for the late answer, I really don't get notifications.

You have to enable INNODB support in your MySQL.

If you don't want it, replace it with "MyISAM". (different engine)
It should be fixed, but it won't be easy and it won't be fast. If you want
to help - wonderful. But keep in mind that it will take months of wading
through the ugliest code we have in the tree. If you've got a weak stomach -
stay out. I've been there and it's not a nice place.

   - Al Viro