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.
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 insert statement looks like:
 
insert into hub_stats values (2006-01-05, 11:01:50, XX.XX.XXX.XX,
http://my.Site.com/Pervious-Page.html;,
http://my.Site.com/Current-Page.html;, SessionIDB9A9F3);
 
This is what my data looks like after hub page has been loaded.
 
*** 2. row ***
   date: 2006-01-05
   time: 11:12:24
 IP_address: XX.XX.XXX.XX
  refer_URL: http://my.Site.com/Pervious-Page.html
current_URL: http://my.Site.com/current-Page.html
  sessionid: 29072B7E7D9E00D9C1651D8E16B9A9F3
*** 3. row ***
   date: 2006-01-05
   time: 11:12:26
 IP_address: XX.XX.XXX.XX
  refer_URL: http://my.Site.com/Pervious-Page.html
current_URL: http://my.site.com/error.html
  sessionid: 29072B7E7D9E00D9C1651D8E16B9A9F3
3 rows in set (0.00 sec)
 
And it is always going to this error.html, and I can't figure out what the
heck is that??? Got any idea? Thanks!


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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, 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.
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 insert statement looks like:
 
insert into hub_stats values (2006-01-05, 11:01:50, XX.XX.XXX.XX, 
http://my.Site.com/Pervious-Page.html;,
http://my.Site.com/Current-Page.html;, SessionIDB9A9F3);
 
This is what my data looks like after hub page has been loaded.
 
*** 2. row ***
   date: 2006-01-05
   time: 11:12:24
 IP_address: XX.XX.XXX.XX
  refer_URL: http://my.Site.com/Pervious-Page.html
current_URL: http://my.Site.com/current-Page.html
  sessionid: 29072B7E7D9E00D9C1651D8E16B9A9F3
*** 3. row ***
   date: 2006-01-05
   time: 11:12:26
 IP_address: XX.XX.XXX.XX
  refer_URL: http://my.Site.com/Pervious-Page.html
current_URL: http://my.site.com/error.html
  sessionid: 29072B7E7D9E00D9C1651D8E16B9A9F3
3 rows in set (0.00 sec)
 
And it is always going to this error.html, and I can't figure out what 
the heck is that??? Got any idea? Thanks!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]