FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » install.php(step 3 of 5) show pg_query warning messages
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
install.php(step 3 of 5) show pg_query warning messages [message #187429] Wed, 28 February 2018 12:03 Go to previous message
liujia is currently offline  liujia
Messages: 3
Registered: February 2018
Karma:
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

http://i66.tinypic.com/2lvd9uq.png

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

[Message index]
 
Read Message
Read Message
Previous Topic: Pspell Extension: disabled
Next Topic: Errore nntp: PHP Fatal error: SQL error has occurred!
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 14:40:13 GMT 2024

Total time taken to generate the page: 0.08015 seconds