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 on dashboard [SOLVED] | Forum

Shane
Shane Apr 22 '13

I get the following error when a user navigates to their dashboard.


Message: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 `questionId` = '19' LIMIT 0, 1' at line 1

File:/ow_core/database.php

Line:331

Trace:

#0 /ow_core/database.php(331): PDOStatement->execute()

#1 /ow_core/database.php(397): OW_Database->execute('SELECT * FROM o...', Array)

#2 /ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'QUESTIONS_BOL_F...', Array, 0, Array)

#3 /ow_plugins/questions/bol/follow_dao.php(100): OW_BaseDao->findObjectByExample(Object(OW_Example))

#4 /ow_plugins/questions/bol/service.php(501): QUESTIONS_BOL_FollowDao->findFollow(NULL, '19')

#5 /ow_plugins/questions/classes/newsfeed_bridge.php(199): QUESTIONS_BOL_Service->isFollow(NULL, '19')

#6 [internal function]: QUESTIONS_CLASS_NewsfeedBridge->onItemRender(Object(OW_Event))

#7 /ow_core/event_manager.php(188): call_user_func(Array, Object(OW_Event))

#8 /ow_plugins/newsfeed/components/feed_item.php(203): OW_EventManager->trigger(Object(OW_Event))

#9 /ow_plugins/newsfeed/components/feed_item.php(448): NEWSFEED_CMP_FeedItem->getActionData(Object(NEWSFEED_CLASS_Action))

#10 /ow_plugins/newsfeed/components/feed_list.php(120): NEWSFEED_CMP_FeedItem->renderMarkup(Array)

#11 /ow_smarty/template_c/454ef94c31af654077eb7e67bf7dc06d8cd0c923.file.feed_list.html.php(41): NEWSFEED_CMP_FeedList->tplRenderItem(Array, Object(Smarty_Internal_Template))

#12 /ow_libraries/smarty3/sysplugins/smarty_internal_templatebase.php(180): content_5175a3c571e889_50343675(Object(Smarty_Internal_Template))

#13 /ow_core/view_renderer.php(101): Smarty_Internal_TemplateBase->fetch('/var/www/social...')

#14 /ow_core/renderable.php(263): OW_ViewRenderer->renderTemplate('/var/www/social...')

#15 /ow_core/component.php(80): OW_Renderable->render()

#16 /ow_plugins/newsfeed/components/feed_list.php(134): OW_Component->render()

#17 /ow_plugins/newsfeed/components/feed.php(181): NEWSFEED_CMP_FeedList->render()

#18 /ow_core/renderable.php(250): NEWSFEED_CMP_Feed->render()

#19 /ow_core/component.php(80): OW_Renderable->render()

#20 /ow_core/renderable.php(250): OW_Component->render()

#21 /ow_core/component.php(80): OW_Renderable->render()

#22 /ow_system_plugins/base/components/drag_and_drop_item.php(256): OW_Component->render()

#23 /ow_system_plugins/base/components/drag_and_drop_item.php(241): BASE_CMP_DragAndDropItem->render()

#24 /ow_system_plugins/base/components/drag_and_drop_entity_panel.php(205): BASE_CMP_DragAndDropItem->renderView()

#25 /ow_smarty/template_c/fcec13e48fd44fbc0df930d933db55c16d7e217e.file.drag_and_drop_entity_panel.html.php(94): BASE_CMP_DragAndDropEntityPanel->tplComponent(Array, Object(Smarty_Internal_Template))

#26 /ow_libraries/smarty3/sysplugins/smarty_internal_templatebase.php(180): content_5175a3c55a7049_95633902(Object(Smarty_Internal_Template))

#27 /ow_core/view_renderer.php(101): Smarty_Internal_TemplateBase->fetch('/var/www/social...')

#28 /ow_core/renderable.php(263): OW_ViewRenderer->renderTemplate('/var/www/social...')

#29 /ow_core/component.php(80): OW_Renderable->render()

#30 /ow_system_plugins/base/controllers/component_panel.php(156): OW_Component->render()

#31 /ow_system_plugins/base/controllers/component_panel.php(182): BASE_CTRL_ComponentPanel->action('dashboard', 1, false, Array, 'drag_and_drop_e...')

#32 [internal function]: BASE_CTRL_ComponentPanel->dashboard(Array)

#33 /ow_core/request_handler.php(266): ReflectionMethod->invokeArgs(Object(BASE_CTRL_ComponentPanel), Array)

#34 /ow_core/application.php(317): OW_RequestHandler->dispatch()

#35 /index.php(65): OW_Application->handleRequest()

#36 {main}

Type:PDOException

The Forum post is edited by Shane Apr 25 '13
Alia Team
Alia Apr 22 '13
Shane, try deactivating "Question" plugin.
If this doesn't help, can you give your site URL?
Shane
Shane Apr 23 '13
I have tried Deactivating all plugins and then adding then one at a time to see what is the problem. Whilst doing this I have also noticed other odd behavior like DEV and DEBUG mode cant be on at the same time as I get the 500.phtml page.

Regrettably my URL is sitting behind the company firewall. I suspect is more a permissions problem. 

Shane
Shane Apr 25 '13
Quote from Shane Magee I have tried Deactivating all plugins and then adding then one at a time to see what is the problem. Whilst doing this I have also noticed other odd behavior like DEV and DEBUG mode cant be on at the same time as I get the 500.phtml page.

Regrettably my URL is sitting behind the company firewall. I suspect is more a permissions problem. 


As suspected this error was caused by file permission settings. Although I did also unistall and reinstall the QUESTIONS plugin as recommended. 


All the file permissions are now set to 775 with 777 added to the following folders

ow_userfiles, 

ow_pluginfiles, 

ow_static 

ow_smarty