I would recommend using an INSERT IGNORE instead of an INSERT.
This is a mysql issue, it means that you have a unique key (primary key)
defined in
your mysql table and your are trying to add another entry with the same
unique key.
***********************************
Brandon Mullenberg
Dialup USA, Inc.
Tel: 888-460-2286 ext 202
Fax: 866-627-8808
Email: [EMAIL PROTECTED]
**********************************
----- Original Message -----
From: "Paul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 6:49 PM
Subject: (RADIATOR) Issue with Duplicate Key when Adding a Session
> Hi All,
>
> We are using Radiator 3.6 with latest patches but we are seeing an issue
> when a new session is added. We're getting Duplicate key which appears to
be
> coming from the internal handler code rather than MySQL itself. Below is
the
> error when it occurs. We've modified our "delete from RADONLINE" query to
> match the details more accurately and we don't appear to be having any
> problems with this, it's just "Adding session for %s" is where it seems to
> go astray.
>
> Thu Jul 24 20:57:37 2003: DEBUG: Adding session for [EMAIL PROTECTED],
> 1.2.3.4, 6256
>
> Thu Jul 24 20:57:37 2003: DEBUG: do query is: 'delete from RADONLINE where
> NASIDENTIFIER='1.2.3.4' and NASPORT=6256 and ACCTSESSIONID = '00062398'':
>
> Thu Jul 24 20:57:37 2003: DEBUG: do query is: 'INSERT INTO RADONLINE
> (USERNAME, NASIDENTIFIER, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
> NASPORT, NASPORTTYPE, SERVICETYPE, DNIS, PHONENO, SESSIONKEY,
> ACCTSESSIONTIME, INPUTOCTETS, OUTPUTOCTETS, POPID,targetid, DOWNLOADRATE,
> UPLOADRATE, ORIGUSER)
>
VALUES('myuser','1.2.3.4','00062398','1059044257','5.6.7.8','6256','Async','
> Framed-User','0312345678','03912345678', '6F419DF2',
> '2185','346903','2410144','61', '15', '45333', '26400',
'[EMAIL PROTECTED]')':
>
> Thu Jul 24 20:57:37 2003: ERR: do failed for 'INSERT INTO RADONLINE
> (USERNAME, NASIDENTIFIER, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
> NASPORT, NASPORTTYPE, SERVICETYPE, DNIS, PHONENO, SESSIONKEY,
> ACCTSESSIONTIME, INPUTOCTETS, OUTPUTOCTETS, POPID, targetid, DOWNLOADRATE,
> UPLOADRATE, ORIGUSER)
>
VALUES('myuser','1.2.3.4','00062398','1059044257','5.6.7.8','6256','Async','
> Framed-User','0312345678','03912345678', '6F419DF2',
> '2185','346903','2410144','61', '15', '45333', '26400',
'[EMAIL PROTECTED]')':
> Duplicate entry '1.2.3.4-6256' for key 1
>
> If you have any ideas that'd be great. Thanks
>
> Regards,
>
> Paul Rivoli
> [EMAIL PROTECTED]
> K B S I N T E R N E T
>
>
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
