{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/17103","repository_url":"https://api.github.com/repos/TrinityCore/TrinityCore","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/17103/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/17103/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/17103/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/17103","id":153708814,"number":17103,"title":"TrinityCore6.x:  first start error of worldserver as DB update on sql/old data  [TrinityCore 6.x ] ","user":{"login":"angelsss","id":19160348,"avatar_url":"https://avatars.githubusercontent.com/u/19160348?v=3","gravatar_id":"","url":"https://api.github.com/users/angelsss","html_url":"https://github.com/angelsss","followers_url":"https://api.github.com/users/angelsss/followers","following_url":"https://api.github.com/users/angelsss/following{/other_user}","gists_url":"https://api.github.com/users/angelsss/gists{/gist_id}","starred_url":"https://api.github.com/users/angelsss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angelsss/subscriptions","organizations_url":"https://api.github.com/users/angelsss/orgs","repos_url":"https://api.github.com/users/angelsss/repos","events_url":"https://api.github.com/users/angelsss/events{/privacy}","received_events_url":"https://api.github.com/users/angelsss/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Invalid-CannotReproduce","name":"Invalid-CannotReproduce","color":"fbca04"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Invalid-IncompleteData/NotTrinityCore","name":"Invalid-IncompleteData/NotTrinityCore","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-05-09T06:05:35Z","updated_at":"2016-05-09T07:19:13Z","closed_at":null,"body":"**Description**:  TrinityCore6.x:  first start error as DB\r\n\r\n**Current behaviour**: TDB6.04 -Start Error as DB init to update world database  from sql/old data\r\n\r\n**Expected behaviour**:  I think not have to update from sql old data as WIKI talking for TDB6.04\r\n\r\n**Steps to reproduce the problem**:\r\nI push TDB_FULL_*.sql to TrinityCore-runserver/bin , in order to autoupdate db with process of worldserver but that to read old date ,This cause error following:\r\n====================================\r\nDatabase World is empty, auto populating it...\r\n>> Applying 'TDB_world_6.04_2016_04_11.sql'...\r\nmysql: [Warning] Using a password on the command line interface can be insecure.\r\n\r\n>> Done!\r\nDatabase Hotfixes is empty, auto populating it...\r\n>> Applying 'TDB_hotfixes_6.04_2016_04_11.sql'...\r\nmysql: [Warning] Using a password on the command line interface can be insecure.\r\n\r\n>> Done!\r\nUpdating Auth database...\r\n>> Auth database is up-to-date! Containing 3 new and 56 archived updates.\r\nUpdating Character database...\r\n>> Character database is up-to-date! Containing 3 new and 42 archived updates.\r\nUpdating World database...\r\n>> Applying update \"2014_10_19_00_world.sql\" 'C9D12A2'...\r\nmysql: [Warning] Using a password on the command line interface can be insecure.\r\n\r\n>> Applying update \"2014_10_19_01_world.sql\" '140B2E4'...\r\nmysql: [Warning] Using a password on the command line interface can be insecure.\r\nERROR 1054 (42S22) at line 1: Unknown column 'basehp3' in 'creature_classlevelstats'\r\n\r\nApplying of file '/opt/trinity/trinity-git/TrinityCore/sql/old/6.x/world/00_2014_10_19/2014_10_19_01_world.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.\r\nCould not update the World database, see log for details.\r\n====================================\r\n-----------------------\r\nResolve myself: delete dir  sql/old,then to skip ;not to repear error message \r\nDBUpdater: Given update include directory \"/opt/trinity/trinity-git/TrinityCore/sql/old/6.x/characters\" isn't existing, skipped!\r\n\r\n1. \r\n2. \r\n3. \r\n\r\n**Branch(es)**: 335/6x  \r\n\r\n**TC hash/commit**:  \r\n\r\n**TDB version**:  \r\n\r\n**Operating system**:  \r\n\r\n**Linking model**: static/dynamic\r\n\r\n\r\n[//]: # (This template is for problem reports, for other type of reports edit it accordingly)\r\n[//]: # (If this is a crash report, include the crashlog with https://gist.github.com/)\r\n"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/217792547","html_url":"https://github.com/TrinityCore/TrinityCore/issues/17103#issuecomment-217792547","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/17103","id":217792547,"user":{"login":"tkrokli","id":4903600,"avatar_url":"https://avatars.githubusercontent.com/u/4903600?v=3","gravatar_id":"","url":"https://api.github.com/users/tkrokli","html_url":"https://github.com/tkrokli","followers_url":"https://api.github.com/users/tkrokli/followers","following_url":"https://api.github.com/users/tkrokli/following{/other_user}","gists_url":"https://api.github.com/users/tkrokli/gists{/gist_id}","starred_url":"https://api.github.com/users/tkrokli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tkrokli/subscriptions","organizations_url":"https://api.github.com/users/tkrokli/orgs","repos_url":"https://api.github.com/users/tkrokli/repos","events_url":"https://api.github.com/users/tkrokli/events{/privacy}","received_events_url":"https://api.github.com/users/tkrokli/received_events","type":"User","site_admin":false},"created_at":"2016-05-09T07:19:13Z","updated_at":"2016-05-09T07:19:13Z","body":"@angelsss : maybe you need to rebuild your local source directory by deleting the existing one and clone it again from source. That usually fixes problems for me if there are any source file read issues."}}