In DB Manager changing field type from String (or other) to Reference just changes to Integer instead

Wappler General Bugs
#1

Wappler Version : 4.4.5
Operating System : Win10
Server Model: NodeJS
Database Type: SQLite local
Hosting Type: Local self host

How to reproduce

  1. Create a string field (or any other type)
  2. Go to field Properties and change Type to Reference. Set table and field.
  3. Click “Apply Database Changes”.
  4. Back to the field to see that the type is Integer now.
Wappler 4.8.3 Released
#2

Could you also post the change file that got generated? Did it execute successfully? Did you change just one field?

Also note that changing fields type to completely different one might result in loosing data as there is no conversion involved so it is up to the database what it does with it.

#3

Before changes was applied.

image
image347×627 10.7 KB

After it was applied.
image
image350×623 11.6 KB

image
image846×328 18.6 KB

Seems like it.
image

Yes

Understood. To be clear, I am not planning to use this option myself.
I just trying DB Manager for the first time, so testing different things and reporting all unusual and potentially troublesome issues. :slight_smile:

#4
#5
#6

This has been fixed in Wappler 4.8.3

1 Like
#7
#8

This topic was automatically closed after 2 days. New replies are no longer allowed.