Abre a tua data base, exclua a table houses caso ela exista, e execute isso:
CREATE TABLE houses (
id INTEGER NOT NULL,
world_id INTEGER NOT NULL
DEFAULT '0',
owner INTEGER NOT NULL,
paid INTEGER NOT NULL
DEFAULT '0',
warnings INTEGER NOT NULL
DEFAULT '0',
lastwarning INTEGER NOT NULL
DEFAULT '0',
name VARCHAR( 255 ) NOT NULL,
town INTEGER NOT NULL
DEFAULT '0',
size INTEGER NOT NULL
DEFAULT '0',
price INTEGER NOT NULL
DEFAULT '0',
rent INTEGER NOT NULL
DEFAULT '0',
doors INTEGER NOT NULL
DEFAULT '0',
beds INTEGER NOT NULL
DEFAULT '0',
tiles INTEGER NOT NULL
DEFAULT '0',
guild BOOLEAN NOT NULL
DEFAULT 'FALSE',
clear BOOLEAN NOT NULL
DEFAULT 'FALSE',
UNIQUE ( id, world_id )
);
Aqui ta meu tutorial de como resolver problemas na data base: http://www.tibiaking.com/forum/topic/33611-tutorial-resolvendo-qualquer-erro-na-data-base/#entry189040