SMF Support > PostgreSQL and SQLite Support

Fatal error when installing SMF 2.0b4

<< < (2/2)

Whenstay:
Testing different things, I tryed with a Fluxbb forum and everything works with these parameters :
Database type: PostgreSQL
Server name: localhost
Username: toto.titi
Password: ********
Database name: toto.titi
Database prefix: flux_
Not any error and I chech the PostgreSQL database which has been correctly created. ::)

Whenstay:
I have the choice of the database encodage :
- SQL_ASCII
- LATIN1 / ISO8859-1
- LATIN9 / ISO8859-15
- Unicode, 8 bits

It was on SQL_ASCII, I don't know if it can help ?

Whenstay:
"Warnings" fixed by creating a "sessions" directory, but fatal error still here... ^^
Maybe the host is using php4.x after all. :P

Does it come from here ?

--- Code: --- 'postgresql' => array(
'name' => 'PostgreSQL',
'version' => '7.4.10',
'function_check' => 'pg_connect',
'version_check' => '$version = pg_version(); return $version[\'client\'];',
'supported' => function_exists('pg_connect'),
'always_has_db' => true,
'validate_prefix' => create_function('&$value', '
$value = preg_replace(\'~[^A-Za-z0-9_\$]~\', \'\', $value);

// Is it reserved?
if ($value == \'pg_\')
return $txt[\'error_db_prefix_reserved\'];

return true;
'),
),
--- End code ---

Thank you ! :)

Edit : PHP Version 4.4.3-dev AND PHP Version 5.1.3RC4-dev

To use the php5 version, I must rename file extension (".php" -> ".php5") or include the "php 1" line in a ".htaccess" ^^.

2nd edit : it solve the problem, thank you Oldiesmann for your clairvoyance ! :p

To reward me, SMF send me three new errors ! ^^

--- Quote ---Warning: pg_escape_string() expects exactly 1 parameter, 2 given in /mnt/102/sda/4/9/toto.titi/Sources/Subs-Db-postgresql.php on line 135

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/lang_index+Modifications_french_default.php) is not within the allowed path(s): (/mnt/102/sda/4/9/toto.titi) in /mnt/102/sda/4/9/toto.titi/Sources/Load.php on line 1801

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/lang_Errors_french_default.php) is not within the allowed path(s): (/mnt/102/sda/4/9/toto.titi) in /mnt/102/sda/4/9/toto.titi/Sources/Load.php on line 1801
--- End quote ---

Oldiesmann:
First one: Known bug.

To fix:
Sources/Subs-Db-Postgresql.php

Find

--- Code: (Line 135) --- return sprintf('\'%1$s\'', pg_escape_string($connection, $replacement));
--- End code ---

Replace

--- Code: --- return sprintf('\'%1$s\'', pg_escape_string($replacement));
--- End code ---

Second and third errors: You need to set the path to your cache directory in Settings.php.

Navigation

[0] Message Index

[*] Previous page