I created a table witha field Type : int Size : normal. Then I wanted to change it to Size > big, so I went to the edit page (admin/build/data/edit/table_name), but whatever I attempt to do doesnt save the change in size. It is probably meant to be so because of a potential data loss ?

Thanks for your help.

Comments

joachim’s picture

joachim commented
Priority: Minor » Major

This has maybe been updated since this was posted, as I am able to at least try to change data size, but I get this error:

user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE chs_venue DROP PRIMARY KEY in /Users/joachim/Sites/chs-squeeze/includes/database.mysql-common.inc on line 395.
Error dropping primary key.

-- even though it wasn't the primary key serial field I was changing.

dafeder’s picture

dafeder
he/him
Location Philadelphia, PA
commented
Version: 6.x-1.0-alpha14 » 7.x-1.x-dev

Seems nothing still happens when you try to change the column size in latest dev.