Duplicate entry into table error

A place for users and developers of the Xataface to discuss and receive support.

Postby perseqtor » Mon Mar 19, 2007 1:37 pm

Newbie error: I've been tweaking some stuff recently, and all of the sudden I'm getting this in my PHP error log file:

Fatal error: [pear_error: message="Duplicate entry into table 'case" code=112 mode= level=notice prefix="" info="On line 101 of file /opt/apache/dataface/Dataface/Error.php in function printStackTrace()
On line 561 of file /opt/apache/dataface/Dataface/IO.php in function duplicateEntry(Duplicate entry into table 'case)
On line 338 of file /opt/apache/dataface/Dataface/IO.php in function _insert(Dataface_Record Object,case)
On line 1922 of file /opt/apache/dataface/Dataface/QuickForm.php in function write(Dataface_Record Object,)
On line of file in function save(array(Guy,Knowles,1980-06-07,Stewart Ferreira,07 CF,DUI,6,2006-09-28,,,SAO,6,2007-06-04,405,1,PR,,1,)
On line 1608 of file /opt/apache/dataface/lib/HTML/QuickForm.php in function call_user_func(array(Dataface_QuickForm Object,save),array(Guy,Knowles,1980-06-07,Stewart Ferreira,07 CF,DUI,6,2006-09-28,,,SAO,6,2007-06-04,405,1,PR,,1,)
On line 87 of file /opt/apache/dataface/actions/new.php in function process(array(Dataface_QuickForm Object,s in /opt/apache/dataface/Dataface/Application.php on line 1202

I get a blank screen after hitting "save", and yet there's no duplicate entry being made or saved.
Any ideas on what area of tweaking might have caused this error?
perseqtor
 
Posts: 11
Joined: Wed Dec 31, 1969 5:00 pm

Postby shannah » Mon Mar 19, 2007 2:37 pm

Duplicate entry into table may be caused by not having a primary key defined on that table.

-Steve

--
Steve Hannah
@shannah78 (on twitter)
sjhannah.com blog
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Postby perseqtor » Wed Mar 21, 2007 1:57 am

The problem was that I had inadvertently added a UNIQUE index to a column via PHPMyAdmin that I didn't notice until I looked at the table using the MySQL console. Had nothing to do with Dataface.
perseqtor
 
Posts: 11
Joined: Wed Dec 31, 1969 5:00 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 29 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved