Page 1 of 1

Server SQL error SELECT region_control FROM conquest_system WHERE region_id

Posted: Wed Oct 02, 2019 7:23 pm
by lolidroid86
I get this error spammed in my server box after loading zones is done:

Code: Select all

[Info] DarkStar[Status] do_init: begin server initialization...          - [OK]
[02/Oct] [20:13:26][Status] do_init: map_config is reading               - [OK]
[02/Oct] [20:13:26][Status] luautils::init:lua initializing...           - [OK]
[02/Oct] [20:13:26][Status] do_init: sqlhandle is allocating             - [OK]
[02/Oct] [20:13:26][Status] do_init: zlib is reading                     - [OK]
[02/Oct] [20:13:26][Status] do_init: loading items                       - [OK]
[02/Oct] [20:13:27][Status] do_init: loading spells                      - [OK]
[02/Oct] [20:13:27][Debug] UpdateGuildPointsPattern is finished. New pattern: 7
[02/Oct] [20:13:28][Status] do_init: loading zones[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id =
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id =
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id =
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id =
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id =
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:25][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:26][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
[02/Oct] [20:14:26][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id =

[02/Oct] [20:14:26][SQL] DB error - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
SQL: SELECT region_control FROM conquest_system WHERE region_id = 
                         - [OK]
[02/Oct] [20:14:26][Status] do_init: server is binding with port 54230   - [OK]
[02/Oct] [20:14:26][Debug] InitializeWeather Finished
[02/Oct] [20:14:26][Status] The map-server is ready to work...
=======================================================================
[02/Oct] [20:14:26][Debug] [Lua] Garbage Collected. Current State Top: 0 
I'm using MariaDB 10.4, Database is named 'dsp', I've properly imported all SQL files using the 'Database_initial_setup.bat' in the tools folder edited to use MariaDB.

Re: Server SQL error SELECT region_control FROM conquest_system WHERE region_id

Posted: Tue Nov 05, 2019 10:22 pm
by Delaide
Have you updated recently? There was an issue in the conquest_system.cpp where a value needed to be static cast to resolve if you built with VS2019. I have checked the repo, and it seems that value has been static cast in the latest master build.
Recommend pulling master updates and rebuilding.