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

Getting 500 error, don't know how to fix it. | Forum

Jobee Bendijo
Jobee Bendijo Jul 26 '16
My site is down, 500 error. Can someone (preferably Ross) tell me what I need to do to fix it? Seems to be in the Newsfeed. When I deactivate newsfeed, the site comes back online.


Here's the debug notice:


Message:SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2147483647' for key 'PRIMARY'File:/home/jomik12/domains/planettickle.com/public_html/ow_core/database.phpLine:723Trace:#0 /home/jomik12/domains/planettickle.com/public_html/ow_core/database.php(723): PDOStatement->execute() #1 /home/jomik12/domains/planettickle.com/public_html/ow_core/database.php(451): OW_Database->execute(' REPLACE INTO o...', Array) #2 /home/jomik12/domains/planettickle.com/public_html/ow_core/database.php(491): OW_Database->query(' REPLACE INTO o...', Array) #3 /home/jomik12/domains/planettickle.com/public_html/ow_plugins/newsfeed/bol/action_set_dao.php(154): OW_Database->update(' REPLACE INTO o...', Array) #4 /home/jomik12/domains/planettickle.com/public_html/ow_plugins/newsfeed/bol/action_dao.php(286): NEWSFEED_BOL_ActionSetDao->generateActionSet(2, 1469592642) #5 /home/jomik12/domains/planettickle.com/public_html/ow_plugins/newsfeed/classes/user_driver.php(42): NEWSFEED_BOL_ActionDao->findByUser(2, Array, 1469592642, NULL) #6 /home/jomik12/domains/planettickle.com/public_html/ow_plugins/newsfeed/classes/driver.php(62): NEWSFEED_CLASS_UserDriver->findActionList(Array) #7 /home/jomik12/domains/planettickle.com/public_html/ow_plugins/newsfeed/components/feed.php(211): NEWSFEED_CLASS_Driver->getActionList() #8 /home/jomik12/domains/planettickle.com/public_html/ow_plugins/newsfeed/components/feed.php(252): NEWSFEED_CMP_Feed->getActionsList() #9 /home/jomik12/domains/planettickle.com/public_html/ow_core/renderable.php(124): NEWSFEED_CMP_Feed->render() #10 /home/jomik12/domains/planettickle.com/public_html/ow_core/view.php(183): OW_Renderable->onRender() #11 /home/jomik12/domains/planettickle.com/public_html/ow_core/component.php(80): OW_View->render() #12 /home/jomik12/domains/planettickle.com/public_html/ow_core/renderable.php(124): OW_Component->render() #13 /home/jomik12/domains/planettickle.com/public_html/ow_core/view.php(183): OW_Renderable->onRender() #14 /home/jomik12/domains/planettickle.com/public_html/ow_core/component.php(80): OW_View->render() #15 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(332): OW_Component->render() #16 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(317): BASE_CMP_DragAndDropItem->render() #17 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/components/drag_and_drop_frontend_panel.php(110): BASE_CMP_DragAndDropItem->renderView() #18 /home/jomik12/domains/planettickle.com/public_html/ow_smarty/template_c/ca1b56eb59e13aed1d54d2a02ff20820c7192f56_0.file.drag_and_drop_entity_panel.html.php(113): BASE_CMP_DragAndDropFrontendPanel->tplComponent(Array, Object(Smarty_Internal_Template)) #19 /home/jomik12/domains/planettickle.com/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(122): content_5780d3e86a6201_45555376(Object(Smarty_Internal_Template)) #20 /home/jomik12/domains/planettickle.com/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(199): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template)) #21 /home/jomik12/domains/planettickle.com/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(159): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template)) #22 /home/jomik12/domains/planettickle.com/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(191): Smarty_Internal_Template->render(false, 0) #23 /home/jomik12/domains/planettickle.com/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(94): Smarty_Internal_TemplateBase->_execute('/home/jomik12/d...', NULL, NULL, NULL, 0) #24 /home/jomik12/domains/planettickle.com/public_html/ow_core/view_renderer.php(101): Smarty_Internal_TemplateBase->fetch('/home/jomik12/d...') #25 /home/jomik12/domains/planettickle.com/public_html/ow_core/view.php(187): OW_ViewRenderer->renderTemplate('/home/jomik12/d...') #26 /home/jomik12/domains/planettickle.com/public_html/ow_core/component.php(80): OW_View->render() #27 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/controllers/component_panel.php(156): OW_Component->render() #28 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/controllers/component_panel.php(182): BASE_CTRL_ComponentPanel->action('dashboard', 2, false, Array, 'drag_and_drop_e...') #29 [internal function]: BASE_CTRL_ComponentPanel->dashboard(Array) #30 /home/jomik12/domains/planettickle.com/public_html/ow_core/request_handler.php(276): ReflectionMethod->invokeArgs(Object(BASE_CTRL_ComponentPanel), Array) #31 /home/jomik12/domains/planettickle.com/public_html/ow_core/request_handler.php(252): OW_RequestHandler->processControllerAction(Object(ReflectionMethod), Object(BASE_CTRL_ComponentPanel)) #32 /home/jomik12/domains/planettickle.com/public_html/ow_core/application.php(364): OW_RequestHandler->dispatch() #33 /home/jomik12/domains/planettickle.com/public_html/index.php(76): OW_Application->handleRequest() #34 {main}Type:PDOException

The Forum post is edited by Jobee Bendijo Jul 26 '16
ross Team
ross Jul 26 '16
truncate ow_newsfeed_action_set database table and see if the issue persists. Please, do the search on the forum, before posting anything, this issue has been discussed a lot of times
Igor
Igor Jul 17 '17

Hi ross
How can truncate this db field?
It's missing in my db or I can't find.
Thanks.
Quote from ross truncate ow_newsfeed_action_set database table and see if the issue persists. Please, do the search on the forum, before posting anything, this issue has been discussed a lot of times