[SOLVED] When i start the world

[albag]

hello emudevs people
i get this error when i start a fresh tc core with fresh db?
i did try with db .58 and .59

TrinityCore rev. 4a368501675a 2015-10-29 21:08:00 +0100 (3.3.5 branch) (Win32, Debug) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                 C O R E  /\___/
http://TrinityCore.org                    \/__/

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.0s 11 Jun 2015 (library: OpenSSL 1.0.2d 9 Jul 2015)
Using Boost version: 1.59.0
Updating Auth database...
>> Auth database is up-to-date! Containing 1 new and 7 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 7 new and 4 archived updates.
Updating World database...
>> Applying update "merged_sql.sql" '3A04F04'...
Warning: Using a password on the command line interface can be insecure.

ERROR 1054 (42S22) at line 5559: Unknown column 'VerifiedBuild' in 'field list'


Applying of file 'C:/Users/Ejer/Documents/wow server/github/sql/updates/world/merged_sql.sql' to database 'world' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query.
Could not update the World database, see log for details.

 

[Tommy]

ERROR 1054 (42S22) at line 5559: Unknown column 'VerifiedBuild' in 'field list'

You might have to find the sql query specifically and manually apply it since it is an outdated table error. Make sure you've applied all updates since a fresh DB pull from TDB isn't always updated.

 

[albag]

i did try to google it and run the update about it but it dont help.

https://github.com/EmuDevs/EDB/blob/master/updates/9-3-2015.sql

DROP TABLE IF EXISTS `gameobject_template_locale`;
CREATE TABLE IF NOT EXISTS `gameobject_template_locale` (
  `entry` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
  `locale` VARCHAR(4) NOT NULL,
  `name` TEXT,
  `castBarCaption` TEXT,
  `VerifiedBuild` SMALLINT(5) DEFAULT '0'
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

ALTER TABLE `gameobject_template_locale`
  ADD PRIMARY KEY (`entry`,`locale`);

-- koKR
INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`)
  (SELECT `entry`, "koKR", `name_loc1`, `castbarcaption_loc1`, `VerifiedBuild`  FROM `locales_gameobject`);

-- frFR
INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`)
  (SELECT `entry`, "frFR", `name_loc2`, `castbarcaption_loc2`, `VerifiedBuild`  FROM `locales_gameobject`);

-- deDE
INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`)
  (SELECT `entry`, "deDE", `name_loc3`, `castbarcaption_loc3`, `VerifiedBuild`  FROM `locales_gameobject`);

-- zhCN
INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`)
  (SELECT `entry`, "zhCN", `name_loc4`, `castbarcaption_loc4`, `VerifiedBuild`  FROM `locales_gameobject`);

-- zhTW
INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`)
  (SELECT `entry`, "zhTW", `name_loc5`, `castbarcaption_loc5`, `VerifiedBuild`  FROM `locales_gameobject`);

-- esES
INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`)
  (SELECT `entry`, "esES", `name_loc6`, `castbarcaption_loc6`, `VerifiedBuild`  FROM `locales_gameobject`);

-- esMX
INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`)
 (SELECT `entry`, "esMX", `name_loc7`, `castbarcaption_loc7`, `VerifiedBuild`  FROM `locales_gameobject`);

-- ruRU
INSERT INTO `gameobject_template_locale` (`entry`, `locale`, `name`, `castBarCaption`, `VerifiedBuild`)
 (SELECT `entry`, "ruRU", `name_loc8`, `castbarcaption_loc8`, `VerifiedBuild`  FROM `locales_gameobject`);

DROP TABLE IF EXISTS `locales_gameobject`;

 

[allelujah]

You might be using the wrong database/outdated version. What patch are you running?