SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 07/11/2014, 08:40 PM   #1
Kelzano
Little Clucker
 
Kelzano's Avatar
 
Join Date: Jun 2012
Location: France ! :D
Posts: 22
Reputation: 11
Default Can't start the server, mysql problem ? [Windows hosted server]

SOLVED !

So here's the situation, I have a script, I made it work under windows on my personnal computer, but when I try to start it on the windows hosted server (smartbytes), it crashes. I re-compiled the script twice or threece, nothing solved yet. Here's the server_log file :

SA-MP Dedicated Server
----------------------
v0.3z-R4, (C)2005-2014 SA-MP Team

[15:27:47] password = "" (string)
[15:27:47]
[15:27:47] Server Plugins
[15:27:47] --------------
[15:27:47] Loading plugin: Whirlpool
[15:27:47]
[15:27:47] ==================
[15:27:47]
[15:27:47] Whirlpool loaded
[15:27:47]
[15:27:47] ==================
[15:27:47]
[15:27:47] Loaded.
[15:27:47] Loading plugin: crashdetect
[15:27:47] crashdetect v4.7.3 is OK.
[15:27:47] Loaded.
[15:27:47] Loading plugin: mysql
[15:27:47] >> plugin.mysql: R39-2 successfully loaded.
[15:27:47] Loaded.
[15:27:47] Loading plugin: streamer
[15:27:47]

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

[15:27:47] Loaded.
[15:27:47] Loading plugin: sscanf
[15:27:47]

[15:27:47] ===============================

[15:27:47] sscanf plugin loaded.

[15:27:47] Version: 2.8.1

[15:27:47] (c) 2012 Alex "******" Cole

[15:27:47] ===============================

[15:27:47] Loaded.
[15:27:47] Loaded 5 plugins.

[15:27:48]
[15:27:48] Filterscripts
[15:27:48] ---------------
[15:27:48] Loading filterscript 'vactions.amx'...
[15:27:48] Loading filterscript 'yom_buttons.amx'...
[15:27:48] *** Streamer Plugin: Warning: Include file version (0x27002) does not match plugin version (0x27401) (script might need to be recompiled with the latest include file)
[15:27:48] Loaded 2 filterscripts.

[15:27:48]
[15:27:48]
[15:27:48]
[15:27:48] =======================================
[15:27:48] | |
[15:27:48] | YSI version 1.06.0002 |
[15:27:48] | By Alex "******" Cole |
[15:27:48] | |
[15:27:48] =======================================
[15:27:48]
[15:27:48]
[15:27:48]
[15:27:48] [debug] Server crashed while executing LACRP.amx
[15:27:48] [debug] Backtrace:
[15:27:48] [debug] #0 native mysql_connect () from mysql.DLL
[15:27:48] [debug] #1 0004e5f4 in public SSCANF_OnGameModeInit () from LACRP.amx
[15:27:48] [debug] #2 native CallLocalFunction () from samp-server.exe
[15:27:48] [debug] #3 0000d0d8 in public zcmd_OnGameModeInit () from LACRP.amx
[15:27:48] [debug] #4 native CallLocalFunction () from samp-server.exe
[15:27:48] [debug] #5 0000ca38 in ?? () from LACRP.amx
[15:27:48] [debug] #6 000066f4 in public Itter_OnGameModeInit () from LACRP.amx
[15:27:48] [debug] #7 native CallLocalFunction () from samp-server.exe
[15:27:48] [debug] #8 0000332c in ?? () from LACRP.amx
[15:27:48] [debug] #9 00000eb0 in public OnGameModeInit () from LACRP.amx
[15:27:48] [debug] Thread backtrace:
[15:27:48] [debug] #0 72BC1430 in ?? () from D:\Servers\donavan113\GameServers\TC03472322338140 702871157\plugins\crashdetect.DLL
[15:27:48] [debug] #1 72BC2735 in ?? () from D:\Servers\donavan113\GameServers\TC03472322338140 702871157\plugins\crashdetect.DLL
[15:27:48] [debug] #2 72BC405E in ?? () from D:\Servers\donavan113\GameServers\TC03472322338140 702871157\plugins\crashdetect.DLL
[15:27:48] [debug] #3 76890303 in ?? () from C:\Windows\syswow64\kernel32.dll
[15:27:48] [debug] #4 0049F096 in ?? () from D:\Servers\donavan113\GameServers\TC03472322338140 702871157\samp-server.exe
[15:27:48] [debug] #5 004984D1 in ?? () from D:\Servers\donavan113\GameServers\TC03472322338140 702871157\samp-server.exe
[15:27:48] [debug] #6 7685338A in ?? () from C:\Windows\syswow64\kernel32.dll
[15:27:48] [debug] #7 77BC9F72 in ?? () from C:\Windows\SysWOW64\ntdll.dll
[15:27:48] [debug] #8 77BC9F45 in ?? () from C:\Windows\SysWOW64\ntdll.dll

Any ideas on how to solve it ? Would be really appreciated.

Last edited by Kelzano; 07/11/2014 at 09:29 PM. Reason: Adding the host's OS.
Kelzano is offline   Reply With Quote
Old 07/11/2014, 08:57 PM   #2
buburuzu19
Huge Clucker
 
buburuzu19's Avatar
 
Join Date: Apr 2013
Location: 127.0.0.1
Posts: 461
Reputation: 9
Default Re: Can't start the server, mysql problem ? [Windows hosted server]

Update your plugins and includes and compile your gm again.
buburuzu19 is offline   Reply With Quote
Old 07/11/2014, 09:21 PM   #3
Kelzano
Little Clucker
 
Kelzano's Avatar
 
Join Date: Jun 2012
Location: France ! :D
Posts: 22
Reputation: 11
Default Re: Can't start the server, mysql problem ? [Windows hosted server]

I updated my includes for all my addons, but now, the compiling results in this : error 017: undefined symbol "mysql_affected_rows"
I believe the script I've found was made using a non-official version of the MySQL plugin, any way I could add a command to it ?

EDIT : MY BAD : It was not supposed to be written like that, it was supposed to be written : "cache_affected_rows". Trying to re-compile.

EDIT 2 : FIXED ! I just had to re-update that damn MySQL plugin and fix the script and it worked ! Thanks a lot ! +Rep for you dear sir.
Kelzano is offline   Reply With Quote
Old 19/05/2017, 02:10 AM   #4
JasonRiggs
Gangsta
 
Join Date: Jul 2016
Location: My bedroom.
Posts: 780
Reputation: 47
Default Re: Can't start the server, mysql problem ? [Windows hosted server]

Posted by mistake at the first time..

Last edited by JasonRiggs; 19/05/2017 at 02:11 AM. Reason: posted by mistake.
JasonRiggs is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql start server error 26_RUSSS Server Support 3 11/12/2013 05:07 PM
MySQL Bug, corrupting owned car ids on server start Jerm Scripting Help 7 22/10/2013 09:07 PM
MySQL server start Deividas1 Scripting Help 13 02/08/2013 05:29 PM
Start a Public IP MySQL Server Jaber_Brown Server Support 4 20/03/2013 11:09 AM
Problem with server start renerk10 Scripting Help 1 01/02/2013 10:17 PM


All times are GMT. The time now is 04:19 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.