[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