error in sql install on clan wars module

[Sjobbe]

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.

[KyleMassacre]

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 May 13, 2013 by KyleMassacre
added sql

[Sjobbe]

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.

[KyleMassacre]

That is strange because the column does exists. Do you have a site up? If so you wanna pm me the domain so I can see for myself?

[VashNaroom]

same error I get

[KyleMassacre]

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;

[VashNaroom]

clan wars and clans donate both work excellent for some reason I had to dump the original SQL from the db then reinstall mod and sql now both work great.