Jump to content

Newest Core: Error: sql ... failed


Guest tendonsie
 Share

Recommended Posts

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)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use