Hi all,
I have a table containing an ID (unique, autoincrement) and some other
fields including IP. When I try to insert the 'ip' I get a "Duplicate entry
for key 1" error (using INSERT INTO tblip (ip) VALUES ('$REMOTE_ADDR
$_agent') ).
This table is needed to handle the amount of online users. The strange thing
is that this happens only with a minority of users. All other users of the
webiste have reported no problem whatsoever.
Someone has an idea whats going wrong here
kind regards
Stijn 5 1796
"Stijn Goris" <me*****@hotmail.com> wrote in message
news:3f***********************@reader0.news.skynet .be... Hi all,
I have a table containing an ID (unique, autoincrement) and some other fields including IP. When I try to insert the 'ip' I get a "Duplicate
entry for key 1" error (using INSERT INTO tblip (ip) VALUES ('$REMOTE_ADDR $_agent') ). This table is needed to handle the amount of online users. The strange
thing is that this happens only with a minority of users. All other users of the webiste have reported no problem whatsoever.
Someone has an idea whats going wrong here
kind regards Stijn
You may have the IP field set to unique.
This would explain what is happening.
Have a look
RG
"RG" <Me@NotTellingYa.com> wrote in message
news:3f***********************@mercury.nildram.net ... "Stijn Goris" <me*****@hotmail.com> wrote in message news:3f***********************@reader0.news.skynet .be... Hi all,
I have a table containing an ID (unique, autoincrement) and some other fields including IP. When I try to insert the 'ip' I get a "Duplicate entry for key 1" error (using INSERT INTO tblip (ip) VALUES ('$REMOTE_ADDR $_agent') ). This table is needed to handle the amount of online users. The strange thing is that this happens only with a minority of users. All other users of
the webiste have reported no problem whatsoever.
Someone has an idea whats going wrong here
kind regards Stijn
You may have the IP field set to unique. This would explain what is happening. Have a look RG
The field ip is not set to unique...
"Stijn Goris" <me*****@hotmail.com> wrote in message
news:3f***********************@reader1.news.skynet .be... "RG" <Me@NotTellingYa.com> wrote in message news:3f***********************@mercury.nildram.net ... "Stijn Goris" <me*****@hotmail.com> wrote in message news:3f***********************@reader0.news.skynet .be... Hi all,
I have a table containing an ID (unique, autoincrement) and some other fields including IP. When I try to insert the 'ip' I get a "Duplicate entry for key 1" error (using INSERT INTO tblip (ip) VALUES ('$REMOTE_ADDR $_agent') ). This table is needed to handle the amount of online users. The strange thing is that this happens only with a minority of users. All other users of the webiste have reported no problem whatsoever.
Someone has an idea whats going wrong here
kind regards Stijn
You may have the IP field set to unique. This would explain what is happening. Have a look RG
The field ip is not set to unique...
Oh well. It's not that then :)
RG
"Stijn Goris" <me*****@hotmail.com> schrieb: INSERT INTO tblip (ip) VALUES ('$REMOTE_ADDR $_agent')
Please give us your table definition.
Regards,
Matthias
On Mon, 29 Sep 2003 17:14:06 +0200, Stijn Goris wrote:
<snip!> The field ip is not set to unique...
It must be either unique or primary key. That is what the reported error
means.
need....more.....information.....
--
Jeffrey D. Silverman | jeffrey AT jhu DOT edu
Johns Hopkins University | Baltimore, MD
Website | http://www.wse.jhu.edu/newtnotes/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jack |
last post by:
I have a text file of data in a file (add2db.txt) where the entries are
already entered on separate lines in the following form:
INSERT INTO `reviews` VALUES("", "Tony's", "Lunch", "Great...
|
by: iqbal |
last post by:
Hi all,
We have an application through which we are bulk inserting rows into a
view. The definition of the view is such that it selects columns from
a table on a remote server. I have added the...
|
by: Philip Boonzaaier |
last post by:
I want to be able to generate SQL statements that will go through a list of
data, effectively row by row, enquire on the database if this exists in the
selected table- If it exists, then the colums...
|
by: harborboy76 |
last post by:
Hi,
I am trying to insert a large number of rows into a table
inside a SPL. But every time, I run the SPL, the table is
locked because of the INSERT. When I tried to issue a COMMIT,
right after...
|
by: 73blazer |
last post by:
Hello,
I'm looking for a way to make some of my insert templates more readable
by placing comments in between the values. I cannot seem to find a way
to do this with DB2, is there a way? I'm...
|
by: MP |
last post by:
Hi
Posted this several hours ago to another ng but it never showed up thought
i'd try here.
using vb6, ado, .mdb, jet4.0, no access
given table tblJob with field JobNumber text(10)
'The...
|
by: mahajanvit |
last post by:
Hi one and all
I got this problem during my project. So in order to solve this I made
a very small application. I am trying to insert using SP and
sqldatasource control. I know that while using...
|
by: anachronic_individual |
last post by:
Hi all,
Is there a standard library function to insert an array of characters
at a particular point in a text stream without overwriting the existing
content, such that the following data in...
|
by: technocraze |
last post by:
Hi guys,
I have encountered this error when updating the values to the MS Acess table.
Error : Update on linked table failed. ODBC sql server error Timeout expired. MS Acess is my front end and...
|
by: rn5a |
last post by:
During registration, users are supposed to enter the following
details: First Name, Last Name, EMail, UserName, Password, Confirm
Password, Address, City, State, Country, Zip & Phone Number. I am...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |