#23 Error adding field.

closed-invalid
nobody
None
5
2010-11-13
2007-01-05
Fabio
No

Hello,

When trying to add a new field to an existing table, I get the following error: "Error adding field. Message from database engine: table TEMP_TABLE already exists."

If I then switch to the "Execute SQL" tab and issue an ALTER TABLE ADD COLUMN there, then the field is successfully added.

This happens with the version 1.3 of SQLite Database Browser as released on sourceforge, no idea about previous releases.

Discussion

  • Nobody/Anonymous

    No such luck replicating with a 5k+ record table. I suggest doing a DROP TABLE `TEMP_TABLE`; and then trying to do the field alter again and see if it still pulls out on you.

     
  • Peter "mash" Morgan

    • status: open --> closed-invalid
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks