Hello everyone,
I have a problem with my database when I change from my local server to my live server and click to apply latest database changes, it gives the below message.
I therefore changed the field it refers to so that the max characters is 60 but it still gives the same error.
Could you please help? All my fields are set to 255 as this is the default setting when a field is created I think.
I am using nodeJS and mySQLite database.
Thanks in advance,
Leo
If you want max 255 characters you should probably use a character (string) type and not decimal (number) type.
Hi Patrick,
Yeah I have since reverted back to using a string but the live database isn’t getting past the changes file from when I converted it to a decimal - and now my change files don’t match my development server.
Do you know if I am best to wipe my live server database and just start it fresh from where my development server database is now?
Thanks,
Leo
