[Mangos Zero] Cannot create a character and SQL Error

[Symons]

Hey guys,

I've ran through every guide that I can find on these forums, on the github and through the stickies. I've installed completely fresh about 6 times and I always without fail get these errors.

I will attach a log for the support staff perusal.

The two errors that seem to be stopping me are

ERROR:SQL: can not execute 'UPDATE account SET last_ip = ? WHERE username = ?'
ERROR:SQL ERROR: Truncated incorrect DOUBLE value: 'ADMINISTRATOR'

and secondly:

ERROR:SQL: can not execute 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, 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, honor_highest_rank, honor_standing, stored_honor_rating , stored_dishonorable_kills, stored_honorable_kills, watchedFaction, drunk, health, power1, power2, power3, power4, power5, exploredZones, equipmentCache, ammoId, actionBars) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) '
2016-04-13 14:19:48 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

Any help would be awesome!

[ATTACH]334[/ATTACH]

[ATTACH]335[/ATTACH]

EDIT WITH SOLUTION

If your server binary folder (The ones with mangosd.exe and your databases) doesn't contain libmysql.dll, you need to retrieve it from your mySQL installation. It's contained within the lib folder.

world-server.txt

realm-list.txt

[Symons]

Reserved for DB_Version Tables + Additional Data

World:

version  structure  content  description          comment                                   
-------  ---------  -------  -------------------  ------------------------------------------
    21         10        1  warden_table_redone  Base Db Install from 21000_01 to 21.10.1  
    21         10        2  Morbent_Fel_fix      Weakened_Morbent_Fel_fix                  
    21         10        3  startup_error_fixes  fix_several_startup_errors                
    21         11        1  quest_relations      modify_quest_relations_tables             
    21         11        2  dbdocs_cleanup_pt1   dbdocs_cleanup_pt1_db_scripts  

Realm:

version  structure  content  description    comment                                   
-------  ---------  -------  -------------  ------------------------------------------
    21          1        2  dbdocs update  Base Database from 20150409 to Rel21_1_2  

Character:

version  structure  content  description          comment                                
-------  ---------  -------  -------------------  ---------------------------------------
    21          5        1  characters_pvpstats  Base Install of 21000_00 to Rel21_5_1  

[krill]

What MySQL version are you running?

[Symons]

What MySQL version are you running?

Server version: 5.6.24-log MySQL Community Server (GPL)

[antz]

The two errors that seem to be stopping me are

ERROR:SQL: can not execute 'UPDATE account SET last_ip = ? WHERE username = ?'
ERROR:SQL ERROR: Truncated incorrect DOUBLE value: 'ADMINISTRATOR'

and secondly:

ERROR:SQL: can not execute 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, 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, honor_highest_rank, honor_standing, stored_honor_rating , stored_dishonorable_kills, stored_honorable_kills, watchedFaction, drunk, health, power1, power2, power3, power4, power5, exploredZones, equipmentCache, ammoId, actionBars) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) '
2016-04-13 14:19:48 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

Since mangos doesn't actually use PHP - i'm guessing you are using a 3rd party application to do stuff.

Mangos accounts and characters tables have had some significant changes made since the introduction of the Warden and PlayerbotAI modules.

- I imagine that the code for writing to these tables needs to be updated in the PHP.

[Symons]

Since mangos doesn't actually use PHP - i'm guessing you are using a 3rd party application to do stuff.

Mangos accounts and characters tables have had some significant changes made since the introduction of the Warden and PlayerbotAI modules.

- I imagine that the code for writing to these tables needs to be updated in the PHP.

No third party application is being used. The PHP Code is just a habit picked up from forums over the years as it tends to leave the formatting in place and provides a smaller area so as to not paste a wall of text.

Those error codes are copy-pasted straight from the logs provided.

The tables are generated in SQLyog and just copy pasted into a "PHP format" for the reason stated above.

[Olion]

2016-04-13 14:19:11 MySQL client library: 5.0.20a
2016-04-13 14:19:11 MySQL server ver: 5.6.24-log 

Since the later realm/character DB dumps look ok at the first glance (though I did not use it recently during installation), the only idea I have at the moment is too large version difference between your SQL server and client library. The library is implemented with libMySQL.dll you have in the forlder with the server binaries. Where did you get the DLL? Try to use one from your MySQL installation instead.

[Symons]

2016-04-13 14:19:11 MySQL client library: 5.0.20a
2016-04-13 14:19:11 MySQL server ver: 5.6.24-log 

Since the later realm/character DB dumps look ok at the first glance (though I did not use it recently during installation), the only idea I have at the moment is too large version difference between your SQL server and client library. The library is implemented with libMySQL.dll you have in the forlder with the server binaries. Where did you get the DLL? Try to use one from your MySQL installation instead.

This is the solution. The library that was in my Server folder came from the built source files. There wasn't actually a libmysql.dll in the Server folder, so I copied the library (libmysql.lib) from the Source\build\bin\Debug folder.

The fix has come from grabbing both the library (libmysql.lib) and the dll (libmysql.dll) from my mySQL lib folder and placing it in with my server binaries.

Thanks heaps for the quick response and detailed help guys. Just for future reference, what actually needs to be in the Server folder? The .dll or the .lib?

[Olion]

Just for future reference, what actually needs to be in the Server folder? The .dll or the .lib?

AFAIK, *.lib is the windows object code library used for the static application building (like *.a libs under Linux). It contains the code to be included directly into the binary being created by the compiler, so the *.lib file is needed nevermore since the compilation is done. On the contrary, dynamically linked library (DLL) is included at the loading application stage (unsure about details, maybe at the loading just a placeholder is created, and the actual DLL code is loaded at the first call to it).

So, you need only libmysql.dll file in your server folder.

[krill]

Has this problem when i was setting up my server. Had to manually copy the libmysql.dll over. Perhaps we should have Cmake/EasyBuild copy the DLL over?

[Symons]

Has this problem when i was setting up my server. Had to manually copy the libmysql.dll over. Perhaps we should have Cmake/EasyBuild copy the DLL over?

That would be awesome

[Olion]

Just let the build system rest in peace plz