[SOLVED] 4.3.4 World DB error

[Mathias]

Hey i get this error when i run worldserver i used all updates but still getting it

In mysql_stmt_prepare() id: 55, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' in 'field list'
DatabasePool world_4.3.4 NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;trinity;trinity;world_4.3.4

and before you say it yes the account yes the auth can connect without any problemes using trinity trinity DB

 

[ExonatioN]

Well this is because you haven't executed all your sql updates in the update folder, i fixed this for a guy via teamviewer who had the same error, merge them all together and run the merged sql.

 

[Mathias]

yeah well i did that..

 

[Hyperion]

There has to be something you missed, that error only appears when not updating the DB fully like ExonatioN said ( unless your mysql info actually IS wrong =P )

 

[Mathias]

hmm yeah i dont know and i sort of dont have any idea of what i am doing wrong

 

[Tommy]

Well, even though you said you did, you didn't run this specific update. Here is the update needed:

ALTER TABLE `command` CHANGE `security` `permission` SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL;


-- Player commands
UPDATE `command` SET `permission` = 7 WHERE `permission` = 0;
-- Moderator commands
UPDATE `command` SET `permission` = 8 WHERE `permission` = 1;
-- GM commands
UPDATE `command` SET `permission` = 9 WHERE `permission` = 2;
-- administrator commands
UPDATE `command` SET `permission` = 10 WHERE `permission` = 3;
-- console commands
UPDATE `command` SET `permission` = 12 WHERE `permission` = 4;

 

[Mathias]

ya it worked now

 

[Mathias]

nvm i got another one this time its

[1054] Unknown column 'quest_repeatable_rate' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

i am using http://collab.kpsn.org/pages/viewpage.action?pageId=1704351

 

[Tommy]

All you need to do is find the query related to your issue and run it. Just because it says + DB Updates doesn't necessarily mean it actually has ALL the updates. TrinityCore lack the knowledge to update ONLY their main DB source when making new queries. They inappropriately spam SQL updates all the time.

Here is where you need to look: https://github.com/TrinityCore/TrinityCore/tree/4.3.4/sql/updates/world

OR in your "SOURCE/sql/updates/world"
Older queries will be "SOURCE/sql/old/4.3.4"

I found the query in less than 2 seconds of searching:

ALTER TABLE `reputation_reward_rate` ADD `quest_repeteable_rate` FLOAT NOT NULL DEFAULT '1' AFTER `quest_weekly_rate`;

Just remember as I said, just because it says + DB Updates doesn't mean that it comes with all the updates..

 

[Mathias]

i figured out what i have done wrong mark as solved its just me that was really tired to day and didnt do exactly as i should

 

[Tommy]

I figured out what you were doing wrong too. :3

Marking as solved..