Can only create 127 records in a table :o(
Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can only create 127 records in a table :o(
most probable is that the auto-inc field is of a type that will not allow higher values than 127!! What is the field-type? \d -Original Message- From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] Sent: den 15 juni 2001 13:46 To: mysql listserver Subject: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can only create 127 records in a table :o(
Change the datatype of your primary key from TINYINT to something larger, like SMALLINT, MEDIUMINT, or INT. -Original Message- From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] Sent: Fri, 15 June 2001 13:46 To: mysql listserver Subject: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODP: Can only create 127 records in a table :o(
Hi WHat is your hardware configuration ? I had such problem with Alpha/Linux (RedHat 5.2) Regards Daniel £a e-direct Polska sp. z o.o. WWW: http://www.e-direct.pl E-mail: [EMAIL PROTECTED] 45-072 Opole ul. Reymonta 45 tel. +48 77 44 26 073 fax. +48 77 44 26 074 -Oryginalna wiadomoæ- Od: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] Wys³ano: 15 czerwca 2001 13:46 Do: mysql listserver Temat: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can only create 127 records in a table :o(
Mette Mller Madsen wrote: Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Change type of your primary key column to something bigger than tinyint -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can only create 127 records in a table :o(
Check your AUTO_INCREMENT column. You probably have it set to a TINYINT (0-128). Use ALTER TABLE to change it to an INT or BIGINT. I hope this helps. Pat... - Original Message - From: Mette Møller Madsen [EMAIL PROTECTED] To: mysql listserver [EMAIL PROTECTED] Sent: Friday, June 15, 2001 7:46 AM Subject: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can only create 127 records in a table :o(
Your autoincrement column is of type TINYINT. This type is specifically designed to only hold numbers from 0 to 127. For best results, use an INTEGER - they can accept numbers up to 999 IIRC. HTH Jon -Original Message- From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] Sent: 15 June 2001 12:46 To: mysql listserver Subject: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can only create 127 records in a table :o(
Hi, When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) perhaps you have the auto_increment-field set as a smallint which can only store values up to 127? Use mediumint or int instead ... Bye, Thomas Karcher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: Re: Re: Can only create 127 records in a table :o(
This is a forwarded message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Dvoøáèek Michal [EMAIL PROTECTED] Date: Friday, June 15, 2001, 1:24:16 PM Subject: Can only create 127 records in a table :o( get back, due post not cointains some key words: database ===8==Original message text=== Hi, check column type of this table for this column (try change to int type) (you probably set columnt type to smallint - range -127 to 127) --- Dvoøáèek Michal mailto:[EMAIL PROTECTED] ===8===End of original message text=== --- Dvoøáèek Michalmailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can only create 127 records in a table :o(
And since it's auto_increment, use something like int unsigned because you don't need to store negative numbers... Bill Elvis Gibbs goEbusiness.com - putting e-motion in your business email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938 -Original Message- From: Bruce Stewart [mailto:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 8:35 AM To: 'Mette Møller Madsen'; 'mysql listserver' Subject: RE: Can only create 127 records in a table :o( Change the datatype of your primary key from TINYINT to something larger, like SMALLINT, MEDIUMINT, or INT. -Original Message- From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] Sent: Fri, 15 June 2001 13:46 To: mysql listserver Subject: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php