[Ajuda] MySQL
#1

Olб pessoal, estou com 1 problema em 1 server de guerra (MySql) que estou trabalhando, acontece que, eu criei as tabelas tudo certo no phpmyadmin, na primeira vez que faзo login/registro, eu logo certinho, da pra jogar tranquilo, mais se eu deslogar e logar novamente e colocar a senha, da mesma conta, o server_samp fecha sozinho, alguйm pode me ajudar?
Reply
#2

Coloca o plug-in Crashdetect para identificar alguma falha no script.
Reply
#3

Quote:
Originally Posted by willttoonn
Посмотреть сообщение
Coloca o plug-in Crashdetect para identificar alguma falha no script.
Olha o debug do crasdetect.
pawn Код:
----------
Loaded log file: "server_log.txt".
----------

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

[15:17:02] filterscripts = ""  (string)
[15:17:02]
[15:17:02] Server Plugins
[15:17:02] --------------
[15:17:02]  Loading plugin: crashdetect
[15:17:02]   CrashDetect v4.15.1 is OK.
[15:17:02]   Loaded.
[15:17:02]  Loading plugin: mysql
[15:17:02]

  > MySQL plugin R6-2 successfully loaded.

[15:17:02]   Loaded.
[15:17:02]  Loading plugin: sscanf
[15:17:02]

[15:17:02]  ===============================

[15:17:02]       sscanf plugin loaded.    

[15:17:02]          Version:  2.8.1        

[15:17:02]    (c) 2012 Alex "******" Cole  

[15:17:02]  ===============================

[15:17:02]   Loaded.
[15:17:02]  Loading plugin: Whirlpool
[15:17:02]  
[15:17:02]  ==================
[15:17:02]  
[15:17:02]   Whirlpool loaded
[15:17:02]  
[15:17:02]  ==================
[15:17:02]  
[15:17:02]   Loaded.
[15:17:02]  Loading plugin: streamer
[15:17:02]

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

[15:17:02]   Loaded.
[15:17:02]  Loaded 5 plugins.

[15:17:02]
[15:17:02] Filterscripts
[15:17:02] ---------------
[15:17:02]   Loaded 0 filterscripts.

[15:17:02]  
[15:17:02]  
[15:17:02]  
[15:17:02]  =======================================
[15:17:02]  |                                     |
[15:17:02]  |        YSI version 3.09.0684        |
[15:17:02]  |        By Alex "******" Cole        |
[15:17:02]  |                                     |
[15:17:02]  =======================================
[15:17:02]  
[15:17:02]    
[15:17:02]   -------------[ J_Admin configuration ] ---------
[15:17:02]   MaxAdminLevel: 7
[15:17:02]    
[15:17:02] Number of vehicle models: 25
[15:17:25] [connection] 127.0.0.1:1387 requests connection cookie.
[15:17:26] [connection] incoming connection: 127.0.0.1:1387 id: 0
[15:17:26] [join] marcos has joined the server (0:127.0.0.1)
[15:17:50] [part] marcos has left the server (0:1)

--- "aqui foi a segunda vez que loguei com a mesma conta, olha o erro abaixo" ------

[15:18:34] [connection] 127.0.0.1:1388 requests connection cookie.
[15:18:35] [connection] incoming connection: 127.0.0.1:1388 id: 0
[15:18:35] [join] marcos has joined the server (0:127.0.0.1)
[15:18:41] [debug] Server crashed while executing COD.amx
[15:18:41] [debug] AMX backtrace:
[15:18:41] [debug] #0 native mysql_fetch_field_row () from mysql.dll
[15:18:41] [debug] #1 000111a4 in ?? (0) from COD.amx
[15:18:41] [debug] #2 0002b8c8 in public OnDialogResponse (0, 554, 1, -1, 2887796) from COD.amx
[15:18:42] [debug] Native backtrace:
[15:18:42] [debug] #0 7855b9f0 in ?? () from C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.6161_x-ww_31a54e43\MSVCR90.dll
[15:18:42] [debug] #1 00c59abe in ?? () from plugins\mysql.dll
[15:18:42] [debug] #2 00c567e3 in ?? () from plugins\mysql.dll
[15:18:42] [debug] #3 004010b6 in ?? () from samp-server.exe
[15:18:42] [debug] #4 100262ca in ?? () from plugins\crashdetect.dll
[15:18:42] [debug] #5 10028b28 in ?? () from plugins\crashdetect.dll
[15:18:42] [debug] #6 100209c7 in ?? () from plugins\crashdetect.dll
[15:18:42] [debug] #7 1002631a in ?? () from plugins\crashdetect.dll
[15:18:42] [debug] #8 0046ec31 in ?? () from samp-server.exe
[15:18:42] [debug] #9 00452270 in ?? () from samp-server.exe
[15:18:42] [debug] #10 00483384 in ?? () from samp-server.exe

Olha esse debug mais detalhado do CrashDetect:
pawn Код:
[15:43:13] [connection] 127.0.0.1:1534 requests connection cookie.
[15:43:14] [connection] incoming connection: 127.0.0.1:1534 id: 0
[15:43:14] [join] marcos has joined the server (0:127.0.0.1)
[15:43:20] [debug] Server crashed while executing COD.amx
[15:43:20] [debug] AMX backtrace:
[15:43:20] [debug] #0 native mysql_fetch_field_row () from mysql.dll
[15:43:20] [debug] #1 00014c74 in MySQL_Login (playerid=0) at C:\Documents and Settings\Administrador\Desktop\Call\gamemodes\COD.pwn:1456
[15:43:20] [debug] #2 00035678 in public OnDialogResponse (playerid=0, dialogid=554, response=1, listitem=-1, inputtext[]=@002c1074 "1111") at C:\Documents and Settings\Administrador\Desktop\Call\gamemodes\COD.pwn:5470
[15:43:22] [debug] Native backtrace:
[15:43:22] [debug] #0 7855b9f0 in ?? () from C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a1e18e3b_9.0.30729.6161_x-ww_31a54e43\MSVCR90.dll
[15:43:22] [debug] #1 00c59abe in ?? () from plugins\mysql.dll
[15:43:22] [debug] #2 00c567e3 in ?? () from plugins\mysql.dll
[15:43:22] [debug] #3 004010b6 in ?? () from samp-server.exe
[15:43:22] [debug] #4 100262ca in ?? () from plugins\crashdetect.dll
[15:43:22] [debug] #5 10028b28 in ?? () from plugins\crashdetect.dll
[15:43:22] [debug] #6 100209c7 in ?? () from plugins\crashdetect.dll
[15:43:22] [debug] #7 1002631a in ?? () from plugins\crashdetect.dll
[15:43:22] [debug] #8 0046ec31 in ?? () from samp-server.exe
[15:43:22] [debug] #9 00452270 in ?? () from samp-server.exe
[15:43:22] [debug] #10 00483384 in ?? () from samp-server.exe
Reply
#4

Te deixei uma mensagem privada filho, talvez possa resolver e ajudar o no seu problema.
Reply
#5

Resolvido !!!
Reply
#6

Quote:
Originally Posted by neymar1477
Посмотреть сообщение
Resolvido !!!
Have fun
Reply
#7

Era de grande ajuda postar a soluзгo aqui no fуrum, para futuras dъvidas de outros usuбrios...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)