SQL DB error and can't create accounts

Can't get the client or server set up? Ask here!
We're on Discord! https://discord.gg/4dgAzfC
maveric3pr
Posts: 8
Joined: Wed Jan 16, 2019 8:21 am

SQL DB error and can't create accounts

Post by maveric3pr » Wed Jan 16, 2019 8:41 am

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 :?: :?

User avatar
whasf
Site Admin
Posts: 1273
Joined: Thu Jul 19, 2012 9:11 pm

Re: SQL DB error and can't create accounts

Post by whasf » Wed Jan 16, 2019 10:32 am

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"
-- Whasf

maveric3pr
Posts: 8
Joined: Wed Jan 16, 2019 8:21 am

Re: SQL DB error and can't create accounts

Post by maveric3pr » Wed Jan 16, 2019 1:45 pm

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..

maveric3pr
Posts: 8
Joined: Wed Jan 16, 2019 8:21 am

Re: SQL DB error and can't create accounts

Post by maveric3pr » Wed Jan 16, 2019 1:50 pm

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

maveric3pr
Posts: 8
Joined: Wed Jan 16, 2019 8:21 am

Re: SQL DB error and can't create accounts

Post by maveric3pr » Wed Jan 16, 2019 1:52 pm

I'm newbee using VS, I don't know if i can build using C++ 2015 in VS2017

User avatar
whasf
Site Admin
Posts: 1273
Joined: Thu Jul 19, 2012 9:11 pm

Re: SQL DB error and can't create accounts

Post by whasf » Wed Jan 16, 2019 3:35 pm

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
-- Whasf

maveric3pr
Posts: 8
Joined: Wed Jan 16, 2019 8:21 am

Re: SQL DB error and can't create accounts

Post by maveric3pr » Thu Jan 17, 2019 1:17 am

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
Last edited by maveric3pr on Thu Jan 17, 2019 1:21 am, edited 2 times in total.

maveric3pr
Posts: 8
Joined: Wed Jan 16, 2019 8:21 am

Re: SQL DB error and can't create accounts

Post by maveric3pr » Thu Jan 17, 2019 1:18 am

do you recommend to use HeidiSQL?

jono659
Posts: 59
Joined: Sat Mar 24, 2018 1:01 pm

Re: SQL DB error and can't create accounts

Post by jono659 » Thu Jan 17, 2019 2:44 am

That query runs perfectly for me
sql query.PNG
sql query.PNG (3.69 KiB) Viewed 299 times

User avatar
whasf
Site Admin
Posts: 1273
Joined: Thu Jul 19, 2012 9:11 pm

Re: SQL DB error and can't create accounts

Post by whasf » Thu Jan 17, 2019 9:54 am

What does your guild_item_points table look like? Can you browse it and see data? Maybe re-run the .sql file
-- Whasf

Post Reply