[Mangos One] Character Creation MySQL Error

[rayon]

I'm having a issue with Mangos One characters database I think.

I followed Rel+21 guide and everything worked like a charm I executed realmd.exe and mangos.exe It loads perfectly, I start WoW, enter the realm, create a character and when I hit "create character" this error shows up:

Tried everything, execute characters.sql DB again, install other version of mysql and nothing works..

Need help please.

[Olion]

Did you browse this thread?

The only issue I can imagine here is the wrong libmySQL.dll found by the CMake script (does not corresponding to the running server version). Could you show the version lines from your either world-server.log or realm-list.log?

2015-12-22 22:12:52 MySQL client library: 5.5.37
2015-12-22 22:12:52 MySQL server ver: 5.1.55-community

Also, was it 32-bit or 64-bit build? All components involved (OpenSSL, MySQL) should have the same type. I personally prefer 32-bit.

[rayon]

it was built in 32 bit. I think the error can be with the libmySQL.dll. at the start It said I was missing the file and where do you guys get it?

[Olion]

To find the correct dll manually, search for and open the text file CMakeCache.txt, and find in the text the name MYSQL_INCLUDE_DIR. For instance, I have the following there:

MYSQL_INCLUDE_DIR:PATH=C:/Program Files (x86)/MySQL/MySQL Server 5.1/include
MYSQL_LIBRARY:FILEPATH=C:/Program Files (x86)/MySQL/MySQL Server 5.1/lib/opt/libmysql.lib

You have the first variable defined, otherwise the build would fail do not providing mangosd.exe. In the MySQL main dir (in my example, C:/Program Files (x86)/MySQL/MySQL Server 5.1) find the folder named lib. Under this one you find libmysql.dll, use it from opt/ subfolder (optimized) since you do not need the debug version of the library. Just copy it to the folder with the built executable files. Hopefully it will be enough.

Two final notes.

1. Didn't you overlook this note in the manual?

NOTE Due to a restriction of MySQL, you can either install the 32Bit OR 64Bit libraries but not both. Install the version you intend to run on your server.

2. You must be sure the same version of mysqld is running as found while building. Open Task Manager, press "Show processes from all users", display column "Path to the image file" and find mysqld.exe. The path should point somewhere around the header files, MYSQL_INCLUDE_DIR. In my case, it was C:/Program Files (x86)/MySQL/MySQL Server 5.1/bin/mysqld.exe.

[rayon]

got fixed today. was really a libmysql.dll error! thanks everyone