[Chaos Llama]

Here's what i have in my databases.cfg file (modified to remove database username, password and name):

"Databases" { "driver_default" "mysql" "sourcebans" { "driver" "mysql" "host" "69.57.183.122" "database" "xxxx" "user" "xxxx" "pass" "xxxxxxxxxxxxxxxxx" //"timeout" "0" "port" "3306" } }

I get an error message before too and it complains about sqlite not being installed (because i deleted the ext so that only mysql is loaded).

I noticed in my scripting directory, i have admin-sql-threaded and admin-sql-prefetch. Should either of these be installed in plugins and if so which one causes the least amount of connections to the database server?

[0815*Sir Tom]

Originally Posted by Davethegreat make sure your php.ini is configured correctly.

erm... My php.ini runs fine, for over one year now. As I said, RC1 ran w/o a problem days ago, before I upgraded to the latest build, which doesn't.

On the other hand, what should I do with my php.ini then?

(webserver works great, WBB3, AMXBans, etc.pp. all running well and smooth)

[Davethegreat]

sorry wrong file in your
.htaccess the following line should be there.
AddHandler application/x-httpd-php .php .php5

[DJ Tsunami]

@Chaos Llama: an ext only gets loaded if a plugin actually uses it, so there's no use in deleting the file. And no, you don't need any of the admin-sql plugins, only admin-flatfile.

@Sir Tom: http://www.php.net/date_create clearly says that date_create is a PHP >= 5.1.0 function, so if your installation says it doesn't recognize that function there's definitely something wrong with your PHP settings.

[Davethegreat]

That command in your .htaccess i gave you should fix it^^

[zerak]

Chaos Llama used debug and tell us the error you are getting with this database.cfg (should not be the same error as previously) and tell us if you run the server behind NAT/PAT (ex of the most common: 192.168.0.XXX)

[Davethegreat]

Or 10.*.*.* in professional hosting

[zerak]

Cool never thought I was professional

One common problem (at least for us, and I keep forgetting it) is that the query use hostip which is the ip inside your local net that is behind NAT/PAT and hence i made the patch a couple of pages back where you can set it to use the ip specified (an if case that removes the overwritting with hostip).

[Davethegreat]

xD, yeah 10, is usually used in companys and 192 in homes. But I myself have done the same zerak

[Chaos Llama]

I finally got it to work. I'm not exactly sure what fixed it as i tried a whole bunch of things. I enabled auto connect and fixed the table prefix in sourcebans.cfg