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

SQLSTATE[42000] | Forum

W.C
W.C Jun 9 '16

Hello,


yesterday the oxwall Systems works fine, but today, witout any changes, it Shows me a error 500!


if you are Login it Shows:


Error 500
Internal Server Error.


If you are the site admin,

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: Exception 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` = '77' LIMIT 0, 1' at line 1 File: /home/windsvav/public_html/ow_core/database.php Line: 723 Trace:

#0 /home/windsvav/public_html/ow_core/database.php(723): PDOStatement->execute() #1 /home/windsvav/public_html/ow_core/database.php(308): OW_Database->execute('SELECT * FROM o...', Array) #2 /home/windsvav/public_html/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'QUESTIONS_BOL_F...', Array, 0, Array) #3 /home/windsvav/public_html/ow_plugins/questions/bol/follow_dao.php(100): OW_BaseDao->findObjectByExample(Object(OW_Example)) #4 /home/windsvav/public_html/ow_plugins/questions/bol/service.php(519): QUESTIONS_BOL_FollowDao->findFollow(NULL, '77') #5 /home/windsvav/public_html/ow_plugins/questions/components/feed_item.php(178): QUESTIONS_BOL_Service->isFollow(NULL, '77') #6 /home/windsvav/public_html/ow_core/view.php(165): QUESTIONS_CMP_FeedItem->onBeforeRender() #7 /home/windsvav/public_html/ow_core/component.php(80): OW_View->render() #8 /home/windsvav/public_html/ow_plugins/questions/components/feed_list.php(73): OW_Component->render() #9 /home/windsvav/public_html/ow_core/view.php(165): QUESTIONS_CMP_FeedList->onBeforeRender() #10 /home/windsvav/public_html/ow_core/component.php(80): OW_View->render() #11 /home/windsvav/public_html/ow_plugins/questions/components/feed.php(131): OW_Component->render() #12 /home/windsvav/public_html/ow_plugins/questions/components/feed.php(138): QUESTIONS_CMP_Feed->renderList() #13 /home/windsvav/public_html/ow_core/view.php(165): QUESTIONS_CMP_Feed->onBeforeRender() #14 /home/windsvav/public_html/ow_core/component.php(80): OW_View->render() #15 /home/windsvav/public_html/ow_core/renderable.php(124): OW_Component->render() #16 /home/windsvav/public_html/ow_core/view.php(183): OW_Renderable->onRender() #17 /home/windsvav/public_html/ow_core/component.php(80): OW_View->render() #18 /home/windsvav/public_html/ow_core/renderable.php(124): OW_Component->render() #19 /home/windsvav/public_html/ow_core/view.php(183): OW_Renderable->onRender() #20 /home/windsvav/public_html/ow_core/component.php(80): OW_View->render() #21 /home/windsvav/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(332): OW_Component->render() #22 /home/windsvav/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(317): BASE_CMP_DragAndDropItem->render() #23 /home/windsvav/public_html/ow_system_plugins/base/components/drag_and_drop_frontend_panel.php(110): BASE_CMP_DragAndDropItem->renderView() #24 /home/windsvav/public_html/ow_smarty/template_c/766b7b4df65edffeaf3ab9d5a21e5383eda5e507_0.file.drag_and_drop_index.html.php(152): BASE_CMP_DragAndDropFrontendPanel->tplComponent(Array, Object(Smarty_Internal_Template)) #25 /home/windsvav/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(122): content_57593be343d765_43933867(Object(Smarty_Internal_Template)) #26 /home/windsvav/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(199): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template)) #27 /home/windsvav/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(159): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template)) #28 /home/windsvav/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(191): Smarty_Internal_Template->render(false, 0) #29 /home/windsvav/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(94): Smarty_Internal_TemplateBase->_execute('/home/windsvav/...', NULL, NULL, NULL, 0) #30 /home/windsvav/public_html/ow_core/view_renderer.php(101): Smarty_Internal_TemplateBase->fetch('/home/windsvav/...') #31 /home/windsvav/public_html/ow_core/view.php(187): OW_ViewRenderer->renderTemplate('/home/windsvav/...') #32 /home/windsvav/public_html/ow_core/component.php(80): OW_View->render() #33 /home/windsvav/public_html/ow_core/renderable.php(124): OW_Component->render() #34 /home/windsvav/public_html/ow_core/view.php(183): OW_Renderable->onRender() #35 /home/windsvav/public_html/ow_system_plugins/base/controllers/component_panel.php(56): OW_View->render() #36 /home/windsvav/public_html/ow_core/request_handler.php(284): BASE_CTRL_ComponentPanel->render() #37 /home/windsvav/public_html/ow_core/request_handler.php(252): OW_RequestHandler->processControllerAction(Object(ReflectionMethod), Object(BASE_CTRL_ComponentPanel)) #38 /home/windsvav/public_html/ow_core/application.php(364): OW_RequestHandler->dispatch() #39 /home/windsvav/public_html/index.php(76): OW_Application->handleRequest() #40 {main}



anyone have a solution and / or can explain what is wrong?


with best regards

ross Team
ross Jun 9 '16
it is due Questions plugin, contact plugin developer to resolve your issue. 
W.C
W.C Jun 9 '16

Hello ross,


thank you for fast Support.


i turn the plugin off and the error are away! :)


with best regards

The Forum post is edited by W.C Jun 9 '16