Reply To: going from version 2018.1.3 to 2019.1.1 (database issue)

#665
chris
Participant

Think i’m having a similar problem, installed SI 2019-2 master installed database and essential data etc, imported my database backup and now getting the upgrade database screen which when run gives:

SqlPatchManager::runSqlPatch() error. See error log for more information.

But i can’t find the error log. ./tmp/log doesn’t have a php.log file in it even though i’ve set error level to debug, have only got the si.log:

2019-10-20T21:01:49+00:00 DEBUG (7): Setup::init() – logger has been setup
2019-10-20T14:01:49-07:00 DEBUG (7): session_timeout loaded[15]
2019-10-20T14:01:49-07:00 DEBUG (7): init.php – frontendOptions – Array
(
[lifetime] => 900
[automatic_serialization] => 1
)

2019-10-20T14:01:49-07:00 DEBUG (7): init.php – authentication-enabled[] fake_auth[1]
2019-10-20T14:01:49-07:00 DEBUG (7): index.php – After init.php – module(] view[]
2019-10-20T14:01:49-07:00 DEBUG (7): index.php – After processing init.php for extensions
2019-10-20T14:01:49-07:00 DEBUG (7): index.php – module[] view[] databaseBuilt[1] databasePopulated[1]
2019-10-20T14:01:49-07:00 DEBUG (7): index.php – apply_db_patches[1]
2019-10-20T14:01:49-07:00 DEBUG (7): index.php – config->authentication->enabled[] auth_session->id: 1
2019-10-20T14:01:49-07:00 DEBUG (7): index.php – view[database_sqlpatches] module[options]
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – module[options] view[database_sqlpatches] action[] id[] menu[]
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After invoices/template
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After api/xml or ajax
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After extension_jquery_files
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – after custom/hooks.tpl
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – after header.tpl
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After extension_php_insert_files, etc.
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After export/export exit
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – post_load…
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After menutpl processed
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After main.tpl
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After options/database_sqlpatches.tpl
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – path[templates/default/options/] my_tpl_path[templates/default/options/database_sqlpatches.tpl]
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – After output my_tpl_path[templates/default/options/database_sqlpatches.tpl]
2019-10-20T14:01:50-07:00 DEBUG (7): index.php – At END

2019-10-20T21:01:52+00:00 DEBUG (7): Setup::init() – logger has been setup
2019-10-20T14:01:52-07:00 DEBUG (7): session_timeout loaded[15]
2019-10-20T14:01:52-07:00 DEBUG (7): init.php – frontendOptions – Array
(
[lifetime] => 900
[automatic_serialization] => 1
)

2019-10-20T14:01:52-07:00 DEBUG (7): init.php – authentication-enabled[] fake_auth[1]
2019-10-20T14:01:52-07:00 DEBUG (7): index.php – After init.php – module(] view[]
2019-10-20T14:01:52-07:00 DEBUG (7): index.php – After processing init.php for extensions
2019-10-20T14:01:52-07:00 DEBUG (7): index.php – module[] view[] databaseBuilt[1] databasePopulated[1]
2019-10-20T14:01:52-07:00 DEBUG (7): index.php – apply_db_patches[1]
2019-10-20T14:01:52-07:00 DEBUG (7): index.php – config->authentication->enabled[] auth_session->id: 1
2019-10-20T14:01:52-07:00 DEBUG (7): index.php – view[database_sqlpatches] module[options]

I’ve lost track of which version i was on beforehand as i got very confused following the status of SI, started with 2013, might have upgraded to 2018 at some point but not sure if it was the fearless version etc. :/

I love it and use it for my business but the version i had stopped working after moving to a newer server with php 7 etc on it. Spent a week following the trail from 2013 original site -> google groups -> github and finally to this site. Would love to get it working .