Alter Table Returns Cryptic Mambo-jumbo :)

[shareaweb]

I've got a new one for you guru's: I am trying to do a simple alter table and change a varchar from 30 to 50.. when I do this in the GUI or the Query window I get the following cryptic error message:

(BTW, the new autocomplete is cool as hell, as Paris would say: It's Hot!)

Error No. 7

Error on rename of '.callcent_shareawebcccccc_area_lst.MYI' to '.callcent_shareawebccc#sql2-608-1a.MYI' (Errcode:13)

Now, I figure this is some sort of index problem, but trying to analyze and fix doen't work.

Here's the structure:

/*Column Information For – callcent_ShareaWebCCC.ccc_area_list*/

---

Field Type Null Key Default Extra Privileges

---

---

---

---

---

---

---

id int(11) unsigned PRI (NULL) auto_increment select,insert,update,references

title varchar(30) select,insert,update,references

parent int(11) 0 select,insert,update,references

meta text select,insert,update,references

meta_keys text select,insert,update,references

meta_desc text select,insert,update,references

meta_phrases text select,insert,update,references

meta_subject text select,insert,update,references

meta_abstract text select,insert,update,references

akey bigint(20) 0 select,insert,update,references

/*Index Information For – callcent_ShareaWebCCC.ccc_area_list*/

---

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment

---

---

---

---

---

---

---

---

---

---

ccc_area_list 0 PRIMARY 1 id A 18 (NULL) (NULL)

/*DDL Information For – callcent_ShareaWebCCC.ccc_area_list*/

---

Table Create Table

---

---

ccc_area_list CREATE TABLE `ccc_area_list` (

`id` int(11) unsigned NOT NULL auto_increment,

`title` varchar(30) NOT NULL default '',

`parent` int(11) NOT NULL default '0',

`meta` text NOT NULL,

`meta_keys` text NOT NULL,

`meta_desc` text NOT NULL,

`meta_phrases` text NOT NULL,

`meta_subject` text NOT NULL,

`meta_abstract` text NOT NULL,

`akey` bigint(20) NOT NULL default '0',

PRIMARY KEY (`id`)

) TYPE=MyISAM

[peterlaursen]

Now .. I can easily do that ALTER TABLE .. see attached.

hmmm… what do we do from here ???

It looks like a server configuration or privilege issue.

What is MySQL version ? A shared (ISP) server?

I assume that the samme error occurs from SQLyog SQL-pane and MySQL command-line client?

BTW 1): NO! the KEYWORDS handling is hotter than autocomplete!

http://www.webyog.com/forums/index.php?showtopic=1953 😀

BTW 2) gurus??? where???? no my dear – PROPHETS !!!

You can try from any other client this

“alter table `test4`.`ccc_area_list` change `title` `title` varchar(50) NOT NULL”

is there somewhere else where it works?

[Ritesh]

Looks like an issue with your MySQL data or index. The error is returned by MySQL.

BTW, which version of MySQL are you using? It might be a known bug in that MySQL version.

[shareaweb]

Prophets. LOL. Could be considered true. :ph34r:

Well, as it turns out I think the tables were FUBAR. It said they were crashed.

Low and behold it was 4.0.1-a on my local machine. I upgraded it to something more reasonable, (5.1.11-noindex) and recreated the tables (after all the fix_priv's and flushes) and looks as though Im in business again.

I had originally dumped the tables from an online 4.1.3 DB, but I think there were some versioning issues between them.

You both are doing a great job. Thanks for the fast relies!

-Eric

[Author]

Posts