MySql Keeps failing me - Printable Version

MySql Keeps failing me - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySql Keeps failing me (/showthread.php?tid=264935)

MySql Keeps failing me - DeadAhead - 28.06.2011

Code:

Код:

	mysql_init();
	mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS,MYSQL_DB);
	mysql_query("INSERT INTO hello (Username,Password) VALUES ('hello','bellow')");

in OnGameModeInit, i have all the plugin set in server.cfg, gamemode loaded, I check my DB with phpMyAdmin, nothing happens (same)

Any idea why?

The Structure is fine, i copy pasted it and ran it into phpyMyAdmin, worked fine. I'm using 000webhost, I defined all those variables, it compiles fine. Now it doesn't do its function

Any idea why?

EDIT: I'm sure i copy pasted the stuff right, but its saying that it can't connect...

Re: MySql Keeps failing me - PrawkC - 28.06.2011

Enable mysql debugging, idk how to with strickens plugin, and then check your mysql_log for the issue

Re: MySql Keeps failing me - DeadAhead - 28.06.2011

Thanks.
I found the two sources of the problem
-Half of my plugin files were 2 Different SQL Plugins, Now i cleaned that up
-000webhost does a bad job at hosting MySql, i switched to another one
-I didn't turn Debug on to fix both of these earlier :P!

~resolved