[wicked] Re: attachment updates

[Brian Martinez]

Jan,

Debugging is now on...Here are the lines around the error:

Mar 17 09:23:06 HORDE [debug] [wicked] SQL Query by Prefs_sql::retrieve(): 
SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 
'test' AND (pref_scope = 'wicked' OR pref_scope = 'horde') ORDER BY 
pref_scope [on line 147 of "/usr/share/pear/Horde/Prefs/sql.php"]
Mar 17 09:23:06 HORDE [debug] [wicked] Wicked_Driver_sql::_retrieve(): 
SELECT * FROM wicked_pages WHERE page_name = 'BranchinG' [on line 676 of 
"/var/www/php/horde/wicked/lib/Driver/sql.php"]
Mar 17 09:23:06 HORDE [debug] [wicked] Wicked_Driver_sql::_retrieve(): 
SELECT * FROM wicked_attachments WHERE page_id = 177 [on line 676 of 
"/var/www/php/horde/wicked/lib/Driver/sql.php"]
Mar 17 09:23:06 HORDE [debug] [wicked] Wicked_Driver_sql::_retrieve(): 
SELECT * FROM wicked_pages WHERE page_name = 'BranchinG' [on line 676 of 
"/var/www/php/horde/wicked/lib/Driver/sql.php"]
Mar 17 09:23:06 HORDE [debug] [wicked] Wicked_Driver_sql::_retrieve(): 
SELECT * FROM wicked_attachments WHERE page_id = 0 AND attachment_name = 
'branching.vsd' [on line 676 of 
"/var/www/php/horde/wicked/lib/Driver/sql.php"]
Mar 17 09:23:06 HORDE [debug] [wicked] DB Error: constraint violation: 
INSERT INTO wicked_attachments (page_id, attachment_majorversion, 
attachment_minorversion, change_log, change_author, attachment_created, 
attachment_name) VALUES ( 177, 1, 0, 'Final update', 'hordemgr', 1111076586, 
'branching.vsd' ); [nativecode=1062 ** Duplicate entry '177-branching.vsd' 
for key 1] [on line 162 of "/usr/share/pear/Horde/Notification.php"]

V/R,
Brian
>From: Jan Schneider <jan at horde.org>
>To: wicked at lists.horde.org
>Subject: [wicked] Re: attachment updates
>Date: Thu, 17 Mar 2005 17:19:19 +0100
>
>Zitat von Brian Martinez <martinez_brain at hotmail.com>:
>
> > Jan,
> >
> > That is the error reported at the top of the page...
> >
> > "Error  DB Error: constraint violation"
> >
> > I also checked the horde.log for any amplifying information and found no
> > errors from wicked being reported to the log.  Nonetheless, the update 
>is
> > not being allowed.
>
>Turn on debug logging and past the last SQL query before the error message.
>
> >> From: Jan Schneider <jan at horde.org>
> >> To: wicked at lists.horde.org
> >> Subject: [wicked] Re: attachment updates
> >> Date: Thu, 17 Mar 2005 10:34:14 +0100
> >>
> >> Zitat von Brian Martinez <martinez_brain at hotmail.com>:
> >>
> >> > All,
> >> >
> >> > Still getting the following error when attempting to "update" an
> >> attached
> >> > file:
> >> >
> >> > DB Error: constraint violation
> >>
> >> And what's the full error message?
> >>
> >> Jan.
> >>
> >> --
> >> Do you need professional PHP or Horde consulting?
> >> http://horde.org/consulting/
> >> --
> >> wicked mailing list - Join the hunt: http://horde.org/bounties/#wicked
> >> Frequently Asked Questions: http://horde.org/faq/
> >> To unsubscribe, mail: wicked-unsubscribe at lists.horde.org
> >
> >
> > --
> > wicked mailing list - Join the hunt: http://horde.org/bounties/#wicked
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: wicked-unsubscribe at lists.horde.org
> >
> >
>
>
>
>Jan.
>
>--
>Do you need professional PHP or Horde consulting?
>http://horde.org/consulting/
>--
>wicked mailing list - Join the hunt: http://horde.org/bounties/#wicked
>Frequently Asked Questions: http://horde.org/faq/
>To unsubscribe, mail: wicked-unsubscribe at lists.horde.org