ERROR 1030: Got error 124 from table handler
Hi, 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 ? When selecting just the primary key from a UNION table, with MySQL 3.23.53 I get the following error - however if I select the primary key and any other field I get the select to work fine ?? Any ideas - thx dave mysql mysql select userId from Collaborate; ERROR 1030: Got error 124 from table handler mysql select userId,email from Collaborate ;+-+---+ | userId | email | +-+---+ | 178 | [EMAIL PROTECTED] | | 118 | [EMAIL PROTECTED]| | 119 | [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: ERROR 1030: Got error 124 from table handler
Dicky, Thank you for the quick response - but it appears tables created as unions do not support these repair commands:- # bin/mysqlcheck -r -p test Collaborate Enter password: test.Collaborate error: The handler for the table doesn't support check/repair # mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43 to server version: 3.23.52-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql repair Collaborate; ERROR 1064: You have an error in your SQL syntax near 'Vodafone_Collaborate' at line 1 mysql Any other ideas ? Would trying an older version of MySQL be useful ? thx dave Dicky Wahyu Purnomo wrote: Pada Fri, 08 Nov 2002 01:59:20 + 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 - 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: ERROR 1030: Got error 124 from table handler
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 + 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
merge tables - errorno: 143 - Is there a limit on columns with mergedtables ?
Hello, I get the following error when trying to access a table created of TYPE=MERGE mysql describe yy; ERROR 1016: Can't open file: 'yy.MRG'. (errno: 143) Reducing the number of colums in the tables to be merged removed the problem. Any ideas gratefully received, Dave ( MySQL version: 3.23.52 ) - 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
How does MySQL generate it's web based documentation
Good morning, Does anyone have any details on the how the MySQL searchable documentation is produced. Is the content held in MySQL with PHP to produce the frontend pages - and is this something that can be applied generally for web based doumentation services. Thx dave - 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