MySQL Question - Thanks! - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Question - Thanks! (/showthread.php?tid=472805)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Question - Thanks! (/showthread.php?tid=472805)
MySQL Question - Thanks! - hewittpro - 30.10.2013
I'm running with delux-host and I've created a MySQL Database but my server won't start up and I'm almost positive it's because of the MySQL side of things, I'm new to it so I could be forgetting something. I've added my .sql file to the database. At the bottom of my screen it also says "Server running with Suhosin. Please refer to documentation for possible issues." I don't know if thats an issue relating to my problem? Thanks guys!
Thanks guys!!!!
Re: MySQL Question - Thanks! - DanishHaq - 30.10.2013
Contact your host about the this is a Suhosin server or whatever, via a ticket or phone call, this is not a scripting problem. However for the database not connecting, you've probably got a problem in your syntax for the mysql_connect. Show us the Debug.txt.
Re: MySQL Question - Thanks! - GWMPT - 30.10.2013
"...but my server won't start up..."
Since when is it related to PHPMyAdmin?
Did you even taken a look in the log file to see what's causing it?
Did you used crashdetect plugin to know what's causing it?
PHP Suhosin has nothing to do with the MySQL server.
Re: MySQL Question - Thanks! - hewittpro - 30.10.2013
@kikito Okay Well actually it does. If the Mysql plugin doesn't connect with the database then it rejects the connection and unloads the mysql plugin, thats how it works for my gamemode at least.
@DanishHaq Yes I've got a ticket on hold right now with them and the my mysql database works perfectly fine when I'm running it via apache from XXAMP on localhost and I also don't get the Suhousin error. But with the database that was provided with the SAMP Hosting its giving me trouble. This is what I've found in my server_log.txt
Код:
Run time error 19: "File or function is not found" [12:01:12] Number of vehicle models: 0 [16:26:58] BAD RCON ATTEMPT BY: 2.133.117.168 [16:33:38] BAD RCON ATTEMPT BY: 2.133.117.168 [16:39:54] BAD RCON ATTEMPT BY: 2.133.117.168 [16:46:26] BAD RCON ATTEMPT BY: 2.133.117.168 [16:59:40] BAD RCON ATTEMPT BY: 2.133.117.168 [17:06:56] BAD RCON ATTEMPT BY: 2.133.117.168 [17:14:05] BAD RCON ATTEMPT BY: 2.133.117.168 [17:22:46] BAD RCON ATTEMPT BY: 2.133.117.168 [17:30:13] BAD RCON ATTEMPT BY: 2.133.117.168 [17:41:09] BAD RCON ATTEMPT BY: 195.58.251.228 [17:43:21] BAD RCON ATTEMPT BY: 195.58.251.228 [17:45:34] BAD RCON ATTEMPT BY: 195.58.251.228 [17:47:55] BAD RCON ATTEMPT BY: 195.58.251.228 [17:50:18] SAMPBrute 1.03.2 by 2010kohtep [17:52:42] BAD RCON ATTEMPT BY: 195.58.251.228 [17:54:52] BAD RCON ATTEMPT BY: 2.133.117.168 [18:01:48] BAD RCON ATTEMPT BY: 2.133.117.168 [18:08:50] BAD RCON ATTEMPT BY: 2.133.117.168 [18:16:07] BAD RCON ATTEMPT BY: 2.133.117.168 [18:24:32] BAD RCON ATTEMPT BY: 2.133.117.168 [18:32:56] BAD RCON ATTEMPT BY: 2.133.117.168 [18:41:25] BAD RCON ATTEMPT BY: 2.133.117.168 [18:50:42] BAD RCON ATTEMPT BY: 2.133.117.168 [18:59:38] BAD RCON ATTEMPT BY: 2.133.117.168 [19:07:38] BAD RCON ATTEMPT BY: 2.133.117.168 [19:18:07] BAD RCON ATTEMPT BY: 2.133.117.168 [19:23:35] BAD RCON ATTEMPT BY: 2.133.117.168 [19:31:45] BAD RCON ATTEMPT BY: 2.133.117.168 [19:44:27] BAD RCON ATTEMPT BY: 2.133.117.168 [19:55:10] BAD RCON ATTEMPT BY: 2.133.117.168 [20:00:01] BAD RCON ATTEMPT BY: 2.133.117.168 [20:05:14] BAD RCON ATTEMPT BY: 2.133.117.168 [20:10:45] BAD RCON ATTEMPT BY: 2.133.117.168 [20:16:53] BAD RCON ATTEMPT BY: 2.133.117.168 [20:21:25] BAD RCON ATTEMPT BY: 2.133.117.168 [20:21:38] BAD RCON ATTEMPT BY: 2.133.117.168 ---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3x, ©2005-2013 SA-MP Team [22:11:11] [22:11:11] Server Plugins [22:11:11] -------------- [22:11:11] Loading plugin: mysql [22:11:11] Failed (plugins/mysql: cannot open shared object file: No such file or directory) [22:11:11] Loading plugin: streamer.dll [22:11:11] Failed (plugins/streamer.dll: invalid ELF header) [22:11:11] Loading plugin: sscanf [22:11:11] Failed (plugins/sscanf: cannot open shared object file: No such file or directory) [22:11:11] Loading plugin: audio [22:11:11] Failed (plugins/audio: cannot open shared object file: No such file or directory) [22:11:11] Loading plugin: nativechecker [22:11:11] Failed (plugins/nativechecker: cannot open shared object file: No such file or directory) [22:11:11] Loaded 0 plugins. [22:11:11] [22:11:11] Ban list [22:11:11] -------- [22:11:11] Loaded: samp.ban [22:11:11] [22:11:11] [22:11:11] Filterscripts [22:11:11] --------------- [22:11:11] Loaded 0 filterscripts. [22:11:12] Script[gamemodes/hgrp10.amx]: Run time error 19: "File or function is not found" [22:11:12] Number of vehicle models: 0
Re: MySQL Question - Thanks! - hewittpro - 30.10.2013
oh fuck... lmao.. I have the windows MySQL plugin not the linux one
oops
Re: MySQL Question - Thanks! - GWMPT - 30.10.2013
PHPMyAdmin ISN'T an MySQL server for god sake!
Since when PHPMyAdmin has to do with the MySQL server?
As well, since when PHP Suhosin has to do with MySQL at all?
And next time, check the logs before creating a thread!
Re: MySQL Question - Thanks! - hewittpro - 30.10.2013
Okay now I've changed it all to Linux and this is what I'm looking at Any Ideas anyone? Please give me a hand with this? I've been stuck on this for a few days now !
Код:
4728 SA-MP Dedicated Server 4729 ---------------------- 4730 v0.3x, ©2005-2013 SA-MP Team 4731 4732 [23:44:23] 4733 [23:44:23] Server Plugins 4734 [23:44:23] -------------- 4735 [23:44:23] Loading plugin: mysql.so 4736 [23:44:23] SA:MP MySQL Plugin v2.1.1 Loaded. 4737 [23:44:23] Loaded. 4738 [23:44:23] Loading plugin: streamer.so 4739 [23:44:23] 4740 4741 *** Streamer Plugin v2.6.1 by Incognito loaded *** 4742 4743 [23:44:23] Loaded. 4744 [23:44:23] Loading plugin: sscanf.so 4745 [23:44:23] 4746 4747 [23:44:23] =============================== 4748 4749 [23:44:23] sscanf plugin loaded. 4750 4751 [23:44:23] © 2009 Alex "******" Cole 4752 4753 [23:44:23] 0.3d-R2 500 Players "dnee" 4754 4755 [23:44:23] =============================== 4756 4757 [23:44:23] Loaded. 4758 [23:44:23] Loading plugin: audio.so 4759 [23:44:23] 4760 4761 *** Audio Plugin v0.5 R2 by Incognito loaded *** 4762 4763 [23:44:23] Loaded. 4764 [23:44:23] Loading plugin: nativechecker.so 4765 [23:44:23] Loaded. 4766 [23:44:23] Loaded 5 plugins. 4767 4768 [23:44:23] [MySQL] Thread running. Threadsafe: Yes. 4769 [23:44:24] 4770 [23:44:24] Ban list 4771 [23:44:24] -------- 4772 [23:44:24] Loaded: samp.ban 4773 [23:44:24] 4774 [23:44:24] 4775 [23:44:24] Filterscripts 4776 [23:44:24] --------------- 4777 [23:44:24] Loaded 0 filterscripts. 4778 4779 [23:44:24] Error: Function not registered: 'mysql_retrieve_row' 4780 [23:44:24] Error: Function not registered: 'mysql_fetch_field_row' 4781 [23:44:24] Script[gamemodes/hgrp10.amx]: Run time error 19: "File or function is not found" 4782 [23:44:24] Number of vehicle models: 0
Re: MySQL Question - Thanks! - hewittpro - 30.10.2013
Kikito I still have a problem! I don't know why you need to give me such a hard time? This section is for asking questions.. is it not? If you are just going to rant on here you don't have to post? Sorry if I irritated you but I was just asking for help..
Re: MySQL Question - Thanks! - GWMPT - 30.10.2013
Код:
4779 [23:44:24] Error: Function not registered: 'mysql_retrieve_row' 4780 [23:44:24] Error: Function not registered: 'mysql_fetch_field_row'
Re: MySQL Question - Thanks! - Djole1337 - 30.10.2013
Quote:
|
Server running with Suhosin. Please refer to documentation for possible issues." I don't know if thats an issue relating to my problem? Thanks guys! |