Re: ERROR 1030: Got error 124 from table handler

[David Herring]

Thanks for your help - problem now resolved.

The issue was I was creating the userId field with auto_increment and setting it as the primary key in the UNION table definition - but had failed to make the same settings in the table which I was making a UNION from. I.E check very carefully when using UNION that you exactly match the table origional table definition......

thx dave



Jocelyn Fournier wrote:

Hi,

In fact, it's :

joce@forum:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index given to function

but the solution to resolve the problem remains the same ;)

Regards,
Jocelyn
----- Original Message -----
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 2:11 AM
Subject: Re: ERROR 1030: Got error 124 from table handler

Pada Fri, 08 Nov 2002 01:59:20 +0000
David Herring <[EMAIL PROTECTED]> menulis:

What does "ERROR 1030: Got error 124 from table handler" mean when
trying to select a single value from a table created as a UNIOn of
another table ?

root@slimmer:~# perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed

Table corrupt ... do
mysql> repair table <tablename>;
or
shell# mysqlcheck -r -p <db> <table>

--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone: +62 21 79199577 - HP: +62 8158787286
Web: http://www.1rstwap.com


---------------------------------------------------------------------
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