SA-MP Forums Archive
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.