I'm going to Spain today and cannot respond to any questions in the next
week. I was going to wait with this until I got home again, but what the
heck ;-)
Run the following script through your MySQL on an empty database with
mysql -uusername -ppassword dbname <scriptname
and the last command should produce the following error:
ERROR 1034 at line 31: Incorrect key file for table: 'visitkort'. Try to
repair it
I've let 3 people besides myself test it, and they all get the same error.
It has now been tested on:
Win2k server SP2, MySQL 3.23.32
Win2k server SP2, MySQL 3.23.39
Win2k Pro (Danish), MySQL 3.23.33 (normal version)
Win2k Pro SP2 (English), MySQL 3.23.38-MAX
Debian GNU/Linux, MySQL 3.23.39 (bniary .deb package)
Some other Linux (didn't get the distro name), MySQL 3.23.39
All of the above produces the error. So something must be wrong.
Sincerily,
- Carsten
Here's the script:
##################################################
CREATE TABLE `visitkort` (
`id` int(10) unsigned NOT NULL auto_increment,
`kategori_id` int(10) unsigned NOT NULL default '0',
`aktiv` tinyint(3) unsigned NOT NULL default '0',
`navn` varchar(60) NOT NULL default '',
`adresse` varchar(150) NOT NULL default '',
`postnr` varchar(5) NOT NULL default '',
`tlf` varchar(20) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`url` varchar(150) NOT NULL default '',
`beskrivelse` varchar(200) NOT NULL default '',
`visitkort` tinyint(3) unsigned NOT NULL default '0',
`skabelon` tinyint(3) unsigned NOT NULL default '0',
`logo` tinyint(3) unsigned NOT NULL default '0',
`billede` tinyint(3) unsigned NOT NULL default '0',
`tekst1` text NOT NULL,
`tekst2` text NOT NULL,
`tekst3` text NOT NULL,
`tekst4` text NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `ft`
(`navn`,`beskrivelse`,`tekst1`,`tekst2`,`tekst3`,`tekst4`)
) TYPE=MyISAM;
insert into visitkort (kategori_id) values (108);
update visitkort set navn = 'test5' where id = last_insert_id();
update visitkort set tekst1 = 'bla bla' where id = last_insert_id();
##################################################
---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php