Upgrade from 2.7 to 2.7.1
Posted: Sat Jul 07, 2012 4:15 pm
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:
Can I sobstitute the starting 'z' character in the substr() function with another character?
Thanks.
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' Thanks.