Upgrade 2.1.5 to 2.2 and now blank frontend

380 Posts

Brian Reply #11, 12 years, 4 months ago

I tried the upgrade again, this time while doing the installation I decided to look at any installation warnings and saw the following in the log file:

[2012-01-05 15:39:31] (ERROR @ /setup/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.rank' in 'field list'
)

[2012-01-05 15:39:31] (ERROR @ /setup/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modContext.rank' in 'field list'
)

[2012-01-05 15:39:31] (ERROR @ /setup/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modTemplateVar.source' in 'field list'
)

[2012-01-05 15:39:31] (ERROR @ /setup/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'modTemplateVar.source' in 'field list'
)

[2012-01-05 15:39:31] (ERROR in xPDOManager_mysql::addField @ /home/user/public_html/core/xpdo/om/mysql/xpdomanager.class.php : 301) Error adding field sources.modMediaSource->is_stream: Array
(
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'is_stream'
)

[2012-01-05 15:39:31] (ERROR in xPDOManager_mysql::addIndex @ /home/user/public_html/core/xpdo/om/mysql/xpdomanager.class.php : 329) Error adding index is_stream to sources.modMediaSource: Array
(
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'is_stream'
)

[2012-01-05 15:39:31] (ERROR in xPDOManager_mysql::addField @ /home/user/public_html/core/xpdo/om/mysql/xpdomanager.class.php : 301) Error adding field modDashboard->hide_trees: Array
(
    [0] => 42S21
    [1] => 1060
    [2] => Duplicate column name 'hide_trees'
)

[2012-01-05 15:39:31] (ERROR in xPDOManager_mysql::addIndex @ /home/user/public_html/core/xpdo/om/mysql/xpdomanager.class.php : 329) Error adding index hide_trees to modDashboard: Array
(
    [0] => 42000
    [1] => 1061
    [2] => Duplicate key name 'hide_trees'
)

[2012-01-05 15:39:43] (ERROR @ /setup/index.php) xPDOVehicle resolver failed: type php (/home/user/public_html/core/packages/core/modDashboardWidget/043f411291b20759288ad11934f25c7d.resolve.dashboardwidgets.resolver)
[2012-01-05 15:39:43] (ERROR @ /setup/index.php) Could not resolve vehicle for object of class modDashboardWidget; criteria: Array
(
    [name] => w_configcheck
)

I also manually cleared out the /core/cache/ directory with no frontend response. The backend manager works beautifully though.

I decided to see if anything was happening so I went into core/config/ and modified my mysql credentials so that it would not be able to make a database connection. I still received no errors and just a blank site.

My next step will be to try and see if a particular package is causing the issues. Attached is a list of all packages which are all installed.

- 380 Posts
Brian Reply #12, 12 years, 4 months ago

So I spent even more time on this and got the system upgraded to 2.2

It was one of two possible problems, I'm afraid I don't know which is was.

1) I re-downloaded the 2.2 package so the download I was using could have been corrupted.

2) I uninstalled and removed 3 packages (directresize, mobiledetection and packman)

Everything is working great except one small problem. I am trying to add a context to a user group to allow access for media sources but I can't. The access policy list does not match the dropdown when adding one to a group. (see attached images)

I have cleared the cache, flushed permissions but just can't figure it out. If I can't fix this, is there anyway I can reset the whole security section back to the "default" settings of a fresh install?