| Summary | DB Error : already exists |
| Queue | Ansel |
| Type | Bug |
| State | Resolved |
| Priority | 1. Low |
| Owners | |
| Requester | casterln (at) nature (dot) berkeley (dot) edu |
| Created | 09/23/2004 (7671 days ago) |
| Due | |
| Updated | 09/27/2004 (7667 days ago) |
| Assigned | 09/27/2004 (7667 days ago) |
| Resolved | 09/27/2004 (7667 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
The port number for sql based session handling in horde/config
had a default for postgres.
I changed it to the mysqld port and now gallery creation works.
Amazing that things worked as well as they did!
_Gary
nature:sql # echo "select * from horde_datatree where
datatree_id='2118'" | mysql -u root -p horde
Enter password:
datatree_id group_uid user_uid datatree_name
datatree_parents datatree_order datatree_data
datatree_serialized datatree_updated2118 horde.history
lemauxpg@nature
imp.lemauxpg@nature.<20031014030441.GB216@nature.Berkeley.edu>
NULL NULL 0 20031014070546
State ⇒ Assigned
column of the horde_datatree table? If so, your sequence generator is
broken somehow, check the horde_datatree_seq table.
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ DB Error : already exists
Queue ⇒ Ansel
Here are the lines from the log:
Sep 23 16:39:16 HORDE [error] [ansel] DB Error: already exists: INSERT
INTO horde_datatree (datatree_id, group_uid, datatree_name,
datatree_order, datatree_data, user_uid, datatree_serialized,
datatree_parents) VALUES (2118, 'horde.shares.ansel',
'562c6c1216bd899d8ed0a51b712fe296', NULL, '', 'glc', 0, '')
[nativecode=1062 ** Duplicate entry '2118' for key 1] [on line 405 of
"/opt/lib/php/Horde/DataTree/sql.php"]
Sep 23 16:39:16 HORDE [error] [ansel] The gallery "" could not be
created: DB Error: already exists [on line 216 of
"/opt/httpd-prefork/htdocs/horde/ansel/lib/Ansel.php"]
Sep 23 16:39:16 HORDE [error] [ansel] The gallery "new gallery"
couldn't be created: The gallery "" could not be created: DB Error:
already exists [on line 272 of
"/opt/httpd-prefork/htdocs/horde/ansel/gallery.php"]
What do these errors indicate? A locking problem in mysql?
As far as I can tell, the datatree mysql specs match what is in the lastest
sql/scripts. _Gary