SA-MP Forums Archive
Mysql errors - 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 errors (/showthread.php?tid=447574)



Mysql errors - wendylorenzo - 30.06.2013

I recently downloaded a GameMode of Pizzy's pilots mode, i configured the mysql correct (guess so) and then i get these errors when i'm starting up the server: [Mysql]: [Error]: Connection to 'a2232493_pa' failed, and 5 times 'Failed to load airline.', is it possible to help me via skype/teamviewer? Skype: lorenzo_is_onnozel.
Код:
#define SQL_HOST "mysql6.000webhost.com"
#define SQL_USER "a2232493_lorenzo"
#define SQL_PASS "*********"
#define SQL_DB "a2232493_pa"
#define TABLENAME "users"
and

Thanks,
Lorenzo.


Re: Mysql errors - Kirollos - 30.06.2013

most of free hosts (like 000webhost) doesn't allow MySQL external connections.


Re: Mysql errors - wendylorenzo - 30.06.2013

Quote:
Originally Posted by kirollos
Посмотреть сообщение
most of free hosts (like 000webhost) doesn't allow MySQL external connections.
Any suggestion of another free/paid host wich allows it?


Re: Mysql errors - Scenario - 30.06.2013

Okay, first of all: https://sampforum.blast.hk/showthread.php?tid=445546

In regards to your most recent post on this thread: https://sampforum.blast.hk/showthread.php?tid=189169


Re: Mysql errors - wendylorenzo - 30.06.2013

Quote:
Originally Posted by RealCop228
Посмотреть сообщение
I only gave my skype here to help me if you need to see the whole script etc..


Re: Mysql errors - dowster - 30.06.2013

A quick ****** search for "free mysql hosting" gave me this website: http://www.freemysqlhosting.net/


Re: Mysql errors - wendylorenzo - 30.06.2013

Does it matters what i put in here:
Quote:

#define TABLENAME "users"

?


Re: Mysql errors - dowster - 30.06.2013

It shouldn't. As long as you have the table created in the database (in this case you're using the table 'users') it will work. I do not know if this script has inbuilt capabilities for creating non-existent databases, so it is better practice to create the database first in the control panel.