ProjectSkyfire/SkyFireEMU_rebase — Issue #36: Don't start
Author: tortosi
Created: 2011-12-17 20:59:53+00:00
State: open

I compiled the rebase 406 perfectly, but i installed the SkyFireDB branch rebase with all updates of core But i have many errors. I fix theese in db but don't start.
I had theese error: "Violación de segmento"

Operating sistem: Debian 6.0.3 64bits

some errors:
SQL: SELECT id, quest, eventEntry FROM game_event_creature_quest
ERROR: [1054] Unknown column 'eventEntry' in 'field list'

SQL: SELECT id, quest, eventEntry FROM game_event_gameobject_quest
ERROR: [1054] Unknown column 'eventEntry' in 'field list'

SQL: SELECT quest, eventEntry, condition_id, num FROM game_event_quest_condition
ERROR: [1054] Unknown column 'eventEntry' in 'field list'

SQL: SELECT eventEntry, condition_id, req_num, max_world_state_field, done_world_state_field FROM game_event_condition
ERROR: [1054] Unknown column 'eventEntry' in 'field list'

SQL: SELECT guid, eventEntry, npcflag FROM game_event_npcflag
ERROR: [1054] Unknown column 'eventEntry' in 'field list'

SQL: SELECT eventEntry, guid, item, maxcount, incrtime, ExtendedCost FROM game_event_npc_vendor ORDER BY guid, slot ASC
ERROR: [1054] Unknown column 'eventEntry' in 'field list'

SQL: SELECT eventEntry, bgflag FROM game_event_battleground_holiday
ERROR: [1054] Unknown column 'eventEntry' in 'field list'

SQL: SELECT pool_template.entry, game_event_pool.eventEntry FROM pool_template JOIN game_event_pool ON pool_template.entry = game_event_pool.pool_entry
ERROR: [1054] Unknown column 'game_event_pool.eventEntry' in 'field list'

SQL: SELECT `guid`, `accessory_entry`, `seat_id`, `minion`, `description` FROM `vehicle_accessory`
ERROR: [1054] Unknown column 'guid' in 'field list'

I fix whith:
ALTER TABLE `game_event_creature_quest`
CHANGE COLUMN `event` `eventEntry` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0;

ALTER TABLE `game_event_gameobject_quest`
CHANGE COLUMN `event` `eventEntry` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
DROP PRIMARY KEY,
ADD PRIMARY KEY USING BTREE(`quest`, `eventEntry`, `id`);

ALTER TABLE `game_event_quest_condition`
CHANGE COLUMN `event_id` `eventEntry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0;

ALTER TABLE `game_event_condition`
CHANGE COLUMN `event_id` `eventEntry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
DROP PRIMARY KEY,
ADD PRIMARY KEY USING BTREE(`eventEntry`, `condition_id`);

ALTER TABLE `game_event_npcflag`
CHANGE COLUMN `event_id` `eventEntry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
DROP PRIMARY KEY,
ADD PRIMARY KEY USING BTREE(`guid`, `eventEntry`);

ALTER TABLE `game_event_npc_vendor`
CHANGE COLUMN `event` `eventEntry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0;

ALTER TABLE `game_event_battleground_holiday`
CHANGE COLUMN `event` `eventEntry` INT(10) UNSIGNED NOT NULL,
DROP PRIMARY KEY,
ADD PRIMARY KEY USING BTREE(`eventEntry`);

ALTER TABLE `game_event_pool`
CHANGE COLUMN `event` `eventEntry` SMALLINT(6) NOT NULL DEFAULT 0 COMMENT 'Put negatives values to remove during event';

ALTER TABLE `vehicle_accessory`
CHANGE COLUMN `entry` `guid` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
DROP PRIMARY KEY,
ADD PRIMARY KEY USING BTREE(`guid`, `seat_id`);

Please, fix the error "violación de segmento" Whith the rebase db

Thanks