Newest Core: Error: sql ... failed

[tendonsie]

I'm using Centos 5.6 32bit with all newest updates.

MaNGOS Core: [11739]

Tryed with, and without ScriptDev2.

Normal Mode: If you log in as administrator: crash of server with "segmentation fault"

After that compiled the server in debug mode.

Mysql account have all rights, mysql version 5.0.77

How do I solve this? Thanks.

The following information I have in debug mode:

2011-07-15 18:11:09 SERVER STARTUP TIME: 0 minutes 28 seconds

2011-07-15 18:11:09 Starting up anti-freeze thread (50 seconds max stuck time)...

2011-07-15 18:11:09

2011-07-15 18:14:08 ERROR:SQL ERROR: mysql_stmt_bind_param() failed

2011-07-15 18:14:08 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4)

2011-07-15 18:14:08 ERROR:SQL: cannot execute 'INSERT INTO account_data VALUES

(?,?,?,?)'

2011-07-15 18:14:08 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

2011-07-15 18:14:08 ERROR:SQL ERROR: mysql_stmt_bind_param() failed

2011-07-15 18:14:08 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4)

2011-07-15 18:14:08 ERROR:SQL: cannot execute 'INSERT INTO account_data VALUES

(?,?,?,?)'

2011-07-15 18:14:08 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

2011-07-15 18:14:08 ERROR:SQL ERROR: mysql_stmt_bind_param() failed

2011-07-15 18:14:08 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4)

2011-07-15 18:14:08 ERROR:SQL: cannot execute 'INSERT INTO account_data VALUES

(?,?,?,?)'

2011-07-15 18:14:08 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

2011-07-15 18:14:20 ERROR:SQL ERROR: mysql_stmt_bind_param() failed

2011-07-15 18:14:20 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 3)

2011-07-15 18:14:20 ERROR:SQL: cannot execute 'UPDATE item_instance SET data = ?, owner_guid = ? WHERE guid = ?'

2011-07-15 18:14:20 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

2011-07-15 18:14:21 ERROR:SQL ERROR: mysql_stmt_bind_param() failed

2011-07-15 18:14:21 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4)

2011-07-15 18:14:21 ERROR:SQL: cannot execute 'INSERT INTO character_account_data VALUES

(?,?,?,?)'

2011-07-15 18:14:21 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

2011-07-15 18:14:21 ERROR:SESSION: received not allowed opcode CMSG_LFG_GET_STATUS (0x0296)

2011-07-15 18:15:01 GameEvent 43 "Hammerfall Under Attack" started.

2011-07-15 18:15:55 ERROR:SQL ERROR: mysql_stmt_bind_param() failed

2011-07-15 18:15:55 ERROR:SQL ERROR: Using unsupported buffer type: -1657095852 (parameter: 5)

2011-07-15 18:15:55 ERROR:SQL: cannot execute 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, dungeon_difficulty, position_x, position_y, position_z, orientation, taximask, online, 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, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, specCount, activeSpec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars) VALUES

(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) '

2011-07-15 18:15:55 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

2011-07-15 18:15:56 ERROR:SQL ERROR: mysql_stmt_bind_param() failed

2011-07-15 18:15:56 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4)

2011-07-15 18:15:56 ERROR:SQL: cannot execute 'INSERT INTO character_account_data VALUES

(?,?,?,?)'

2011-07-15 18:15:56 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

If we search on the error type:

http://dev.mysql.com/doc/refman/5.0/en/mysql-stmt-bind-param.html

Error: 2036 (CR_UNSUPPORTED_PARAM_TYPE)

Message: Using unsupported buffer type: %d (parameter: %d)

[VladimirMangos]

Very strange. Releated code lines:

       stmt = CharacterDatabase.CreateStatement(insId, "INSERT INTO account_data VALUES
(?,?,?,?)");
       stmt.PExecute(acc, uint32(type), uint64(time_), data.c_str());

So, uint32, uint32, uint64, char const*

So look like pointing to "char const*"

But in

2011-07-15 18:15:55 ERROR:SQL ERROR: Using unsupported buffer type: -1657095852  (parameter: 5)
2011-07-15 18:15:55 ERROR:SQL: cannot execute 'INSERT INTO characters 

It point to "class," that uint8

[Patman128]

Maybe a problem with your MySQL client library?

[VladimirMangos]

I am also think about this. Maybe it old or not compatible with mysql server itself by other reasons.

[tendonsie]

Okay thinks. I will try!

[tendonsie]

Updated mysql and tryed new build/compile.

mysql-devel-5.0.77-4.el5_6.6.i386.rpm

mysql-5.0.77.4-el5_6.6.i386.rpm

mysql-server-5.0.77-4.el5_6_6.i386.rpm

Problem not fixed. Same error in the debug mode.

[tendonsie]

Alsof if I logout I get this:

Remove player Tendonsie from grid[62,62]

Player: channels cleaned up!

SESSION: Sent SMSG_LOGOUT_COMPLETE Message

SQL: START TRANSACTION

SQL ERROR: mysql_stmt_bind_param() failed

SQL ERROR: Using unsupported buffer type: -1670337708 (parameter: 5)

SQL: cannot execute 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, dungeon_difficulty, position_x, position_y, position_z, orientation, taximask, online, 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, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, specCount, activeSpec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars) VALUES

(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) '

SQL ERROR: No data supplied for parameters in prepared statement

SQL: ROLLBACK

WORLD: Received CMSG_UPDATE_ACCOUNT_DATA

UAD: type 1, time 1311092589, decompressedSize 453

SQL: START TRANSACTION

SQL ERROR: mysql_stmt_bind_param() failed

SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4)

SQL: cannot execute 'INSERT INTO character_account_data VALUES

(?,?,?,?)'

SQL ERROR: No data supplied for parameters in prepared statement

SQL: ROLLBACK

WORLD: CMSG_READY_FOR_ACCOUNT_DATA_TIMES

CMSG_REALM_SPLIT

[0 ms] SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.equipmentCache FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '32' ORDER BY characters.guid

If I run the server in this "debug" mode for players, it that good? Because in debug mode he doesn't crash.

If we don't find any solution.

[tendonsie]

Problem FIXED!

Solution:

Mysql Version 5.0.x with yum update = doesn't work. (Centos 5.6 32bit)

Mysql Version 5.0.x with directadmin script = does work, and is a little bit older then the 4.0.x of Centos Yum.

No errors and no crashes. 4.x also doesn't work.

Thanks for the help of VladirMaNGOS and Patman128!