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

SQL Problem: 1062 Duplicate entry 'origin' for key 'name' [Solved] | Forum

Daniel
Daniel Jul 30 '13
Hi all,

since a while I get the following error message:


Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'origin' for key 'name' File: /users/dww/www/ow_core/database.php
Line: 331
Trace:
#0 /users/dww/www/ow_core/database.php(331): PDOStatement->execute()
#1 /users/dww/www/ow_core/database.php(564): OW_Database->execute('INSERT INTO `ow...', Array)
#2 /users/dww/www/ow_core/database.php(601): OW_Database->insert('INSERT INTO `ow...', Array)
#3 /users/dww/www/ow_core/base_dao.php(215): OW_Database->insertObject('ow_base_theme', Object(BOL_Theme))
#4 /users/dww/www/ow_system_plugins/base/bol/theme_service.php(197): OW_BaseDao->save(Object(BOL_Theme))
#5 /users/dww/www/ow_core/application.php(729): BOL_ThemeService->updateThemeList()
#6 /users/dww/www/ow_core/application.php(536): OW_Application->updateCachedEntities(1)
#7 /users/dww/www/ow_core/application.php(146): OW_Application->devActions()
#8 /users/dww/www/index.php(43): OW_Application->init()
#9 {main}
Type: PDOException


I googled already a lot and tried for hours. I guess, that the problem is in the ow_base_theme
table. So I tried to clear it, delete it, import it from an backup. But nothing worked.
I also tried to clear all tables step by step, so see if another error occurs. I needed to leave the ow_base_config, but i was able to clear all other tables - the error stayed, but after each reload ow_base_theme filled automatically with information.

Do you have any ideas, how to solve this problem?
Thank you very much, Daniel
The Forum post is edited by Alia Jul 31 '13
Alia Team
Alia Jul 31 '13
Daniel, will you be able to provide access details ( admin panel, and control panel) ?
Daniel
Daniel Jul 31 '13
Hi Aliia,


thank you for this quick reply.

Of course I can provide this to you. I'll send you a private message with all the details.


Thank you very much, Daniel.

Alia Team
Alia Jul 31 '13
Issue solved.

Causes:

Within "ow_themes" folder, Daniel had: "Origin" and "Origin-backup" subfolders.
Both folders contained same theme.xml file with the same values:

<name>Origin</name>
<key>origin</key>


Solution:

Move "Origin-backup" subfolder out of the "ow_themes" folder.
OR
Delete unneeded folder completely.
OR
Change name and key within the theme.xml file to something other then "origin"/"Origin"
Daniel
Daniel Jul 31 '13
This is great, thank you Aliia!