Upgradtion error from OJS-2.4.0-8 to OJS-3.2.1-4 (Deprecated: Function get_magic_quotes_runtime)

Hello
We have upgraded from OJS-2.3 to OJS-2.4 and now we are trying to upgrade from OJS-2.4.0-8 to OJS-3.2.1-4 but bellow mentioned error log is generated during the upgradation.
But the upgradation process is still running with this log.

[29-Nov-2022 11:13:32 UTC] PHP Deprecated:  Function get_magic_quotes_runtime() is deprecated in D:\wamp64\www\ojs-3.2.1-4\lib\pkp\lib\vendor\adodb\adodb-php\adodb-xmlschema.inc.php on line 1307
[29-Nov-2022 11:13:32 UTC] PHP Stack trace:
[29-Nov-2022 11:13:32 UTC] PHP   1. {main}() D:\wamp64\www\ojs-3.2.1-4\index.php:0
[29-Nov-2022 11:13:32 UTC] PHP   2. PKPApplication->execute() D:\wamp64\www\ojs-3.2.1-4\index.php:68
[29-Nov-2022 11:13:32 UTC] PHP   3. Dispatcher->dispatch($request = class Request { public $_router = class PageRouter { public $_installationPages = [...]; public $_page = 'install'; public $_op = 'installUpgrade'; public $_indexUrl = NULL; public $_cacheFilename = NULL; public $_application = class Application { ... }; public $_dispatcher = class Dispatcher { ... }; public $_contextDepth = 1; public $_contextList = [...]; public $_flippedContextList = [...]; public $_contextPaths = [...]; public $_contexts = [...]; public $_handler = class InstallHandler { ... } }; public $_dispatcher = class Dispatcher { public $_application = class Application { ... }; public $_routerNames = [...]; public $_routerInstances = [...]; public $_router = class PageRouter { ... }; public $_requestCallbackHack = NULL }; public $_requestVars = []; public $_basePath = '/ojs-3.2.1-4'; public $_requestPath = '/ojs-3.2.1-4/index.php/index/install/installUpgrade'; public $_isRestfulUrlsEnabled = FALSE; public $_isPathInfoEnabled = TRUE; public $_serverHost = 'localhost'; public $_protocol = 'http'; public $_isBot = NULL; public $_userAgent = NULL }) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\core\PKPApplication.inc.php:281
[29-Nov-2022 11:13:32 UTC] PHP   4. PKPPageRouter->route($request = class Request { public $_router = class PageRouter { public $_installationPages = [...]; public $_page = 'install'; public $_op = 'installUpgrade'; public $_indexUrl = NULL; public $_cacheFilename = NULL; public $_application = class Application { ... }; public $_dispatcher = class Dispatcher { ... }; public $_contextDepth = 1; public $_contextList = [...]; public $_flippedContextList = [...]; public $_contextPaths = [...]; public $_contexts = [...]; public $_handler = class InstallHandler { ... } }; public $_dispatcher = class Dispatcher { public $_application = class Application { ... }; public $_routerNames = [...]; public $_routerInstances = [...]; public $_router = class PageRouter { ... }; public $_requestCallbackHack = NULL }; public $_requestVars = []; public $_basePath = '/ojs-3.2.1-4'; public $_requestPath = '/ojs-3.2.1-4/index.php/index/install/installUpgrade'; public $_isRestfulUrlsEnabled = FALSE; public $_isPathInfoEnabled = TRUE; public $_serverHost = 'localhost'; public $_protocol = 'http'; public $_isBot = NULL; public $_userAgent = NULL }) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\core\Dispatcher.inc.php:143
[29-Nov-2022 11:13:32 UTC] PHP   5. PKPRouter->_authorizeInitializeAndCallRequest($serviceEndpoint = [0 => class InstallHandler { protected $_apiToken = NULL; public $_id = 'install'; public $_dispatcher = class Dispatcher { ... }; public $_checks = [...]; public $_roleAssignments = [...]; public $_authorizationDecisionManager = class AuthorizationDecisionManager { ... }; public $_enforceRestrictedSite = TRUE; public $_roleAssignmentsChecked = FALSE }, 1 => 'installUpgrade'], $request = class Request { public $_router = class PageRouter { public $_installationPages = [...]; public $_page = 'install'; public $_op = 'installUpgrade'; public $_indexUrl = NULL; public $_cacheFilename = NULL; public $_application = class Application { ... }; public $_dispatcher = class Dispatcher { ... }; public $_contextDepth = 1; public $_contextList = [...]; public $_flippedContextList = [...]; public $_contextPaths = [...]; public $_contexts = [...]; public $_handler = class InstallHandler { ... } }; public $_dispatcher = class Dispatcher { public $_application = class Application { ... }; public $_routerNames = [...]; public $_routerInstances = [...]; public $_router = class PageRouter { ... }; public $_requestCallbackHack = NULL }; public $_requestVars = []; public $_basePath = '/ojs-3.2.1-4'; public $_requestPath = '/ojs-3.2.1-4/index.php/index/install/installUpgrade'; public $_isRestfulUrlsEnabled = FALSE; public $_isPathInfoEnabled = TRUE; public $_serverHost = 'localhost'; public $_protocol = 'http'; public $_isBot = NULL; public $_userAgent = NULL }, $args = [], $validate = FALSE) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\core\PKPPageRouter.inc.php:231
[29-Nov-2022 11:13:32 UTC] PHP   6. InstallHandler->installUpgrade($args = [], $request = class Request { public $_router = class PageRouter { public $_installationPages = [...]; public $_page = 'install'; public $_op = 'installUpgrade'; public $_indexUrl = NULL; public $_cacheFilename = NULL; public $_application = class Application { ... }; public $_dispatcher = class Dispatcher { ... }; public $_contextDepth = 1; public $_contextList = [...]; public $_flippedContextList = [...]; public $_contextPaths = [...]; public $_contexts = [...]; public $_handler = class InstallHandler { ... } }; public $_dispatcher = class Dispatcher { public $_application = class Application { ... }; public $_routerNames = [...]; public $_routerInstances = [...]; public $_router = class PageRouter { ... }; public $_requestCallbackHack = NULL }; public $_requestVars = []; public $_basePath = '/ojs-3.2.1-4'; public $_requestPath = '/ojs-3.2.1-4/index.php/index/install/installUpgrade'; public $_isRestfulUrlsEnabled = FALSE; public $_isPathInfoEnabled = TRUE; public $_serverHost = 'localhost'; public $_protocol = 'http'; public $_isBot = NULL; public $_userAgent = NULL }) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\core\PKPRouter.inc.php:391
[29-Nov-2022 11:13:32 UTC] PHP   7. UpgradeForm->execute() D:\wamp64\www\ojs-3.2.1-4\lib\pkp\pages\install\InstallHandler.inc.php:106
[29-Nov-2022 11:13:32 UTC] PHP   8. Installer->execute() D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\install\form\UpgradeForm.inc.php:42
[29-Nov-2022 11:13:32 UTC] PHP   9. Installer->executeInstaller() D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\install\Installer.inc.php:186
[29-Nov-2022 11:13:32 UTC] PHP  10. Installer->executeAction($action = ['type' => 'schema', 'file' => 'lib/pkp/xml/schema/common.xml', 'attr' => ['file' => 'lib/pkp/xml/schema/common.xml']]) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\install\Installer.inc.php:263
[29-Nov-2022 11:13:32 UTC] PHP  11. adoSchema->__construct($db = class ADODB_mysqli { public $databaseType = 'mysqli'; public $dataProvider = 'mysql'; public $hasInsertID = TRUE; public $hasAffectedRows = TRUE; public $metaTablesSQL = 'SELECT\n\t\t\tTABLE_NAME,\n\t\t\tCASE WHEN TABLE_TYPE = \'VIEW\' THEN \'V\' ELSE \'T\' END\n\t\tFROM INFORMATION_SCHEMA.TABLES\n\t\tWHERE TABLE_SCHEMA='; public $metaColumnsSQL = 'SHOW COLUMNS FROM `%s`'; public $fmtTimeStamp = '\'Y-m-d H:i:s\''; public $hasLimit = TRUE; public $hasMoveFirst = TRUE; public $hasGenID = TRUE; public $isoDates = TRUE; public $sysDate = 'CURDATE()'; public $sysTimeStamp = 'NOW()'; public $hasTransactions = TRUE; public $forceNewConnect = FALSE; public $poorAffectedRows = TRUE; public $clientFlags = 0; public $substr = 'substring'; public $port = 3306; public $socket = ''; public $_bindInputArray = FALSE; public $nameQuote = '`'; public $optionFlags = [0 => [...]]; public $arrayClass = 'ADORecordSet_array_mysqli'; public $multiQuery = FALSE; public $_genIDSQL = 'update %s set id=LAST_INSERT_ID(id+1);'; public $_genSeqSQL = 'create table if not exists %s (id int not null)'; public $_genSeqCountSQL = 'select count(*) from %s'; public $_genSeq2SQL = 'insert into %s values (%s)'; public $_dropSeqSQL = 'drop table if exists %s'; public $database = 'ojs2'; public $host = 'localhost'; public $user = 'epubs'; public $password = 'not stored'; public $debug = FALSE; public $maxblobsize = 262144; public $concat_operator = '+'; public $length = 'length'; public $random = 'rand()'; public $upperCase = 'upper'; public $fmtDate = '\'Y-m-d\''; public $true = '1'; public $false = '0'; public $replaceQuote = '\\\''; public $charSet = FALSE; public $metaDatabasesSQL = ''; public $uniqueOrderBy = FALSE; public $emptyDate = ' '; public $emptyTimeStamp = ' '; public $lastInsID = FALSE; public $hasTop = FALSE; public $readOnly = FALSE; public $genID = 0; public $raiseErrorFn = FALSE; public $cacheSecs = 3600; public $memCache = FALSE; public $memCacheHost = NULL; public $memCachePort = 11211; public $memCacheCompress = FALSE; public $sysUTimeStamp = FALSE; public $noNullStrings = FALSE; public $numCacheHits = 0; public $numCacheMisses = 0; public $pageExecuteCountRows = TRUE; public $uniqueSort = FALSE; public $leftOuter = FALSE; public $rightOuter = FALSE; public $ansiOuter = FALSE; public $autoRollback = FALSE; public $fnExecute = FALSE; public $fnCacheExecute = FALSE; public $blobEncodeType = FALSE; public $rsPrefix = 'ADORecordSet_'; public $autoCommit = TRUE; public $transOff = 0; public $transCnt = 0; public $fetchMode = FALSE; public $null2null = 'null'; public $bulkBind = FALSE; public $_oldRaiseFn = FALSE; public $_transOK = NULL; public $_connectionID = class mysqli { public $affected_rows = 1; public $client_info = 'mysqlnd 7.4.26'; public $client_version = 70426; public $connect_errno = 0; public $connect_error = NULL; public $errno = 0; public $error = ''; public $error_list = [...]; public $field_count = 0; public $host_info = 'localhost via TCP/IP'; public $info = 'Rows matched: 1  Changed: 1  Warnings: 0'; public $insert_id = 0; public $server_info = '8.0.27'; public $server_version = 80027; public $sqlstate = '00000'; public $protocol_version = 10; public $thread_id = 146; public $warning_count = 0 }; public $_errorMsg = FALSE; public $_errorCode = FALSE; public $_queryID = TRUE; public $_isPersistentConnection = FALSE; public $_evalAll = FALSE; public $_affected = FALSE; public $_logsql = FALSE; public $_transmode = ''; protected $connectionParameters = []; public $databaseName = 'ojs2' }) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\install\Installer.inc.php:365
[29-Nov-2022 11:19:54 UTC] PHP Deprecated:  Function get_magic_quotes_runtime() is deprecated in D:\wamp64\www\ojs-3.2.1-4\lib\pkp\lib\vendor\adodb\adodb-php\adodb-xmlschema.inc.php on line 1307
[29-Nov-2022 11:19:54 UTC] PHP Stack trace:
[29-Nov-2022 11:19:54 UTC] PHP   1. {main}() D:\wamp64\www\ojs-3.2.1-4\index.php:0
[29-Nov-2022 11:19:54 UTC] PHP   2. PKPApplication->execute() D:\wamp64\www\ojs-3.2.1-4\index.php:68
[29-Nov-2022 11:19:54 UTC] PHP   3. Dispatcher->dispatch($request = class Request { public $_router = class PageRouter { public $_installationPages = [...]; public $_page = 'install'; public $_op = 'installUpgrade'; public $_indexUrl = NULL; public $_cacheFilename = NULL; public $_application = class Application { ... }; public $_dispatcher = class Dispatcher { ... }; public $_contextDepth = 1; public $_contextList = [...]; public $_flippedContextList = [...]; public $_contextPaths = [...]; public $_contexts = [...]; public $_handler = class InstallHandler { ... } }; public $_dispatcher = class Dispatcher { public $_application = class Application { ... }; public $_routerNames = [...]; public $_routerInstances = [...]; public $_router = class PageRouter { ... }; public $_requestCallbackHack = NULL }; public $_requestVars = []; public $_basePath = '/ojs-3.2.1-4'; public $_requestPath = '/ojs-3.2.1-4/index.php/index/install/installUpgrade'; public $_isRestfulUrlsEnabled = FALSE; public $_isPathInfoEnabled = TRUE; public $_serverHost = 'localhost'; public $_protocol = 'http'; public $_isBot = NULL; public $_userAgent = NULL }) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\core\PKPApplication.inc.php:281
[29-Nov-2022 11:19:54 UTC] PHP   4. PKPPageRouter->route($request = class Request { public $_router = class PageRouter { public $_installationPages = [...]; public $_page = 'install'; public $_op = 'installUpgrade'; public $_indexUrl = NULL; public $_cacheFilename = NULL; public $_application = class Application { ... }; public $_dispatcher = class Dispatcher { ... }; public $_contextDepth = 1; public $_contextList = [...]; public $_flippedContextList = [...]; public $_contextPaths = [...]; public $_contexts = [...]; public $_handler = class InstallHandler { ... } }; public $_dispatcher = class Dispatcher { public $_application = class Application { ... }; public $_routerNames = [...]; public $_routerInstances = [...]; public $_router = class PageRouter { ... }; public $_requestCallbackHack = NULL }; public $_requestVars = []; public $_basePath = '/ojs-3.2.1-4'; public $_requestPath = '/ojs-3.2.1-4/index.php/index/install/installUpgrade'; public $_isRestfulUrlsEnabled = FALSE; public $_isPathInfoEnabled = TRUE; public $_serverHost = 'localhost'; public $_protocol = 'http'; public $_isBot = NULL; public $_userAgent = NULL }) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\core\Dispatcher.inc.php:143
[29-Nov-2022 11:19:54 UTC] PHP   5. PKPRouter->_authorizeInitializeAndCallRequest($serviceEndpoint = [0 => class InstallHandler { protected $_apiToken = NULL; public $_id = 'install'; public $_dispatcher = class Dispatcher { ... }; public $_checks = [...]; public $_roleAssignments = [...]; public $_authorizationDecisionManager = class AuthorizationDecisionManager { ... }; public $_enforceRestrictedSite = TRUE; public $_roleAssignmentsChecked = FALSE }, 1 => 'installUpgrade'], $request = class Request { public $_router = class PageRouter { public $_installationPages = [...]; public $_page = 'install'; public $_op = 'installUpgrade'; public $_indexUrl = NULL; public $_cacheFilename = NULL; public $_application = class Application { ... }; public $_dispatcher = class Dispatcher { ... }; public $_contextDepth = 1; public $_contextList = [...]; public $_flippedContextList = [...]; public $_contextPaths = [...]; public $_contexts = [...]; public $_handler = class InstallHandler { ... } }; public $_dispatcher = class Dispatcher { public $_application = class Application { ... }; public $_routerNames = [...]; public $_routerInstances = [...]; public $_router = class PageRouter { ... }; public $_requestCallbackHack = NULL }; public $_requestVars = []; public $_basePath = '/ojs-3.2.1-4'; public $_requestPath = '/ojs-3.2.1-4/index.php/index/install/installUpgrade'; public $_isRestfulUrlsEnabled = FALSE; public $_isPathInfoEnabled = TRUE; public $_serverHost = 'localhost'; public $_protocol = 'http'; public $_isBot = NULL; public $_userAgent = NULL }, $args = [], $validate = FALSE) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\core\PKPPageRouter.inc.php:231
[29-Nov-2022 11:19:54 UTC] PHP   6. InstallHandler->installUpgrade($args = [], $request = class Request { public $_router = class PageRouter { public $_installationPages = [...]; public $_page = 'install'; public $_op = 'installUpgrade'; public $_indexUrl = NULL; public $_cacheFilename = NULL; public $_application = class Application { ... }; public $_dispatcher = class Dispatcher { ... }; public $_contextDepth = 1; public $_contextList = [...]; public $_flippedContextList = [...]; public $_contextPaths = [...]; public $_contexts = [...]; public $_handler = class InstallHandler { ... } }; public $_dispatcher = class Dispatcher { public $_application = class Application { ... }; public $_routerNames = [...]; public $_routerInstances = [...]; public $_router = class PageRouter { ... }; public $_requestCallbackHack = NULL }; public $_requestVars = []; public $_basePath = '/ojs-3.2.1-4'; public $_requestPath = '/ojs-3.2.1-4/index.php/index/install/installUpgrade'; public $_isRestfulUrlsEnabled = FALSE; public $_isPathInfoEnabled = TRUE; public $_serverHost = 'localhost'; public $_protocol = 'http'; public $_isBot = NULL; public $_userAgent = NULL }) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\core\PKPRouter.inc.php:391
[29-Nov-2022 11:19:54 UTC] PHP   7. UpgradeForm->execute() D:\wamp64\www\ojs-3.2.1-4\lib\pkp\pages\install\InstallHandler.inc.php:106
[29-Nov-2022 11:19:54 UTC] PHP   8. Installer->execute() D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\install\form\UpgradeForm.inc.php:42
[29-Nov-2022 11:19:54 UTC] PHP   9. Installer->executeInstaller() D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\install\Installer.inc.php:186
[29-Nov-2022 11:19:54 UTC] PHP  10. Installer->executeAction($action = ['type' => 'schema', 'file' => 'lib/pkp/xml/schema/log.xml', 'attr' => ['file' => 'lib/pkp/xml/schema/log.xml']]) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\install\Installer.inc.php:263
[29-Nov-2022 11:19:54 UTC] PHP  11. adoSchema->__construct($db = class ADODB_mysqli { public $databaseType = 'mysqli'; public $dataProvider = 'mysql'; public $hasInsertID = TRUE; public $hasAffectedRows = TRUE; public $metaTablesSQL = 'SELECT\n\t\t\tTABLE_NAME,\n\t\t\tCASE WHEN TABLE_TYPE = \'VIEW\' THEN \'V\' ELSE \'T\' END\n\t\tFROM INFORMATION_SCHEMA.TABLES\n\t\tWHERE TABLE_SCHEMA='; public $metaColumnsSQL = 'SHOW COLUMNS FROM `%s`'; public $fmtTimeStamp = '\'Y-m-d H:i:s\''; public $hasLimit = TRUE; public $hasMoveFirst = TRUE; public $hasGenID = TRUE; public $isoDates = TRUE; public $sysDate = 'CURDATE()'; public $sysTimeStamp = 'NOW()'; public $hasTransactions = TRUE; public $forceNewConnect = FALSE; public $poorAffectedRows = TRUE; public $clientFlags = 0; public $substr = 'substring'; public $port = 3306; public $socket = ''; public $_bindInputArray = FALSE; public $nameQuote = '`'; public $optionFlags = [0 => [...]]; public $arrayClass = 'ADORecordSet_array_mysqli'; public $multiQuery = FALSE; public $_genIDSQL = 'update %s set id=LAST_INSERT_ID(id+1);'; public $_genSeqSQL = 'create table if not exists %s (id int not null)'; public $_genSeqCountSQL = 'select count(*) from %s'; public $_genSeq2SQL = 'insert into %s values (%s)'; public $_dropSeqSQL = 'drop table if exists %s'; public $database = 'ojs2'; public $host = 'localhost'; public $user = 'epubs'; public $password = 'not stored'; public $debug = FALSE; public $maxblobsize = 262144; public $concat_operator = '+'; public $length = 'length'; public $random = 'rand()'; public $upperCase = 'upper'; public $fmtDate = '\'Y-m-d\''; public $true = '1'; public $false = '0'; public $replaceQuote = '\\\''; public $charSet = FALSE; public $metaDatabasesSQL = ''; public $uniqueOrderBy = FALSE; public $emptyDate = ' '; public $emptyTimeStamp = ' '; public $lastInsID = FALSE; public $hasTop = FALSE; public $readOnly = FALSE; public $genID = 0; public $raiseErrorFn = FALSE; public $cacheSecs = 3600; public $memCache = FALSE; public $memCacheHost = NULL; public $memCachePort = 11211; public $memCacheCompress = FALSE; public $sysUTimeStamp = FALSE; public $noNullStrings = FALSE; public $numCacheHits = 0; public $numCacheMisses = 0; public $pageExecuteCountRows = TRUE; public $uniqueSort = FALSE; public $leftOuter = FALSE; public $rightOuter = FALSE; public $ansiOuter = FALSE; public $autoRollback = FALSE; public $fnExecute = FALSE; public $fnCacheExecute = FALSE; public $blobEncodeType = FALSE; public $rsPrefix = 'ADORecordSet_'; public $autoCommit = TRUE; public $transOff = 0; public $transCnt = 0; public $fetchMode = FALSE; public $null2null = 'null'; public $bulkBind = FALSE; public $_oldRaiseFn = FALSE; public $_transOK = NULL; public $_connectionID = class mysqli { public $affected_rows = 1105; public $client_info = 'mysqlnd 7.4.26'; public $client_version = 70426; public $connect_errno = 0; public $connect_error = NULL; public $errno = 0; public $error = ''; public $error_list = [...]; public $field_count = 0; public $host_info = 'localhost via TCP/IP'; public $info = 'Records: 1105  Duplicates: 0  Warnings: 0'; public $insert_id = 0; public $server_info = '8.0.27'; public $server_version = 80027; public $sqlstate = '00000'; public $protocol_version = 10; public $thread_id = 146; public $warning_count = 0 }; public $_errorMsg = FALSE; public $_errorCode = FALSE; public $_queryID = TRUE; public $_isPersistentConnection = FALSE; public $_evalAll = FALSE; public $_affected = FALSE; public $_logsql = FALSE; public $_transmode = ''; protected $connectionParameters = []; public $databaseName = 'ojs2' }) D:\wamp64\www\ojs-3.2.1-4\lib\pkp\classes\install\Installer.inc.php:365

Hi @shantanusingh

What is your PHP version?
OJS 3.2 is recommend to run under PHP 7.2 (ojs/README.md at 3_2_1-1 · pkp/ojs · GitHub).
As you can see on PHP documentation, this function was deprecated on PHP 7.4 and removed on PHP 8 (https://www.php.net/manual/en/function.get-magic-quotes-runtime.php)

Best,
Israel

1 Like

Thank you for your reply.
As per your suggestion, now it’s working fine.

1 Like