How to upgrade from mid 2011

[danielf]

Steven,

Thanks for your response. I have sequentially applied all the sql changes from the change log, starting at 11.11.03, which is the first one up from my build that has any schema changes (I believe my build is 11.03.22). The first time I encountered some errors, but on later tries the only error I got was the sfo_row_height error wich is documented elsewhere. Apart from that, all sql changes go through without a hitch.

The outcome is always the same: The browse screen in messed up, the report builder is broken, and there is some access problem, in that some forms are only accessible to globeadmin (which they shouldn't). Details of the problems are in my thread here: http://forums.nubuilder.cloud/viewtopic.php?f=5&t=7810

I've also noticed that I am missing some tables compared to the list you posted the other day: zzsys_field and zzsys_sql_log, and I have image, style, and property_messed_up which aren't in your list.

I really don't see what I'm doing wrong. Unless, there is something special about update 11-12-20 which states that THE MENU ON FORMS NEEDS THE SQL BELOW TO BE ADDED!', whereas the other just state schema changes. Is this in some way different to the other schema changes?

Sorry if I sound daft. I'm just stumped.

Thanks,

Dan.

[admin]

Daniel,

Your problem is probably because of some missing styles.

If you run the following sql it will replace the existing zzsys_style and zzsys_style_property tables and it should sort out your problems.

BUT, you will need to recreate your color schemes.

Code: Select all

DROP TABLE IF EXISTS `zzsys_style`;
CREATE TABLE IF NOT EXISTS `zzsys_style` (
  `zzsys_style_id` varchar(15) NOT NULL DEFAULT '',
  `sst_class` varchar(255) DEFAULT NULL,
  `sst_description` mediumtext,
  `sst_custom` varchar(5) DEFAULT NULL,
  `sys_setup` varchar(1) NOT NULL,
  PRIMARY KEY (`zzsys_style_id`),
  KEY `sst_class` (`sst_class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `zzsys_style` (`zzsys_style_id`, `sst_class`, `sst_description`, `sst_custom`, `sys_setup`) VALUES
('145ff16a8c1f35', '.objects', 'Defaults for all objects', '0', '1'),
('145ff15a70adfc', '.calbutton', 'Calender button', '0', '1'),
('145fdf97c070f0', '.button', 'Setup tab buttons. (NOTE width is not adjustable)', '0', '1'),
('145ff19df280a6', '.actionButton', 'Action Buttons', '0', '1'),
('145ff1a84323b8', '.lookupdesc', 'Lookup Description Field', '0', '1'),
('145ff1c706facf', '.lookupcode', 'Lookup Code Field', '0', '1'),
('145ff200e6b053', '.tab', 'Tab font & background defaults', '0', '1'),
('145ff2d58c4bf2', '.unselected', 'Font & background settings for unselected non index pages', '0', '1'),
('145ff2dd1e09b5', '.selected', 'Font & background settings for selected non index pages', '0', '1'),
('14611a4cfee42a', '.subformobject', 'Custom Subform Style for changing the scrollbars', '0', '1'),
('145ff370b1fb81', '.searchcolor', 'Default Search Bar settings', '0', '1'),
('145ff3d9ed73b4', '.white', 'Special Sunken field', '0', '1'),
('145ff3e90ac1e6', '.readonly', 'Special read only field', '0', '1'),
('145ff3f33b982d', '.words', 'Special settings for Words', '0', '1'),
('1467095eb708c8', '.phpcodefields', 'Special assigned courier font for PHP code fields', '0', '1'),
('14a304a6e2e945', '#logo', 'Banner at top of Index page', '1', '1'),
('14c748b17004e5', '.browsematch', 'hightlights matching search strings in the browse screen.', '1', '1'),
('14ee0509986438', '.nuMenu ul li', '', '1', '1'),
('14ee8324a3527c', '.nuMenu', 'DIV surrounding Form Tabs', '1', '1'),
('14ef2b10c7d2dc', '.nuStatus', 'Status bar of Form', '1', '1'),
('14ef3ae93cb41f', '.nuAction', 'DIV surrounding Action Buttons', '1', '1'),
('14ef3bc342619f', '.nuForm', 'DIV surrounding Editable Objects', '1', '1'),
('14f011afcf056d', '.nuBrowse', 'DIV surrounding Browse rows', '1', '1'),
('14f022598ba89b', '.nuSearch', 'DIV surroundingSearch and Buttons', '1', '1'),
('14f035e836a52e', '.nuUnselectedRow', 'Unselected Rows on Browse Form', '1', '1'),
('14f037c6573fb2', '.nuSelectedRow', 'Selected Rows on Browse Form', '1', '1'),
('14f1ca2b37cecf', '.nuBreadCrumb', 'DIV surrounding Breadcrumb', '', '1'),
('14f31abc691ed4', '.test', 'Custom Subform Style for changing the scrollbars', '1', '');

DROP TABLE IF EXISTS `zzsys_style_property`;
CREATE TABLE IF NOT EXISTS `zzsys_style_property` (
  `zzsys_style_property_id` varchar(15) NOT NULL DEFAULT '',
  `ssp_property_name` varchar(255) DEFAULT NULL,
  `ssp_property_value` varchar(255) DEFAULT NULL,
  `ssp_zzsys_style_id` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`zzsys_style_property_id`),
  KEY `ssp_zzsys_style_id` (`ssp_zzsys_style_id`),
  KEY `ssp_property_name` (`ssp_property_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `zzsys_style_property` (`zzsys_style_property_id`, `ssp_property_name`, `ssp_property_value`, `ssp_zzsys_style_id`) VALUES
('145ff370b22e47', 'font-size', 'x-small', '145ff370b1fb81'),
('145ff370b22677', 'color', 'black', '145ff370b1fb81'),
('145ff370b21ea7', 'background-color', '#c7f086', '145ff370b1fb81'),
('145ff370b216d6', 'border-color', 'Gray', '145ff370b1fb81'),
('145ff370b20f07', 'border-width', '1px', '145ff370b1fb81'),
('145ff370b20737', 'border-style', 'solid', '145ff370b1fb81'),
('145ff368991382', 'font-family', 'tahoma', '145ff36898e7b6'),
('145ff3689907c9', 'font-size', 'x-small', '145ff36898e7b6'),
('145ff36898fffa', 'color', 'white', '145ff36898e7b6'),
('145ff36898f441', 'background-color', 'lightgrey', '145ff36898e7b6'),
('145ff2dd1e4591', 'text-align', 'center', '145ff2dd1e09b5'),
('145ff2dd1e3d86', 'vertical-align', 'top', '145ff2dd1e09b5'),
('145ff2dd1e2d7f', 'font-family', 'tahoma', '145ff2dd1e09b5'),
('145ff2dd1e2587', 'font-size', '10pt', '145ff2dd1e09b5'),
('145ff2dd1e1d8f', 'color', 'black', '145ff2dd1e09b5'),
('145ff2dd1e1597', 'background-color', '#9bcae1', '145ff2dd1e09b5'),
('145ff2d58c6f19', 'font-family', 'tahoma', '145ff2d58c4bf2'),
('145ff16a8c8738', 'font-weight', '500', '145ff16a8c1f35'),
('145ff177d056dc', 'font-weight', '500', '145ff15a70adfc'),
('145ff178a2eed8', 'font-weight', '500', '145fdf97c070f0'),
('145ff2d58c674a', 'font-size', 'small', '145ff2d58c4bf2'),
('145ff2d58c5f79', 'color', 'white', '145ff2d58c4bf2'),
('145ff2d58c57aa', 'background-color', '#0899e1', '145ff2d58c4bf2'),
('14611a4cff0b8b', 'border-width', '0', '14611a4cfee42a'),
('14611a4cff177f', 'border-color', 'Gray', '14611a4cfee42a'),
('14611a4d001107', 'font-weight', '500', '14611a4cfee42a'),
('14611a4cff2376', 'background-color', 'white', '14611a4cfee42a'),
('14611a4cff2f68', 'color', 'black', '14611a4cfee42a'),
('14611a4cff3b5e', 'font-size', '10pt', '14611a4cfee42a'),
('14611a4d000513', 'font-family', 'tahoma', '14611a4cfee42a'),
('14a2f4b0fd9ab7', 'margin-left', 'auto', '145ff2dd1e09b5'),
('145ff19df2f01e', 'font-weight', '500', '145ff19df280a6'),
('14a2f4b0fdaa4b', 'margin-right', 'auto', '145ff2dd1e09b5'),
('145ff1a8438f65', 'font-weight', '500', '145ff1a84323b8'),
('145ff200e6e852', 'margin', '0px', '145ff200e6b053'),
('145ff200e6d84d', 'font-family', 'tahoma', '145ff200e6b053'),
('145ff200e6d040', 'font-size', 'x-small', '145ff200e6b053'),
('145ff1c7074507', 'font-weight', '500', '145ff1c706facf'),
('145ff200e6c834', 'color', 'white', '145ff200e6b053'),
('145ff200e6c027', 'background-color', '#0899e1', '145ff200e6b053'),
('145ff1c7074cf9', 'margin', '1px', '145ff1c706facf'),
('145ff1c7073d37', 'text-align', 'left', '145ff1c706facf'),
('145ff200e6e045', 'font-weight', 'bold', '145ff200e6b053'),
('145ff1c7073567', 'font-family', 'tahoma', '145ff1c706facf'),
('14a304a6e30af7', 'cursor', 'pointer', '14a304a6e2e945'),
('145ff1c70725c8', 'color', '#212d0f', '145ff1c706facf'),
('145ff1c7071df9', 'background-color', '#c7f086', '145ff1c706facf'),
('145ff1c707162a', 'border-color', '#8ac82c', '145ff1c706facf'),
('145ff1c7070e59', 'border-width', '1px', '145ff1c706facf'),
('145ff1c7070687', 'border-style', 'solid', '145ff1c706facf'),
('145ff1a8439b5a', 'margin', '1px', '145ff1a84323b8'),
('145ff1c30a225c', 'text-align', 'left', '145ff1a84323b8'),
('145ff1a843777c', 'font-family', 'tahoma', '145ff1a84323b8'),
('14a304a0274895', 'cursor', 'pointer', '145ff200e6b053'),
('145ff1a8435f93', 'color', 'black', '145ff1a84323b8'),
('145ff1a843539e', 'background-color', '#70b7d9', '145ff1a84323b8'),
('145ff1a84347a9', 'border-color', '#4d7d94', '145ff1a84323b8'),
('145ff1a8433fb1', 'border-width', '1px', '145ff1a84323b8'),
('145ff1a84337b8', 'border-style', 'solid', '145ff1a84323b8'),
('145ff19df2e04c', 'font-family', 'tahoma', '145ff19df280a6'),
('145ff2d58c76e9', 'font-weight', '500', '145ff2d58c4bf2'),
('145ff19df2d456', 'font-size', '10pt', '145ff19df280a6'),
('145ff19df2c861', 'color', 'black', '145ff19df280a6'),
('145ff19df2bc6c', 'background-color', '#f9a53a', '145ff19df280a6'),
('145ff2dd1e3577', 'font-weight', '500', '145ff2dd1e09b5'),
('145ff19df2b078', 'border-color', 'c46e00', '145ff19df280a6'),
('145ff19df2a483', 'border-width', '1px', '145ff19df280a6'),
('145ff19df2988e', 'border-style', 'ridge', '145ff19df280a6'),
('145ff1993797e1', 'margin', '1px', '145ff16a8c1f35'),
('14611a4d001cfc', 'margin', '1', '14611a4cfee42a'),
('145ff368991b51', 'font-weight', 'bold', '145ff36898e7b6'),
('14611a4d0028f1', 'scrollbar-shadow-color', '#0183c7', '14611a4cfee42a'),
('14611a4d0034e5', 'scrollbar-highlight-color', '#60c9ff', '14611a4cfee42a'),
('14611a4d0040c5', 'scrollbar-face-color', '#0899e1', '14611a4cfee42a'),
('14611a4d004ca6', 'scrollbar-darkshadow-color', '#016aa1', '14611a4cfee42a'),
('145ff370b23de7', 'font-weight', '500', '145ff370b1fb81'),
('14611a4d005887', 'scrollbar-base-color', '#9bcae1', '14611a4cfee42a'),
('14611a4cfeff95', 'border-style', 'solid', '14611a4cfee42a'),
('145ff16a8c7748', 'font-family', 'tahoma', '145ff16a8c1f35'),
('145ff16a8c6f3b', 'font-size', '10pt', '145ff16a8c1f35'),
('145ff16a8c672f', 'color', 'black', '145ff16a8c1f35'),
('145ff16a8c5c89', 'background-color', 'white', '145ff16a8c1f35'),
('145ff16a8c4f31', 'border-color', '#7F9DB9', '145ff16a8c1f35'),
('145ff16a8c4327', 'border-width', '1px', '145ff16a8c1f35'),
('145ff16a8c3732', 'border-style', 'solid', '145ff16a8c1f35'),
('145ff3d9edb1c6', 'font-weight', '500', '145ff3d9ed73b4'),
('145ff15a711774', 'width', '20px', '145ff15a70adfc'),
('145ff15a710bbc', 'font-family', 'tahoma', '145ff15a70adfc'),
('145ff15a710004', 'font-size', 'small', '145ff15a70adfc'),
('145ff15a70f44c', 'color', 'black', '145ff15a70adfc'),
('145ff3e90b11d8', 'font-weight', '500', '145ff3e90ac1e6'),
('145ff15a70e894', 'background-color', 'FF9934', '145ff15a70adfc'),
('145ff15a70dcdc', 'border-color', 'lightgrey', '145ff15a70adfc'),
('145ff15a70d124', 'border-width', '0px', '145ff15a70adfc'),
('145ff3f3412ab6', 'font-weight', 'bold', '145ff3f33b982d'),
('145ff15a70c56c', 'border-style', 'solid', '145ff15a70adfc'),
('145ff15a70b9b4', 'height', '20px', '145ff15a70adfc'),
('145ff14ec4a2de', 'font-family', 'tahoma', '145fdf97c070f0'),
('145ff14ec4aad6', 'font-size', '10pt', '145fdf97c070f0'),
('145ff14ec4b2cf', 'color', 'black', '145fdf97c070f0'),
('145ff14ec4bac7', 'background-color', '#f9a53a', '145fdf97c070f0'),
('145ff14ed1f152', 'border-color', 'c46e00', '145fdf97c070f0'),
('1467095eb785c1', 'font-weight', '500', '1467095eb708c8'),
('145ff14ed1fdc7', 'border-width', '1px', '145fdf97c070f0'),
('145ff14ed20d65', 'border-style', 'ridge', '145fdf97c070f0'),
('145ff14ed23475', 'height', '25px', '145fdf97c070f0'),
('145ff370b23618', 'font-family', 'tahoma', '145ff370b1fb81'),
('145ff370b245b6', 'margin', '1px', '145ff370b1fb81'),
('14f3b2a48b817c', 'border-color', 'black', '14f011afcf056d'),
('145ff3d9ed8ab6', 'border-color', 'white', '145ff3d9ed73b4'),
('145ff3d9ed9287', 'background-color', 'white', '145ff3d9ed73b4'),
('145ff3d9ed9a56', 'color', 'white', '145ff3d9ed73b4'),
('145ff3d9eda226', 'font-size', 'x-small', '145ff3d9ed73b4'),
('145ff3d9eda9f6', 'font-family', 'tahoma', '145ff3d9ed73b4'),
('145ff3e90ad9a7', 'border-style', 'solid', '145ff3e90ac1e6'),
('145ff3e90ae19e', 'border-width', '1px', '145ff3e90ac1e6'),
('145ff3e90ae9ab', 'border-color', '#6a838f', '145ff3e90ac1e6'),
('145ff3e90af1b8', 'background-color', '#98bbcd', '145ff3e90ac1e6'),
('145ff3e90af9c5', 'color', 'black', '145ff3e90ac1e6'),
('145ff3e90b09c9', 'font-family', 'tahoma', '145ff3e90ac1e6'),
('145ff3e90b1dcd', 'margin', '0px', '145ff3e90ac1e6'),
('145ff3f3410787', 'color', 'black', '145ff3f33b982d'),
('145ff3f341133f', 'font-size', 'x-small', '145ff3f33b982d'),
('145ff3f3411ef7', 'font-family', 'tahoma', '145ff3f33b982d'),
('1467095eb72fd7', 'border-style', 'solid', '1467095eb708c8'),
('1467095eb73f76', 'border-width', '1px', '1467095eb708c8'),
('1467095eb74b2f', 'border-color', 'Gray', '1467095eb708c8'),
('1467095eb756e4', 'background-color', 'white', '1467095eb708c8'),
('1467095eb7629c', 'color', 'black', '1467095eb708c8'),
('1467095eb76e52', 'font-size', '10pt', '1467095eb708c8'),
('1467095eb77a0a', 'font-family', 'courier', '1467095eb708c8'),
('1467095eb79178', 'margin', '1px', '1467095eb708c8'),
('1473a30806c179', 'vertical-align', '-15%', '145ff15a70adfc'),
('14c748b1701eca', 'color', 'red', '14c748b17004e5'),
('14ee8331f6cde0', 'left', '12px', '14ee8324a3527c'),
('14ee8324a39a61', 'top', '70px', '14ee8324a3527c'),
('14ee82a0335754', 'height', '20px', '14ee0509986438'),
('14ee82a0333965', 'float', 'left', '14ee0509986438'),
('14ee82a0331eec', 'padding', '0px 15px 0px 15px', '14ee0509986438'),
('14ee050998b66f', 'font-size', '12px', '14ee0509986438'),
('14ee0509989b17', 'font-family', 'tahoma', '14ee0509986438'),
('14ef2b10c8228e', 'position', 'absolute', '14ef2b10c7d2dc'),
('14ef2b10c842c3', 'top', '600px', '14ef2b10c7d2dc'),
('14ef2b10c863d1', 'left', '12px', '14ef2b10c7d2dc'),
('14ef2b10c883cc', 'width', '968px', '14ef2b10c7d2dc'),
('14ef2b10c8a364', 'height', '20px', '14ef2b10c7d2dc'),
('14ef2b3cfc1a62', 'font-size', '10px', '14ef2b10c7d2dc'),
('14ef3e686663d9', 'color', 'white', '14ee0509986438'),
('14ef2b5092b7be', 'color', 'black', '14ef2b10c7d2dc'),
('14ef3ae93cfc19', 'top', '20px', '14ef3ae93cb41f'),
('14ef3ae93d1eba', 'left', '165px', '14ef3ae93cb41f'),
('14ef3ae93d408a', 'width', '660px', '14ef3ae93cb41f'),
('14ef3ae93d6334', 'height', '40px', '14ef3ae93cb41f'),
('14ef3aea5b3565', 'text-align', 'center', '14ef3ae93cb41f'),
('14ef3b17a61a8f', 'width', '968px', '14ee8324a3527c'),
('14ef3b2cc94867', 'height', '20px', '14ee8324a3527c'),
('14ef3b54560539', 'overflow', 'hidden', '14ee8324a3527c'),
('14ef3bc342a98b', 'top', '90px', '14ef3bc342619f'),
('14ef3bc342cb86', 'left', '12px', '14ef3bc342619f'),
('14ef3bc342ed60', 'width', '968px', '14ef3bc342619f'),
('14ef3bc3430ed9', 'height', '512px', '14ef3bc342619f'),
('14ef3bc3433098', 'border-style', 'none solid none solid', '14ef3bc342619f'),
('14ef3bc56ea24e', 'border-width', '2px', '14ef3bc342619f'),
('14ef3bddad919a', 'border-style', 'solid solid none solid', '14ee8324a3527c'),
('14ef3bdfe150ee', 'border-width', '2px', '14ee8324a3527c'),
('14ef3be5eaccc6', 'border-style', 'none solid solid solid', '14ef2b10c7d2dc'),
('14ef3be5eaeec2', 'border-width', '2px', '14ef2b10c7d2dc'),
('14ef3e55ab9b3e', 'padding', '4px 0px 0px 0px', '14ef2b10c7d2dc'),
('14ef3d5ceae101', 'border-color', 'black', '14ee8324a3527c'),
('14f035e837116c', 'font-family', 'tahoma', '14f035e836a52e'),
('14f036064f32cd', 'background-color', '#0899E1', '14f011afcf056d'),
('14f011afd00bb4', 'border-width', '2px', '14f011afcf056d'),
('14f035e83754ba', 'color', 'black', '14f035e836a52e'),
('14f0380be76186', 'border-style', 'solid', '14f011afcf056d'),
('14f037c657f6b5', 'font-size', '12px', '14f037c6573fb2'),
('14f037c657d47f', 'background-color', '#3963BD', '14f037c6573fb2'),
('14f037c657b155', 'color', 'white', '14f037c6573fb2'),
('14f037c6578cbd', 'font-family', 'tahoma', '14f037c6573fb2'),
('14f036382559bb', 'color', 'white', '14f011afcf056d'),
('14f035e837763a', 'background-color', '#9BCAE1', '14f035e836a52e'),
('14f013b1a0c1ef', 'width', '1000px', '14f011afcf056d'),
('14f011afd0a180', 'left', '10px', '14f011afcf056d'),
('14f011afd0c4ab', 'top', '70px', '14f011afcf056d'),
('14f013cc2b5a02', 'height', '600px', '14f011afcf056d'),
('14f01232115651', 'overflow', 'hidden', '14f011afcf056d'),
('14f035e8373329', 'font-size', '12px', '14f035e836a52e'),
('14f022598c352b', 'left', '220px', '14f022598ba89b'),
('14f022598c56e5', 'top', '22px', '14f022598ba89b'),
('14f0391e35ac25', 'font-family', 'tahoma', '14f011afcf056d'),
('14f03924fd80dc', 'font-size', '12px', '14f011afcf056d'),
('14f039a0a95ef5', 'family-font', 'tahoma', '14f022598ba89b'),
('14f1ca2b382c93', 'left', '11px', '14f1ca2b37cecf'),
('14f1ca2b383c2d', 'top', '54px', '14f1ca2b37cecf'),
('14f1ca2b384bd0', 'family-font', 'tahoma', '14f1ca2b37cecf'),
('14f1ca2f4307ac', 'font-size', '12px', '14f1ca2b37cecf'),
('14f1df0cd59e33', 'color', 'grey', '14f1ca2b37cecf'),
('14f31abc697c93', 'border-width', '0', '14f31abc691ed4'),
('14f31abc698c34', 'border-color', 'Gray', '14f31abc691ed4'),
('14f31abc699bd3', 'font-weight', '500', '14f31abc691ed4'),
('14f31abc69ab73', 'background-color', 'white', '14f31abc691ed4'),
('14f31abc69bb09', 'color', 'black', '14f31abc691ed4'),
('14f31abc69cab3', 'font-size', '10pt', '14f31abc691ed4'),
('14f31abc69da52', 'font-family', 'tahoma', '14f31abc691ed4'),
('14f31abc69e9f2', 'margin', '1', '14f31abc691ed4'),
('14f31abc69f994', 'scrollbar-shadow-color', '#0183c7', '14f31abc691ed4'),
('14f31abc6a0941', 'scrollbar-highlight-color', '#60c9ff', '14f31abc691ed4'),
('14f31abc6a18d3', 'scrollbar-face-color', '#0899e1', '14f31abc691ed4'),
('14f31abc6a2873', 'scrollbar-darkshadow-color', '#016aa1', '14f31abc691ed4'),
('14f31abc6a3813', 'scrollbar-base-color', '#9bcae1', '14f31abc691ed4'),
('14f31abc6a5764', 'border-style', 'solid', '14f31abc691ed4');

Steven

[admin]

Here are the new styles used..

[pickle_jimmy]

Hi All (again),

Just thought I'd go through the process I just used to upgrade a site to the new version of nuBuilder - in case it helps.

First, I copied the contents of the latest productionnu2 directory (the PHP part of nuBuilder) into my webroot.
(rename the old productionnu2 directory and then copy in the new one)

Then, I opened PHPMyAdmin and selected the database for the site I was upgrading.
This site isnt too old, so I went to the nubuilder.com site and started with the change log 11.11.03 (far enough back to be sure I had all the required changes)

I then ran the SQL (in PHPMyAdmin) for the schema changes from 11.11.03, 11.12.20, 11.12.29, 12.01.01, and 2.5
If an ALTER TABLE statement failed - it was because the schema already had the change, so I deleted the line in the sql and re-ran it.
I also changed the INSERT INTO to REPLACE INTO - this adds or updates where needed and doesn't error for duplicate keys

After this, the site looked awful, as the styles were broken, so I ran the SQL suggested by Steven a couple of posts ago regarding zzsys_style and zzsys_style_property tables. (Actually, I just dumped the two tables out of the latest sample database and used them to replace mine.)

This changed the colors on the site, but fixed all the positioning issues. I then just went back in and changed the colors back.

Hope this was some use.

Cheers

PJ

[danielf]

The second is that the SUM() function in reports is messed up. That is, reports work if I don't make any changes to them. But, if I go into the report builder for an existing report that uses the SUM() function, and I copy changes and run the report, it crashes with the following error:

SQL

SELECT SUM(ethnicity_count_Sum) as answerA FROM ___nu14f61ab5fab909___ WHERE ethnicity_name = "Black and Black British (Caribbean)"

Transaction

No Transaction.
Error

1054: Unknown column 'ethnicity_count_Sum' in 'field list'

There is no reference to SUM(ethnicity_count_SUM) anywhere in the report, just to SUM(ethnicity_count). SUM(ethnicity_count_SUM) is something generated by nubuilder, seemingly by the report builder as I can edit the basic PHP code with no problem. The problem arises when I go into and save changes in the report builder. I'm also getting this error when I try to create a new report with the SUM() function. Something's broken..

[danielf]

Okay, I've now noticed that the nufanancials site that ships with the windows installer for 2.5 suffers from the same problem with reports. I just ran the 'payments list' report which runs fine out of the box. Next, I went into the report builder, clicked copy changes (without actually making any changes) and saved the report. I then ran the report again and it crashed (see attachment). This looks like a bug to me. Presumably, reports are stored in compiled form and saving forces a recompile which fails on the sum() (and possibly percent() as well) function. The bug appears located in the report builder, as I can make changes to the PHP code and save these without any problem. It's also not possible to create new reports with the sum() function.

I've also poked into the access level issue a bit more. I've deleted all users, groups and access levels, and re-created them, and still have the same problem. Access denied for users other than globeadmin for a double click event on a subform.

[danielf]

Why the deafening silence please?

I first reported these two issues last Wednesday, and no one has even acknowledged the problems I'm having apart from the style issues. I have a client waiting for me to deploy this site, and at present I'm unable to deploy it under 2.5 as it's broken (and I'd really like to deploy it under 2.5 as 2.5 is so much better). I can only edit/create reports in the old build, and the access level problem I'm having breaks major functionality on the site. I'm more than happy to entertain the possibility that these problems are particular to my install and code, but the evidence doesn't suggest it is as the report builder problem affects the nufinancials site that ships with 2.5. Either way, I could really do with some help here. I can't string along the client for much longer. Please???

[danielf]

Panic over. Thank you Shane

[admin]

.