Error in Upgrading to 1.8 at Oxwall Software Forum

Team

ross Sep 10 '15

I need error logs not logs.

#21

Silvio Sep 10 '15

/var/log/httpd/error_log is this one?

this is the last 30 lines output

[root@CentOS-70-64-minimal httpd]# tail -30 error_log
[Sun Sep 06 03:47:02.296676 2015] [auth_digest:notice] [pid 762] AH01757: generating secret for digest authentication ...
[Sun Sep 06 03:47:02.320116 2015] [lbmethod_heartbeat:notice] [pid 762] AH02282: No slotmem from mod_heartmonitor
[Sun Sep 06 03:47:02.366816 2015] [mpm_prefork:notice] [pid 762] AH00163: Apache/2.4.6 (CentOS) PHP/5.4.16 configured -- resuming normal operations
[Sun Sep 06 03:47:02.366838 2015] [core:notice] [pid 762] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Wed Sep 09 20:22:13.469284 2015] [mpm_prefork:notice] [pid 762] AH00170: caught SIGWINCH, shutting down gracefully
[Wed Sep 09 20:22:47.472006 2015] [suexec:notice] [pid 760] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 78.47.220.190. Set the 'ServerName' directive globally to suppress this message
[Wed Sep 09 20:22:47.488372 2015] [auth_digest:notice] [pid 760] AH01757: generating secret for digest authentication ...
[Wed Sep 09 20:22:47.488799 2015] [lbmethod_heartbeat:notice] [pid 760] AH02282: No slotmem from mod_heartmonitor
[Wed Sep 09 20:22:47.654257 2015] [mpm_prefork:notice] [pid 760] AH00163: Apache/2.4.6 (CentOS) PHP/5.4.16 configured -- resuming normal operations
[Wed Sep 09 20:22:47.654295 2015] [core:notice] [pid 760] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Sep 10 11:46:11.229846 2015] [mpm_prefork:notice] [pid 760] AH00170: caught SIGWINCH, shutting down gracefully
[Thu Sep 10 11:46:12.395479 2015] [suexec:notice] [pid 6948] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 78.47.220.190. Set the 'ServerName' directive globally to suppress this message
[Thu Sep 10 11:46:12.417871 2015] [auth_digest:notice] [pid 6948] AH01757: generating secret for digest authentication ...
[Thu Sep 10 11:46:12.418291 2015] [lbmethod_heartbeat:notice] [pid 6948] AH02282: No slotmem from mod_heartmonitor
[Thu Sep 10 11:46:12.479897 2015] [mpm_prefork:notice] [pid 6948] AH00163: Apache/2.4.6 (CentOS) PHP/5.4.16 configured -- resuming normal operations
[Thu Sep 10 11:46:12.479941 2015] [core:notice] [pid 6948] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

#22

Team

ross Sep 10 '15

PM me your CPanel and admin access details.

#23

Oxwall Türkiye Sep 11 '15

Something went wrong!
To get the error details follow these steps:
- Open ow_includes/config.php file and set DEBUG_MODE to true
- Reproduce your last action.

Error details:Type:ExceptionMessage:SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'simplicity' for key 'name'File:/home/romarekl/public_html/sosyallift.com/ow_core/database.phpLine:720Trace:#0 /home/romarekl/public_html/sosyallift.com/ow_core/database.php(720): PDOStatement->execute() #1 /home/romarekl/public_html/sosyallift.com/ow_core/database.php(473): OW_Database->execute('INSERT INTO `ow...', Array) #2 /home/romarekl/public_html/sosyallift.com/ow_core/database.php(509): OW_Database->insert('INSERT INTO `ow...', Array) #3 /home/romarekl/public_html/sosyallift.com/ow_core/base_dao.php(216): OW_Database->insertObject('ow_base_theme', Object(BOL_Theme)) #4 /home/romarekl/public_html/sosyallift.com/ow_system_plugins/base/bol/theme_service.php(210): OW_BaseDao->save(Object(BOL_Theme)) #5 /home/romarekl/public_html/sosyallift.com/ow_core/application.php(789): BOL_ThemeService->updateThemeList() #6 /home/romarekl/public_html/sosyallift.com/ow_core/application.php(572): OW_Application->updateCachedEntities(1) #7 /home/romarekl/public_html/sosyallift.com/ow_core/application.php(161): OW_Application->devActions() #8 /home/romarekl/public_html/sosyallift.com/index.php(54): OW_Application->init() #9 {main}

#24

Team

ross Sep 13 '15

Did you install the theme twice? Please provide the screenshot of your ow_base_theme table.

#25

Silvio Sep 21 '15

Quote from ross The warning is because you deactivated photo plugin
and you can ignore the notice.
There's some other major error, like parse error or fatal error if you still see blank page when visiting the admin panel, check your SERVER error logs not software ow_logs/error.logs

Hi ross.. today i tryied to upgrade the other site (the important one) and it crashed. Fortunatly this time i've made a backup also of the DB and i recovered the site.

the steps i followed was update core first (manually) then i went to update the themes (but i saw an error on a permission dedied on request on php).. i went on.. everything ok till photo plugin update. Since that moment the website died again

now i've recovered againt the website but i really dont feel confident to do this upgrade since i'm not sure it is not so dangerous (i remember i've lost one site and i gave up).

don't you think your develop team could take a live "look" at the server to understand why photo plugin is so dangerous when updated?

later i will do another test.. i will deinstall photo plugin before update. I want to see if i solve the problem

#26

Team

ross Sep 21 '15

Silvio, do the update again, please.

1. disable 3rd party plugins and javascript code you have on your website.

2. switch to the default theme.

3. make backup.

4. enable debug mode.

5. update platform first

6. then plugins.

if you run into the issue again, please provide us with the actual error, if you get one on the screen.

If you don't see anything check your server error logs and provide us with the error.

#27

Silvio Sep 21 '15

ok i'll do it again in the afternoon... i will let u know

#28

Silvio Sep 21 '15

Let's start again .. this is what i do...

Set site in maintenance mode
Switched to default theme (Origin)
Enabled Debug
Downloaded package http://www.oxwall.org/dl/ow_core_update_pack_1.8.0.zip
Unzipped

OW Debug - NoticeMessage:Undefined index: hostFile:/var/www/retegay.it/ow_core/request.phpLine:214

OW Debug - WarningMessage:Can't generate URI! Route `admin_themes_add_new` not found!File:/var/www/retegay.it/ow_core/router.phpLine:262

OW Debug - WarningMessage:Can't generate URI! Route `admin_pages_splash_screen` not found!File:/var/www/retegay.it/ow_core/router.phpLine:262

OW Debug - NoticeMessage:Trying to get property of non-objectFile:/var/www/retegay.it/ow_system_plugins/base/bol/component_service.phpLine:115

OW Debug - ExceptionMessage:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `entityId` = 0 LIMIT 0, 1' at line 1File:/var/www/retegay.it/ow_core/database.phpLine:720Trace:#0 /var/www/retegay.it/ow_core/database.php(720): PDOStatement->execute() #1 /var/www/retegay.it/ow_core/database.php(305): OW_Database->execute('SELECT * FROM o...', Array) #2 /var/www/retegay.it/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'BOL_ComponentPl...', Array, 0, Array) #3 /var/www/retegay.it/ow_system_plugins/base/bol/component_place_cache_dao.php(110): OW_BaseDao->findObjectByExample(Object(OW_Example)) #4 /var/www/retegay.it/ow_system_plugins/base/bol/component_service.php(176): BOL_ComponentPlaceCacheDao->findCache(NULL) #5 /var/www/retegay.it/ow_system_plugins/admin/controllers/base.php(52): BOL_ComponentService->findCache('admin.dashboard') #6 [internal function]: ADMIN_CTRL_Base->dashboard(Array) #7 /var/www/retegay.it/ow_core/request_handler.php(266): call_user_func_array(Array, Array) #8 /var/www/retegay.it/ow_core/application.php(342): OW_RequestHandler->dispatch() #9 /var/www/retegay.it/index.php(76): OW_Application->handleRequest() #10 {main}Type:PDOException

Site Died :)

#29

Silvio Sep 21 '15

after i recovered the site i tried to repeat the installation as Root (for the installation i've used another user in centos but..ok..)

in this case the menu admin open again but i've this error

Message:Undefined index: hostFile:/var/www/retegay.it/ow_core/request.phpLine:214

but there's no way to open the admin page.

(rolling back and waiting for a solution) ;)

The Forum post is edited by Silvio Sep 21 '15

#30

Team

ross Sep 21 '15

Silvio, can you please apply this fix: http://www.oxwall.org/forum/topic/40766?page=2#post-159619

after you do the update of the core and update of the photo plugin and in case you get a blank admin page.

#31

Silvio Sep 24 '15

OW Debug - NoticeMessage:Undefined index: hostFile:/var/www/retegay.it/ow_core/request.phpLine:214

OW Debug - WarningMessage:Can't generate URI! Route `admin_themes_add_new` not found!File:/var/www/retegay.it/ow_core/router.phpLine:262

OW Debug - WarningMessage:Can't generate URI! Route `admin_pages_splash_screen` not found!File:/var/www/retegay.it/ow_core/router.phpLine:262

OW Debug - NoticeMessage:Trying to get property of non-objectFile:/var/www/retegay.it/ow_system_plugins/base/bol/component_service.phpLine:115

OW Debug - ExceptionMessage:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `entityId` = 0 LIMIT 0, 1' at line 1File:/var/www/retegay.it/ow_core/database.phpLine:720Trace:#0 /var/www/retegay.it/ow_core/database.php(720): PDOStatement->execute() #1 /var/www/retegay.it/ow_core/database.php(305): OW_Database->execute('SELECT * FROM o...', Array) #2 /var/www/retegay.it/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'BOL_ComponentPl...', Array, 0, Array) #3 /var/www/retegay.it/ow_system_plugins/base/bol/component_place_cache_dao.php(110): OW_BaseDao->findObjectByExample(Object(OW_Example)) #4 /var/www/retegay.it/ow_system_plugins/base/bol/component_service.php(176): BOL_ComponentPlaceCacheDao->findCache(NULL) #5 /var/www/retegay.it/ow_system_plugins/admin/controllers/base.php(52): BOL_ComponentService->findCache('admin.dashboard') #6 [internal function]: ADMIN_CTRL_Base->dashboard(Array) #7 /var/www/retegay.it/ow_core/request_handler.php(266): call_user_func_array(Array, Array) #8 /var/www/retegay.it/ow_core/application.php(342): OW_RequestHandler->dispatch() #9 /var/www/retegay.it/index.php(76): OW_Application->handleRequest() #10 {main}Type:PDOException

#32

Silvio Sep 24 '15

i've used the normal user with sudo (the one i always used to do the upgrade manually in the past)... on this website things goes worst. After i updated the site if i go to the dashboard i receive this error. If i go directly to the page users/unapproved it's the same except the SQLSTATE error.

do you confirm i've to upgrade first the core then the plugin and the themes? because it's what i've done

Ps: i've no Cpanel

#33

Team

ross Sep 29 '15

PM me your FTP, phpmyadmin, admin website and SSH access details if you have such

#34

Team

ross Oct 21 '15

Silvio, please check your site has been successfully updated.

#35

Oxwall Software

Please sign in

We build. You grow.

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Error in Upgrading to 1.8 | Forum