1

Closed

Quests - Missing a table Column?

description

I get this error now on quests.
 
SQL ERROR [ mysqli ]
 
Unknown column 'kingdom_exp_total' in 'field list' [1054]
 
SQL
 
UPDATE aod_kingdoms SET kingdom_exp = kingdom_exp + 2, kingdom_exp_total = kingdom_exp_total + 2 WHERE id = 1
 
BACKTRACE
 
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
 
FILE: games/aod/includes/functions.php
LINE: 1966
CALL: dbal_mysqli->sql_query()
 
FILE: games/aod/quests.php
LINE: 674
CALL: kingdom_add_exp()
 
I do not see kingdom_exp_total in the DB so maybe its missing? Or is there an error in the php?
Closed Jan 19, 2010 at 4:34 PM by GameCharmer
Fixed in AoD 1.4.1

comments

GameCharmer wrote Jan 16, 2010 at 3:21 AM

I forgot to add it to the installer...

kingdom_exp_total bigint(20) NOT NULL DEFAULT '0',

wrote Jan 19, 2010 at 4:34 PM

wrote Feb 1, 2013 at 9:35 PM

wrote May 14, 2013 at 11:06 PM