Question

здраствуйте,проблемы с модом вот логи базы данных

 

 

[09:32:11 11/29/21] [ERROR] mysql_query - invalid connection handle (id: 0)
[09:32:11 11/29/21] [WARNING] cache_get_row_count - no active cache
[09:32:11 11/29/21] [ERROR] cache_delete - invalid connection handle (id: 1)

 

мод прекрасно работает и к базе данных подключение есть но иногда сервер сам по себе выключается вот с такими ошибками

 

Спойлер

09:19:24] [connection] incoming connection: 176.59.123.233:17607 id: 0
[09:19:25] [join] Blake_Kaif has joined the server (0:176.59.123.233)
[09:20:05] [debug] Long callback execution detected (hang or performance issue)
[09:20:05] [debug] AMX backtrace:
[09:20:05] [debug] #0 001770a8 in CreatePlanshetForPlayer (playerid=0) at C:\Users\даниил\Pictures\Desktop\Слитый мод\gamemodes\desmond.pwn:38947
[09:20:05] [debug] #1 00184eac in SetPlayerInit (playerid=0) at C:\Users\даниил\Pictures\Desktop\Слитый мод\gamemodes\desmond.pwn:39713
[09:20:05] [debug] #2 000d1a54 in public OnPlayerClickTextDraw (playerid=0, Text:clickedid=32) at C:\Users\даниил\Pictures\Desktop\Слитый мод\gamemodes\desmond.pwn:28322
[09:20:06] [debug] Server crashed due to an unknown error
[09:20:06] [debug] Native backtrace:
[09:20:06] [debug] #0 f7c5df7f in _Z13GetStackTraceRSt6vectorI10StackFrameSaIS0_EEPv () in plugins/crashdetect.so
[09:20:06] [debug] #1 f7c5681d in _ZN11CrashDetect20PrfP8ruvDkjcqemnWXatLREqiy2heFeMBTcextE () in plugins/crashdetect.so
[09:20:06] [debug] #2 f7c56e48 in _ZN11CrashDetect20PrfP8ruvDkjcqemnWXatLREqiy2heFeMBTcE () in plugins/crashdetect.so
[09:20:06] [debug] #3 f7c585dc in _ZN1JDofP7F7GCic4zDnSTJa7sQXwhqpmc4z5xtE () in plugins/crashdetect.so
[09:20:06] [debug] #4 f7c5d79f in ?? () in plugins/crashdetect.so
[09:20:06] [debug] #5 f7fc5bf0 in __kernel_rt_sigreturn () in linux-gate.so.1
[09:20:06] [debug] #6 08386ae0 in ?? ()
[09:20:06] [debug] #7 080cb0b6 in ?? () in ./samp03svr
[09:20:06] [debug] #8 080cb94e in ?? () in ./samp03svr
[09:20:06] [debug] #9 080cbe2f in ?? () in ./samp03svr
[09:20:06] [debug] #10 080cd5e4 in ?? () in ./samp03svr
[09:20:06] [debug] #11 080ac97c in ?? () in ./samp03svr
[09:20:06] [debug] #12 080aed90 in ?? () in ./samp03svr
[09:20:06] [debug] #13 080aef02 in ?? () in ./samp03svr
[09:20:06] [debug] #14 080aa13a in ?? () in ./samp03svr
[09:20:06] [debug] #15 f7cada63 in __libc_start_main () in /lib32/libc.so.6
[09:20:06] [debug] Registers:
[09:20:06] [debug] EAX: 00000010 EBX: 00000049 ECX: 00000020 EDX: 00000000
[09:20:06] [debug] ESI: 0836e52a EDI: ff8651d0 EBP: ff865308 ESP: ff865184
[09:20:06] [debug] EIP: 08386ae0 EFLAGS: 00010202
[09:20:06] [debug] Stack:
[09:20:06] [debug] ESP+00000000: ff8651ca 00000010 00000001 0000006d
[09:20:06] [debug] ESP+00000020: 00000000 00000188 00000000 011e1900
[09:20:06] [debug] ESP+00000040: 00ffffdd ffff3e49 0002ffff 000000d8
[09:20:06] [debug] ESP+00000060: 2f00ffff 2dc42049 b54479e5 00415037
[09:20:06] [debug] ESP+00000080: 081e3960 00000008 f7c86000 ff86531c
[09:20:06] [debug] ESP+000000a0: ff86531c 0000006d f7d06ea5 00000008
[09:20:06] [debug] ESP+000000c0: ff86531c 0000006d 0809571b f6e5fd79
[09:20:06] [debug] ESP+000000e0: ff86531c 0000006d 0000006d 0000006d
[09:20:06] [debug] ESP+00000100: 08159681 ff8652a0 f6e7b000 083847e0
[09:20:06] [debug] ESP+00000120: ff86531c f0754cb8 f076a7f0 00000000
[09:20:06] [debug] ESP+00000140: 0837a7d8 ff865308 f06df68a f0754cb8
[09:20:06] [debug] ESP+00000160: 004b01f8 00000002 ff865320 08345e10
[09:20:06] [debug] ESP+00000180: 00000002 ff865328 080cb0b6 0836e4e8
[09:20:06] [debug] ESP+000001a0: 0836f52a ff865378 080cb94e 08bf5e60
[09:20:06] [debug] ESP+000001c0: 00000002 00000000 47afc800 00000000
[09:20:06] [debug] ESP+000001e0: 08346e48 08bf5e60 08bf5e60 08bf5ede
[09:20:06] [debug] ESP+00000200: ff8653e8 ff8653c8 f7dc6349 08bf5ede
[09:20:06] [debug] ESP+00000220: c421dc98 447a0196 41403790 00000000
[09:20:06] [debug] ESP+00000240: 081e8784 ec6005e0 081e8784 081e8784
[09:20:06] [debug] ESP+00000260: 00000220 ff865490 0804cf9b ff865440
[09:20:06] [debug] ESP+00000280: 00000000 01865588 ec6005e0 ec6005e0
[09:20:06] [debug] ESP+000002a0: ff865440 00000000 00000001 00000000
[09:20:06] [debug] ESP+000002c0: dc980000 0196c421 3790447a 10844140
[09:20:06] [debug] ESP+000002e0: 00000000 00000000 00000000 00000000
[09:20:06] [debug] ESP+00000300: 00000004 081e2028 f7f9ff50 00000228
[09:20:06] [debug] ESP+00000320: 08bf477c ff86551c f6889000 f6889000
[09:20:06] [debug] ESP+00000340: 65636e75 ff865578 f7e3d000 ff865548
[09:20:06] [debug] ESP+00000360: ff865548 00000001 00000000 1362c75a
[09:20:06] [debug] ESP+00000380: 00000000 00000000 f6889000 f6889000
[09:20:06] [debug] ESP+000003a0: 00000000 ff8655a8 f7e3d000 6a59c18e
[09:20:06] [debug] ESP+000003c0: f7d8d342 f7899dd0 f78964f6 00000001
[09:20:06] [debug] ESP+000003e0: 00000000 00000071 2c08a62b f7899dd0
[09:20:06] [debug] Loaded modules:
[09:20:06] [debug] 00000000 - 00187d1f samp03svr
[09:20:06] [debug] f7fc5000 - f7fc5d82 linux-gate.so.1
[09:20:06] [debug] f7fb3000 - f7fb581b /lib32/libdl.so.2
[09:20:06] [debug] f7f97000 - f7fb1d2b /lib32/libpthread.so.0
[09:20:06] [debug] f7ea5000 - f7f9ed1a /usr/lib32/libstdc++.so.6
[09:20:06] [debug] f7e5f000 - f7ea3b97 /lib32/libm.so.6
[09:20:06] [debug] f7e42000 - f7e5e3c4 /usr/lib32/libgcc_s.so.1
[09:20:06] [debug] f7c94000 - f7e49237 /lib32/libc.so.6
[09:20:06] [debug] f7fc6000 - f7fe74a0 /lib/ld-linux.so.2
[09:20:06] [debug] f7c87000 - f7c90b96 plugins/anti-freeze.so
[09:20:06] [debug] f7c3e000 - f7c863d4 plugins/crashdetect.so
[09:20:06] [debug] f7fbd000 - f7fbedf4 plugins/CRP.so
[09:20:06] [debug] f789a000 - f7c42ac7 plugins/mysql_static.so
[09:20:06] [debug] f7889000 - f789009f /lib32/librt.so.1
[09:20:06] [debug] f6e7c000 - f6e873ef /lib32/libnss_files.so.2
[09:20:06] [debug] f6a72000 - f6b050a1 plugins/pawnbots.so
[09:20:06] [debug] f698d000 - f6a74b50 plugins/pawncmd.so
[09:20:06] [debug] f68a4000 - f6990778 plugins/pawnregex.so
[09:20:06] [debug] f6e4f000 - f6e7ad70 plugins/profiler.so
[09:20:06] [debug] f66fa000 - f68ae349 plugins/sampvoice.so
[09:20:06] [debug] f6e3e000 - f6e4d9b4 plugins/sscanf.so
[09:20:06] [debug] f06a7000 - f076c740 plugins/streamer.so
[09:20:06] [debug] f7892000 - f78992bd plugins/timerfix.so
[09:20:06] [debug] f6e38000 - f6e3b7a0 plugins/TOTP.so

 

и в базе данных после выключание по самому себе сервера появляется снова же ошибки в логах базы данных

 

[10:29:28 11/29/21] [ERROR] mysql_query - invalid connection handle (id: 0)
[10:29:28 11/29/21] [WARNING] cache_get_row_count - no active cache

[10:29:28 11/29/21] [ERROR] cache_delete - invalid connection handle (id: 1)

 

полные логи когда мод нормально работает

 

Спойлер

 

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[09:32:11] filterscripts = ""  (string)
[09:32:11] 
[09:32:11] Server Plugins
[09:32:11] --------------
[09:32:11]  Loading plugin: crashdetect.so
[09:32:11]   CrashDetect plugin 4.20
[09:32:11]   Loaded.
[09:32:11]  Loading plugin: pawncmd.so
[09:32:11] Pawn.CMD plugin v3.2.0 by urShadow has been loaded
[09:32:11]   Loaded.
[09:32:11]  Loading plugin: mysql_static.so
[09:32:11]   plugin.mysql: R39-6 successfully loaded.
[09:32:11]   Loaded.
[09:32:11]  Loading plugin: profiler.so
[09:32:11]   Profiler plugin 2.15.3
[09:32:11]   Loaded.
[09:32:11]  Loading plugin: sscanf.so
[09:32:11] 

[09:32:11]  ===============================

[09:32:11]       sscanf plugin loaded.     

[09:32:11]          Version:  2.8.3        

[09:32:11]   (c) 2018 Alex "Y_Less" Cole  

[09:32:11]  ===============================

[09:32:11]   Loaded.
[09:32:11]  Loading plugin: streamer.so
[09:32:11] 

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[09:32:11]   Loaded.
[09:32:11]  Loading plugin: timerfix.so
[09:32:11]    TimerFix v1.5 successfully loaded.
[09:32:11]   Loaded.
[09:32:11]  Loading plugin: sampvoice.so
[09:32:11] [sv:dbg:network:init] : module initializing...
[09:32:11] [dbg:raknet:init] : module initializing...
[09:32:11] [dbg:raknet:init] : installed hook to 'GetRakServerInterface' function (ptr:0x806ca30)
[09:32:11] [dbg:raknet:init] : installed hook to 'OnPlayerDisconnect' function (ptr:0x80a51d0)
[09:32:11] [dbg:raknet:init] : module initialized
[09:32:11] [sv:dbg:network:init] : module initialized
[09:32:11]  -------------------------------------------    
[09:32:11]    ___                __   __    _              
[09:32:11]   / __| __ _ _ __  _ _\ \ / /__ (_) __ ___    
[09:32:11]   \__ \/ _` | '  \| '_ \   / _ \| |/ _/ -_)
[09:32:11]   |___/\__,_|_|_|_| .__/\_/\___/|_|\__\___|
[09:32:11]                   |_|                           
[09:32:11]  -------------------------------------------    
[09:32:11]            SampVoice by MOR loaded              
[09:32:11]  -------------------------------------------    
[09:32:11]   Loaded.
[09:32:11]  Loaded 8 plugins.

[09:32:11] 
[09:32:11] Filterscripts
[09:32:11] ---------------
[09:32:11]   Loaded 0 filterscripts.

[09:32:11] [sv:dbg:main:AmxLoad] : net game pointer (value:0x8c4d090) received
[09:32:11] [sv:dbg:network:bind] : voice server running on port 35747
[09:32:11] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[09:32:11] [plugin.timerfix] Contein: Function was not found.
[09:32:11] [plugin.timerfix] ConteinDelete: Function was not found.
[09:32:11] [TextDraw]: Все текстдравы созданы
[09:32:11] [Vehicle]: Все транспортные средства созданы
[09:32:11] [TP]: Все входы/выходы созданы
[09:32:11] [ATM]: Все банкоматы созданы
[09:32:11] [Repositories]: Все склады загружнены
[09:32:11] [debug] Long callback execution detected (hang or performance issue)
[09:32:11] [debug] AMX backtrace:
[09:32:11] [debug] #0 0000dac4 in n_CreatePickup (model=1273, type=23, Float:X=2300.11011, Float:Y=1380.82996, Float:Z=12.25760, Virtualworld=0, action_type=15, action_id=6) at C:\Users\даниил\Pictures\Desktop\Слитый мод\pawno\include\system/pickup.pwn:68
[09:32:11] [debug] #1 0014c67c in UpdateHouse (houseid=6) at C:\Users\даниил\Pictures\Desktop\Слитый мод\gamemodes\desmond.pwn:35562
[09:32:11] [debug] #2 000ecf88 in public LoadHouses () at C:\Users\даниил\Pictures\Desktop\Слитый мод\gamemodes\desmond.pwn:31146
[09:32:11] [debug] #3 0001eda0 in public n_veh_OnGameModeInit () at C:\Users\даниил\Pictures\Desktop\Слитый мод\gamemodes\desmond.pwn:6449
[09:32:11] [debug] #4 0000ed0c in public n_OnGameModeInit () at C:\Users\даниил\Pictures\Desktop\Слитый мод\pawno\include\system/vehicle.pwn:439
[09:32:11] [debug] #5 0000e1a4 in public PawnCmd_OnGameModeInit () at C:\Users\даниил\Pictures\Desktop\Слитый мод\pawno\include\system/pickup.pwn:133
[09:32:11] [debug] #6 00008e0c in public Iter_OnGameModeInit () at C:\Users\даниил\Pictures\Desktop\Слитый мод\pawno\include\pawncmd.inc:125
[09:32:11] [debug] #7 native CallLocalFunction () in samp03svr
[09:32:11] [debug] #8 00007f98 in public SSCANF_OnGameModeInit () at C:\Users\даниил\Pictures\Desktop\Слитый мод\pawno\include\foreach.inc:735
[09:32:11] [debug] #9 000009ec in public OnGameModeInit () at C:\Users\даниил\Pictures\Desktop\Слитый мод\pawno\include\sscanf2.inc:211
[09:32:11] [Houses]: Домов загружено: 26
[09:32:11] [Houses]: Арендаторов загружено: 0
[09:32:11] [FuelST]: Заправок загружено: 3
[09:32:11] [Business]: Бизнесов загружено: 8
[09:32:11] [Garage]: Гаражей загружено: 0
[09:32:11] [GangZones]: Гангзон загружено: 9
[09:32:11] [GangRepositories]: Склады банд загружены
[09:32:11] Number of vehicle models: 45
[09:33:27] [connection] 176.59.123.233:28451 requests connection cookie.
[09:33:28] [connection] incoming connection: 176.59.123.233:28451 id: 0
[09:33:28] [join] Blake_Kaif has joined the server (0:176.59.123.233)
[09:35:38] [sv:dbg:network:connect] : disconnecting player (0) ...
[09:35:38] [part] Blake_Kaif has left the server (0:1)

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[10:29:28] filterscripts = ""  (string)
[10:29:28] 
[10:29:28] Server Plugins
[10:29:28] --------------
[10:29:28]  Loading plugin: crashdetect.so
[10:29:28]   CrashDetect plugin 4.20
[10:29:28]   Loaded.
[10:29:28]  Loading plugin: pawncmd.so
[10:29:28] Pawn.CMD plugin v3.2.0 by urShadow has been loaded
[10:29:28]   Loaded.
[10:29:28]  Loading plugin: mysql_static.so
[10:29:28]   plugin.mysql: R39-6 successfully loaded.
[10:29:28]   Loaded.
[10:29:28]  Loading plugin: profiler.so
[10:29:28]   Profiler plugin 2.15.3
[10:29:28]   Loaded.
[10:29:28]  Loading plugin: sscanf.so
[10:29:28] 

[10:29:28]  ===============================

[10:29:28]       sscanf plugin loaded.     

[10:29:28]          Version:  2.8.3        

[10:29:28]   (c) 2018 Alex "Y_Less" Cole  

[10:29:28]  ===============================

[10:29:28]   Loaded.
[10:29:28]  Loading plugin: streamer.so
[10:29:28] 

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[10:29:28]   Loaded.
[10:29:28]  Loading plugin: timerfix.so
[10:29:28]    TimerFix v1.5 successfully loaded.
[10:29:28]   Loaded.
[10:29:28]  Loading plugin: sampvoice.so
[10:29:28] [sv:dbg:network:init] : module initializing...
[10:29:28] [dbg:raknet:init] : module initializing...
[10:29:28] [dbg:raknet:init] : installed hook to 'GetRakServerInterface' function (ptr:0x806ca30)
[10:29:28] [dbg:raknet:init] : installed hook to 'OnPlayerDisconnect' function (ptr:0x80a51d0)
[10:29:28] [dbg:raknet:init] : module initialized
[10:29:28] [sv:dbg:network:init] : module initialized
[10:29:28]  -------------------------------------------    
[10:29:28]    ___                __   __    _              
[10:29:28]   / __| __ _ _ __  _ _\ \ / /__ (_) __ ___    
[10:29:28]   \__ \/ _` | '  \| '_ \   / _ \| |/ _/ -_)
[10:29:28]   |___/\__,_|_|_|_| .__/\_/\___/|_|\__\___|
[10:29:28]                   |_|                           
[10:29:28]  -------------------------------------------    
[10:29:28]            SampVoice by MOR loaded              
[10:29:28]  -------------------------------------------    
[10:29:28]   Loaded.
[10:29:28]  Loaded 8 plugins.

[10:29:28] 
[10:29:28] Filterscripts
[10:29:28] ---------------
[10:29:28]   Loaded 0 filterscripts.

[10:29:28] [sv:dbg:main:AmxLoad] : net game pointer (value:0x95c4090) received
[10:29:28] [sv:dbg:network:bind] : voice server running on port 50496
[10:29:28] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[10:29:28] [plugin.timerfix] Contein: Function was not found.
[10:29:28] [plugin.timerfix] ConteinDelete: Function was not found.
[10:29:28] [TextDraw]: Все текстдравы созданы
[10:29:28] [Vehicle]: Все транспортные средства созданы
[10:29:28] [TP]: Все входы/выходы созданы
[10:29:28] [ATM]: Все банкоматы созданы
[10:29:28] [Repositories]: Все склады загружнены
[10:29:28] [debug] Long callback execution detected (hang or performance issue)
[10:29:28] [debug] AMX backtrace:
[10:29:28] [debug] #0 000bb308 in public LoadHouses () in desmond.amx
[10:29:28] [debug] #1 00018f68 in public n_veh_OnGameModeInit () in desmond.amx
[10:29:28] [debug] #2 0000c2b8 in public n_OnGameModeInit () in desmond.amx
[10:29:28] [debug] #3 0000ba54 in public PawnCmd_OnGameModeInit () in desmond.amx
[10:29:28] [debug] #4 000076a8 in public Iter_OnGameModeInit () in desmond.amx
[10:29:28] [debug] #5 native CallLocalFunction () in samp03svr
[10:29:28] [debug] #6 00006b84 in public SSCANF_OnGameModeInit () in desmond.amx
[10:29:28] [debug] #7 0000087c in public OnGameModeInit () in desmond.amx
[10:29:28] [Houses]: Домов загружено: 26
[10:29:28] [Houses]: Арендаторов загружено: 0
[10:29:28] [FuelST]: Заправок загружено: 3
[10:29:28] [Business]: Бизнесов загружено: 8
[10:29:28] [Garage]: Гаражей загружено: 0
[10:29:28] [GangZones]: Гангзон загружено: 9
[10:29:28] [GangRepositories]: Склады банд загружены
[10:29:28] Number of vehicle models: 45

 


 

может кто знает как исправить?

 

Edited by keyl

Заметка от keyl , создано

3.2. Код больше 10 строк необходимо брать в теги "Код" и "Спойлер". Как это сделать рассказано в разделе "FAQ".

Устное предупреждение.

Share this post


Link to post

1 answer to this question

  • 0

Проблема в паблике OnPlayerClickTextDraw, а если конкретнее в clickedid=32, советую удалить и проверить будет ли запускатся мод, или же исправить, дело ваше. Надеюсь помог)

Share this post


Link to post
Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • Vlad0s1k
      By Vlad0s1k
      Ну чтож это копия мапиинга Радмира и да это инклуд, и чтобы его применить нужно в самом вашем моде прописать
      // -----------------
      // mapping
      #include "../include/map"
      // -----------------
      Маппинг Радмира.zip
    • Ruman
      By Ruman
      Приветствую! У меня вопрос, связанный с загрузкой игрового аккаунта, просто я делаю регистрацию свою по уроку но в этом уроке функции MySQL из версии R39. Естественно при нажатии F5 выдаёт это:
      D:\Users\Ruman\Desktop\Time RP\gamemodes\project.pwn(1373) : error 017: undefined symbol "cache_get_field_content_int" D:\Users\Ruman\Desktop\Time RP\gamemodes\project.pwn(1374) : error 017: undefined symbol "cache_get_field_content_int" Код:
      forward LoadAcc(playerid); public LoadAcc(playerid) {     player_info[playerid][ID] = cache_get_field_content_int(0, "id", dbHandle);     player_info[playerid][LEVEL] = cache_get_field_content_int(0, "level", dbHandle); } Просто мне нужна другая версия данной функции под R40.
       
      Спасибо тем, что всегда рад помочь! 
       
      P.S Просто с MySQL я вообще в целом не знаком, поэтому так много вопросов.