[Character twitching issue, on Unix based system only.]

Oh darn it.. let's get onto the Bugtracker then.. I am really sorry.

 

The hash I was running on is at the very begning of 2017: https://github.com/TrinityCore/TrinityCore/commit/e3700df8fa8b92fbd70a32aa0c63d138d02c569f

 

Once again, sorry for not searching a tad more.

 

[Character twitching issue, on Unix based system only.]

Hi there! I was wondering if anyone could help me trace an issue, what might be able to cause it. While running TC(3.3.5) branch, and the hash is not important since it's like this for a while now, the character when pressing C, twitches, while having applied a weapon enchantment. Take for example, sharpening stone, or RockBiter weapon. While trying to identify the issue I have noticed that compiling the core under Windows, it works just fine. As soon as I move it to centOS, it reappears. I am merely asking if anyone ever had something similar like this and if they could point me towards where the real problem might be.

 

Really sorry if this has not been posted in the appropriate section, but I couldn't find anything related to it for about two months now.

["unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page]

Hi. I recently tried to make my server working via Linux.

I`m using a VPS with: CentOS 5

Trinity COre:(I used the guide from wiki to install libAce, succesfully, and I'm trying to make Jeutie's pack working. I keep getting problems over problems, but this I really can't fix it because I can't find any default characters.sql file.

I`m not sure what I need but anyway, please try to help me if you can.

It goes like THIS:

Opening databasepool 'world'. Async threads: 1, synch threads: 1

MySQL client library: 5.0.77

MySQL server ver: 5.0.77

MySQL client library: 5.0.77

MySQL server ver: 5.0.77

Databasepool opened succesfuly. 2 total connections running.

Opening databasepool 'characters'. Async threads: 1, synch threads: 2

MySQL client library: 5.0.77

MySQL server ver: 5.0.77

[ERROR]: In mysql_stmt_prepare() id: 14, sql: "SELECT guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags, position_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, online, death_expire_time, taxi_path, instance_mode_mask, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, instance_id, speccount, activespec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars, grantableLevels FROM characters WHERE guid = ?"

[ERROR]: Unknown column 'grantableLevels' in 'field list'

[ERROR]: In mysql_stmt_prepare() id: 19, sql: "SELECT quest, status, explored, timer, mobcount1, mobcount2, mobcount3, mobcount4, itemcount1, itemcount2, itemcount3, itemcount4, playercount FROM character_queststatus WHERE guid = ?"

[ERROR]: Unknown column 'playercount' in 'field list'

MySQL client library: 5.0.77

MySQL server ver: 5.0.77

MySQL client library: 5.0.77

MySQL server ver: 5.0.77

Databasepool opened succesfuly. 3 total connections running.

Cannot connect to Character database -----------------------------------;characters

~DatabaseWorkerPool for ''.

~DatabaseWorkerPool for 'characters'.

~DatabaseWorkerPool for 'world'.

Thank you.