View Full Version : [SOLVED] [4.3.4] Database error, please help

10-23-2013, 04:31 PM

I installed TrinityCore 4.3.4, but I stuck at database installation. When I start the worldserver, I get the following error:

In mysql_stmt_prepare() id: 55, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' in 'field list'

I found a solution to run a specific sql query, which renames the security field to permissions, but after that, I get the following error:

[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 downloaded the main world sql here: http://www.trinitycore.org/f/files/download/9-tdb-full-434/ (TDB_full_434.05_2013_07_17.7z file),
then updated the database from here: https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha .

What did I do wrong?

10-23-2013, 04:59 PM
Here's the query for that:

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

10-23-2013, 05:02 PM
Ok, I'll try it

10-23-2013, 07:26 PM
Thanks for your help, It's working now! :D

10-23-2013, 07:32 PM
No problem, you're welcome. Marking as solved, if you have anymore issues create a new thread. \o/