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

(SOLVED) ERROR 500 INTERNAL SERVER ERROR | Forum

Robert Thornton
Robert Thornton Jul 13 '19

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":"Primarul general, Gabriela Firea, a declarat, miercu' at line 1




File:



/home/rhapsody/public_html/ow_core/database.php



Line: 723



Trace:


#0 /home/rhapsody/public_html/ow_core/database.php(723): PDOStatement->execute() #1 /home/rhapsody/public_html/ow_core/database.php(344): OW_Database->execute('SELECT * FROM o...', NULL) #2 /home/rhapsody/public_html/ow_plugins/newsfeed/bol/like_dao.php(172): OW_Database->queryForObjectList('SELECT * FROM o...', 'NEWSFEED_BOL_Li...') #3 /home/rhapsody/public_html/ow_plugins/newsfeed/bol/service.php(519): NEWSFEED_BOL_LikeDao->findByEntityList(Array) #4 /home/rhapsody/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/rhapsody/public_html/ow_core/ow.php(492): ReflectionClass->newInstanceArgs(Array) #7 /home/rhapsody/public_html/ow_core/ow.php(456): OW::getClassInstanceArray('NEWSFEED_CMP_Fe...', Array) #8 /home/rhapsody/public_html/ow_plugins/newsfeed/components/feed.php(230): OW::getClassInstance('NEWSFEED_CMP_Fe...', Array, Array) #9 /home/rhapsody/public_html/ow_plugins/newsfeed/components/feed.php(255): NEWSFEED_CMP_Feed->createFeedList(Array, Array) #10 /home/rhapsody/public_html/ow_core/renderable.php(124): NEWSFEED_CMP_Feed->render() #11 /home/rhapsody/public_html/ow_core/view.php(183): OW_Renderable->onRender() #12 /home/rhapsody/public_html/ow_core/component.php(80): OW_View->render() #13 /home/rhapsody/public_html/ow_core/renderable.php(124): OW_Component->render() #14 /home/rhapsody/public_html/ow_core/view.php(183): OW_Renderable->onRender() #15 /home/rhapsody/public_html/ow_core/component.php(80): OW_View->render() #16 /home/rhapsody/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(332): OW_Component->render() #17 /home/rhapsody/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(317): BASE_CMP_DragAndDropItem->render() #18 /home/rhapsody/public_html/ow_system_plugins/base/components/drag_and_drop_frontend_panel.php(110): BASE_CMP_DragAndDropItem->renderView() #19 /home/rhapsody/public_html/ow_smarty/template_c/eadcbc92a6186c5a771758cd1df302ea0d8d0ca1_0.file.drag_and_drop_entity_panel.html.php(113): BASE_CMP_DragAndDropFrontendPanel->tplComponent(Array, Object(Smarty_Internal_Template)) #20 /home/rhapsody/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(122): content_5a42c44f2aa7f1_24543458(Object(Smarty_Internal_Template)) #21 /home/rhapsody/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/rhapsody/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(159): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template)) #23 /home/rhapsody/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(191): Smarty_Internal_Template->render(false, 0) #24 /home/rhapsody/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/rhapsody/public_html/ow_core/view_renderer.php(80): Smarty_Internal_TemplateBase->fetch('/home/rhapsody/...') #26 /home/rhapsody/public_html/ow_core/view.php(187): OW_ViewRenderer->renderTemplate('/home/rhapsody/...') #27 /home/rhapsody/public_html/ow_core/component.php(80): OW_View->render() #28 /home/rhapsody/public_html/ow_system_plugins/base/controllers/component_panel.php(156): OW_Component->render() #29 /home/rhapsody/public_html/ow_system_plugins/base/controllers/component_panel.php(182): BASE_CTRL_ComponentPanel->action('dashboard', 4, false, Array, 'drag_and_drop_e...') #30 [internal function]: BASE_CTRL_ComponentPanel->dashboard(Array) #31 /home/rhapsody/public_html/ow_core/request_handler.php(250): ReflectionMethod->invokeArgs(Object(BASE_CTRL_ComponentPanel), Array) #32 /home/rhapsody/public_html/ow_core/request_handler.php(226): OW_RequestHandler->processControllerAction(Object(ReflectionMethod), Object(BASE_CTRL_ComponentPanel)) #33 /home/rhapsody/public_html/ow_core/application.php(346): OW_RequestHandler->dispatch() #34 /home/rhapsody/public_html/index.php(76): OW_Application->handleRequest() #35 {main}


Type:

PDOException


The Forum post is edited by Robert Thornton Jul 13 '19
Bob Newbie
Bob Newbie Oct 15 '19
I'm having the same problem when I do a forum search. Would someone please tell me how to solve this problem.  It would be appreciated.
dave Leader
dave Oct 15 '19
When a post says solved please dont add to it because people think its solved and wont reply, so in that case just make a new post and referrence this one in a link. 


Here is a help page for errors, many times your error is caused by special characters.

https://wiki.oxwall.com/faq:sqlstate-errors


Are you new to oxwall?



The Forum post is edited by dave Oct 15 '19
Bob Newbie
Bob Newbie Oct 15 '19

Thanks for your reply and for the link you provided.  I wasn't able to find a solution to my problem. I checked to be be sure the problem wasn't special characters so my problem is different. I will start a new topic about the problem I'm having soon.  I'm not good with database problems so I would greatly appreciate any help you and other forum members could give me.


I am new posting on here the forum.  I have been testing Oxwall on and off for several years. I've never used it on a live site but I intend to do so soon.