2.4.1 upgrade..setup gives blank screen

268 Posts

elz064 Reply #1, 8 years, 6 months ago

Hi,

Trying to upgrade from a revo 2.2.14 to 2.4.
Done as usual for other upgrade:

duplicated DB from within Plesk
duplicated the site 'root' folder -R with shh terminal with rsync -a command
cleared the cache from the manager, flushed sessions.
then rm -rf * into core/cache/ original folder

wget the modx 2.41 zip and unzip it in a 'modx verisons' folder
Go back to the current website folder and rsync -a ../upd_modx/modx-2.4.1-pl/ .

Then run myurl/setup

Everything is ok, chose the advanced option, test connection to db and db collations, everything is green,
then clicked the install button, and then.....immediate blank screen.

The core/cahe folder now contains only this:

drwxr-xr-x 3 aaaa_admin psacln 4096 Oct 2 14:26 logs
drwxr-xr-x 3 aaaa_admin psacln 4096 Oct 2 14:26 setup
drwxr-xr-x 2 aaaa_admin psacln 4096 Oct 2 14:26 system_settings

Tried in different browsers. no way.

But the core/cache/ logs last files says:
[2015-10-02 14:27:02] (ERROR @ /setup/index.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-02 14:27:02] (ERROR @ /setup/index.php) Could not prepare context: mgr

This site is running babel.

Any help appreciated.

Thank you

295 Posts

comp_nerd26 Reply #2, 8 years, 6 months ago

i believe the setup folder also needs to be writable, as the config you specify in the setup writes to xml files

24,544 Posts

BobRay Reply #3, 8 years, 6 months ago

If you make too big a jump in the upgrade, some of the upgrade steps can be skipped. It's not supposed to happen, but sometimes it does. One of the intermediate upgrades adds a 'name' column to the modx_context table and it looks like that didn't happen for you.

If you can go back to 2.2.14, upgrade to 2.3.0, then to 2.3.6, then 2.4.1. The UpgradeMODX extra makes it a lot easier, but I haven't been able to determine the oldest version of Revo it works in. I'm pretty sure it will work in 2.2.14, but I'm not positive.

BTW, later versions of MODX require PHP 5.3.3 or above, so make sure you have that.

Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting

268 Posts

elz064 Reply #4, 8 years, 6 months ago

Thank you Mark.

I've just been into 2.30 update.
Setup seams to work (all green), except this red warning at the end

Erreur de mise à jour de la table pour la classe modResource
Array
(
[0] => 42000
[1] => 1061
[2] => Duplicate key name 'cache_refresh_idx'
)

But in the manager there's now an issue: each click on a ressource to edit it gives a blank page (right click, quick edit is ok).

In the front all 'sub pages' gives a blank page only first level pages on the tree are correctly returned in the front end.
Language switching still ok apparently.

..Babel ...? (previously uptaded to 3.0) could be in cause ??

I have now in the error log of Modx a few

[2015-10-05 11:07:58] (ERROR @ /index.php) Could not prepare context: web
[2015-10-05 11:07:58] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

and then an 'infinite' list of :

....
[2015-10-05 11:18:56] (ERROR @ /index.php) [OnTVOutputRenderList]1
[2015-10-05 11:18:56] (ERROR @ /index.php) [OnTVOutputRenderList]1
[2015-10-05 11:18:56] (ERROR @ /index.php) [OnTVOutputRenderList]1
[2015-10-05 11:18:56] (ERROR @ /index.php) [OnTVOutputRenderList]1
[2015-10-05 11:18:57] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-05 11:18:57] (ERROR @ /index.php) [OnPageNotFound]1
[2015-10-05 11:18:57] (ERROR @ /index.php) [OnLoadWebDocument]1
[2015-10-05 11:18:58] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-05 11:18:58] (ERROR @ /index.php) [OnPageNotFound]1
[2015-10-05 11:18:58] (ERROR @ /index.php) [OnLoadWebDocument]1
[2015-10-05 11:19:09] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-05 11:19:09] (ERROR @ /index.php) [OnPageNotFound]1
[2015-10-05 11:19:09] (ERROR @ /index.php) [OnLoadWebDocument]1
[2015-10-05 11:20:19] (ERROR @ /manager/index.php) [OnHandleRequest]1
[2015-10-05 11:20:19] (ERROR @ /manager/index.php) [OnManagerPageBeforeRender]1
....

268 Posts

elz064 Reply #5, 8 years, 6 months ago

Hi

once reversed to 2.2.14 again I just updated to 2.2.15 (everything was ok during the setup process, no warning, all green.
front looks like beeing ok

But no way to edit any page in the manager. > blank page.
here's the error log on server

[Tue Oct 06 14:35:32 2015] [warn] [client xxx.14.174.144] mod_fcgid: stderr: PHP Fatal error: Cannot redeclare phpthumb::__destruct() in /var/www/vhosts/xxx.fr/dev01.xxx.fr/core/model/phpthumb/phpthumb.class.php on line 254, referer: http://dev01.xxx.fr/manager/?a=system/event
[Tue Oct 06 14:43:40 2015] [warn] [client xxx.14.174.144] mod_fcgid: stderr: PHP Parse error: syntax error, unexpected end of file in /var/www/vhosts/xxx.fr/dev01.xxx.fr/core/cache/includes/elements/modplugin/11.include.cache.php on line 2
[Tue Oct 06 14:45:24 2015] [warn] [client xxx.14.174.144] mod_fcgid: stderr: PHP Fatal error: Call to undefined method Babel::getMenu() in /var/www/vhosts/xxx.fr/dev01.xxxx.fr/core/cache/includes/elements/modplugin/5.include.cache.php on line 86, referer: http://dev01.xxx.fr/manager/?a=66
[Tue Oct 06 14:46:33 2015] [warn] [client xxx.14.174.144] mod_fcgid: stderr: PHP Fatal error: Call to undefined method Babel::getMenu() in /var/www/vhosts/xxx.fr/dev01.xxx.fr/core/cache/includes/elements/modplugin

php 5.4.45

☆ A M B ☆
79 Posts

matdave Reply #6, 8 years, 6 months ago

Quote from: elz064 at Oct 06, 2015, 12:54 PM

Hi

once reversed to 2.2.14 again I just updated to 2.2.15 (everything was ok during the setup process, no warning, all green.
front looks like beeing ok

But no way to edit any page in the manager. > blank page.
here's the error log on server

[Tue Oct 06 14:35:32 2015] [warn] [client xxx.14.174.144] mod_fcgid: stderr: PHP Fatal error: Cannot redeclare phpthumb::__destruct() in /var/www/vhosts/xxx.fr/dev01.xxx.fr/core/model/phpthumb/phpthumb.class.php on line 254, referer: http://dev01.xxx.fr/manager/?a=system/event
[Tue Oct 06 14:43:40 2015] [warn] [client xxx.14.174.144] mod_fcgid: stderr: PHP Parse error: syntax error, unexpected end of file in /var/www/vhosts/xxx.fr/dev01.xxx.fr/core/cache/includes/elements/modplugin/11.include.cache.php on line 2
[Tue Oct 06 14:45:24 2015] [warn] [client xxx.14.174.144] mod_fcgid: stderr: PHP Fatal error: Call to undefined method Babel::getMenu() in /var/www/vhosts/xxx.fr/dev01.xxxx.fr/core/cache/includes/elements/modplugin/5.include.cache.php on line 86, referer: http://dev01.xxx.fr/manager/?a=66
[Tue Oct 06 14:46:33 2015] [warn] [client xxx.14.174.144] mod_fcgid: stderr: PHP Fatal error: Call to undefined method Babel::getMenu() in /var/www/vhosts/xxx.fr/dev01.xxx.fr/core/cache/includes/elements/modplugin

php 5.4.45

What is your plugin ID 11? I'd recommend opening up the database, going to the site_plugins table, and setting those plugin ID's to disabled (value 1 on disabled column) if you can't get logged in. You may need to manually clear out your [b]core/cache[b] folder after doing so.

Mat Dave Jones

268 Posts

elz064 Reply #7, 8 years, 6 months ago

Quote from: matdave at Oct 06, 2015, 04:59 PM

What is your plugin ID 11? I'd recommend opening up the database, going to the site_plugins table, and setting those plugin ID's to disabled (value 1 on disabled column) if you can't get logged in. You may need to manually clear out your [b]core/cache[b] folder after doing so.

id 11 was not satated into any log, however it was 'Cliche' not actually used, so I deactivated it. But this was not the point.

The plugin 5 was the point (Babel) as it fired a php error in the server's logs.

The 2.15 is now ok, because, when dealing with backup/restore of the DB something wen't wrong (I mean I probably mixed up some files from one of the upgrades I tested and version of Babel stored into the DB.
Components list in the manager showed a 3.00b Babel as it's not supposed to work in 2.1x (afaik) .. anyway I succeed in downgrading (deleting the 3.00 Babel) and the 2.5 component poped up back.
(but same issue)
I reinstalled it again and everything went right.

So Now the next step is to go through the whole 2.3xx upgrade process again.......

24,544 Posts

BobRay Reply #8, 8 years, 6 months ago

Just a reminder: I suggest that you upgrade to 2.3.0, then to 2.3.6, then 2.4.1, unless you want to be really careful, in which case you should do all the intermediate upgrades.

One of the advantages of the UpgradeMODX extra (besides the convenience) is that it deletes all files in the core/cache directory when it's finished upgrading the site. This prevents lots of weird problems in the Manager after an upgrade.

Did I help you? Buy me a beer
Get my Book: MODX:The Official Guide
MODX info for everyone: http://bobsguides.com/modx.html
My MODX Extras
Bob's Guides is now hosted at A2 MODX Hosting

268 Posts

elz064 Reply #9, 8 years, 6 months ago

ok

here we go updating to 2.3.0

all green except this warning

Erreur de mise à jour de la table pour la classe modResource
Array
(
[0] => 42000
[1] => 1061
[2] => Duplicate key name 'cache_refresh_idx'
)

entered manager. Did not try anything else tha updating Babel to 3.0.0b4.
Looked ok.

but error log...

[2015-10-09 13:49:00] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:00] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:00] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:00] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:00] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:00] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:01] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:01] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:12] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:12] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:12] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:12] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:14] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:14] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:14] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:14] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:17] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:17] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:17] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:17] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:23] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:23] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:23] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.name' in 'field list'
)

[2015-10-09 13:49:23] (ERROR @ /index.php) Could not prepare context: web
[2015-10-09 13:49:33] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:49:33] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:49:38] (ERROR @ /index.php) Error 23000 executing statement:
INSERT INTO `imch_session` (`id`, `access`, `data`) VALUES ('jlvk203pda78ehrsph848f4k55', 1444391378, 'modx.user.0.resourceGroups|a:1:{s:3:\"web\";a:1:{i:0;s:1:\"4\";}}modx.user.0.attributes|a:1:{s:3:\"web\";a:4:{s:16:\"modAccessContext\";a:2:{s:2:\"en\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}s:3:\"web\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:22:\"modAccessResourceGroup\";a:1:{i:4;a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:17:\"modAccessCategory\";a:0:{}s:28:\"sources.modAccessMediaSource\";a:0:{}}}modx.user.contextTokens|a:0:{}')
Array
(
    [0] => 23000
    [1] => 1062
    [2] => Duplicate entry 'jlvk203pda78ehrsph848f4k55' for key 'PRIMARY'
)

[2015-10-09 13:50:35] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:50:35] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:51:10] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:51:13] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:51:14] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:51:29] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:51:29] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:51:33] (ERROR @ /manager/index.php) [OnHandleRequest]1
[2015-10-09 13:51:35] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:51:35] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:51:55] (ERROR @ /manager/index.php) [OnHandleRequest]1
[2015-10-09 13:51:56] (ERROR @ /manager/index.php) [OnHandleRequest]1
[2015-10-09 13:52:02] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:52:06] (ERROR @ /manager/index.php) [OnHandleRequest]1
[2015-10-09 13:52:06] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:52:07] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:52:11] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:52:12] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:52:12] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:52:12] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:53:31] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:53:31] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:53:32] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:53:35] (ERROR @ /manager/index.php) [OnHandleRequest]1

then upgrade to 2.3.6

and log is

[2015-10-09 13:55:42] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:55:42] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:55:43] (ERROR @ /index.php) [OnHandleRequest]1
[2015-10-09 13:56:43] (ERROR @ /index.php) Error 23000 executing statement:
INSERT INTO `imch_session` (`id`, `access`, `data`) VALUES ('remofhjki554j2eelgkm3m71t1', 1444391803, 'modx.user.0.resourceGroups|a:1:{s:3:\"web\";a:1:{i:0;s:1:\"4\";}}modx.user.0.attributes|a:1:{s:3:\"web\";a:4:{s:16:\"modAccessContext\";a:2:{s:2:\"en\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}s:3:\"web\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:22:\"modAccessResourceGroup\";a:1:{i:4;a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:17:\"modAccessCategory\";a:0:{}s:28:\"sources.modAccessMediaSource\";a:0:{}}}modx.user.contextTokens|a:0:{}')
Array
(
    [0] => 23000
    [1] => 1062
    [2] => Duplicate entry 'remofhjki554j2eelgkm3m71t1' for key 'PRIMARY'
)

268 Posts

elz064 Reply #10, 8 years, 6 months ago

Now
walked around in the manager, edited some pages and sub-pages, chunks..
things seams to be pretty ok, babel too.

But
VersionX looks like being perturbed :

[2015-10-09 14:02:39] (ERROR @ /assets/components/versionx/connector.php) Error caching lexicon topic lexicon/fr/core/default

(1 time)

Media sources are gone..well not all of them...
oh.. the one where some specific user's group had right and ...those groups do not exist anymore.... hum strange.

hmm. MIGX broken. Reinstalled it and ok.