Code:
Error in DBLoadDoors query 'SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading
,opentype,guild,lockpick,keyitem,triggerdoor,triggertype,dest_zone,dest_x,dest_y
,dest_z,dest_heading,door_param,invert_state,incline,size from doors' #1054: Unk
nown column 'door_param' in 'field list'
If you get an error about door_param and size, run the following queries:
ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" NOT NUL
L;
ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NULL;
Did you follow the instructions in those error messages and do:
Code:
C:> mysql -u root <your eq database>
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2130 to server version: 4.0.18-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" NOT NULL;
Query OK, 3495 rows affected (0.05 sec)
Records: 3495 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NULL;
Query OK, 3495 rows affected (0.05 sec)
Records: 3495 Duplicates: 0 Warnings: 0
mysql>