SQL errors - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Server (
https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (
https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: SQL errors (
/showthread.php?tid=572038)
SQL errors -
Lukex - 24.04.2015
IIt works fine on my pc then i moved my server accross to my VPS and now get this.
http://prntscr.com/6xqolj
Anyhelp would be great!
Re: SQL errors -
Infinity001 - 24.04.2015
Your VPS Linux or Windows?
Re: SQL errors -
Lukex - 24.04.2015
Windows Server 2008 R2
Re: SQL errors -
Infinity001 - 24.04.2015
Hmm, are you running the latest version of MySQL?
Re: SQL errors -
Lukex - 24.04.2015
I believe so i just installed it. Unless there's something wrong with my sql code in my script
g_MySQLConnections[0] = mysql_connect("localhost", "root", "DB", "pass");
mysql_debug(1);
mysql_query("set session query_cache_type=0;", THREAD_NO_RESULT, 0, g_MySQLConnections[0]);
Re: SQL errors -
Infinity001 - 24.04.2015
You may need to change the mysql_connect information, Since your not using 'localhost' since that's your own SQL DB, Try looking for you SQL information.
Re: SQL errors -
Lukex - 24.04.2015
What do you mean, i am hosting my own SQL server from my VPS so it would be localhost wouldnt it the server is hosted on same server as sql
Re: SQL errors -
Jake187 - 24.04.2015
Your not loading your MySQL plugin
Re: SQL errors -
Lukex - 24.04.2015
Its in my server.config
Re: SQL errors -
Jake187 - 25.04.2015
Quote:
Originally Posted by Lukex
Its in my server.config
|
Just because it's in your config doesn't mean you're actually loading it. You're loading the lib not the actual plugin.