Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Missing 'sfo_row_height' field in the `zzsys_form` table

Locked
Fike
Posts: 79
Joined: Thu Oct 20, 2011 9:13 pm

Missing 'sfo_row_height' field in the `zzsys_form` table

Unread post by Fike »

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
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Missing 'sfo_row_height' field in the `zzsys_form` table

Unread post by admin »

Fike,

We did have a slight versioning problem at one point, this is probably what you have encountered.
But as you have done, these glitches can be fixed manually.

Sorry I can't be more exact about when this happened.

It may have been from a downloadable module. http://www.nubuilder.com/index.php?nav=modules
Currently these are older versions.

Attached is a list of all zzsys tables and their fields and indexes for nuBuilder 2.5

Steven
You do not have the required permissions to view the files attached to this post.
Fike
Posts: 79
Joined: Thu Oct 20, 2011 9:13 pm

Re: Missing 'sfo_row_height' field in the `zzsys_form` table

Unread post by Fike »

Thanks a lot for the information Steven!

I have checked my tables and they do have all the fields listed in your attached file. So I guess I have nothing to worry about.

Kind regards,

Fike
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Missing 'sfo_row_height' field in the `zzsys_form` table

Unread post by admin »

.
Locked