install.php(step 3 of 5) show pg_query warning messages [message #187429] |
Wed, 28 February 2018 07:03 |
|
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
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
|
|
|
|