Missing 'sfo_row_height' field in the `zzsys_form` table
Posted: Sun Mar 04, 2012 6:27 am
I have just upgraded my nuBuilder database to version 2.5 and the changes are great! Thanks a lot for improving this great tool!
I had a small problem in the upgrading process. When I tried to apply the Schema Changes to upgrade my database from version 11.12.29 to version 12.01.09, I got an error message saying that the line ALTER TABLE `zzsys_form` CHANGE `sfo_row_height` `sfo_row_height` INT NOT NULL could not be excecuted because the `sfo_row_height` field was unknown in the `zzsys_form` table.
I just created that field in the `zzsys_form` table and applied again the Schema Changes (succesfully this time). Then I upgraded the database to version 2.5 and everything is working great so far!
However, I would like to know whether there is missing a line in the Schema Changes posted in the web page of version 12.01.09, in order to insert the 'sfo_row_height' field in the `zzsys_form` table before the line ALTER TABLE `zzsys_form` CHANGE `sfo_row_height` `sfo_row_height` INT NOT NULL is executed.
If this is not the case, that means I did something wrong when I upgraded my database to version 11.12.29 because that field (and maybe some other fields) should have been there in the database of this version.
I just want to make sure that the recently upgraded database (version 2.5) has all the required Schema Changes to work correctly and be upgraded to the next version.
Fike
I had a small problem in the upgrading process. When I tried to apply the Schema Changes to upgrade my database from version 11.12.29 to version 12.01.09, I got an error message saying that the line ALTER TABLE `zzsys_form` CHANGE `sfo_row_height` `sfo_row_height` INT NOT NULL could not be excecuted because the `sfo_row_height` field was unknown in the `zzsys_form` table.
I just created that field in the `zzsys_form` table and applied again the Schema Changes (succesfully this time). Then I upgraded the database to version 2.5 and everything is working great so far!
However, I would like to know whether there is missing a line in the Schema Changes posted in the web page of version 12.01.09, in order to insert the 'sfo_row_height' field in the `zzsys_form` table before the line ALTER TABLE `zzsys_form` CHANGE `sfo_row_height` `sfo_row_height` INT NOT NULL is executed.
If this is not the case, that means I did something wrong when I upgraded my database to version 11.12.29 because that field (and maybe some other fields) should have been there in the database of this version.
I just want to make sure that the recently upgraded database (version 2.5) has all the required Schema Changes to work correctly and be upgraded to the next version.
Fike