FUDforum: FUDforum Installation Issues » install.php(step 3 of 5) show pg

Home » FUDforum » FUDforum Installation Issues » install.php(step 3 of 5) show pg_query warning messages

Show: Today's Messages :: Polls :: Message Navigator

install.php(step 3 of 5) show pg_query warning messages [message #187429]

Wed, 28 February 2018 12:03

liujia
Messages: 3
Registered: February 2018

Karma: 0

Junior Member

Sir,

I tried to install FUDforum: 3.0.8RC1 on Debian(nginx + php7.0 + pgsql 9.6.7), after I entered pgsql connection information, step 3 of 5 installation show below warning messages:

Warning:pg_query(): Query failed: ERROR: table "fud30_tv_2" does not exist in /var/www/FUDforum/sql/pgsql/db.inc on line 108

Warning:pg_query(): Query failed: ERROR: table "fud30_tv_3" does not exist in /var/www/FUDforum/sql/pgsql/db.inc on line 108

Warning:pg_query(): Query failed: ERROR: table "fud30_fl_2" does not exist in /var/www/FUDforum/sql/pgsql/db.inc on line 108

Warning:pg_query(): Query failed: ERROR: table "fud30_fl_3" does not exist in /var/www/FUDforum/sql/pgsql/db.inc on line 108

But I finished the installation after ignore it.

/var/www/FUDforum/sql/pgsql/db.inc around 108 line content:

function uq($q)
{
	return q($q);
}

if (!defined('fud_query_stats')) {
	function q($q)
	{
		$GLOBALS['__FLPG__'] = pg_query(fud_sql_lnk, $q) or fud_sql_error_handler($q, pg_last_error(fud_sql_lnk), '', db_version());
		return $GLOBALS['__FLPG__'];
	}
} else {
	function q($q)
	{
		if (!isset($GLOBALS['__DB_INC_INTERNALS__']['query_count'])) {
			$GLOBALS['__DB_INC_INTERNALS__']['query_count'] = 1;
		} else {
			++$GLOBALS['__DB_INC_INTERNALS__']['query_count'];
		}
	
		if (!isset($GLOBALS['__DB_INC_INTERNALS__']['total_sql_time'])) {
			$GLOBALS['__DB_INC_INTERNALS__']['total_sql_time'] = 0;
		}
	
		$s = microtime(true);
		$GLOBALS['__FLPG__'] = pg_query(fud_sql_lnk, $q) or fud_sql_error_handler($q, pg_last_error(fud_sql_lnk), '', db_version());
		$e = microtime(true);
	
		$GLOBALS['__DB_INC_INTERNALS__']['last_time'] = ($e - $s);;
		$GLOBALS['__DB_INC_INTERNALS__']['total_sql_time'] += $GLOBALS['__DB_INC_INTERNALS__']['last_time'];

		echo '<hr><b>Query #'. $GLOBALS['__DB_INC_INTERNALS__']['query_count'] .'</b><small>';
		echo ': time taken:     <i>'. number_format($GLOBALS['__DB_INC_INTERNALS__']['last_time'], 4) .'</i>';
		echo ', affected rows:  <i>'. db_affected() .'</i>';
		echo ', total sql time: <i>'.  number_format($GLOBALS['__DB_INC_INTERNALS__']['total_sql_time'], 4) .'</i>';
		echo '<pre>'. preg_replace('!\s+!', ' ', htmlspecialchars($q)) .'</pre></small>';

		return $GLOBALS['__FLPG__'];
	}
}

[Updated on: Wed, 28 February 2018 12:09]

Report message to a moderator