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

SITE DOWN 500 ERROR - PLEASE HELP! | Forum

Jobee Bendijo
Jobee Bendijo Feb 13 '16
Hoping someone can help me. Here's the debug notice:



OW Debug - ExceptionMessage: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, 1455421417) #5 /home/jomik12/domains/planettickle.com/public_html/ow_plugins/newsfeed/classes/user_driver.php(42): NEWSFEED_BOL_ActionDao->findByUser(2, Array, 1455421417, 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(258): NEWSFEED_CMP_Feed->render() #10 /home/jomik12/domains/planettickle.com/public_html/ow_core/component.php(80): OW_Renderable->render() #11 /home/jomik12/domains/planettickle.com/public_html/ow_core/renderable.php(258): OW_Component->render() #12 /home/jomik12/domains/planettickle.com/public_html/ow_core/component.php(80): OW_Renderable->render() #13 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(332): OW_Component->render() #14 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/components/drag_and_drop_item.php(317): BASE_CMP_DragAndDropItem->render() #15 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/components/drag_and_drop_frontend_panel.php(110): BASE_CMP_DragAndDropItem->renderView() #16 /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)) #17 /home/jomik12/domains/planettickle.com/public_html/ow_libraries/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(122): content_56be7af62a0a23_33239138(Object(Smarty_Internal_Template)) #18 /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)) #19 /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)) #20 /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) #21 /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) #22 /home/jomik12/domains/planettickle.com/public_html/ow_core/view_renderer.php(101): Smarty_Internal_TemplateBase->fetch('/home/jomik12/d...') #23 /home/jomik12/domains/planettickle.com/public_html/ow_core/renderable.php(271): OW_ViewRenderer->renderTemplate('/home/jomik12/d...') #24 /home/jomik12/domains/planettickle.com/public_html/ow_core/component.php(80): OW_Renderable->render() #25 /home/jomik12/domains/planettickle.com/public_html/ow_system_plugins/base/controllers/component_panel.php(156): OW_Component->render() #26 /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...') #27 [internal function]: BASE_CTRL_ComponentPanel->dashboard(Array) #28 /home/jomik12/domains/planettickle.com/public_html/ow_core/request_handler.php(266): call_user_func_array(Array, Array) #29 /home/jomik12/domains/planettickle.com/public_html/ow_core/application.php(353): OW_RequestHandler->dispatch() #30 /home/jomik12/domains/planettickle.com/public_html/index.php(76): OW_Application->handleRequest() #31 {main}Type:PDOException

tammy harris
tammy harris Feb 13 '16
try deactivate nesfeed plugin 


Jobee Bendijo
Jobee Bendijo Feb 13 '16
How do I do that? I can't get into the site
tammy harris
tammy harris Feb 13 '16
should not be all site 

go yoursite/admin  and sign in




Jobee Bendijo
Jobee Bendijo Feb 13 '16
Thanks Tammy, yeah, can get into the admin, deactivated newsfeed, site restored, then I activated newsfeed again, and site seems fine now. How very strange.
Jobee Bendijo
Jobee Bendijo Feb 13 '16
hhhmmmm it's gone back to 505 error
tammy harris
tammy harris Feb 14 '16
problem was dbmanager plugin
Jobee Bendijo
Jobee Bendijo Feb 14 '16
actually, the problem has returned. I've had to disable newsfeed again. 
Jobee Bendijo
Jobee Bendijo Feb 14 '16
So I still need help.
ross Team
ross Feb 14 '16
Jobee, activate the newsfeed back, 

go to your database-> to ow_newsfeed_action_set table and truncate it, it should fix the issue. 


ow_newsfeed_action_set - is a caching table. By truncating this table you wont lose any data on your site.

Jobee Bendijo
Jobee Bendijo Feb 15 '16
Hi Ross,

I'm not sure how to truncate it. When I go to the db, there is no selection to truncate. 


Using phpMyAdmin, can you tell me how to truncate the table please?


Edit/update: After a little research, I'm thinking that I just empty the table?

The Forum post is edited by Jobee Bendijo Feb 15 '16
Jobee Bendijo
Jobee Bendijo Feb 15 '16
Ross, you are truly worth your weight in gold. Problem resolved. Thank you so much!
ross Team
ross Feb 15 '16
Great, thanks for letting us know. 
kalvindarwan
kalvindarwan Dec 21 '23
Second, you never know when you might need a tow. Atlanta Mobile Truck Repair Co.