It looks to me like there is a problem with your settings for the auth DB
[ERROR]: In mysql_stmt_prepare() id: 51, sql: "SELECT type, time, data FROM acco
unt_data WHERE account = ?"
[ERROR]: Unknown column ‘account’ in ‘where clause’
~DatabaseWorkerPool for ‘’.
~DatabaseWorkerPool for ‘characters’.
~DatabaseWorkerPool for ‘world’.
Or, the fact that you have mixed mysql 5.1 with 5.5 is causing prepared statements to mess up, just like it says in the warning.
I am new to TrinityCore, and I have my server completely updated and installed. The server was giving a MySQL server mismatch, so I downloaded the version to match it. Now, when I run worldserver.exe, it closes. (Note: authserver.exe works perfectly fine) I anticipated that the error would be inside Server.txt, but this is all it gave me
[CODE]2011-03-06 16:25:58 Using configuration file worldserver.conf.
2011-03-06 16:25:58 TrinityCore Rev: 0 Release Hash: Archive (Win32, little-endian) (core-daemon)
2011-03-06 16:25:58 to stop.
2011-03-06 16:25:58 ______ __
2011-03-06 16:25:58 /__ _\ __ _/\ _
2011-03-06 16:25:58 //\ / _ __ /_\ ___ /_\ \ ,\ __ __
2011-03-06 16:25:58 \ \ /`‘__/\ \ /’ _ `/\ \ \ / /\ /\ \
2011-03-06 16:25:58 \ \ \ \ / \ \ /\ /\ \ \ \ \ _\ \ _\ \
2011-03-06 16:25:58 \ _\ _\ \ _\ _\ _\ _\ _\/`___ \
2011-03-06 16:25:58 //// ////////// `/_/> \
2011-03-06 16:25:58 C O R E /___/
2011-03-06 16:25:58 http://TrinityCore.org /__/
[/CODE]
It also says that my revision is 0. But, I went into the Database and executed query SELECT * FROM version; on my world database and it said I am running on Rev 11360. I searched around and it told me to recreate my characters database. I did this, and it did not fix the error. Any way to fix this error? Below is the configuration for my authserver.conf and my worldserver.conf
Authserver
Worldserver
The rev 0 part is because you are using an old revision of git and/or have not installed properly git extensions.
As for the crash, try running from the command line (start->run->cmd) and see if it prints the error there.
Okay, I opened worldserver.exe again and I saw a little something ( [ERROR]). It gave me these two errors on startup:
[ERROR]: In mysql_stmt_prepare() id: 51, sql: "SELECT type, time, data FROM account_data WHERE account = ?"[ERROR]: Unknown column 'account' in 'where clause'–EDIT: In regards to git, I pulled the latest material and git returned with this error:
[CODE]C:\Program Files\Git\bin\git.exe pull --progress “origin”
error: unknown object type 0 at offset 65861 in .git/objects/pack/pack-86e2627b85eb13edbc3590cc8ab98e65a70617e0.pack
error: failed to read object 6c91d28eaa1f1e009d32bb87fb49a70b7158edf3 at offset 65861 from .git/objects/pack/pack-86e2627b85eb13edbc3590cc8ab98e65a70617e0.pack
fatal: packed object 6c91d28eaa1f1e009d32bb87fb49a70b7158edf3 (stored in .git/objects/pack/pack-6c91d28eaa1f1e009d32bb87fb49a70b7158edf3.pack) is corrupted
remote: Total 210 (delta 146), reused 3 (delta 0)[K
fatal: index-pack failed[/CODE]
Fixed. Changed column ‘accountId’ to column ‘account’. Fixed it. Still having problems with the git though.
Manually changing DB field name without knowing why your DB is different from what the core expect is a recipe for disaster. You might have corruption later on too. Check again which DB revision you use and which core revision you use.
You better off go through the SQL updates, checking which revision you missed out this change because changing the field name may not be the only change submitted on that revision.
Cheers…
BC
— Canned message start
It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread.
— Canned message end —
Facing a new error after I updated DB & Core to the latest available. World crashes emitting following error:
[ERROR]: In mysql_stmt_prepare() id: 154, sql: “INSERT INTO channels(name, team,lastUsed) VALUES (?, ?, UNIX_TIMESTAMP())”
[ERROR]: Unknown column ‘name’ in ‘field list’
Apply the proper SQL updates for your core revision. Looks like you have missed at least https://github.com/TrinityCore/TrinityCore/commit/3973d1b45444c0c8fcd7aa1e033be4329dce05ae#diff-1
— Canned message start
It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread.
— Canned message end —
wow_trinity@luckshot-gamers:~/build$ screen -AmS mk_tri
C O R E /\___/
http://TrinityCore.org \/__/
Daemon PID: 27294
Opening databasepool 'world'. Async threads: 1, synch threads: 1
MySQL client library: 5.0.51a
MySQL server ver: 5.0.51a-24+lenny5
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.51a
MySQL server ver: 5.0.51a-24+lenny5
Connected to MySQL database at 127.0.0.1
Databasepool opened succesfuly. 2 total connections running.
Opening databasepool 'characters'. Async threads: 1, synch threads: 2
MySQL client library: 5.0.51a
MySQL server ver: 5.0.51a-24+lenny5
Connected to MySQL database at 127.0.0.1
[ERROR]: In mysql_stmt_prepare() id: 177, sql: "DELETE FROM game_event_save WHERE eventEntry = ?"
[ERROR]: Unknown column 'eventEntry' in 'where clause'
~DatabaseWorkerPool for ''.
~DatabaseWorkerPool for 'characters'.
~DatabaseWorkerPool for 'world'.
Cannot find a Solution. Google got me no Reasons/Solutions
Please Help Me /emoticons/default_sad.png
In the commit, the file https://github.com/TrinityCore/TrinityCore/blob/90a3fee2329571863e907315fc6b5bfc7d1c96f5/sql/updates/auth_char/2011_03_18_0_characters_game_event_misc.sql does not have the DROP TABLE for the temp table.
it does now.
— Canned message start
It appears the issue in the original post was solved, so this thread shall be closed. Should you encounter any other difficulties, please open a new thread.
— Canned message end —
I have the newst core rev.
…
…
Initialize game time and timers
Starting Map System
Starting Game Event system…
Player::DeleteOldChars: Deleting all characters which have been deleted 30 days before…
Starting Arena Season…
Speicherzugriffsfehler
Why this? All updates are in the Database…
Lol i don’t see any error?
Speicherzugriffsfehler
Memory access error ← English
right … didn’t know that. What’s your core rev?
The newst rev, i have make the core from 20min