sqlite does not support dropping columns. That prevents the migration from moving the data into a dummy columns to perform the conversion.
If you do not have important data in the database I suggest you delete the databases/* files. Else give me some details about the model and I can provide a script to do this conversion. On Aug 20, 3:50 pm, Philip <philip.el...@gmail.com> wrote: > I am using SQLite. > Thanks, > Philip > > On Aug 17, 5:54 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > The problem is that web2py relies on the database to perform the data > > conversion. Which database do you use? > > > Massimo > > > On Aug 17, 4:38 pm, Philip <philip.el...@gmail.com> wrote: > > > > I have an application that is up and running (which is relevant > > > because I don't want to erase all the data already in it), in which I > > > want to change a field type from float to decimal. As soon as I > > > change my model file and refresh the app, I get the following error: > > > > ValueError: invalid literal for int() with base 10: ' > > > > As I understand it, that error should arise from trying to convert a > > > string to an integer (and having a non-numeric character). In this > > > case, all the existing values in the database are floats, so when the > > > field type is changed, the values should be converted from float to > > > decimal - I don't see how that conversion would cause the above error. > > > > Is there anything about the migration of data that happens when a > > > field type is changed that would cause an issue like this? Also, I am > > > using SQLite as the DB; is that in some way contributing to the > > > problem? > > > > Any suggestions? > > > > The reason for the switch was that the DB includes a lot of financial > > > data, so the rounding errors that were resulting from using floats > > > were unfortunately material. If there's a better way to solve this > > > problem, I'm all ears. > > > > Thanks, > > > Philip
