[jonah] (no subject)
Brandon Knitter
knitterb at blandsite.org
Sat Jan 15 17:41:45 PST 2005
Hi there! I'm new to Jonah, but cool stuff! :)
Horde: 3.0.2
Jonah: cvs (2005/01/15 1700PST)
When trying to add my own news content I am getting the error:
There was an error saving the channel. DB Error: constraint violation
Further review of the logs shows:
Jan 15 17:32:28 HORDE [error] [jonah] DB Error: constraint violation: INSERT
INTO jonah_channels (channel_id, channel_name, channel_type, channel_desc,
channel_interval, channel_url, channel_link, channel_story_url, channel_img)
VALUES (2, 'Engadget', 1, NULL, 86400, 'http://www.engadget.com/rss.xml', '',
NULL, '') [nativecode=1062 ** Duplicate entry '2' for key 1] [on line 102 of
"/var/www/html/horde-3.0.2/jonah-cvs/lib/News/sql.php"]
I can tell that this won't work because the current max key is at 121:
mysql> select max(channel_id) from jonah_channels;
+-----------------+
| max(channel_id) |
+-----------------+
| 121 |
+-----------------+
1 row in set (0.07 sec)
mysql>
I'm still getting used to Horde3 (good stuff), so I'm not sure where that "next
key" value is stored. I'm assuming that this is happening cause I ran the
script in <jonah>/scripts/sql/scripts.feeds.sql, but I didn't update the "next
key" whereever it may be.
Any hints where in the UI I can set the next key to be 122 or higher? Wasn't
every key in H3 moving toward GGUIDs?
Thanks! :)
--
-bk
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
More information about the jonah
mailing list