Page 1 of 2

SQL DB error and can't create accounts

Posted: Wed Jan 16, 2019 8:41 am
by maveric3pr
I having SQL error when I up the DSGame-server...

-------------------------------------------------------------------------------------------

[Info] DarkStar[Status] do_init: begin server initialization... - [OK]
[16/Jan] [09:02:11][Status] do_init: map_config is reading - [OK]
[16/Jan] [09:02:11][Status] luautils::init:lua initializing... - [OK]
[16/Jan] [09:02:11][Status] do_init: sqlhandle is allocating - [OK]
[16/Jan] [09:02:11][Status] do_init: zlib is reading - [OK]
[16/Jan] [09:02:11][Status] do_init: loading items - [OK]
[16/Jan] [09:02:13][Status] do_init: loading spells - [OK]
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 0 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 0 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 0 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 0 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 0 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 0 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 0 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 1 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 1 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 1 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 1 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 1 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 1 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 1 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 2 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 2 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 2 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 2 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 2 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 2 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 2 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 3 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 3 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 3 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 3 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 3 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 3 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 3 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 4 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 4 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 4 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 4 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 4 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 4 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 4 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 5 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 5 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 5 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 5 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 5 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 5 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 5 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 6 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 6 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 6 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 6 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 6 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 6 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 6 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 7 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 7 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 7 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 7 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 7 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 7 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 7 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 8 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 8 AND pattern = 5 AND rank = 0
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 3' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 8 AND pattern = 5 AND rank = 3
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 2' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 8 AND pattern = 5 AND rank = 2
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 1' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 8 AND pattern = 5 AND rank = 1
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 6' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 8 AND pattern = 5 AND rank = 6
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 5' at line 1
SQL: SELECT itemid, points, max_points FROM guild_item_points WHERE guildid = 8 AND pattern = 5 AND rank = 5
[16/Jan] [09:02:13][Debug] UpdateGuildPointsPattern is finished. New pattern: 5
[16/Jan] [09:02:13][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', modifier, value, content_tag, meritid FROM traits ' at line 1
SQL: SELECT traitid, job, level, rank, modifier, value, content_tag, meritid FROM traits WHERE traitid < 128 ORDER BY job, traitid ASC, rank DESC
[16/Jan] [09:02:14][Status] do_init: loading zones - [OK]
[16/Jan] [09:04:32][Status] do_init: server is binding with port 54230 - [OK]
[16/Jan] [09:04:33][Debug] InitializeWeather Finished
[16/Jan] [09:04:33][Status] The map-server is ready to work...
=======================================================================
[16/Jan] [09:04:33][Debug] [Lua] Garbage Collected. Current State Top: 0
[16/Jan] [09:04:50][Debug] UpdateGuildsStock is finished
[16/Jan] [09:04:50][Debug] Player playtime saving finished
[16/Jan] [09:19:33][Debug] [Lua] Garbage Collected. Current State Top: 0

---------------------------------------------------------------------------------------------------------------------------------

I rebuild the DB several times and the build in VS2017, but still having the problem...

I'm using windows10, mysql 8.0 and for login using windower with xiloader and my server is local...

also i can't create account...

----------------------------------------------------------------------------------------------------------------------------------

[01/16/19 09:30:56] ==========================================================
[01/16/19 09:30:56] DarkStar Boot Loader (c) 2015 DarkStar Team
[01/16/19 09:30:56] Bug Reports: https://github.com/DarkstarProject/darkstar/issues
[01/16/19 09:30:56] Git Repo : https://github.com/DarkstarProject/darkstar
[01/16/19 09:30:56] ==========================================================
[01/16/19 09:30:56] Connected to server!
[01/16/19 09:30:56] Resolving host: DESKTOP-#######
[01/16/19 09:30:56] ==========================================================
[01/16/19 09:30:56] What would you like to do?
[01/16/19 09:30:56] 1.) Login
[01/16/19 09:30:56] 2.) Create New Account
[01/16/19 09:30:56] ==========================================================

Enter a selection: 2

[01/16/19 09:31:53] Please enter your desired login information.

Username (3-15 characters): thetest
Password (6-15 characters): 123456
Repeat Password : 123456


[01/16/19 09:32:10] Failed to create the new account. Username already taken.
[01/16/19 09:32:10] Connected to server!
[01/16/19 09:32:10] Resolving host: DESKTOP-#######
[01/16/19 09:32:10] Autologin activated!
[01/16/19 09:32:10] Failed to login. Invalid username or password.
[01/16/19 09:32:11] Connected to server!
[01/16/19 09:32:11] Resolving host: DESKTOP-#######
[01/16/19 09:32:11] ==========================================================
[01/16/19 09:32:11] What would you like to do?
[01/16/19 09:32:11] 1.) Login
[01/16/19 09:32:11] 2.) Create New Account
[01/16/19 09:32:11] ==========================================================

Enter a selection:

--------------------------------------------------------------------------------------------------------------

[Info] DarkStar[16/Jan 09:02][Info] Console Silent Setting: 0
[16/Jan 09:02][Status] The login-server-auth is ready (Server is listening on the port 54231).

[16/Jan 09:02][Status] The login-server-lobbydata is ready (Server is listening on the port 54230).

[16/Jan 09:02][Status] The login-server-lobbyview is ready (Server is listening on the port 54001).

[16/Jan 09:02][Status] The login-server is ready to work...
[16/Jan 09:02][Status] Console input thread is ready..
[16/Jan 09:32][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('123456'),'2019:01:16 09:32:10',NULL,1,1)' at line 1
SQL: INSERT INTO accounts(id,login,password,timecreate,timelastmodify,status,priv) VALUES(1000,'thetest',PASSWORD('123456'),'2019:01:16 09:32:10',NULL,1,1);
[16/Jan 09:32][Info] login_parse:127.0.0.1shutdown socket...
[16/Jan 09:32][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('123456')' at line 1
SQL: SELECT accounts.id,accounts.status FROM accounts WHERE accounts.login = 'thetest' AND accounts.password = PASSWORD('123456')
[16/Jan 09:32][Warning] login_parse: unexisting user<thetest> tried to connect
[16/Jan 09:32][Info] login_parse:127.0.0.1shutdown socket...

--------------------------------------------------------------------------------------------------------------

Someone have same problem or solution please :?: :?

Re: SQL DB error and can't create accounts

Posted: Wed Jan 16, 2019 10:32 am
by whasf
I am guessing your Windows language is not set to English (Since your dates in the log files has : as delimiters). You need to change the character set for the database tables to "utf8_general_ci"

Re: SQL DB error and can't create accounts

Posted: Wed Jan 16, 2019 1:45 pm
by maveric3pr
thanks for answer :)

Is not exactly from the logs thats are the output from the active promts when i run the exe file and all the tables are utf8_general_ci.
DSGame-server_Capture.JPG
I do not know what else do...I gonna try to re-compile the exe using C++ 2015 because the VS2017 run un C++2017 updating the 2015 to 2017. I not know if that matter..

Re: SQL DB error and can't create accounts

Posted: Wed Jan 16, 2019 1:50 pm
by maveric3pr
this is all the redistributable i have install, but 2015 is missing because update to 2017. so I don't know if that matter when i do the build.
C++Redistributableinstall.JPG

Re: SQL DB error and can't create accounts

Posted: Wed Jan 16, 2019 1:52 pm
by maveric3pr
I'm newbee using VS, I don't know if i can build using C++ 2015 in VS2017

Re: SQL DB error and can't create accounts

Posted: Wed Jan 16, 2019 3:35 pm
by whasf
What happens if you use HeidiSQL (or whatever is your favorite SQL client) to try one of the queries?

Code: Select all

SELECT itemid, points, max_points from guild_item_points where guildid=8 and pattern=5 and rank=6
Do you get results back?

Image

Re: SQL DB error and can't create accounts

Posted: Thu Jan 17, 2019 1:17 am
by maveric3pr
I'm using MySql Workbench to see the DB.

just putting the SQL code MySQL tell me the line have error...when I execute it toast me syntax error...

for example this is your same line...
query_Capture.JPG
and this is the result...
response_Capture.JPG

Re: SQL DB error and can't create accounts

Posted: Thu Jan 17, 2019 1:18 am
by maveric3pr
do you recommend to use HeidiSQL?

Re: SQL DB error and can't create accounts

Posted: Thu Jan 17, 2019 2:44 am
by jono659
That query runs perfectly for me
sql query.PNG
sql query.PNG (3.69 KiB) Viewed 1410 times

Re: SQL DB error and can't create accounts

Posted: Thu Jan 17, 2019 9:54 am
by whasf
What does your guild_item_points table look like? Can you browse it and see data? Maybe re-run the .sql file