This topic is locked
[SOLVED]

Upgrade PostgreSQL from 13 to 14

2/4/2022 8:22:40 PM
PHPRunner General questions
B
binarykevin author

I upgraded to a new system 40GB, SSD Gen 4, 8 Core I7, etc....
While was at it, I upgraded to Postgresql 14.x from 13.x

This is what I get.
http://localhost:8086/login.php

Fatal error: Uncaught Error: Call to undefined function pg_escape_string() in R:\output\connections\PostgreConnection.php:29 Stack trace: #0 R:\output\connections\Connection.php(54): PostgreConnection->assignConnectionParams(Array) #1 R:\output\connections\PostgreConnection.php(18): Connection->construct(Array) #2 R:\output\connections\ConnectionManager.php(91): PostgreConnection->construct(Array) #3 R:\output\connections\ConnectionManager_base.php(95): ConnectionManager->getConnection('Tables') #4 R:\output\connections\ConnectionManager_base.php(115): ConnectionManager_Base->byId('Tables') #5 R:\output\include\appsettings.php(912): ConnectionManager_Base->getDefault() #6 R:\output\include\dbcommon.php(90): include('R:\output\inclu...') #7 R:\output\login.php(5): require_once('R:\output\inclu...') #8 {main} thrown in R:\output\connections\PostgreConnection.php on line 29

Contents From the R:\output\connections\PostgreConnection.php:29

* Set db connection's properties
* @param Array params
*/
protected function assignConnectionParams( $params )
{
parent::assignConnectionParams( $params );

29 $host = pg_escape_string( $params["connInfo"][0] ); //strConnectInfo1
$user = pg_escape_string( $params["connInfo"][1] ); //strConnectInfo2
$password = pg_escape_string( $params["connInfo"][2] ); //strConnectInfo3
$dbname = pg_escape_string( $params["connInfo"][4] ); //strConnectInfo5
$options = $params["connInfo"][3]; //strConnectInfo4

$this->connstr = "host='". $host .
"' user='". $user .
"' password='". $password .
"' dbname='". $dbname .
"' ".$options;
}
-- And Contents from #18 //(I notice it says versionn 8)

/**
* db version
* @type Number
*/
public $postgreDbVersion = 8;

function __construct( $params )
{

18 parent::__construct( $params );

}