Upgrade from 2.7 to 2.7.1

[massiws]

Running the SQL in the change log explained in this page http://www.nubuilder.com/change.php?cha ... 188601ebed I found an error on the last SQL sentence:

Code: Select all

INSERT INTO zzsys_access_level_form
SELECT concat( 'z', substr( zzsys_access_level_object_id, 2 ) ) AS zzsys_access_level_form_id, sao_zzsys_access_level_id AS saf_zzsys_access_level_id, sob_button_zzsys_form_id AS saf_zzsys_form_id, '' AS saf_add_button, '' AS saf_save_button, '' AS saf_delete_button, '' AS saf_clone_button, '' AS saf_close_button, '' AS saf_print_button
FROM zzsys_object
INNER JOIN zzsys_access_level_object ON zzsys_object_id = sao_zzsys_object_id
WHERE sob_zzsys_form_id = 'index'
AND sob_all_type = 'button';

#1062 - Duplicate entry 'z4fdd311ecc678' for key 'PRIMARY' 

Can I sobstitute the starting 'z' character in the substr() function with another character?

Thanks.

[admin]

massiws,

Yes you can.

BTW how many users do you have?

Steven

[massiws]

steven,

I'm developing. End users should be about ten.

Thanks.

[admin]

massiws,

Just make sure each access level has all the forms they need allowed.

http://wiki.nubuilder.com/tiki-index.ph ... #Forms_Tab

Steven

[massiws]

Ok, solved truncating table zzsys_access_level_form and adding new items in Access level > Forms.

Thanks.

[admin]

massiws,

There is a bug in the way the buttons may not get hidden, that is fixed by replacing this file..

common.zip

Steven