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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
install.php(step 3 of 5) show pg_query warning messages [message #187429] Wed, 28 February 2018 07:03 Go to next message
liujia is currently offline  liujia
Messages: 3
Registered: February 2018
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 07:09]

Report message to a moderator

Re: install.php(step 3 of 5) show pg_query warning messages [message #187438 is a reply to message #187429] Sun, 01 April 2018 07:55 Go to previous message
naudefj is currently offline  naudefj   United States
Messages: 3654
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You can safely ignore these warning.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Thu Jun 21 14:23:18 EDT 2018

Total time taken to generate the page: 0.00649 seconds