Jump to content
MakeWebGames

error in sql install on clan wars module


Sjobbe

Recommended Posts

I have found that when you install the clan-wars module it trys to put 2 declareER in the sql

replace into clans_stats_types(name) values('Honor');

CREATE TABLE IF NOT EXISTS clan_wars (

id int(10) NOT NULL AUTO_INCREMENT,

declareER int(10) NOT NULL,

declaredON int(10) NOT NULL,

reason varchar(255) COLLATE utf8_unicode_ci NOT NULL,

time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

declareER int(10) NOT NULL,

PRIMARY KEY (id)

) ENGINE InnoDB, CHARACTER SET utf8, COLLATE utf8_bin;

 

after what I can see it should have surrenderER in it, but not sure on what spot and the different setups, I will post more when I fint out of that.

Link to comment
Share on other sites

Change that last declareER to surrenderER. Ill look up my sql and fix it and submit the update.

Here is the correct sql

replace into clans_stats_types(name) values('Honor');

CREATE TABLE IF NOT EXISTS clan_wars (
 id int(10) NOT NULL AUTO_INCREMENT,
 declareER int(10) NOT NULL,
 declaredON int(10) NOT NULL,
 reason varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 surrenderER int(10) NOT NULL,
 PRIMARY KEY (id)
) ENGINE InnoDB, CHARACTER SET utf8, COLLATE utf8_bin;
Edited by KyleMassacre
added sql
Link to comment
Share on other sites

Change that last declareER to surrenderER. Ill look up my sql and fix it and submit the update.

Here is the correct sql

replace into clans_stats_types(name) values('Honor');

CREATE TABLE IF NOT EXISTS clan_wars (
 id int(10) NOT NULL AUTO_INCREMENT,
 declareER int(10) NOT NULL,
 declaredON int(10) NOT NULL,
 reason varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 surrenderER int(10) NOT NULL,
 PRIMARY KEY (id)
) ENGINE InnoDB, CHARACTER SET utf8, COLLATE utf8_bin;

thanks

but now when I click on Clan in the menu I get this error

Query error: Unknown column 'declareER' in 'field list'

select id, declareER, declaredON, reason, time, surrenderER from clan_wars where (declareER = ?) OR (declaredON = ?)

if I disable clan_wars it works.

Link to comment
Share on other sites

same error I get

Try this:

 DROP TABLE clan_wars;
CREATE TABLE IF NOT EXISTS clan_wars (
id int(10) NOT NULL AUTO_INCREMENT,
declareER int(10) NOT NULL,
declaredON int(10) NOT NULL,
reason varchar(255) COLLATE utf8_unicode_ci NOT NULL,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
surrenderER int(10) NOT NULL,
PRIMARY KEY (id)
) ENGINE InnoDB, CHARACTER SET utf8, COLLATE utf8_bin;
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...