Server SQL error SELECT region_control FROM conquest_system WHERE region_id
Posted: Wed Oct 02, 2019 7:23 pm
I get this error spammed in my server box after loading zones is done:
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.
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