Solved ZnoteACC Database problem

[Prox Plox]

Hello!
​

When I try to create the database tables for Znote, this happens:

The error that appears after I click go:

Error
SQL query:


CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `limit` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
MySQL said: Documentation

#1215 - Cannot add foreign key constraint

What should I do here?
appreciate help!

 

[StreamSide]

do you have the table "guild_wars" created? cus of the error I mean:
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

 

[Prox Plox]

do you have the table "guild_wars" created? cus of the error I mean:
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

No, I dont have a table named "guild_wars"

 

[HalfAway]

If you're using an server without guild war system, simply remove this from the SQL Query (in phpmyadmin):

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `limit` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Then disable guild_wars in config.php.

 

[Prox Plox]

Well, that was easy, thanks!
Solved

 

[Szka]

Have the same problem:
https://otland.net/threads/problem-with-znote.244868/

Couldn't get this fix yet, I didn't understand where to disable guild_wars, anyway when I deleted this

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `limit` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

The SQL code just get the value to 0, that means deleted