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
We build. You grow.
Get best community software hereStart 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
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}
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
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 ?
Leader
kalvindarwan
Dec 20 '23
We like to praise the versatility of concrete, but natural stone is no slouch in this department either.
Pleasanton Pest Control
pu ff
Dec 31 '23
Playing Wordle can significantly improve spelling abilities. As players attempt to guess the correct word, they gain exposure to different letter combinations, allowing them to practice and reinforce correct spelling patterns with this page https://www.twitch.tv/wordle_games/about.
James Walter
Jan 1
In addition, we provide a comprehensive range of services, so you can be certain that your vehicle is in good hands.
The Bronx Onsite Truck Repair
