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
