[fantarn]

Hi,


I've just installed http://forums.alliedmods.net/showthread.php?p=613430.

Uploaded everything, made an database but it doesn't show any names, i mean, it won't update.

This is the top15

Since i got none knowledge of MySql, i was hoping i could get some help here.


Thanks in advance!

[piepie]

Maybe your host dont support sql remote since it's free (i guess). Any errors on the server?

[fantarn]

Hi,

This site came free with a gameserver at gameservers.com
the website can be controlled with cPanel X, there's something called remote MySql.
When i open this up there's something about a "wildcard"?

"Add Access Host"
"Host (% wildcard is allowed):"


In my server console it do say something like this:

EDIT:

L 05/18/2013 - 053:28: [MySQL] Invalid database handle: 0 L 05/18/2013 - 053:28: [AMXX] Displaying debug trace (plugin "psd_007-3.amxx") L 05/18/2013 - 053:28: [AMXX] Run time error 10: native error (native "SQL_PrepareQuery") L 05/18/2013 - 053:28: [AMXX] [0] 27570.attach::SequentialData (line 286) L 05/18/2013 - 053:28: [AMXX] [1] 27570.attach::client_putinserver (line 25

These are the errors that causes it.

Another small question,

When you've uploaded all the website stuff to your site.
http://website.com/ranking_sample.php, There should the top15 be at right?


Thanks

[piepie]

Go to remote sql and put the ip from your server.

[fantarn]

Hi,

It had no succes, this error shows up in console:

[PSD] Error No.2013: Lost connection to MySQL server at 'reading initial communication packet', system error: 0

and after a second restart this error showed up:

L 05/18/2013 - 06:25:43: [MySQL] Invalid database handle: 0 L 05/18/2013 - 06:25:43: [AMXX] Displaying debug trace (plugin "psd_007-3.amxx") L 05/18/2013 - 06:25:43: [AMXX] Run time error 10: native error (native "SQL_PrepareQuery") L 05/18/2013 - 06:25:43: [AMXX] [0] 27570.attach::SequentialData (line 286) L 05/18/2013 - 06:25:43: [AMXX] [1] 27570.attach::client_putinserver (line 25

I've read something about creating a table, is this true? Or does it make one automaticly?


Thanks

[piepie]

Originally Posted by fantarn Hi, I've read something about creating a table, is this true? Or does it make one automaticly? Thanks

It creates the table automaticly (it should).

[fantarn]

Hi,

I really hate to ask you this but could you perhaps make a step-by-step tutorial for how to install this?


Thanks in advance

[fantarn]

Now it says this:

[PSD] Error: Can't connect: Can't connect to MySQL server on '127.0.0.1' (111)

I have this in the script:

g_dbhost = register_cvar("amx_sql_host","mysql1.000webho st.com") g_dbuser = register_cvar("amx_sql_user","a9419207_admin" ) g_dbpass = register_cvar("amx_sql_pass","*****") g_dbname = register_cvar("amx_sql_db","a9419207_stats") g_tbname = register_cvar("psd_tbname","statustable")

and this in sql.cfg

amx_sql_host "mysql1.000webhost.com" amx_sql_user "a9419207_admin" amx_sql_pass "****" amx_sql_db "stats" amx_sql_table "admins" amx_sql_type "mysql"

i've been working on this all day and still don't have a solution.
Well i'm off to work now, hopefully someone knows the solution for this.

I'd be very happy.


Thanks

[piepie]

000webhost.com dont support remote sql.

[fantarn]

Where can i get an good DB with Remote sql?