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

Privacy error | Forum

Simone
Simone Oct 4 '14
hi,
when I try to change privacy it give me 500 error.

with debug it says


Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-confessions_view_confession_conf' for key 'userId'
File: /home/cenex/public_html/ow_core/database.php
Line: 707
Trace: 
#0 /home/cenex/public_html/ow_core/database.php(707): PDOStatement->execute()
#1 /home/cenex/public_html/ow_core/database.php(460): OW_Database->execute('INSERT INTO `ow...', Array)
#2 /home/cenex/public_html/ow_core/database.php(496): OW_Database->insert('INSERT INTO `ow...', Array)
#3 /home/cenex/public_html/ow_core/base_dao.php(216): OW_Database->insertObject('ow_privacy_acti...', Object(PRIVACY_BOL_ActionData))
#4 /home/cenex/public_html/ow_plugins/privacy/bol/action_service.php(419): OW_BaseDao->save(Object(PRIVACY_BOL_ActionData))
#5 /home/cenex/public_html/ow_plugins/privacy/controllers/privacy.php(162): PRIVACY_BOL_ActionService->saveActionValues(Array, 1)
#6 [internal function]: PRIVACY_CTRL_Privacy->index(Array)
#7 /home/cenex/public_html/ow_core/request_handler.php(263): call_user_func_array(Array, Array)
#8 /home/cenex/public_html/ow_core/application.php(327): OW_RequestHandler->dispatch()
#9 /home/cenex/public_html/index.php(73): OW_Application->handleRequest()
#10 {main}
Type: PDOException

can you help me?

thank you
Simone
Simone Oct 4 '14
If I save privacy for the first time (for any users) its ok.


From the second time it gives me the error

tammy harris
tammy harris Oct 4 '14
try deactivate confessions plugin
The Forum post is edited by tammy harris Oct 4 '14
tammy harris
tammy harris Oct 4 '14
or do you use boost compressor plugin
ross Team
ross Oct 6 '14
Simone, also, please truncate your ow_newsfeed_action_set table and see if the error persists.