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

Marius
Marius Jan 3 '18



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":"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 Marius Jan 3 '18
Klaus Rock
Klaus Rock Jun 11 '18

Is this issue fixed ?


I restored the complete database because Site was not working anymore.


Klaus Rock
Klaus Rock Aug 30 '18

A real ugly bug !!


2 times a week which needs a complete System Restore.


Can anybody fix this ?


Klaus

Marius
Marius Aug 30 '18

Quote from Klaus Rock

A real ugly bug !!


2 times a week which needs a complete System Restore.


Can anybody fix this ?


Klaus


Hello Klaus,


It's a server problem. Contact technical support at host company .


Best regards,


Marius



Marius
Marius Aug 30 '18



Server requirements

If you plan to host your site elsewhere make sure your host meets the following hosting requirements:

  • Linux/Unix/Windows
  • Apache 2 or higher with:
    • mod_rewrite on
    • mod_security (strict configurations) off
  • PHP 5.5 and 5.6 with:
    • cURL on
    • fopen on
    • register_globals off
    • safe_mode off
    • suPHP off
    • suApache off
    • suhosin off
  • PHP modules:
    • PDO
    • DOM
    • mbstring
    • zip
    • zlib
    • ftp
    • json
    • php_openssl
  • MySQL from 5.0 to 5.6
  • GD Library 2 with FreeType support
  • Mail server (SendMail, Exim or other)
  • Cron
Daniel
Daniel Apr 22 '21
Hi, why is this syntax error a server issue? Can it not be fixed with rewriting the code?
The Forum post is edited by Daniel Apr 22 '21