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]: Syntax error or access violation: 1064 | Forum

Wilzer
Wilzer Jan 3 '20

Dear Friends,  Any suggestions on fixing this, the site is frozen with this message after trying to post news feed with link to Facebook page


See attached

Attachments:
  OW Debug.doc (32Kb)
Wilzer
Wilzer Jan 4 '20
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 'type":"link","description":null,"title":null,"thumbnail_url":"https://facebook.c' at line 1 File: /home/scsealsc/public_html/ow_core/database.php Line: 723 Trace: #0 /home/scsealsc/public_html/ow_core/database.php(723): PDOStatement->execute() #1 /home/scsealsc/public_html/ow_core/database.php(344): OW_Database->execute('SELECT * FROM o...', NULL) #2 /home/scsealsc/public_html/ow_plugins/newsfeed/bol/like_dao.php(172): OW_Database->queryForObjectList('SELECT * FROM o...', 'NEWSFEED_BOL_Li...') #3 /home/scsealsc/public_html/ow_plugins/newsfeed/bol/service.php(519): NEWSFEED_BOL_LikeDao->findByEntityList(Array) #4 /home/scsealsc/public_html/ow_plugins/newsfeed/components/feed_list.php(101): NEWSFEED_BOL_Service->findLikesByEntityList(Array) #5 [internal function]: NEWSFEED_CMP_FeedList->__construct(Array, Array) #6 /home/scsealsc/public_html/ow_core/ow.php(492): ReflectionClass->newInstanceArgs(Array) #7 /home/scsealsc/public_html/ow_core/ow.php(456): OW::getClassInstanceArray('NEWSFEED_CMP_Fe...', Array) #8 /home/scsealsc/public_html/ow_plugins/newsfeed/components/feed.php(230): OW::getClassInstance('NEWSFEED_CMP_Fe...', Array, Array) #9 /home/scsealsc/public_html/ow_plugins/newsfeed/components/feed.php(255): NEWSFEED_CMP_Feed->createFeedList(Array, Array) #10 /home/scsealsc/public_html/ow_core/renderable.php(124): NEWSFEED_CMP_Feed->render() #11 /home/scsealsc/public_html/ow_core/view.php(183): OW_Renderable->onRender() #12 /home/scsealsc/public_html/ow_core/component.php(80): OW_View->render() #13 /home/scsealsc/public_html/ow_core/renderable.php(124): OW_Component->render() #14 /home/scsealsc/public_html/ow_core/view.php(183): OW_Renderable->onRender() #15 /home/scsealsc/public_html/ow_core/component.php(80): OW_View->render() #16 /home/scsealsc/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(332): OW_Component->render() #17 /home/scsealsc/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(317): BASE_CMP_DragAndDropItem->render() #18 /home/scsealsc/public_html/ow_system_plugins/base/components/drag_and_drop_frontend_panel.php(110): BASE_CMP_DragAndDropItem->renderView() #19 /home/scsealsc/public_html/ow_smarty/template_c/1680ac21dc3d481bb5a05afacbeb97c05d324797_0.file.drag_and_drop_index.html.php(152): BASE_CMP_DragAndDropFrontendPanel->tplComponent(Array, Object(Smarty_Internal_Template)) #20 /home/scsealsc/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(122): content_57e00aa9a2ccf2_41539794(Object(Smarty_Internal_Template)) #21 /home/scsealsc/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(199): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template)) #22 /home/scsealsc/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(159): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template)) #23 /home/scsealsc/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(191): Smarty_Internal_Template->render(false, 0) #24 /home/scsealsc/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(94): Smarty_Internal_TemplateBase->_execute(Object(Smarty_Internal_Template), NULL, NULL, NULL, 0) #25 /home/scsealsc/public_html/ow_core/view_renderer.php(80): Smarty_Internal_TemplateBase->fetch('/home/scsealsc/...') #26 /home/scsealsc/public_html/ow_core/view.php(187): OW_ViewRenderer->renderTemplate('/home/scsealsc/...') #27 /home/scsealsc/public_html/ow_core/component.php(80): OW_View->render() #28 /home/scsealsc/public_html/ow_core/renderable.php(124): OW_Component->render() #29 /home/scsealsc/public_html/ow_core/view.php(183): OW_Renderable->onRender() #30 /home/scsealsc/public_html/ow_system_plugins/base/controllers/component_panel.php(56): OW_View->render() #31 /home/scsealsc/public_html/ow_core/request_handler.php(258): BASE_CTRL_ComponentPanel->render() #32 /home/scsealsc/public_html/ow_core/request_handler.php(226): OW_RequestHandler->processControllerAction(Object(ReflectionMethod), Object(BASE_CTRL_ComponentPanel)) #33 /home/scsealsc/public_html/ow_core/application.php(346): OW_RequestHandler->dispatch() #34 /home/scsealsc/public_html/index.php(76): OW_Application->handleRequest() #35 {main}
Patricia Zorrilla Leader
Patricia Zorrilla Jan 4 '20

There is news in NewsFeed with a broken link: "https: //facebook.c"

I recommend going to MySql, look for the record that contains this link and simply replace this URL with an empty string. Not touching anything but NewsFeed is very delicate.

Wilzer
Wilzer Jan 4 '20

Thanks for reply, I have just restored site and database back to before error occurred, Wondering if it will occur again if I try to link to facebook  ?


Patricia Zorrilla Leader
Patricia Zorrilla Jan 5 '20
It must work, it must have been a casual mistake
Wilzer
Wilzer Jan 7 '20
Thanks everyone, still not sure I want to try again.