can't create characeters (missing SQL write values) [zero]

[alabastardeuce]

Made it past the "logging into server problem" (some combo of needing 127.0.0.1 instead of actual IP for configs/realm DB/realmlist.wtf & not having a matching port between DB realmlist entry and "worldserverport" config) -

Anyhow; upon attempting to create a character in the client; I immediately get spit back to the char select screen (w/o a new char) and the mangosd.exe box spits the following:

SQL: can not execute 'UPDATE account SET last_ip = ? Where username = ?

SQL error: Truncated incorrect Double value: 'ADMINISTRATOR'

SQL: can not execute 'UPDATE account SET last_ip = ? Where username = ?

SQL error: Truncated incorrect Double value: 'ADMINISTRATOR'

//EXTRA EDIT: I double checked the realmd DB; and it indicates that the parameter input for "username" (which I am certain is where it got the value 'administrator' from) - only receives "varchar32" type values; NOT doubles; which is making this torturous to try to fix.. Its also perhaps relevant that It is always referencing the first account in the list; whichever that happens to be; despite my logging into the game with an account further down the list

// EDIT: Although I "somewhat" doubt this is relevant to the issue at hand; I do not yet have the script2dev files/config in my setup - the folly encompassing that endeavor can be viewed here-- https://www.getmangos.eu/help-amp-support/9788-scriptdev2-error-zero.html

//more likely real issue:

SQL error: mysql_stmt_bind_param() failed

SQL error: Using unsupported buffer type: 213765656 (parameter: 3)

SQL: can not execute ' INSERT INTO characters (guid,account,name,race,class,gender,xp,money....)

Values ( ?,?,?,?,?,?,?,?,?,?,?,?...)

SQL error: No data supplied for parameters in prepared statement

// EXTRA EDIT: this has every appearance of " mySQL version related syntax error" to me.... to that end; Mangosd tells me I have : MySQL client library: 5.0.20a //// MySQL server ver: 5.5.37-log /// ... Is this a problem?

[wolverine]

Well, I'm assuming that you are using the database that comes with MaNGOS. You did install it, right? Without it, there are no tables and there are more tables and databases in MaNGOS than I would ever wish to manually install myself.

Also, there is already an ADMINISTRATOR account in the realm/accounts table.

And if I am reading the output wrong and your trying to use a "ADMINISTRATOR" account to write to your database, did you create the "ADMINISTRATOR" account on your SQL server already?

[alabastardeuce]

Yes; Initially I had imported the "full_db.sql" file onto its own schema and patched; however I soon found out from the readme that It is actually to be applied to the mangos schema; So I just imported the previously made "full_db.sql" and the 2 patches there as well;

A dumb mistake; However I still get both the same errors from the initial post; despite this time creating from the console and using an account with "0" as the gmlevel :OO and the full DB in the proper schema... yikes

[wolverine]

Alright. I always use

account create <user> <password>

I don't bother giving it a expansion level with MaNGOS 0 because there is no expansion, besides 0. And if you get in to later versions of mangos, you can always manually change the expansion in the database directly. It's actually kinda simple.

In fact, I don't remember ever using an expansion number while creating an account, I just changed it in the database.

Hope this helps in some fashion.

[alabastardeuce]

yaa now that u mention it; it DOES seem quite suspicious to need to set the expansion to "1" for mangos "zero" :rolleyes:... tried reverting the gmlevel 0 account's "expansion level" to "0"; still getting both errors...

I suspect this has to do improper set up of the mangos DB so I'll quickly review the process I went to get it set up (mySQL):

imported "mangos.SQL" (and the other 2 to their own schema) to a manually created SQL schema called mangos (never ran createmangos.sql; however the mangos/realmd/characters.sql files set the proper utf 8 collation themselves (?); and I manually gave the account used in the configs full privileges from any address (%)- EXTRA EDIT: and am using a separate account from root; as this was suggested somewhere else on this forum as good practice)

Used the "make_full_db.bat" to create the "full_db.sql" file (can't remember specifically since i did this part about a week ago)

imported "full_db.sql" to the mangos schema

imported "210_corepatch_mangos.sql" and "210_updatepack.sql" to the mangos schema

...not that this info is likely to help with the first error block in the first post :OO

[antz]

Mangos Zero normally expects MySql version 5.5 (i think !, the wiki lists the correct version number) - If you are running a very old version of mySql you might possibly hit issues.

[antz]

Which version of Zero are you using ? master or Rel19 ?

[alabastardeuce]

Ya I used the link from the 18.1 wiki for it and am quite certain I DL'ed the right one all I'm looking for is confirmation that this output (from the mangos daemon) :

MySQL client library: 5.0.20a //// MySQL server ver: 5.5.37-log ///

Is the same for people that have working zero servers.

Id bet theirs is the same since I "followed" the guide as far as DLing and installing mySQL; it just looks suspicious to me since the guide recommends version 5.5, and yet the daemon alleges that my client library is before that (see 3 lines above); granted I currently don't know NUFFIN' about the client/server SQL relationship- and thus can't know as well- whether or not the difference is even relevant in the context of the problems of the first post...

I had been running the master; But have most recently taken to trying Rel19; but cant get VS 2010 to build it just yet; I'll make a new thread with the output If I can't fix it soon.

EDIT: I'm only at 15/25 build parts succeeded w/ rel19; and a slew of errors that would involve a much deeper understanding of the code to solve- an understanding I'll pursue on my own for now as I'm not sadistic enough to pastebin the 100+ lines of problems for someone else to languish over >< ... I'm probly just going to try the debug version of the master and failing that; possibly switch to a different DB handler than mySQL. (or take rifle shots at fixing the rel19 compile issues... because the error output is so god damn far downstream its virtually irrelevant to the actual fixes required :mad:)

EDIT2: compiled the "master-debug" zero server today: however I still get both the errors from the first post; in addition to scriptdev2 issues from the other thread pointed at by the first post; so ima try whats 2 lines above tomorrow.

EDIT3: spent today initially following the advice from this thread:: https://www.getmangos.eu/oldinstallation-configuration-amp-upgrades/6109-mangoszero-tbb-ace-fail-build.html?highlight=unknown+switch+%2Fupgrade :: as I have the same "unknown switch /upgrade" error as my first error when compiling Rel19 on VS 2010 express (first error being known to cause the later ones sometimes ><) - however upon downloading the SP1 update for VS 2010 express; (and updating it thru windows update) not jack shit changed for me: I then went on to try installing VS ultimate 2013 to compile only to be given the exact same errors... (granted I tried the .sln from the VS 2010 for that attempt... I'm too bugged out to know how to manually do Cmake's job for a VS 2013 version)- so in the next few days; Ima wipe my OS (got all types of conflicting VS bloat) - and hopefully I'll find a VS 2010 somewhere that has the alleged MASM support/SP1 alongside itself... however I have a sinking feeling that the problems are more DB related than actually being "an error than was fixed between the master and Rel19 release" - so for now I'll focus on setting up maria/postgres

[alabastardeuce]

Following the advice from this thread :: https://www.getmangos.eu/archived-help/9435-sql-execute-update-account-set-last_ip-username-ca.html?highlight=mySQL+libraries :: I was able to fix having the identical problem as that guy (the first error block from first post); For me this involved using Cmake and rebuilding all over again to make sure I had the right filepath for the mySQL libraries; which for me was 'libmysql.lib' (I initially had about 3 different folders with full install files of mySQL 5.5...dont ask; and must have pointed to one of the libs from an install I wasnt actually using the host the DB; or simply picked the wrong file within the lib folder)...

However this error from the first post:

2014-05-27 14:22:41 ERROR:SQL ERROR: mysql_stmt_bind_param() failed

2014-05-27 14:22:41 ERROR:SQL ERROR: Using unsupported buffer type: 219312808 (parameter: 3)

2014-05-27 14:22:41 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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) '

2014-05-27 14:22:41 ERROR:SQL ERROR: No data supplied for parameters in prepared statement

Is still there; despite most recently uninstalling all mySQL and rebuilding the DB from scratch as well; this time following the wiki guide to a tee... Tho I wound up just using mySQL again for starters; alongside the revelation that in order to even touch postgre; you must already have it all set up on mySQL and port it over: Yet I'll likely have to take this step for lack of any less time consuming way to get past this ><.

[alabastardeuce]

I'm not going to port over to Postgre just yet; this thread :: https://www.getmangos.eu/oldgeneral-support/6100-core-error-sql-failed.html?highlight=data+supplied :: points to a somewhat similar issue; with the main culprit alleged to be "mismatched client/server versions" (which AFAIK means that porting over to postgre/maria wouldnt do anything since postgre/maria depend on the client/server version files of mySQL anyhow) ; that said I'd REALLY love some confirmation that anyone is able to run mangos zero with the following versions :

MySQL client library: 5.0.20a //// MySQL server ver: 5.5.37-log

(this can be easily viewed in the very early lines of the output logs whose name defaults to 'world-server.log' in the same directory as mangosd.exe )

google is very unfriendly about the premise of independently updating/ ones mySQL client library; yet there were some forums about SQL plugins that manage this type of situation- although none I saw explicitly referenced updating the client library for a DB (most talked about simply the server ver)

any insight on either of these points (plugins to update/if u use same versions) would be ideal; as my current ratio of timespent/'likelihood of a fix' is absolute garbage for this problem ><

[antz]

This is definitely a character DB issue.

So forgive my if you've tried the following already and i've missed it.

1) Rename / remove you current characters database

2) Create a blank database Characters

From the mangos Repo mangoszero/server · GitHub

3) Import sql/Characters.sql

This will set you on version z1794_s1350_11716_09_characters_auction of the database, which is the current version.

4) Create a new account, then logon the attempt to create a character again

[alabastardeuce]

SUCCESS!!

Finally got char create to work; I just wish the reasons behind why it wasn't working weren't so weak >< :

The fix for me involved either (or both) upgrading from the current master (which i believe is synonymous with 18.1) to Rel19; in addition to actually applying the proper .sql updates to the DB- ( previously I hadn't done this and posted about it; as I recall I tried to import each update 1 by 1 and received an error for "all" of them- tho I most likely missed the single ordinal one required at that time- in addition to the wiki guide not even mentioning the updates as necessary)- the Rel19 fortunately had upgraded error output that pointed me in the right direction as far as the only 3 or so updates actually needed. Huge thanks to those responsible for the Rel19!

[antz]

Glad you're up and running.

Rel19 has been 3 months of virtually single handed hell for me, but hopefully will be worth it for the result of a seriously cleaned up build system.

[dany]

Yes; Initially I had imported the "full_db.sql" file onto its own schema and patched; however I soon found out from the readme that It is actually to be applied to the mangos schema; So I just imported the previously made "full_db.sql" and the 2 patches there as well