Upgrade to version 2.6

[Fike]

Hi,

I saw the video that show the major enhancement for 2.6 version of nuBuilder and I found it so great that I couldn't way to try it. Congratulations to all the nuBuilder team for such a great enhancement!

I have run the schema changes to upgrade from version 2.5 to 2.6 and now I am able to see the changes made to the "Subform" tab.

However, when I selected a Form in the "Browse in subform" drop down field of my subform, the main form didn't show the browse form inside the subform. It only showed a blank subform.

I guess I need to update the php files of my productionnu2 folder in order to complete the upgrade process, so I am trying to download the 2.6 version of nuBuilder, but the download links point to nuBuilder 12.02.15.zip (the 2.5 version).

Will there be a downloadable package with the 2.6 version (containing the new php files of the productionnu2 folder) or it should run fine with the php files of the 2.5 version (applying only the schema changes for the 2.6 version to my database)?

Kind regrads,


Fike

[Fike]

I just replaced 2.5 for 2.6 and 12.02.15 for 12.05.17 in the download link and I was able to download the package of the 2.6 version.

I replaced the php files of he productionnu2 folder and everything is working great so far!

Congratulations again for this great imporvement!

Fike

[johan]

Hi,

I tried to upgrade to 2.6.

When I run the schema changes I get an error

#1062 - Duplicate entry '14f3852d29db17' for key 'PRIMARY'

Any idea how to solve this?

Johan

[Fike]

In the first line of the Shcema Changes, I just replaced the words "Insert into " for "Replace Into" and that did it.

Befor trying it, backup your data base (in case somethign goes wrong), and make sure you have the "sfo_rows" column in the "zzsys_form" table and the "sys_setup" column in the "zzsys_list" table.

I didn't have those columns in my database and therefore I got some errors before upgarding succesfully.

Regards,

Fike

[johan]

Fike,

Thanks for your reply but after changing insert in replace I have other errors.

these items already exists :

ALTER TABLE `zzsys_setup` ADD `set_box_net` VARCHAR(255) NOT NULL, ADD `set_box_net_key` VARCHAR(255) NOT NULL, ADD `set_box_net_token` VARCHAR(255) NOT NULL;

ALTER TABLE `zzsys_form` ADD `sys_box_net` VARCHAR(255) NOT NULL;

Can I just delete this part?

here

ALTER TABLE `zzsys_list` CHANGE `sys_setup` `sys_setup` VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

column doesn't exist. I've added it.

Johan

[Fike]

Johan,

I guess that if the columns `set_box_net`, `set_box_net_key`, `set_box_net_token`, and `sys_box_net` already exist in your 'zzsys_setup' and 'zzsys_form' tables, it would be better to delete those columns in your database (in case they are empty) and then execute the Schema Changes incluiding the lines:

ALTER TABLE `zzsys_setup` ADD `set_box_net` VARCHAR(255) NOT NULL, ADD `set_box_net_key` VARCHAR(255) NOT NULL, ADD `set_box_net_token` VARCHAR(255) NOT NULL;

ALTER TABLE `zzsys_form` ADD `sys_box_net` VARCHAR(255) NOT NULL;


If you are not using box.net right now in your database, it should not be a problem to delete those columns. Anyway I would backup the database before trying it.

Good luck!

Fike

[johan]

Fike,

Works fine now thanks.

Johan

[admin]

.