Updating from 10.07.12 to latest

[JeffTaylor]

Hey guys, great to see so much activity here

I got very excited when I saw nuBuilder does not use new windows, and I think its time to jump on board and update my version!

Do i just go through https://www.nubuilder.net/change.php and make each change in sequence manually to upgrade? Is there anything else that I require to install to get that running?

Thanks,

Jeff

[admin]

Jeff,

Nice to hear from you!

You'll need to run the schema updates in order starting from your version.

It should be fine.

Steven

[JeffTaylor]

Thanks, i'll get that underway then, wish me luck!

[JeffTaylor]

Hmm,, went to do the changes as outlined on http://www.nubuilder.net/change.php but the changes do not seem to be complete...

When I went to complete the changes from 10.07.12 -> 10.09.03, ( https://www.nubuilder.net/change.php?ch ... e552432b2e ), I noticed 2 issues.

The first issue I can see is that there are 7 changes listed in the changes section, but the steps section only show 2 steps, and doesnt include the changes to create new JavaScript functions.

<edit... i didnt read properly, so only 1 issue >

You mentioned 'running schema updates'... is that different from going to this change log and following the steps listed?

Thanks,

Jeff

[JeffTaylor]

Hi, thought i'd give this a bump

The differences in changelog vs steps to move from 10.09.03 are listed as follows:

1-Object type "File" now available for uploading files/documents into fields of mysql type BLOB.

Code: Select all

1- The Form that is used to create Objects needs to be changed in the 'zzsys_form' table. <br>
The primary key for this row is 'object'<br>
You will need to manually edit the 'sfo_javascript' field using PHPmyAdmin. <br>
Remove the following javascript.<br>
(Otherwise file objects won't be allowed in Subforms)<br>
<pre>
			case 'file':
				returnCode = validateNotOnSubform('File',parentType);
			break;
</pre>

2-Browse screens will extend wider if width of columns become greater than the default width.

Missing

3-Browse screen text strings that match search criteria will be highlighted with the css class 'browsematch'.

Code for this listed below, but suspect its missing the SQL to actually use the new css class.

Code: Select all

2-Run this sql to create css class 'browsematch'..
INSERT INTO `zzsys_style` (`zzsys_style_id`, `sst_class`, `sst_description`, `sst_custom`) VALUES
('14c748b17004e5', '.browsematch', 'hightlights matching search strings in the browse screen.', '1');
INSERT INTO `zzsys_style_property` (`zzsys_style_property_id`, `ssp_property_name`, `ssp_property_value`, `ssp_zzsys_style_id`) VALUES
('14c748b1701eca', 'color', 'red', '14c748b17004e5');

Following are missing:

4-Hash Variables can now be used in the 'Default Filter for Browse Screen' property for button objects.

5-A new JavaScript function called nuGetRow() has been added to return the last subform row that had focus.

6-A new JavaScript function called nuGetRowId() - returns the Primary Key value for the Subform row with focus.

7-A new JavaScript function called nuGetRowObjectValue() - returns the Object (column) value for the Subform row with focus.

[admin]

Jeff,

I'm not sure what you are saying.

Steven

[JeffTaylor]

Hi Steve, I am saying that I am unable to begin updating my version (10.07.12) of nuBuilder to the current version because the change log for 10.09.03 (next version up) is incomplete. It lists 7 changes made, but only has 2 steps listed in the text box below.

i.e:
Change log (from https://www.nubuilder.net/change.php?ch ... e552432b2e ):
5-A new JavaScript function called nuGetRow() has been added to return the last subform row that had focus.

However:
The text box contains no instruction on how to insert nuGetRow() into the nuBuilder JavaScript files.

Therefore, I am wondering if i use the instructions provided on each change log to update my nubuilder, or is there something else I require?

[JeffTaylor]

Did some searching on the forum, and that this issue has been identified before:

post:
http://forums.nubuilder.cloud/viewtopic.p ... hema#p9232

quote from post:

Hi,
We put some schema changes on http://www.nubuilder.com/change.php?cha ... f91b77ee97

But they lose something being displayed on the html of the page.

So I've attached a file that contains them here..

update.zip
(2.56 KiB) Downloaded 21 times



I hope this is what you need to fix it.

Steven

[admin]

Jeff,

I can't honestly tell you what's going on with that changelog (its so long ago).

Wouldn't you just be better off downloading the latest version?

Steven