[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?

[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

[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.

[0815*Sir Tom]

Originally Posted by DJ Tsunami @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.

Ok. I'm using 5.1.2 and as your link is saying this:

07-Mar-2007 02:05 date_create and other DateTime related functions are included by default only in PHP versions equal and greater than 5.2. In PHP 5.1.2 this functionality is marked to be experimental and has to be enabled at compile time.

It isn't included in my PHP setup, I would need to recompile my PHP with option "on" for this function, called experimental by PHP "experts"?!

Ok, thanks for the support, I will not risk an "unstable" system, regarding all other applications running at our webserver.

[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