Jump to content
  • 0

Sql error cant create character ingame...


Shaorin

Question

Posted

hey all i ahve frechly pulled source on mangos one, not costum stuff nothing deleted everything and installed the db 2 times. but when i try to amke a character ingame i get this serror was not there before something it broke. what to do?

 

SQL ERROR: mysql_stmt_bind_param() failed

SQL ERROR: Using unsupported buffer type: 436770736  (parameter: 3)
SQL: can not 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, watchedFaction, drunk, health, power1, power2, power3, power4, power5, exploredZones, equipmentCache, ammoId, knownTitles, actionBars) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) '
SQL ERROR: No data supplied for parameters in prepared statement

if anyone know how to fix and can comit a fix the core please do so,, thanks for the help, 

5 answers to this question

Recommended Posts

Posted

What is your characer DB version?

Also just to be 100% certain, this is a fresh install of both the MaNGOS Rel21 Database with all updates and the MaNGOS Rel21 Corefiles?

 

I see a lot of your posts asking about updating/patching out of date and sometimes database and code from other projects.

 

Posted

and yea about the updateing stuff im just intressted in updateing a older core i ahve 3.2.2 trinity but i cant do it mayself sadly,,,,, and those 2 run on diffrent mysql server aswell.

Posted
On 5/11/2017 at 1:02 AM, Shaorin said:

and yea about the updateing stuff im just intressted in updateing a older core i ahve 3.2.2 trinity but i cant do it mayself sadly,,,,, and those 2 run on diffrent mysql server aswell.

Is this still a problem? I have been doing some research on it but had some real life stuff cause trouble.

Posted
Quote

this serror was not there before something it broke. what to do?

If this error was not happening before, and started recently... I would retrace your steps. Did you make changes somewhere?
Also what is the DB version of your character database?

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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