Hello Guys,
I was just informed by a visitor, that a bunch of my websites show
PHP/pgsql errors... Of course, they relay all on the same database
scripts and now I discovered, that the physical server had an error, my
ISP replaced the harddisks and put a backup of the content on it!
Several month old!
WTF?
I am now for 6 month (or longer) in Estonia and have no physical access
to my Backups in Strasbourg which really p..s me off!
However, the offending sniplet is:
8<--
[47]} elseif (DB_TYPE == 'pgsql') {
[48]
[49] function db_connect($host=DB_HOST, $port=DB_PORT, $database=DB_NAME,
$user=DB_USER, $pass=DB_PASS, $link='db_link') {
[50]global $$link;
[51]$$link = pg_pconnect("host=$host port=$port dbname=$database user=$user
password=$pass");
[52]return $$link;
[53] }
[54]
[55] function db_close($link='db_link') {
[56]global $$link;
[57]return pg_close($link);
[58] }
[59]
[60] function db_error($query, $errno, $error) {
[61]die("Error $errno$error$query");
[62] }
[63]
[64] function db_query($query, $link='db_link') {
[65]global $$link;
[66]$result = pg_query($link, $query) or db_error($query, '',
pg_last_error($link));
[67]return $result;
[68] }
[69]
[70] function db_fetch_array($db_query) {
[71]return pg_fetch_array($db_query);
[72] }
[73]
[74] function db_free_result($db_query) {
[75]return pg_free_result($db_query);
[76]
[77] function db_fetch_fields($db_query) {
[78]return pg_fetch_fields($db_query);
[79] }
[80]
[81] function db_input($string, $link='db_link') {
[82]return pg_escape_string($link, $string);
[83]return addslashes($string);
[84] }
8<--
[Sun May 28 12:14:20 2017] [error] [client 85.29.216.115] PHP Warning:
pg_query() expects parameter 1 to be resource, string given in
/srv/tdphp-vserver2/includes/01_database.inc on line 64
[Sun May 28 12:14:20 2017] [error] [client 85.29.216.115] PHP Warning:
pg_last_error() expects parameter 1 to be resource, string given in
/srv/tdphp-vserver2/includes/01_database.inc on line 64
The page show "Resource id #17".
This script was working 68 days ago (before the crash) but it seems, I
sit on my line and do not find the error.
Any suggestions?
Have a nice Sunday
--
Michelle KonzackMiila ITSystems @ TDnet
GNU/Linux Developer 00372-54541400
signature.asc
Description: Digital signature