Server Crashes when Mysql fetchs a field
#1

Hello,

I have a bug in my system and i've searched long for a solution, but i found none.

When the Server starts and strickendkid tries to fetch a field, the Server crashes with the putty msg: "Segementation Fault" Here are some Logs:

Strickenkid's Plugin:

[Thu Jun 13 21:39:07 2013] -------------------------
[Thu Jun 13 21:39:07 2013] Logging Started
[Thu Jun 13 21:39:07 2013] -------------------------
[Thu Jun 13 21:39:07 2013] Function: mysql_init executed with result: "0".
[Thu Jun 13 21:39:07 2013] Connected (0) to sa-mp @ 127.0.0.1 via TCP/IP.
[Thu Jun 13 21:39:07 2013] MySQL Server Version 5.1.66-0+squeeze1.
[Thu Jun 13 21:39:07 2013] Function: mysql_query executed: "SELECT * FROM config LIMIT 1" with result: "0".
[Thu Jun 13 21:39:07 2013] Function: mysql_store_result executed with result: "1"
[Thu Jun 13 21:39:07 2013] Function: mysql_num_rows executed with result: "%".
[Thu Jun 13 21:39:07 2013] Function: mysql_fetch_field executed.







Server log:

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

SA-MP Dedicated Server
----------------------
v0.3x, ©2005-2013 SA-MP Team

[22:02:19] filterscripts = "" (string)
[22:02:19]
[22:02:19] Server Plugins
[22:02:19] --------------
[22:02:19] Loading plugin: mysql.so
[22:02:19]

> MySQL plugin R6 successfully loaded.

[22:02:19] Loaded.
[22:02:19] Loading plugin: streamer.so
[22:02:19]

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

[22:02:19] Loaded.
[22:02:19] Loaded 2 plugins.

[22:02:19]
[22:02:19] Filterscripts
[22:02:19] ---------------
[22:02:19] Loaded 0 filterscripts.

[22:02:19] Config wird geladen..
[22:02:19] 1
[22:02:19] 2
[22:02:19] 3
[22:02:19] 4
[22:02:19] 5
[22:02:19] 6
[22:02:19] 7

code for the config load command:

stock Load_Config()
{
print("1");
new data[128];
print("2");
mysql_query("SELECT * FROM config LIMIT 1");
print("3");
mysql_store_result();
print("4");
if(mysql_num_rows())
{
print("5");
data = "baum";
mysql_fetch_field("hausanzahl",data);
Config[hausanzahl] = strval(data);
mysql_fetch_field("staatskasse",data);
Config[staatskasse] = strval(data);
mysql_fetch_field("steuern",data);
Config[steuern] = strval(data);
mysql_fetch_field("kfzsteuer",data);
Config[kfzsteuer] = strval(data);
mysql_fetch_field("benzinsteuer",data);
Config[benzinsteuer] = strval(data);
mysql_fetch_field("vermoegenssteuer",data);
Config[vermoegenssteuer] = strval(data);
mysql_fetch_field("arbeitslosengeld",data);
Config[arbeitslosengeld] = strval(data);
mysql_fetch_field("lotto",data);
Config[lotto] = strval(data);
}
print("6");
mysql_free_result();
print("7");
return 1;
}


My System:
- Debian Wheezy(7.0) 64 bit
- 4GB RAM
- libmysqlclient(16) installed

If i comment out the config load, the server crashes on the next fetch field

Hope you can help Me

Best regards
Hammerboy


PS: I'm German... here is my thread in the german forums: http://forum.sa-mp.de/san-andreas-mu...kt-beim-laden/
But there no one could help me :/
Reply
#2

Problem fixed. The only plugin which works for me is the Mysql Plugin by Dan.
When you have the same errors above then use this: https://sampforum.blast.hk/showthread.php?tid=429464
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)