The valid range for an 'int' data type (your "id" column) is -2147483648 to
2147483647. The value you are attempting to set (37647438380) is not within this
range.
--Greg Johnson
-----Original Message-----
From: Andreas Gietl [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:46 AM
To: [EMAIL PROTECTED]
Subject: table handler
I've got a nasty problem with my mysql-database.
On the following INSERT (and on others too and on some SELECTs) i get
the following error.
mysql> INSERT INTO hyperseek_keys SET
keyword='meiner_asiatinne',id='37647438380',price='0.01',xfactor='7.50';
ERROR 1030: Got error -1 from table handler
I can't explain this error, i looked at the Documentation and found
neither error 1030 (not in perror nor online) nor error -1.
In the LOGFILE there's nothing special about these failing
transactions.
These are my table definitions:
mysql> DESCRIBE hyperseek_keys;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| keyword | char(50) | | MUL | | |
| id | int(11) | | MUL | 0 | |
| price | decimal(2,2) | | MUL | 0.00 | |
| xfactor | decimal(4,2) | | | 0.00 | |
+---------+--------------+------+-----+---------+-------+---------------------------------+
| Field | Type | Null | Key | Default | Extra |
Privileges |
+---------+--------------+------+-----+---------+-------+---------------------------------+
| keyword | char(50) | | MUL | | |
select,insert,update,references |
| id | int(11) | | MUL | 0 | |
select,insert,update,references |
| price | decimal(2,2) | | MUL | 0.00 | |
select,insert,update,references |
| xfactor | decimal(4,2) | | | 0.00 | |
select,insert,update,references |
+---------+--------------+------+-----+---------+-------+---------------------------------+
+----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name
|
Collation | Cardinality | Sub_part | Packed | Comment |
+----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+
| hyperseek_keys | 1 | hsl_keys1 | 1 | keyword
|
A | NULL | NULL | NULL | |
| hyperseek_keys | 1 | hsl_keys2 | 1 | price
|
A | NULL | NULL | NULL | |
| hyperseek_keys | 1 | hsl_keys2 | 2 | xfactor
|
A | NULL | NULL | NULL | |
| hyperseek_keys | 1 | hsl_keys3 | 1 | id
|
A | NULL | NULL | NULL | |
+----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+
Perhaps you have an idea?
thanx
andreas
--
ACHTUNG NEUE ADRESSE + Telefonnummer
andreas gietl
gietl internet services
roter-brach-weg 124a / 93049 Regensburg
fon +49 941 3810884
fax +49 941 3810891
mobile +49 171 60 70 008
[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
---------------------------------------------------------------------
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