0
I get this error.
144 Table './_joomla/#__muscol_artists' is marked as crashed and last (automatic?) repair failed SQL=SELECT * FROM #__muscol_artists WHERE letter = "" ORDER BY letter+0<>0 ASC, letter+0, letter,class_name LIMIT 0, 20
How can this be fixed?
144 Table './_joomla/#__muscol_artists' is marked as crashed and last (automatic?) repair failed SQL=SELECT * FROM #__muscol_artists WHERE letter = "" ORDER BY letter+0<>0 ASC, letter+0, letter,class_name LIMIT 0, 20
How can this be fixed?
Accepted Answer
0
I hear you.. this is the MySQL structure for the artists table:
CREATE TABLE IF NOT EXISTS `#__muscol_artists` (
`id` int(11) NOT NULL auto_increment,
`artist_name` varchar(255) NOT NULL,
`image` varchar(127) NOT NULL,
`review` mediumtext NOT NULL,
`letter` varchar(1) NOT NULL,
`class_name` varchar(255) NOT NULL,
`related` varchar(63) NOT NULL,
`keywords` varchar(512) NOT NULL,
`added` datetime NOT NULL,
`hits` INT( 11 ) NOT NULL ,
`country` VARCHAR( 255 ) NOT NULL ,
`picture` varchar(255) NOT NULL,
`user_id` int(11) NOT NULL,
`metakeywords` text NOT NULL,
`metadescription` text NOT NULL,
`city` varchar(255) NOT NULL,
`years_active` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`genre_id` int(11) NOT NULL,
`tags` varchar(255) NOT NULL,
`cover` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `genre_id` (`genre_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM;Responses (12)
-
Accepted Answer
-
Accepted Answer
0[steelsol_joomla.joomla_muscol_artists] warning: Table is marked as crashed and last repair failed
[steelsol_joomla.joomla_muscol_artists] warning: 1 client is using or hasn't closed the table properly
[steelsol_joomla.joomla_muscol_artists] error: Found 102 keys of 412
[steelsol_joomla.joomla_muscol_artists] error: Corrupt -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0hello,
if it keeps crashing then it means there's some problem in the DB itself for sure. what I would do is to make a backup copy of this DB. then, create another DIFFERENT db, and import the backup copy. finally you can erase the old one, and give the new one the same name that the old one had... -
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »