[muukis]

Originally Posted by Paco I'm not a programmer or I might do something to get this working. I did, however, get past the initial timeout which I believe is because the browser isn't receiving anything. This could easily be fixed by adding a few more if statements I bet where you give a percentage of how far along it is or send something back to the browser every 25-30 seconds. My method? The noob way! I added an echo to show the row number as they were being created. lol Well, it worked somewhat and allowed it to get to 2156304 rows this time! ;) (It also took up a decent amount of memory on my PC, but not too bad. lol) So, another timeout, but at least I have a message this time: Apache Keep-Alive: timeout=15, max=99 I'm wondering if it wasn't having to echo each row if it might have completed. lol

You can test this, though I don't think it will help you...

In the unmodified updatetable.php, add below this code (all of them):

PHP Code:

if (mysql_query($query)) echo "| "; else die("<br /><font color=\"darkred\">" . mysql_error() . "</font><br />\n"); 


this:

PHP Code:

flush(); 


The PHP docs for method flush: LINK

[bloodmaan]

Hello muukis i have problem http://93.152.173.161/normal/ db is ok and imported

[muukis]

Originally Posted by bloodmaan Hello muukis i have problem http://93.152.173.161/normal/ db is ok and imported

https://forums.alliedmods.net/showth...56#post1079256

[bloodmaan]

tnx muukis now is ok

[nakashimakun]

Hello,

I'm having a problem with getting this working. I have everything installed and set up. But when I load the server the plugin Failed to load.

Heres whats the Error Log says.

L 02/10/2010 - 16:51:19: SourceMod error session started
L 02/10/2010 - 16:51:19: Info (map "c1m1_hotel") (file "errors_20100210.log")
L 02/10/2010 - 16:51:19: [l4d_stats.smx] Databases.cfg missing 'l4dstats' entry!
L 02/10/2010 - 16:51:19: [SM] Plugin encountered error 25: Call was aborted
L 02/10/2010 - 16:51:19: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 02/10/2010 - 16:51:19: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 02/10/2010 - 16:51:19: [SM] [0] Line 566, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()
L 02/10/2010 - 16:534: Error log file session closed.
L 02/10/2010 - 16:534: SourceMod error session started
L 02/10/2010 - 16:534: Info (map "c3m1_plankcountry") (file "errors_20100210.log")
L 02/10/2010 - 16:534: [l4d_stats.smx] Databases.cfg missing 'l4dstats' entry!
L 02/10/2010 - 16:534: [SM] Plugin encountered error 25: Call was aborted
L 02/10/2010 - 16:534: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 02/10/2010 - 16:534: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 02/10/2010 - 16:534: [SM] [0] Line 566, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()
L 02/10/2010 - 16:55:29: Error log file session closed.

But On my database.cfg I have the l4dstats entry in there and all the connection information is correct I don't understand why its not connecting if your could help me towards this matter. That would be fantastic.

."Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"l4dstats"
{
"driver" "mysql"
"host" "theomega.co.uk.mysql"
"database" "theomega_co_uk"
"user" "theomega_co_uk"
"pass" "hillier25138803"

}
}


NakashimaKun

[lekzero]

I think these two stats are not being recorded.

Saved Friendlies from Hunters 0
Rescued Friendlies0 (Just for coop right?)

[muukis]

Originally Posted by nakashimakun I'm having a problem with getting this working. I have everything installed and set up. But when I load the server the plugin Failed to load.

It looks good... is your databases.cfg in the correct place? Does the game have full file access to the it? What else is there to check?

Originally Posted by lekzero I think these two stats are not being recorded. Saved Friendlies from Hunters 0 Rescued Friendlies0 (Just for coop right?)

You might be right. Something has broken. I'll take a look soon.

[nakashimakun]

Originally Posted by muukis It looks good... is your databases.cfg in the correct place? Does the game have full file access to the it? What else is there to check?

Its located on my server in

addons/sourcemod/configs/

So it should be in the right place. it has full read/write access. so it should all be working. I don't get where I've gone wrong.

[.=QUACK=.Major.pain]

Originally Posted by nakashimakun Its located on my server in addons/sourcemod/configs/ So it should be in the right place. it has full read/write access. so it should all be working. I don't get where I've gone wrong.

Your "host" is theomega.co.uk.mysql

Not really sure, but don't think it is any good.
Try to ping the url and not found.

[nakashimakun]

Weird thats what my provider gave me. I ill get on the pipe to them and contact them about this. but If thats the only problem with it not contacting would that fix the problem?