OciXCrom's Rank System [SQL Error]

[Nordic Warrior]

Ошибка

L 01/28/2019 - 21:59:50: [crx_ranksystem.amxx] [SQL Error] Query failed (1064): 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 'W' at line 1
L 01/28/2019 - 21:59:49: [crx_ranksystem.amxx] [SQL Error] Query failed (1064): 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
L 01/28/2019 - 21:59:48: [crx_ranksystem.amxx] [SQL Error] Query failed (1064): 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 ''n/a' at line 1
L 01/28/2019 - 21:59:48: [crx_ranksystem.amxx] [SQL Error] Query failed (1064): 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 ''n' at line 1

ОС

Linux

Amx Mod X

AMX Mod X 1.9.0.5234 (http://www.amxmodx.org)

Authors:

	David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko

	Felix "SniperBeamer" Geyer, Jonny "Got His Gun" Bergstrom

	Lukasz "SidLuke" Wlasinski, Christian "Basic-Master" Hammacher

	Borja "faluco" Ferrer, Scott "DS" Ehlert

Compiled: Nov  3 2018 14:55:29

Built from: https://github.com/alliedmodders/amxmodx/commit/9eb1f42

Build ID: 5234:9eb1f42

Core mode: JIT+ASM32

Билд

Protocol version 48

Exe version 1.1.2.7/Stdio (cstrike)

ReHLDS version: 3.4.0.668-dev

Build date: 09:47:42 Sep 29 2018 (1631)

Build from: https://github.com/dreamstalker/rehlds/commit/89be216

ReGamedll

ReGameDLL version: 5.7.0.318-dev

Build date: 21:07:26 Oct 30 2018

Build from: https://github.com/s1lentq/ReGameDLL_CS/commit/932001b

Версия Metamod

meta version

Metamod-r v1.3.0.128, API (5:13)

Metamod-r build: 17:47:54 Aug 24 2018

Metamod-r from: https://github.com/theAsmodai/metamod-r/commit/0cf2f70

Список метамодулей

Currently loaded plugins:

      description   stat pend  file                       vers            src  load  unload

 [ 1] Reunion       RUN   -    reunion_mm_i386.so         v0.1.0.133      ini  Start Never

 [ 2] AMX Mod X     RUN   -    amxmodx_mm_i386.so         v1.9.0.5234     ini  Start ANY  

 [ 3] ReAuthCheck   RUN   -    reauthcheck_mm_i386.so     v0.1.6          ini  Start Never

 [ 4] Rechecker     RUN   -    rechecker_mm_i386.so       v2.5            ini  Chlvl ANY  

 [ 5] Revoice       RUN   -    revoice_mm_i386.so         v0.1.0.32       ini  Start Never

 [ 6] MySQL         RUN   -    mysql_amxx_i386.so         v1.9.0.5234     pl2  ANY   ANY  

 [ 7] SQLite        RUN   -    sqlite_amxx_i386.so        v1.9.0.5234     pl2  ANY   ANY  

 [ 8] Fun           RUN   -    fun_amxx_i386.so           v1.9.0.5234     pl2  ANY   ANY  

 [ 9] Engine        RUN   -    engine_amxx_i386.so        v1.9.0.5234     pl2  ANY   ANY  

 [10] FakeMeta      RUN   -    fakemeta_amxx_i386.so      v1.9.0.5234     pl2  ANY   ANY  

 [11] CStrike       RUN   -    cstrike_amxx_i386.so       v1.9.0.5234     pl2  ANY   ANY  

 [12] Ham Sandwich  RUN   -    hamsandwich_amxx_i386.so   v1.9.0.5234     pl2  ANY   ANY  

 [13] hackdetector  RUN   -    hackdetector_amxx_i386.so  v0.15.328.lite  pl2  ANY   ANY  

 [14] ReAPI         RUN   -    reapi_amxx_i386.so         v5.6.0.160-dev  pl2  ANY   Never

14 plugins, 14 running

Список плагинов

amxx plugins

Currently loaded plugins:

       name                    version     author            file             status   

 [  1] fb_forwards             0.1.4       Kanagava & Realu  fb_forwards.amx  running  

 [  2] WebHS                   0.1         kanagava          fb_web_online.a  running  

 [  3] FreshBans               1.4.0b      kanagava          fresh_bans_140_  running  

 [  4] SF Warn Menu            0.1.4g      serfreeman1337    sf_admin_warns.  running  

 [  5] CSStatsX SQL            0.7.4+1     serfreeman1337    csstatsx_sql.am  running  

 [  6] Rank Menu               1.1         h1k3              rankmenu.amxx    running  

 [  7] AES: StatsX             0.5 Vega    serfreeman1337    statsx_cstrike.  running  

 [  8] Admin Load              3.10.0      F@nt0M            adminload.amxx   running  

 [  9] Admin Commands          1.9.0.5234  AMXX Dev Team     admincmd.amxx    running  

 [ 10] Admin Help              1.9.0.5234  AMXX Dev Team     adminhelp.amxx   running  

 [ 11] Menus Front-End         1.9.0.5232  AMXX Dev Team     menufront.amxx   running  

 [ 12] Commands Menu           1.9.0.5234  AMXX Dev Team     cmdmenu.amxx     running  

 [ 13] Players Menu            1.9.0.5234  AMXX Dev Team     plmenu.amxx      running  

 [ 14] Teleport Menu           1.9.0.5234  AMXX Dev Team     telemenu.amxx    running  

 [ 15] Maps Menu               1.9.0.5234  AMXX Dev Team     mapsmenu.amxx    running  

 [ 16] Admin Chat              1.9.0.5234  AMXX Dev Team     adminchat.amxx   running  

 [ 17] Anti Flood              1.9.0.5234  AMXX Dev Team     antiflood.amxx   running  

 [ 18] Admin Votes             1.9.0.5234  AMXX Dev Team     adminvote.amxx   running  

 [ 19] Pause Plugins           1.9.0.5234  AMXX Dev Team     pausecfg.amxx    running  

 [ 20] Stats Configuration     1.9.0.5234  AMXX Dev Team     statscfg.amxx    running  

 [ 21] AdminMenu               1.1         Nordic Warrior    adminmenu.amxx   running  

 [ 22] Admin menu central      0.1         Nordic Warrior    adminmenu_centr  running  

 [ 23] Advanced Lottery        0.4         Nordic Warrior    advanced_lotter  running  

 [ 24] [ReAPI] Advanced Team   0.1.0       Vaqtincha         AdvancedTeamCho  running  

 [ 25] Advert Messages         1.22        neygomon          adverts.amxx     running  

 [ 26] AFK Protection          2.3         rapara13/Nordic   afk.amxx         running  

 [ 27] AimInfo                 2.1         xPaw/Nordic Warr  aim_info.amxx    running  

 [ 28] Auto recording demo     2.1e        IzI | Bonaqua (R  amx_autodemorec  running  

 [ 29] Ball                    1.2         xPaw/Nordic Warr  ball.amxx        running  

 [ 30] CameraChanger Lite      0.1         Nordic Warrior    camera_changer.  running  

 [ 31] Advanced Client Checke  0.3.6       Mistrick          cmdchecker.amxx  running  

 [ 32] Connect Exec            1.0         AleX              connect_exec.am  running  

 [ 33] Chat Manager            4.3.1       OciXCrom          crx_chatmanager  running  

 [ 34] CM: Toggle Chat         4.1         OciXCrom          crx_chatmanager  running  

 [ 35] OciXCrom's Rank System  3.1         OciXCrom          crx_ranksystem.  running  

 [ 36] Knife Models            2.5.7       OciXCrom          crx_knife_model  running  

 [ 37] [ReAPI] Custom Models   1.6.1       neugomon          custom_models.a  running  

 [ 38] Fix for sky             0.3         NordicWarrior     fix_maps.amxx    running  

 [ 39] Gag System              1.1         TheRedShoko @ AM  gag_system.amxx  running  

 [ 40] GameName Changer        1.0         neugomon          gamename.amxx    running  

 [ 41] iFLY                    1.0         arttty7           iFLY.amxx        running  

 [ 42] iHOOK                   1.0         arttty7           iHOOK.amxx       running  

 [ 43] Invisible Spectator     1.0         ReHLDS Team       invisible_spect  running  

 [ 44] key listener            0.7         cheap_suit        keylistener.amx  running  

 [ 45] Kill Distance (mod)     0.4 [N.W.   Nightscream       kill_distance.a  running  

 [ 46] Knife Duel Arena        1.3         bionext           knife_duel_aren  debug    

 [ 47] unknown                 unknown     unknown           knife_duel_aren  running  

 [ 48] Language Menu           1.0         F@nt0M            langmenu.amxx    running  

 [ 49] Light Menu              0.2         Nordic Warrior    light_menu.amxx  running  

 [ 50] Mind Games              1.1         fifayer/Nordic W  MindGames.amxx   running  

 [ 51] Money System            Best        t3rkecorejz       MoneySystem.amx  running  

 [ 52] Mute Menu               30.10.2018  w0w               mute_menu.amxx   running  

 [ 53] MG Grab                 2.0         Nickron           new_grab.amxx    running  

 [ 54] Knife Menu              1.2         Nordic Warrior    nknifemenu.amxx  running  

 [ 55] Knife shop              0.1         Nordic Warrior    nknifeshop.amxx  running  

 [ 56] Online Helper           1.0.1       Nordic Warrior    online_helper.a  running  

 [ 57] Paint Marker            1.1         w0w               paint_marker.am  running  

 [ 58] [ReAPI] Parachute       1.1         ReHLDS Team       parachute.amxx   running  

 [ 59] Ping Checker            26.0.1 RC1  h1k3              ping_checker.am  running  

 [ 60] Pingwinowa bombka       0.1         diablix           pingwin.amxx     running  

 [ 61] ADV. QUAKE SOUNDS       5.0         HATTRICK (HTTRCK  QuakeSounds.amx  running  

 [ 62] Random Skies            1.1         rmk by N.W.       randomskies.amx  running  

 [ 63] ReChecker Logging       1.0         custom            rc_logging.amxx  running  

 [ 64] Reset Score             0.2         Silenttt / CepeH  RESET_SCORE_V0.  running  

 [ 65] Spectator Bots          2.1         SISA              spectator_bots.  running  

 [ 66] SteamID Limiter         0.4         Mistrick          steamid_limiter  running  

 [ 67] Money Transfer          1.2         x3/Nordic Warrio  tm.amxx          running  

 [ 68] Train Killer            1.1         Pastout!/Nordic   trainkiller.amx  running  

 [ 69] VipMenu                 1.0         Nordic Warrior    vipmenu.amxx     running  

 [ 70] Yet Another Voteban     1.8         AndrewZ/voed      yet_another_vot  running  

 [ 71] Map Manager: Core       3.0.1       Mistrick          map_manager_cor  running  

 [ 72] Map Manager: Scheduler  0.1.0       Mistrick          map_manager_sch  running  

 [ 73] Map Manager: Rtv        0.0.4       Mistrick          map_manager_rtv  running  

 [ 74] Map Manager: Nominatio  0.0.8       Mistrick          map_manager_nom  running  

 [ 75] Map Manager: Effects    0.0.8       Mistrick          map_manager_eff  running  

 [ 76] Map Manager: Informer   0.0.5       Mistrick          map_manager_inf  running  

 [ 77] Map Manager: Advanced   0.0.4       Mistrick          map_manager_adv  running  

77 plugins, 77 running

Автор плагина

OciXCrom

Версия плагина

3.1

Исходный код

https://dev-cs.ru/resources/541/field?field=source

После перехода с версии 3.0 на 3.1 появилась данная ошибка. Зашел в бд вручную - туда ничего не пишется

 

[bionext]

sbelov020, А таблицу в базе данных старую указал или использовал новое имя. Если старую то по формату она не совпадает с новой версией. Версия 3.0 (`User`,`XP`) Версия 3.1 (`Player`,`XP`,`Level`,`Next XP`,`Rank`,`Next Rank`). Также судя по ошибкам скорее всего некорректно сработал SQL_QuoteString, 'W' ''' вторая часть ника W'arrior ???

 

[Nordic Warrior]

bionext, конечно указал другое имя таблицы.

 

[bionext]

sbelov020, а по поводу второго варианта от ника зависимость проверял?

 

[Nordic Warrior]

bionext, не проверял, но не думаю что она существует (завсимость). На сервере было несколько игроков, но ни один не записался в таблицу.
Так же, при попытке импортировать данные из старой таблицы, ничего не записалось

29 Янв 2019

OciXCrom

 

[Nordic Warrior]

up

 

[Nordic Warrior]

UP

 

[BlackSignature]

sbelov020, Если автор плагина морозит, можно отдебажить самостоятельно. Добавьте вывод "сломанного" запроса при ошибке. Так хоть ясно будет без ныряния с аквалангом, в каком месте оно там ломается. Пример:

    if(iFailState == TQUERY_QUERY_FAILED) {
        SQL_GetQueryString(hQueryHandle, g_szQuery, chx(g_szQuery))
        log_to_file(g_szSqlErrLog, "* Query error!")
        log_to_file(g_szSqlErrLog, "[Error #%d] %s", iErrorCode, szError)
        log_to_file(g_szSqlErrLog, "[Query] %s", g_szQuery)
        return PLUGIN_HANDLED
    }

16 Фев 2019

Вроде как прилетает ошибка сюда:

public QueryHandler(iFailState, Handle:iQuery, szError[], iErrorCode)
{
    switch(iFailState)
    {
        case TQUERY_CONNECT_FAILED: log_amx("[SQL Error] Connection failed (%i): %s", iErrorCode, szError)
        case TQUERY_QUERY_FAILED:   log_amx("[SQL Error] Query failed (%i): %s", iErrorCode, szError)
    }
}

Т.е. сюда и добавьте SQL_GetQueryString() + вывод буфера в лог.

 

[Nordic Warrior]

BlackSignature, какого размера должен быть g_szQuery?

 

[BlackSignature]

sbelov020, Чтобы строка запроса влезла. Полагаю, 1024 должно хватить (код я не смотрел от слова совсем, если что).

 

[Sonyx]

sbelov020,

-const MAX_QUERY_LENGTH = 128
+const MAX_QUERY_LENGTH = 1024

 

[Nordic Warrior]

Sonyx, BlackSignature, вот что получилось.

16 Фев 2019

Как я понял, OciXCrom некорректно настроил перенос из старой таблицы в новую?

 

[Nordic Warrior]

Проблема решена автором в новой версии плагина.