Updaten naar versie 3.3.x hoe je eigen site onderzoeken?

Na bovenstaande toch nog 's terug gegaan naar versie 3.3.3 maar opnieuw dezelfde foutmeldingen als in het begin:

front end:

1054
Unknown column 'ordering' in 'order clause' SQL=SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC

back end:

witte pagina's bij doorklikken na hoofdscherm...

Ik krijg nu wel het hoofdscherm van de backend te zien maar als ik ergens op klik krijg ik een wit scherm te zien.

Dit zijn de belangrijkste zaken die ik kan terugvinden op dat backend scherm:

Bij Maintenance:

PLG_QUICKICON_JOOMLAUPDATE_CHECKING
PLG_QUICKICON_EXTENSIONUPDATE_CHECKING

Bij Quick Icons maar ook onder Maintenance:

PLG_QUICKICON_JOOMLAUPDATE_ERROR
PLG_QUICKICON_EXTENSIONUPDATE_ERROR

En opnieuw na uitvoeren Query astrid ivm column ordering deze melding op frontend: (hier zit ik op vast)

1054
Unknown column 'c.version' in 'field list' SQL=SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=102 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

Lukt het je om met dit achter je url je database te repareren?

Hey, neen dat lukt niet dan krijg ik die fameuze witte pagina...

Staat error reporting op development? Of kan je de oorzaak van die witte pagina zien in de error logs van je hoster?

Ondertussen weer eventjes teruggedraaid naar 2.5.24 (want dan draait de site goed).

Development aangezet en dit zijn de meldingen die ik krijg in de backend:

trict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/loader.php on line 197

Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29

Warning: is_file(): open_basedir restriction in effect. File(/data/sites/web/hetdakorg/www/../../../../media/system/css/system.css) is not within the allowed path(s): (/data/sites/web/hetdakorg:/usr/local/php-5.4/lib/php:/tmp:/data/sites/vendor-scripts/hetdakorg:/data/sites/web/disabled) in /data/sites/web/hetdakorg/www/components/com_scriptmerge/helpers/helper.php on line 615

Dit is de error log file:

[Mon Aug 04 04:02:51 2014] [warn] RSA server certificate CommonName (CN) `linweb001' does NOT match server name!?
[Mon Aug 04 04:08:33 2014] [warn] [client 66.249.78.99] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/joomla/html/parameter.php on line 512
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/joomla/html/parameter.php on line 512, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Strict Standards: Declaration of JCacheControllerView::get() should be compatible with JCacheController::get($id, $group = NULL) in /data/sites/web/hetdakorg/www/libraries/joomla/cache/controller/view.php on line 137, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Notice: Use of undefined constant REQUEST_URI - assumed 'REQUEST_URI' in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 3, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Deprecated: Function eregi() is deprecated in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 12, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:32:55 2014] [warn] [client 195.3.144.84] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/joomla/html/parameter.php on line 512
[Mon Aug 04 05:32:55 2014] [warn] [client 195.3.144.84] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29
[Mon Aug 04 05:32:55 2014] [warn] [client 195.3.144.84] mod_fcgid: stderr: PHP Warning: is_file(): open_basedir restriction in effect. File(/data/sites/web/hetdakorg/www/../../../../media/system/css/system.css) is not within the allowed path(s): (/data/sites/web/hetdakorg:/usr/local/php-5.4/lib/php:/tmp:/data/sites/vendor-scripts/hetdakorg:/data/sites/web/disabled) in /data/sites/web/hetdakorg/www/components/com_scriptmerge/helpers/helper.php on line 615
[Mon Aug 04 05:32:55 2014] [warn] [client 195.3.144.84] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/loader.php on line 197
[Mon Aug 04 06:16:54 2014] [warn] [client 66.249.78.92] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/joomla/html/parameter.php on line 512
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/loader.php on line 197
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Strict Standards: Declaration of JCacheControllerView::get() should be compatible with JCacheController::get($id, $group = NULL) in /data/sites/web/hetdakorg/www/libraries/joomla/cache/controller/view.php on line 137
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Notice: Use of undefined constant REQUEST_URI - assumed 'REQUEST_URI' in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 3
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Deprecated: Function eregi() is deprecated in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 12
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/loader.php on line 197
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Strict Standards: Declaration of JCacheControllerView::get() should be compatible with JCacheController::get($id, $group = NULL) in /data/sites/web/hetdakorg/www/libraries/loader.php on line 332
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Notice: Use of undefined constant REQUEST_URI - assumed 'REQUEST_URI' in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 3
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Deprecated: Function eregi() is deprecated in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 12
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29

Zijn allemaal redelijk normale meldingen. Zou geen probleem moeten zijn. Maar ik bedoel ook eigenlijk dat je de error reporting aan moet zetten in je Joomla 3 site. Neem aan dat je dit wel allemaal gevolgd hebt?

Enne......... als je ruimte genoeg hebt op je server is het misschien handiger om die backup eens terug te zetten in een submap. Dan kan je rustig experimenteren terwijl je site gewoon online blijft.

Hoe stel je dan die submap in als je hoofd directory? thx

Dat is straks heel eenvoudig. Maar graag 1 onderwerp per topic, zo houden we het forum overzichtelijk.

Ok, dit is trouwens de error log file van versie 3.3.3 (lijkt me exact hetzelfde)

[Mon Aug 04 04:02:51 2014] [warn] RSA server certificate CommonName (CN) `linweb001' does NOT match server name!?
[Mon Aug 04 04:08:33 2014] [warn] [client 66.249.78.99] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/joomla/html/parameter.php on line 512
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/joomla/html/parameter.php on line 512, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Strict Standards: Declaration of JCacheControllerView::get() should be compatible with JCacheController::get($id, $group = NULL) in /data/sites/web/hetdakorg/www/libraries/joomla/cache/controller/view.php on line 137, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Notice: Use of undefined constant REQUEST_URI - assumed 'REQUEST_URI' in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 3, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Deprecated: Function eregi() is deprecated in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 12, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:24:20 2014] [warn] [client 219.69.120.125] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29, referer: semalt.semalt.com/crawler.php?u=http://hetdak.org
[Mon Aug 04 05:32:55 2014] [warn] [client 195.3.144.84] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/joomla/html/parameter.php on line 512
[Mon Aug 04 05:32:55 2014] [warn] [client 195.3.144.84] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29
[Mon Aug 04 05:32:55 2014] [warn] [client 195.3.144.84] mod_fcgid: stderr: PHP Warning: is_file(): open_basedir restriction in effect. File(/data/sites/web/hetdakorg/www/../../../../media/system/css/system.css) is not within the allowed path(s): (/data/sites/web/hetdakorg:/usr/local/php-5.4/lib/php:/tmp:/data/sites/vendor-scripts/hetdakorg:/data/sites/web/disabled) in /data/sites/web/hetdakorg/www/components/com_scriptmerge/helpers/helper.php on line 615
[Mon Aug 04 05:32:55 2014] [warn] [client 195.3.144.84] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/loader.php on line 197
[Mon Aug 04 06:16:54 2014] [warn] [client 66.249.78.92] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/joomla/html/parameter.php on line 512
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/loader.php on line 197
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Strict Standards: Declaration of JCacheControllerView::get() should be compatible with JCacheController::get($id, $group = NULL) in /data/sites/web/hetdakorg/www/libraries/joomla/cache/controller/view.php on line 137
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Notice: Use of undefined constant REQUEST_URI - assumed 'REQUEST_URI' in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 3
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Deprecated: Function eregi() is deprecated in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 12
[Mon Aug 04 06:21:34 2014] [warn] [client 37.58.100.74] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /data/sites/web/hetdakorg/www/libraries/loader.php on line 197
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Strict Standards: Declaration of JCacheControllerView::get() should be compatible with JCacheController::get($id, $group = NULL) in /data/sites/web/hetdakorg/www/libraries/loader.php on line 332
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Notice: Use of undefined constant REQUEST_URI - assumed 'REQUEST_URI' in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 3
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Deprecated: Function eregi() is deprecated in /data/sites/web/hetdakorg/www/templates/ajt005_j30/html/template.php on line 12
[Mon Aug 04 06:23:13 2014] [warn] [client 208.115.113.87] mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /data/sites/web/hetdakorg/www/plugins/system/bigshotgoogleanalytics/bigshotgoogleanalytics.php on line 29

toevoeging:

met development aan in configuration.php enkel deze melding op backend:

Warning: is_file(): open_basedir restriction in effect. File(/data/sites/web/hetdakorg/www/../../../../media/system/css/system.css) is not within the allowed path(s): (/data/sites/web/hetdakorg:/usr/local/php-5.4/lib/php:/tmp:/data/sites/vendor-scripts/hetdakorg:/data/sites/web/disabled) in /data/sites/web/hetdakorg/www/components/com_scriptmerge/helpers/helper.php on line 615

Dan zou ik scriptmerge eens de-installeren voor de migratie. Ik weet niet waarom je die melding krijgt, maar hij komt van die component in ieder geval.