500 Error Site temporarily unavailable. After moving from local host tot live host.

265 Posts

thapriest86 Reply #1, 11 years, 4 months ago

Hi Guys,

Configured and tested a evo to revo upgrade and then uploaded it to live host.
Now it is only giving me the 500 Error Site temporarily unavailable. I changed the paths in config.inc.php and tried running setup. I can select language and that i do want to upgrade, clicking next results in the 500 error.

Anyone knows what is going on?

Regards

Edit: when checking source it is telling this:

<br />
<b>Warning</b>:  array_merge() [<a href='function.array-merge'>function.array-merge</a>]: Argument #2 is not an array in <b>/public/sites/www.website.nl/core/xpdo/xpdo.class.php</b> on line <b>335</b><br />
<br />
<b>Fatal error</b>:  Class 'xPDODriver_' not found in <b>/public/sites/www.website.nl/core/xpdo/xpdo.class.php</b> on line <b>1823</b><br />

[ed. note: thapriest86 last edited this post 11 years, 4 months ago.]

☆ A M B ☆
3,112 Posts

goldsky Reply #2, 11 years, 4 months ago

There are other config files, config.core.php, under

webroot
manager/
connectors/

Try to fix the path in them.

Rico
Genius is one percent inspiration and ninety-nine percent perspiration. Thomas A. Edison
MODx is great, but knowing how to use it well makes it perfect!

www.virtudraft.com

Security, security, security! | Indonesian MODx Forum | MODx Revo's cheatsheets | MODx Evo's cheatsheets

Author of Easy 2 Gallery 1.4.x, PHPTidy, spieFeed, FileDownload R, Upload To Users CMP, Inherit Template TV, LexRating, ExerPlan, Lingua, virtuNewsletter, Grid Class Key, SmartTag, prevNext

Maintainter/contributor of Babel

Because it's hard to follow all topics on the forum, PING ME ON TWITTER @_goldsky if you need my help.

265 Posts

thapriest86 Reply #3, 11 years, 4 months ago

Thanks, i checked those

They contain this:

define('MODX_CORE_PATH', dirname(dirname(__FILE__)) . '/core/');
define('MODX_CONFIG_KEY', 'config');

To my understanding it is taking the global MODX core path, the subdi(if any) it's in and the the (in this case) core folder. So that seems to me that that's good.

Nevermind the failures, seems my hoster is toying somehow. Just now it got the folders right, then it failed a couple of update queries, tried again now gives a white screen. No idea as of yet what is going on, but i'm going to email the hoster and findout. [ed. note: thapriest86 last edited this post 11 years, 4 months ago.]

265 Posts

thapriest86 Reply #4, 11 years, 4 months ago

Well, started of fresh, setup comleted, returned no errors in installation. Manager or front page does not load and spits out a 503 error, but header says it's 404.

Checking the error log it says:

[2012-12-11 14:28:03] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'context_key' in 'field list'
)

[2012-12-11 14:28:04] (FATAL) The requested resource has no valid content type specified.
[2012-12-11 14:28:04] (ERROR @ /index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:04] (ERROR @ /index.php) Error 42S02 executing statement:
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('af5254d6f639c8f30edfa9fec42706f9', 1355232484, '')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:05] (ERROR @ /index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_context' doesn't exist
)

[2012-12-11 14:28:05] (ERROR @ /index.php) Could not prepare context: web
[2012-12-11 14:28:05] (ERROR @ /index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:05] (ERROR @ /index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_access_context' doesn't exist
)

[2012-12-11 14:28:05] (ERROR @ /index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'context_key' in 'field list'
)

[2012-12-11 14:28:05] (FATAL) The requested resource has no valid content type specified.
[2012-12-11 14:28:05] (ERROR @ /index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:05] (ERROR @ /index.php) Error 42S02 executing statement:
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('afa9016cc6bd9e7dd32e0576924822c4', 1355232485, '')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:06] (ERROR @ /setup/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_context' doesn't exist
)

[2012-12-11 14:28:06] (ERROR @ /setup/index.php) Could not prepare context: mgr
[2012-12-11 14:28:06] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_context' doesn't exist
)

[2012-12-11 14:28:06] (ERROR @ /manager/index.php) Could not prepare context: mgr
[2012-12-11 14:28:06] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:06] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_access_context' doesn't exist
)

[2012-12-11 14:28:06] (ERROR @ /manager/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'context_key' in 'field list'
)

[2012-12-11 14:28:07] (ERROR @ /manager/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'context_key' in 'field list'
)

[2012-12-11 14:28:07] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:07] (ERROR @ /manager/index.php) Error 42S02 executing statement:
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('2a13f30bfbdb8d5e0d802ec4ef698164', 1355232487, '')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:13] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_context' doesn't exist
)

[2012-12-11 14:28:13] (ERROR @ /manager/index.php) Could not prepare context: mgr
[2012-12-11 14:28:13] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:13] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_access_context' doesn't exist
)

[2012-12-11 14:28:13] (ERROR @ /manager/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'context_key' in 'field list'
)

[2012-12-11 14:28:13] (ERROR @ /manager/index.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'context_key' in 'field list'
)

[2012-12-11 14:28:13] (ERROR @ /manager/index.php) Error 42S02 executing statement: 
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

[2012-12-11 14:28:13] (ERROR @ /manager/index.php) Error 42S02 executing statement:
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('2a13f30bfbdb8d5e0d802ec4ef698164', 1355232493, '')
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'md34653db118285.modx_session' doesn't exist
)

Anyone got a clue?

265 Posts

thapriest86 Reply #5, 11 years, 4 months ago

Ok. Seemed the upgrade i did upgraded the tables in a different manner than a clean revolution install would do.
Solution was drastic but fruitfull. Deleted all tables and the folders, reinstalled a complete fresh install(with quite the hassle, but that's due to the hoster who already knows). Then replaced the fresh install by the one i had in my xampp and updated the database. Then rebuild it al all by running the setup again and it works now. Yay!:-)

☆ A M B ☆
3,112 Posts

goldsky Reply #6, 11 years, 4 months ago

GoDaddy?

Rico
Genius is one percent inspiration and ninety-nine percent perspiration. Thomas A. Edison
MODx is great, but knowing how to use it well makes it perfect!

www.virtudraft.com

Security, security, security! | Indonesian MODx Forum | MODx Revo's cheatsheets | MODx Evo's cheatsheets

Author of Easy 2 Gallery 1.4.x, PHPTidy, spieFeed, FileDownload R, Upload To Users CMP, Inherit Template TV, LexRating, ExerPlan, Lingua, virtuNewsletter, Grid Class Key, SmartTag, prevNext

Maintainter/contributor of Babel

Because it's hard to follow all topics on the forum, PING ME ON TWITTER @_goldsky if you need my help.

265 Posts

thapriest86 Reply #7, 11 years, 4 months ago

No, i have this one on a dutch budget hoster (MijnDomein). When the contract expires for the domainname, i will move it to my own VPS.

3 Posts

twenty3nl Reply #8, 11 years, 3 months ago

Let me guess. mijnhostnet something?

I be been fighting with the exact same thing for hours. Only mine is an actual install of 2.2.6 that has the same errors.

I'm going to retry or maybe replicate you and see if it's fixed.

3 Posts

twenty3nl Reply #9, 11 years, 3 months ago

An update on this one.

Managed to get a clean install working but the problem was essentially in the database conversion/initialization.

The VPS had as default set the DB that i had created to UTF8-"i dont remember which strange flavor" and instead of 3 bytes per character (UTF-8) it was more so hence the "Specified key was too long; max key length is 1000 bytes" i was getting on the install logs, as well as the same messages thapriest86 was getting.

Hope this helps someone in the future

☆ A M B ☆
2,475 Posts

Everett Reply #10, 11 years, 3 months ago

Ooof... database encoding issues are the worst.

I had some 500 errors migrating a site recently, and the problem just seemed to be that re-running the setup failed. That's one of the recommended steps: http://rtfm.modx.com/display/revolution20/Moving+Your+Site+to+a+New+Server

But it's not always necessary. It seems that 2.2.6's setup may hang sometimes, but who cares if you don't need to re-run it anyway.

Hosting stuff: http://fireproofsocks.com/
Coding stuff: http://craftsmancoding.com/
Blog stuff: http://tipsfor.us/