Hello all,
I have a problem with running server.
The problem is that core want atribute "permission" in world.command table:
Using configuration file /home/tccata/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.0 29 Mar 2010 (library: OpenSSL 1.0.0 29 Mar 2010)
Using ACE version: 6.0.3
TrinityCore rev. 912808887749+ 2013-10-15 23:35:40 +0200 (4.3.4 branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/__ _ __ __/ __
/_/ / _ __ /_ ___ /_ , _ __ __
/`'__/ /' _ `/ / / /
/ / / _ _
_ _ _ _ _ _ __/`____
/_//_/ /_//_//_//_//__/ `/___/>
C O R E /___/
http://TrinityCore.org /__/
In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' in 'field list'
DatabasePool cata_world 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;MySecretUsername;MySecretPassword;cata_world
I have read a lot on forum and I did those steps:
1. - Downloaded TrinityCore via git clone https://github.com/TrinityCore/TrinityCore.git
2. - Then I used command git checkout 4.3.4 ( for switching to 4.3.4 branche )
3. - After this I used git reset HEAD~10 - some files were downloaded...
4. - I checked if there is a BuradinHold folder in src/scripts/EasternKingdoms - it was, so I thought that 4.3.4 files were downloaded
5. - config, make, install - succesfully
6. - Google, found this - http://collab.kpsn.org/pages/viewpage.action?pageId=1704351
7. - I used command ( in my home directory ) - git clone https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha.git
8. - Then I've downloaded TDB_full_434.05_2013_07_17.7z, which should be the newest one.
9. - Extracted TDB_full_434.05_2013_07_17.7z, executed to worldDB file from it.
10. - Then I've opened TrinityCore_4.3.4_DB_Alpha and used commands:
cd updates
cat *.sql > updtm.sql
11. - Tried to execute on world DB - allright.
12. I've re-written the config files to MySQL connection
13. - The lucky number - I've got the error
So, I've read DatabasePool cata_world NOT opened. There were errors opening the MySQL connections. -First think - there's wrong connection string in my config, but it is not..
I want to ask you for check my procedure for some wrong steps or errors and what to insted.
Thx so much, Thomson