We build. You grow.

Get best community software here

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

Error 500 When Clicking on Notification | Forum

Robert Rodrigues
Robert Rodrigues Nov 3 '14
I'm getting this weird 500 error.  Here is the debug report when repeating the steps.  This happens when I click on a notification in the drop down notifications list.  Would anyone be able to help with this?  Thanks.



OW Debug - NoticeMessage:Undefined index: ajaxFuncFile:/home1/phluid13/public_html/theresocial/ow_plugins/photo/controllers/photo.phpLine:82

OW Debug - NoticeMessage:Undefined index: userFile:/home1/phluid13/public_html/theresocial/ow_plugins/photo/components/page_head.phpLine:78

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 'LIMIT 0, 1' at line 1File:/home1/phluid13/public_html/theresocial/ow_core/database.phpLine:707Trace:#0 /home1/phluid13/public_html/theresocial/ow_core/database.php(707): PDOStatement->execute() #1 /home1/phluid13/public_html/theresocial/ow_core/database.php(305): OW_Database->execute('SELECT * FROM o...', Array) #2 /home1/phluid13/public_html/theresocial/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'BOL_User', Array, 0, Array) #3 /home1/phluid13/public_html/theresocial/ow_system_plugins/base/bol/user_dao.php(156): OW_BaseDao->findObjectByExample(Object(OW_Example)) #4 /home1/phluid13/public_html/theresocial/ow_system_plugins/base/bol/user_service.php(319): BOL_UserDao->findByUserName(NULL) #5 /home1/phluid13/public_html/theresocial/ow_plugins/photo/components/page_head.php(78): BOL_UserService->findByUsername(NULL) #6 /home1/phluid13/public_html/theresocial/ow_plugins/photo/controllers/photo.php(158): PHOTO_CMP_PageHead->__construct(false, NULL) #7 /home1/phluid13/public_html/theresocial/ow_core/request_handler.php(249): PHOTO_CTRL_Photo->init() #8 /home1/phluid13/public_html/theresocial/ow_core/application.php(327): OW_RequestHandler->dispatch() #9 /home1/phluid13/public_html/theresocial/index.php(73): OW_Application->handleRequest() #10 {main}Type:PDOException

ross Team
ross Nov 3 '14
Robert, what did you do before this error started to occur?


Especially this one: 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 'LIMIT 0, 1' at line 1File:/home1/phluid13/public_html/theresocial/ow_core/database.phpLine:707Trace:#0 /home1/phluid13/public_html/theresocial/ow_core/database.php(707): PDOStatement->execute() #1 /home1/phluid13/public_html/theresocial/ow_core/database.php(305): OW_Database->execute('SELECT * FROM o...', Array) #2 /home1/phluid13/public_html/theresocial/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'BOL_User', Array, 0, Array) #3 /home1/phluid13/public_html/theresocial/ow_system_plugins/base/bol/user_dao.php(156): OW_BaseDao->findObjectByExample(Object(OW_Example)) #4 /home1/phluid13/public_html/theresocial/ow_system_plugins/base/bol/user_service.php(319): BOL_UserDao->findByUserName(NULL) #5 /home1/phluid13/public_html/theresocial/ow_plugins/photo/components/page_head.php(78): BOL_UserService->findByUsername(NULL) #6 /home1/phluid13/public_html/theresocial/ow_plugins/photo/controllers/photo.php(158): PHOTO_CMP_PageHead->__construct(false, NULL) #7 /home1/phluid13/public_html/theresocial/ow_core/request_handler.php(249): PHOTO_CTRL_Photo->init() #8 /home1/phluid13/public_html/theresocial/ow_core/application.php(327): OW_RequestHandler->dispatch() #9 /home1/phluid13/public_html/theresocial/index.php(73): OW_Application->handleRequest() #10 {main}Type:PDOException

Robert Rodrigues
Robert Rodrigues Nov 5 '14
You know.. I don't know what happened.  I tried deactivating all the plugins that are installed and clicking on it again, but no change.
ross Team
ross Nov 5 '14
What software version and photo plugin version do you have?

You can check the plugin version in ow_plugins/photo/plugin.xml file the build line.