Alter Table Returns Cryptic Mambo-jumbo :)

[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