Error changing field type TEXT > BLOB

[bhola]

I am trying to change an existing field from type TEXT to BLOB but I get the following error:

SQL-query :

ALTER TABLE wbt_courses CHANGE course_description course_description BLOB NOT NULL

MySQL said:

Can't create table '.\noeltest#sql-558_7171.frm' (errno: 140)

Is it an error with the settings for BLOB or is it a server problem?

Any help much appreciated.

[Sxooter]

All add index or alter table operations in MySQL require the database to copy the WHOLE table to another table, the delete the original. If you run out of space you get an error. could be that. Do you have enough room on your hard drive for a copy of that table?