Strange insert: ERROR 1172 (42000)

2006-09-26 Thread Wai-Sun Chia
This is so weird! I'm getting a: ERROR 1172 (42000): Result consisted of more than one row I've setup 2 machines. Same table (dbsetup.sql) , same insert statement (foo.sql), same version (5.0.24a). Only difference is: One is my laptop on FC5-i386, the other is a server on RHEL4u4-i386 Any

Strange insert

2006-01-05 Thread Ngim
Hi all, I have an one insert statement in my hub page. For some reason, and just only on this link, I get two inserts happening about 2 seconds apart. I looked all over my code for a second insert statment, but it is just that one. Why should it be recording two inserts? This is what my

Re: Strange insert

2006-01-05 Thread James Harvard
I assume you did not intend to post to this list, but if you did then this is a problem with your application code, not with MySQL, so I'm afraid this list is not the best place to ask. James Harvard At 11:19 am -0600 5/1/06, Ngim wrote: Hi all, I have an one insert statement in my hub page.

RE: Strange insert

2006-01-05 Thread nngau
Sorry I apologize, it has to do something with my apache. -Original Message- From: James Harvard [mailto:[EMAIL PROTECTED] Sent: Thursday, January 05, 2006 11:46 AM To: Ngim Cc: mysql@lists.mysql.com Subject: Re: Strange insert I assume you did not intend to post to this list

Strange insert behavior with larger tables

2001-09-10 Thread Brett Error
This weekend I wanted to better characterize how different key configurations affect the way rows are inserted. I ran into some behavior I can't understand: I created a prototype table to allow me to track the number of events that occur on a particular day. Events are described with three