upgrade enterprise 10.4 => 10.5 error

C

christensen.ken@gmail.com

Member
PHP Version: 7.4.11

mysql version: 8.0.22

Web server: Apache/2.4.46 (Win64) OpenSSL/1.1.1g PHP/7.4.11

Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36

URL installation: http://vanadium.periodic-tbl.com/inventory/



Successfully upgraded 3 out of 4 apps. The fourth gave this error in up2.php:

[08] Error: during query execution. ALTER TABLE `dadabik_permissions` ADD CONSTRAINT unique_permission UNIQUE (id_subject,object_type_permission,object_permission,id_permission_type)
The DBMS server said: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-table-containers-1' for key 'dadabik_permissions.unique_permission'

I re-ran ugrade process resulting in the same error.

I ran the following query and can see lots of duplicates in the results, but I don't know what to do about them.

[pre]
select id_subject,object_type_permission,object_permission,id_permission_type
from dadabik_permissions
order by 1,2,3,4;
[/pre]

Sorry about the volume of data, but I can't find a way to attach a file.

[pre]
id_subject,object_type_permission,object_permission,id_permission_type
1,custom_page,1,13
1,custom_page,2,13
1,field,build_containers.build_containers_id,7
1,field,build_containers.build_containers_id,8
1,field,build_containers.build_containers_id,9
1,field,build_containers.build_containers_id,10
1,field,build_containers.build_containers_id,11
1,field,build_containers.build_containers_id,12
1,field,build_containers.build_containers_id,15
1,field,build_containers.container_prefix,7
1,field,build_containers.container_prefix,8
1,field,build_containers.container_prefix,9
1,field,build_containers.container_prefix,10
1,field,build_containers.container_prefix,11
1,field,build_containers.container_prefix,12
1,field,build_containers.container_prefix,15
1,field,build_containers.number_of_containers,7
1,field,build_containers.number_of_containers,8
1,field,build_containers.number_of_containers,9
1,field,build_containers.number_of_containers,10
1,field,build_containers.number_of_containers,11
1,field,build_containers.number_of_containers,12
1,field,build_containers.number_of_containers,15
1,field,build_shelving_units.bin_prefix,7
1,field,build_shelving_units.bin_prefix,8
1,field,build_shelving_units.bin_prefix,9
1,field,build_shelving_units.bin_prefix,10
1,field,build_shelving_units.bin_prefix,11
1,field,build_shelving_units.bin_prefix,12
1,field,build_shelving_units.bin_prefix,15
1,field,build_shelving_units.build_shelving_units_id,7
1,field,build_shelving_units.build_shelving_units_id,8
1,field,build_shelving_units.build_shelving_units_id,9
1,field,build_shelving_units.build_shelving_units_id,10
1,field,build_shelving_units.build_shelving_units_id,11
1,field,build_shelving_units.build_shelving_units_id,12
1,field,build_shelving_units.build_shelving_units_id,15
1,field,build_shelving_units.new_shelving_unit_name,7
1,field,build_shelving_units.new_shelving_unit_name,8
1,field,build_shelving_units.new_shelving_unit_name,9
1,field,build_shelving_units.new_shelving_unit_name,10
1,field,build_shelving_units.new_shelving_unit_name,11
1,field,build_shelving_units.new_shelving_unit_name,12
1,field,build_shelving_units.new_shelving_unit_name,15
1,field,build_shelving_units.number_of_shelves,7
1,field,build_shelving_units.number_of_shelves,8
1,field,build_shelving_units.number_of_shelves,9
1,field,build_shelving_units.number_of_shelves,10
1,field,build_shelving_units.number_of_shelves,11
1,field,build_shelving_units.number_of_shelves,12
1,field,build_shelving_units.number_of_shelves,15
1,field,build_shelving_units.rooms_rooms_id,7
1,field,build_shelving_units.rooms_rooms_id,8
1,field,build_shelving_units.rooms_rooms_id,9
1,field,build_shelving_units.rooms_rooms_id,10
1,field,build_shelving_units.rooms_rooms_id,11
1,field,build_shelving_units.rooms_rooms_id,12
1,field,build_shelving_units.rooms_rooms_id,15
1,field,build_shelving_units.storage_areas_storage_areas_id,7
1,field,build_shelving_units.storage_areas_storage_areas_id,8
1,field,build_shelving_units.storage_areas_storage_areas_id,9
1,field,build_shelving_units.storage_areas_storage_areas_id,10
1,field,build_shelving_units.storage_areas_storage_areas_id,11
1,field,build_shelving_units.storage_areas_storage_areas_id,12
1,field,build_shelving_units.storage_areas_storage_areas_id,15
1,field,containers.build_container_id,7
1,field,containers.build_container_id,8
1,field,containers.build_container_id,9
1,field,containers.build_container_id,10
1,field,containers.build_container_id,11
1,field,containers.build_container_id,12
1,field,containers.build_container_id,15
1,field,containers.containers_id,7
1,field,containers.containers_id,7
1,field,containers.containers_id,8
1,field,containers.containers_id,8
1,field,containers.containers_id,9
1,field,containers.containers_id,9
1,field,containers.containers_id,10
1,field,containers.containers_id,10
1,field,containers.containers_id,11
1,field,containers.containers_id,11
1,field,containers.containers_id,12
1,field,containers.containers_id,12
1,field,containers.containers_id,15
1,field,containers.containers_id,15
1,field,containers.contents_contents_id,7
1,field,containers.contents_contents_id,7
1,field,containers.contents_contents_id,8
1,field,containers.contents_contents_id,8
1,field,containers.contents_contents_id,9
1,field,containers.contents_contents_id,9
1,field,containers.contents_contents_id,10
1,field,containers.contents_contents_id,10
1,field,containers.contents_contents_id,11
1,field,containers.contents_contents_id,11
1,field,containers.contents_contents_id,12
1,field,containers.contents_contents_id,12
1,field,containers.contents_contents_id,15
1,field,containers.contents_contents_id,15
1,field,containers.lname,7
1,field,containers.lname,8
1,field,containers.lname,9
1,field,containers.lname,10
1,field,containers.lname,11
1,field,containers.lname,12
1,field,containers.lname,15
1,field,containers.name,7
1,field,containers.name,7
1,field,containers.name,8
1,field,containers.name,8
1,field,containers.name,9
1,field,containers.name,9
1,field,containers.name,10
1,field,containers.name,10
1,field,containers.name,11
1,field,containers.name,11
1,field,containers.name,12
1,field,containers.name,12
1,field,containers.name,15
1,field,containers.name,15
1,field,containers.parent_location,7
1,field,containers.parent_location,8
1,field,containers.parent_location,9
1,field,containers.parent_location,10
1,field,containers.parent_location,11
1,field,containers.parent_location,12
1,field,containers.parent_location,15
1,field,containers.shelves_shelves_id,7
1,field,containers.shelves_shelves_id,7
1,field,containers.shelves_shelves_id,8
1,field,containers.shelves_shelves_id,8
1,field,containers.shelves_shelves_id,9
1,field,containers.shelves_shelves_id,9
1,field,containers.shelves_shelves_id,10
1,field,containers.shelves_shelves_id,10
1,field,containers.shelves_shelves_id,11
1,field,containers.shelves_shelves_id,11
1,field,containers.shelves_shelves_id,12
1,field,containers.shelves_shelves_id,12
1,field,containers.shelves_shelves_id,15
1,field,containers.shelves_shelves_id,15
1,field,containers.shelves_shelving_units_shelving_units_id,7
1,field,containers.shelves_shelving_units_shelving_units_id,7
1,field,containers.shelves_shelving_units_shelving_units_id,8
1,field,containers.shelves_shelving_units_shelving_units_id,8
1,field,containers.shelves_shelving_units_shelving_units_id,9
1,field,containers.shelves_shelving_units_shelving_units_id,9
1,field,containers.shelves_shelving_units_shelving_units_id,10
1,field,containers.shelves_shelving_units_shelving_units_id,10
1,field,containers.shelves_shelving_units_shelving_units_id,11
1,field,containers.shelves_shelving_units_shelving_units_id,11
1,field,containers.shelves_shelving_units_shelving_units_id,12
1,field,containers.shelves_shelving_units_shelving_units_id,12
1,field,containers.shelves_shelving_units_shelving_units_id,15
1,field,containers.shelves_shelving_units_shelving_units_id,15
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,7
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,7
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,8
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,8
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,9
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,9
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,10
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,10
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,11
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,11
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,12
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,12
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,15
1,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,15
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,7
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,7
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,8
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,8
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,9
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,9
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,10
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,10
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,11
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,11
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,12
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,12
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,15
1,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,15
1,field,containers.status,7
1,field,containers.status,8
1,field,containers.status,9
1,field,containers.status,10
1,field,containers.status,11
1,field,containers.status,12
1,field,containers.status,15
1,field,contents.containers_containers_id,7
1,field,contents.containers_containers_id,8
1,field,contents.containers_containers_id,9
1,field,contents.containers_containers_id,10
1,field,contents.containers_containers_id,11
1,field,contents.containers_containers_id,12
1,field,contents.containers_containers_id,15
1,field,contents.contents_id,7
1,field,contents.contents_id,7
1,field,contents.contents_id,8
1,field,contents.contents_id,8
1,field,contents.contents_id,9
1,field,contents.contents_id,9
1,field,contents.contents_id,10
1,field,contents.contents_id,10
1,field,contents.contents_id,11
1,field,contents.contents_id,11
1,field,contents.contents_id,12
1,field,contents.contents_id,12
1,field,contents.contents_id,15
1,field,contents.contents_id,15
1,field,contents.descr,7
1,field,contents.descr,7
1,field,contents.descr,8
1,field,contents.descr,8
1,field,contents.descr,9
1,field,contents.descr,9
1,field,contents.descr,10
1,field,contents.descr,10
1,field,contents.descr,11
1,field,contents.descr,11
1,field,contents.descr,12
1,field,contents.descr,12
1,field,contents.descr,15
1,field,contents.descr,15
1,field,contents.lname,7
1,field,contents.lname,8
1,field,contents.lname,9
1,field,contents.lname,10
1,field,contents.lname,11
1,field,contents.lname,12
1,field,contents.lname,15
1,field,contents.parent_location,7
1,field,contents.parent_location,8
1,field,contents.parent_location,9
1,field,contents.parent_location,10
1,field,contents.parent_location,11
1,field,contents.parent_location,12
1,field,contents.parent_location,15
1,field,contents.picture,7
1,field,contents.picture,7
1,field,contents.picture,8
1,field,contents.picture,8
1,field,contents.picture,9
1,field,contents.picture,9
1,field,contents.picture,10
1,field,contents.picture,10
1,field,contents.picture,11
1,field,contents.picture,11
1,field,contents.picture,12
1,field,contents.picture,12
1,field,contents.picture,15
1,field,contents.picture,15
1,field,dadabik_groups.id_group,7
1,field,dadabik_groups.id_group,7
1,field,dadabik_groups.id_group,8
1,field,dadabik_groups.id_group,8
1,field,dadabik_groups.id_group,9
1,field,dadabik_groups.id_group,9
1,field,dadabik_groups.id_group,10
1,field,dadabik_groups.id_group,10
1,field,dadabik_groups.id_group,11
1,field,dadabik_groups.id_group,11
1,field,dadabik_groups.id_group,12
1,field,dadabik_groups.id_group,12
1,field,dadabik_groups.id_group,15
1,field,dadabik_groups.id_group,15
1,field,dadabik_groups.name_group,7
1,field,dadabik_groups.name_group,7
1,field,dadabik_groups.name_group,8
1,field,dadabik_groups.name_group,8
1,field,dadabik_groups.name_group,9
1,field,dadabik_groups.name_group,9
1,field,dadabik_groups.name_group,10
1,field,dadabik_groups.name_group,10
1,field,dadabik_groups.name_group,11
1,field,dadabik_groups.name_group,11
1,field,dadabik_groups.name_group,12
1,field,dadabik_groups.name_group,12
1,field,dadabik_groups.name_group,15
1,field,dadabik_groups.name_group,15
1,field,dadabik_users.authentication_type_user,7
1,field,dadabik_users.authentication_type_user,7
1,field,dadabik_users.authentication_type_user,8
1,field,dadabik_users.authentication_type_user,8
1,field,dadabik_users.authentication_type_user,9
1,field,dadabik_users.authentication_type_user,9
1,field,dadabik_users.authentication_type_user,10
1,field,dadabik_users.authentication_type_user,10
1,field,dadabik_users.authentication_type_user,11
1,field,dadabik_users.authentication_type_user,11
1,field,dadabik_users.authentication_type_user,12
1,field,dadabik_users.authentication_type_user,12
1,field,dadabik_users.authentication_type_user,15
1,field,dadabik_users.authentication_type_user,15
1,field,dadabik_users.email_user,7
1,field,dadabik_users.email_user,7
1,field,dadabik_users.email_user,8
1,field,dadabik_users.email_user,8
1,field,dadabik_users.email_user,9
1,field,dadabik_users.email_user,9
1,field,dadabik_users.email_user,10
1,field,dadabik_users.email_user,10
1,field,dadabik_users.email_user,11
1,field,dadabik_users.email_user,11
1,field,dadabik_users.email_user,12
1,field,dadabik_users.email_user,12
1,field,dadabik_users.email_user,15
1,field,dadabik_users.email_user,15
1,field,dadabik_users.first_name_user,7
1,field,dadabik_users.first_name_user,7
1,field,dadabik_users.first_name_user,8
1,field,dadabik_users.first_name_user,8
1,field,dadabik_users.first_name_user,9
1,field,dadabik_users.first_name_user,9
1,field,dadabik_users.first_name_user,10
1,field,dadabik_users.first_name_user,10
1,field,dadabik_users.first_name_user,11
1,field,dadabik_users.first_name_user,11
1,field,dadabik_users.first_name_user,12
1,field,dadabik_users.first_name_user,12
1,field,dadabik_users.first_name_user,15
1,field,dadabik_users.first_name_user,15
1,field,dadabik_users.id_group,7
1,field,dadabik_users.id_group,7
1,field,dadabik_users.id_group,8
1,field,dadabik_users.id_group,8
1,field,dadabik_users.id_group,9
1,field,dadabik_users.id_group,9
1,field,dadabik_users.id_group,10
1,field,dadabik_users.id_group,10
1,field,dadabik_users.id_group,11
1,field,dadabik_users.id_group,11
1,field,dadabik_users.id_group,12
1,field,dadabik_users.id_group,12
1,field,dadabik_users.id_group,15
1,field,dadabik_users.id_group,15
1,field,dadabik_users.id_user,7
1,field,dadabik_users.id_user,7
1,field,dadabik_users.id_user,8
1,field,dadabik_users.id_user,8
1,field,dadabik_users.id_user,9
1,field,dadabik_users.id_user,9
1,field,dadabik_users.id_user,10
1,field,dadabik_users.id_user,10
1,field,dadabik_users.id_user,11
1,field,dadabik_users.id_user,11
1,field,dadabik_users.id_user,12
1,field,dadabik_users.id_user,12
1,field,dadabik_users.id_user,15
1,field,dadabik_users.id_user,15
1,field,dadabik_users.last_name_user,7
1,field,dadabik_users.last_name_user,7
1,field,dadabik_users.last_name_user,8
1,field,dadabik_users.last_name_user,8
1,field,dadabik_users.last_name_user,9
1,field,dadabik_users.last_name_user,9
1,field,dadabik_users.last_name_user,10
1,field,dadabik_users.last_name_user,10
1,field,dadabik_users.last_name_user,11
1,field,dadabik_users.last_name_user,11
1,field,dadabik_users.last_name_user,12
1,field,dadabik_users.last_name_user,12
1,field,dadabik_users.last_name_user,15
1,field,dadabik_users.last_name_user,15
1,field,dadabik_users.password_user,7
1,field,dadabik_users.password_user,7
1,field,dadabik_users.password_user,8
1,field,dadabik_users.password_user,8
1,field,dadabik_users.password_user,9
1,field,dadabik_users.password_user,9
1,field,dadabik_users.password_user,10
1,field,dadabik_users.password_user,10
1,field,dadabik_users.password_user,11
1,field,dadabik_users.password_user,11
1,field,dadabik_users.password_user,12
1,field,dadabik_users.password_user,12
1,field,dadabik_users.password_user,15
1,field,dadabik_users.password_user,15
1,field,dadabik_users.username_user,7
1,field,dadabik_users.username_user,7
1,field,dadabik_users.username_user,8
1,field,dadabik_users.username_user,8
1,field,dadabik_users.username_user,9
1,field,dadabik_users.username_user,9
1,field,dadabik_users.username_user,10
1,field,dadabik_users.username_user,10
1,field,dadabik_users.username_user,11
1,field,dadabik_users.username_user,11
1,field,dadabik_users.username_user,12
1,field,dadabik_users.username_user,12
1,field,dadabik_users.username_user,15
1,field,dadabik_users.username_user,15
1,field,inventory_details.container,7
1,field,inventory_details.container,8
1,field,inventory_details.container,9
1,field,inventory_details.container,10
1,field,inventory_details.container,11
1,field,inventory_details.container,12
1,field,inventory_details.container,15
1,field,inventory_details.containers_id,7
1,field,inventory_details.containers_id,8
1,field,inventory_details.containers_id,9
1,field,inventory_details.containers_id,10
1,field,inventory_details.containers_id,11
1,field,inventory_details.containers_id,12
1,field,inventory_details.containers_id,15
1,field,inventory_details.contents,7
1,field,inventory_details.contents,8
1,field,inventory_details.contents,9
1,field,inventory_details.contents,10
1,field,inventory_details.contents,11
1,field,inventory_details.contents,12
1,field,inventory_details.contents,15
1,field,inventory_details.contents_id,7
1,field,inventory_details.contents_id,8
1,field,inventory_details.contents_id,9
1,field,inventory_details.contents_id,10
1,field,inventory_details.contents_id,11
1,field,inventory_details.contents_id,12
1,field,inventory_details.contents_id,15
1,field,inventory_details.inventory_details_id,7
1,field,inventory_details.inventory_details_id,8
1,field,inventory_details.inventory_details_id,9
1,field,inventory_details.inventory_details_id,10
1,field,inventory_details.inventory_details_id,11
1,field,inventory_details.inventory_details_id,12
1,field,inventory_details.inventory_details_id,15
1,field,inventory_details.location,7
1,field,inventory_details.location,8
1,field,inventory_details.location,9
1,field,inventory_details.location,10
1,field,inventory_details.location,11
1,field,inventory_details.location,12
1,field,inventory_details.location,15
1,field,inventory_details.picture,7
1,field,inventory_details.picture,8
1,field,inventory_details.picture,9
1,field,inventory_details.picture,10
1,field,inventory_details.picture,11
1,field,inventory_details.picture,12
1,field,inventory_details.picture,15
1,field,inventory_details.room,7
1,field,inventory_details.room,8
1,field,inventory_details.room,9
1,field,inventory_details.room,10
1,field,inventory_details.room,11
1,field,inventory_details.room,12
1,field,inventory_details.room,15
1,field,inventory_details.shelf,7
1,field,inventory_details.shelf,8
1,field,inventory_details.shelf,9
1,field,inventory_details.shelf,10
1,field,inventory_details.shelf,11
1,field,inventory_details.shelf,12
1,field,inventory_details.shelf,15
1,field,inventory_details.shelves_shelves_id,7
1,field,inventory_details.shelves_shelves_id,8
1,field,inventory_details.shelves_shelves_id,9
1,field,inventory_details.shelves_shelves_id,10
1,field,inventory_details.shelves_shelves_id,11
1,field,inventory_details.shelves_shelves_id,12
1,field,inventory_details.shelves_shelves_id,15
1,field,inventory_details.shelves_shelving_units_shelving_units_id,7
1,field,inventory_details.shelves_shelving_units_shelving_units_id,8
1,field,inventory_details.shelves_shelving_units_shelving_units_id,9
1,field,inventory_details.shelves_shelving_units_shelving_units_id,10
1,field,inventory_details.shelves_shelving_units_shelving_units_id,11
1,field,inventory_details.shelves_shelving_units_shelving_units_id,12
1,field,inventory_details.shelves_shelving_units_shelving_units_id,15
1,field,inventory_details.shelves_shelving_units_storage_areas_rooms_rooms_id,7
1,field,inventory_details.shelves_shelving_units_storage_areas_rooms_rooms_id,8
1,field,inventory_details.shelves_shelving_units_storage_areas_rooms_rooms_id,9
1,field,inventory_details.shelves_shelving_units_storage_areas_rooms_rooms_id,10
1,field,inventory_details.shelves_shelving_units_storage_areas_rooms_rooms_id,11
1,field,inventory_details.shelves_shelving_units_storage_areas_rooms_rooms_id,12
1,field,inventory_details.shelves_shelving_units_storage_areas_rooms_rooms_id,15
1,field,inventory_details.shelving_unit,7
1,field,inventory_details.shelving_unit,8
1,field,inventory_details.shelving_unit,9
1,field,inventory_details.shelving_unit,10
1,field,inventory_details.shelving_unit,11
1,field,inventory_details.shelving_unit,12
1,field,inventory_details.shelving_unit,15
1,field,inventory_details.storage_area,7
1,field,inventory_details.storage_area,8
1,field,inventory_details.storage_area,9
1,field,inventory_details.storage_area,10
1,field,inventory_details.storage_area,11
1,field,inventory_details.storage_area,12
1,field,inventory_details.storage_area,15
1,field,rooms.name,7
1,field,rooms.name,7
1,field,rooms.name,8
1,field,rooms.name,8
1,field,rooms.name,9
1,field,rooms.name,9
1,field,rooms.name,10
1,field,rooms.name,10
1,field,rooms.name,11
1,field,rooms.name,11
1,field,rooms.name,12
1,field,rooms.name,12
1,field,rooms.name,15
1,field,rooms.name,15
1,field,rooms.rooms_id,7
1,field,rooms.rooms_id,7
1,field,rooms.rooms_id,8
1,field,rooms.rooms_id,8
1,field,rooms.rooms_id,9
1,field,rooms.rooms_id,9
1,field,rooms.rooms_id,10
1,field,rooms.rooms_id,10
1,field,rooms.rooms_id,11
1,field,rooms.rooms_id,11
1,field,rooms.rooms_id,12
1,field,rooms.rooms_id,12
1,field,rooms.rooms_id,15
1,field,rooms.rooms_id,15
1,field,rooms.status,7
1,field,rooms.status,8
1,field,rooms.status,9
1,field,rooms.status,10
1,field,rooms.status,11
1,field,rooms.status,12
1,field,rooms.status,15
1,field,shelves.lname,7
1,field,shelves.lname,8
1,field,shelves.lname,9
1,field,shelves.lname,10
1,field,shelves.lname,11
1,field,shelves.lname,12
1,field,shelves.lname,15
1,field,shelves.name,7
1,field,shelves.name,7
1,field,shelves.name,8
1,field,shelves.name,8
1,field,shelves.name,9
1,field,shelves.name,9
1,field,shelves.name,10
1,field,shelves.name,10
1,field,shelves.name,11
1,field,shelves.name,11
1,field,shelves.name,12
1,field,shelves.name,12
1,field,shelves.name,15
1,field,shelves.name,15
1,field,shelves.parent_location,7
1,field,shelves.parent_location,8
1,field,shelves.parent_location,9
1,field,shelves.parent_location,10
1,field,shelves.parent_location,11
1,field,shelves.parent_location,12
1,field,shelves.parent_location,15
1,field,shelves.shelves_id,7
1,field,shelves.shelves_id,7
1,field,shelves.shelves_id,8
1,field,shelves.shelves_id,8
1,field,shelves.shelves_id,9
1,field,shelves.shelves_id,9
1,field,shelves.shelves_id,10
1,field,shelves.shelves_id,10
1,field,shelves.shelves_id,11
1,field,shelves.shelves_id,11
1,field,shelves.shelves_id,12
1,field,shelves.shelves_id,12
1,field,shelves.shelves_id,15
1,field,shelves.shelves_id,15
1,field,shelves.shelving_units_shelving_units_id,7
1,field,shelves.shelving_units_shelving_units_id,7
1,field,shelves.shelving_units_shelving_units_id,8
1,field,shelves.shelving_units_shelving_units_id,8
1,field,shelves.shelving_units_shelving_units_id,9
1,field,shelves.shelving_units_shelving_units_id,9
1,field,shelves.shelving_units_shelving_units_id,10
1,field,shelves.shelving_units_shelving_units_id,10
1,field,shelves.shelving_units_shelving_units_id,11
1,field,shelves.shelving_units_shelving_units_id,11
1,field,shelves.shelving_units_shelving_units_id,12
1,field,shelves.shelving_units_shelving_units_id,12
1,field,shelves.shelving_units_shelving_units_id,15
1,field,shelves.shelving_units_shelving_units_id,15
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,7
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,7
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,8
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,8
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,9
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,9
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,10
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,10
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,11
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,11
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,12
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,12
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,15
1,field,shelves.shelving_units_storage_areas_rooms_rooms_id,15
1,field,shelves.shelving_units_storage_areas_storage_areas_id,7
1,field,shelves.shelving_units_storage_areas_storage_areas_id,7
1,field,shelves.shelving_units_storage_areas_storage_areas_id,8
1,field,shelves.shelving_units_storage_areas_storage_areas_id,8
1,field,shelves.shelving_units_storage_areas_storage_areas_id,9
1,field,shelves.shelving_units_storage_areas_storage_areas_id,9
1,field,shelves.shelving_units_storage_areas_storage_areas_id,10
1,field,shelves.shelving_units_storage_areas_storage_areas_id,10
1,field,shelves.shelving_units_storage_areas_storage_areas_id,11
1,field,shelves.shelving_units_storage_areas_storage_areas_id,11
1,field,shelves.shelving_units_storage_areas_storage_areas_id,12
1,field,shelves.shelving_units_storage_areas_storage_areas_id,12
1,field,shelves.shelving_units_storage_areas_storage_areas_id,15
1,field,shelves.shelving_units_storage_areas_storage_areas_id,15
1,field,shelves.status,7
1,field,shelves.status,8
1,field,shelves.status,9
1,field,shelves.status,10
1,field,shelves.status,11
1,field,shelves.status,12
1,field,shelves.status,15
1,field,shelving_units.lname,7
1,field,shelving_units.lname,8
1,field,shelving_units.lname,9
1,field,shelving_units.lname,10
1,field,shelving_units.lname,11
1,field,shelving_units.lname,12
1,field,shelving_units.lname,15
1,field,shelving_units.Name,7
1,field,shelving_units.Name,7
1,field,shelving_units.Name,8
1,field,shelving_units.Name,8
1,field,shelving_units.Name,9
1,field,shelving_units.Name,9
1,field,shelving_units.Name,10
1,field,shelving_units.Name,10
1,field,shelving_units.Name,11
1,field,shelving_units.Name,11
1,field,shelving_units.Name,12
1,field,shelving_units.Name,12
1,field,shelving_units.Name,15
1,field,shelving_units.Name,15
1,field,shelving_units.parent_location,7
1,field,shelving_units.parent_location,8
1,field,shelving_units.parent_location,9
1,field,shelving_units.parent_location,10
1,field,shelving_units.parent_location,11
1,field,shelving_units.parent_location,12
1,field,shelving_units.parent_location,15
1,field,shelving_units.shelving_units_id,7
1,field,shelving_units.shelving_units_id,7
1,field,shelving_units.shelving_units_id,8
1,field,shelving_units.shelving_units_id,8
1,field,shelving_units.shelving_units_id,9
1,field,shelving_units.shelving_units_id,9
1,field,shelving_units.shelving_units_id,10
1,field,shelving_units.shelving_units_id,10
1,field,shelving_units.shelving_units_id,11
1,field,shelving_units.shelving_units_id,11
1,field,shelving_units.shelving_units_id,12
1,field,shelving_units.shelving_units_id,12
1,field,shelving_units.shelving_units_id,15
1,field,shelving_units.shelving_units_id,15
1,field,shelving_units.status,7
1,field,shelving_units.status,8
1,field,shelving_units.status,9
1,field,shelving_units.status,10
1,field,shelving_units.status,11
1,field,shelving_units.status,12
1,field,shelving_units.status,15
1,field,shelving_units.storage_areas_rooms_rooms_id,7
1,field,shelving_units.storage_areas_rooms_rooms_id,7
1,field,shelving_units.storage_areas_rooms_rooms_id,8
1,field,shelving_units.storage_areas_rooms_rooms_id,8
1,field,shelving_units.storage_areas_rooms_rooms_id,9
1,field,shelving_units.storage_areas_rooms_rooms_id,9
1,field,shelving_units.storage_areas_rooms_rooms_id,10
1,field,shelving_units.storage_areas_rooms_rooms_id,10
1,field,shelving_units.storage_areas_rooms_rooms_id,11
1,field,shelving_units.storage_areas_rooms_rooms_id,11
1,field,shelving_units.storage_areas_rooms_rooms_id,12
1,field,shelving_units.storage_areas_rooms_rooms_id,12
1,field,shelving_units.storage_areas_rooms_rooms_id,15
1,field,shelving_units.storage_areas_rooms_rooms_id,15
1,field,shelving_units.storage_areas_storage_areas_id,7
1,field,shelving_units.storage_areas_storage_areas_id,7
1,field,shelving_units.storage_areas_storage_areas_id,8
1,field,shelving_units.storage_areas_storage_areas_id,8
1,field,shelving_units.storage_areas_storage_areas_id,9
1,field,shelving_units.storage_areas_storage_areas_id,9
1,field,shelving_units.storage_areas_storage_areas_id,10
1,field,shelving_units.storage_areas_storage_areas_id,10
1,field,shelving_units.storage_areas_storage_areas_id,11
1,field,shelving_units.storage_areas_storage_areas_id,11
1,field,shelving_units.storage_areas_storage_areas_id,12
1,field,shelving_units.storage_areas_storage_areas_id,12
1,field,shelving_units.storage_areas_storage_areas_id,15
1,field,shelving_units.storage_areas_storage_areas_id,15
1,field,storage_areas.lname,7
1,field,storage_areas.lname,8
1,field,storage_areas.lname,9
1,field,storage_areas.lname,10
1,field,storage_areas.lname,11
1,field,storage_areas.lname,12
1,field,storage_areas.lname,15
1,field,storage_areas.name,7
1,field,storage_areas.name,7
1,field,storage_areas.name,8
1,field,storage_areas.name,8
1,field,storage_areas.name,9
1,field,storage_areas.name,9
1,field,storage_areas.name,10
1,field,storage_areas.name,10
1,field,storage_areas.name,11
1,field,storage_areas.name,11
1,field,storage_areas.name,12
1,field,storage_areas.name,12
1,field,storage_areas.name,15
1,field,storage_areas.name,15
1,field,storage_areas.parent_location,7
1,field,storage_areas.parent_location,8
1,field,storage_areas.parent_location,9
1,field,storage_areas.parent_location,10
1,field,storage_areas.parent_location,11
1,field,storage_areas.parent_location,12
1,field,storage_areas.parent_location,15
1,field,storage_areas.rooms_rooms_id,7
1,field,storage_areas.rooms_rooms_id,7
1,field,storage_areas.rooms_rooms_id,8
1,field,storage_areas.rooms_rooms_id,8
1,field,storage_areas.rooms_rooms_id,9
1,field,storage_areas.rooms_rooms_id,9
1,field,storage_areas.rooms_rooms_id,10
1,field,storage_areas.rooms_rooms_id,10
1,field,storage_areas.rooms_rooms_id,11
1,field,storage_areas.rooms_rooms_id,11
1,field,storage_areas.rooms_rooms_id,12
1,field,storage_areas.rooms_rooms_id,12
1,field,storage_areas.rooms_rooms_id,15
1,field,storage_areas.rooms_rooms_id,15
1,field,storage_areas.status,7
1,field,storage_areas.status,8
1,field,storage_areas.status,9
1,field,storage_areas.status,10
1,field,storage_areas.status,11
1,field,storage_areas.status,12
1,field,storage_areas.status,15
1,field,storage_areas.storage_areas_id,7
1,field,storage_areas.storage_areas_id,7
1,field,storage_areas.storage_areas_id,8
1,field,storage_areas.storage_areas_id,8
1,field,storage_areas.storage_areas_id,9
1,field,storage_areas.storage_areas_id,9
1,field,storage_areas.storage_areas_id,10
1,field,storage_areas.storage_areas_id,10
1,field,storage_areas.storage_areas_id,11
1,field,storage_areas.storage_areas_id,11
1,field,storage_areas.storage_areas_id,12
1,field,storage_areas.storage_areas_id,12
1,field,storage_areas.storage_areas_id,15
1,field,storage_areas.storage_areas_id,15
1,table,build_containers,1
1,table,build_containers,2
1,table,build_containers,3
1,table,build_containers,4
1,table,build_containers,5
1,table,build_containers,14
1,table,build_shelving_units,1
1,table,build_shelving_units,2
1,table,build_shelving_units,3
1,table,build_shelving_units,4
1,table,build_shelving_units,5
1,table,build_shelving_units,14
1,table,containers,1
1,table,containers,1
1,table,containers,2
1,table,containers,2
1,table,containers,3
1,table,containers,3
1,table,containers,4
1,table,containers,4
1,table,containers,5
1,table,containers,5
1,table,containers,14
1,table,containers,14
1,table,contents,1
1,table,contents,1
1,table,contents,2
1,table,contents,2
1,table,contents,3
1,table,contents,3
1,table,contents,4
1,table,contents,4
1,table,contents,5
1,table,contents,5
1,table,contents,14
1,table,contents,14
1,table,dadabik_groups,1
1,table,dadabik_groups,1
1,table,dadabik_groups,2
1,table,dadabik_groups,2
1,table,dadabik_groups,3
1,table,dadabik_groups,3
1,table,dadabik_groups,4
1,table,dadabik_groups,4
1,table,dadabik_groups,5
1,table,dadabik_groups,5
1,table,dadabik_groups,14
1,table,dadabik_groups,14
1,table,dadabik_users,1
1,table,dadabik_users,1
1,table,dadabik_users,2
1,table,dadabik_users,2
1,table,dadabik_users,3
1,table,dadabik_users,3
1,table,dadabik_users,4
1,table,dadabik_users,4
1,table,dadabik_users,5
1,table,dadabik_users,5
1,table,dadabik_users,14
1,table,dadabik_users,14
1,table,inventory_details,1
1,table,inventory_details,2
1,table,inventory_details,3
1,table,inventory_details,4
1,table,inventory_details,5
1,table,inventory_details,14
1,table,rooms,1
1,table,rooms,1
1,table,rooms,2
1,table,rooms,2
1,table,rooms,3
1,table,rooms,3
1,table,rooms,4
1,table,rooms,4
1,table,rooms,5
1,table,rooms,5
1,table,rooms,14
1,table,rooms,14
1,table,shelves,1
1,table,shelves,1
1,table,shelves,2
1,table,shelves,2
1,table,shelves,3
1,table,shelves,3
1,table,shelves,4
1,table,shelves,4
1,table,shelves,5
1,table,shelves,5
1,table,shelves,14
1,table,shelves,14
1,table,shelving_units,1
1,table,shelving_units,1
1,table,shelving_units,2
1,table,shelving_units,2
1,table,shelving_units,3
1,table,shelving_units,3
1,table,shelving_units,4
1,table,shelving_units,4
1,table,shelving_units,5
1,table,shelving_units,5
1,table,shelving_units,14
1,table,shelving_units,14
1,table,storage_areas,1
1,table,storage_areas,1
1,table,storage_areas,2
1,table,storage_areas,2
1,table,storage_areas,3
1,table,storage_areas,3
1,table,storage_areas,4
1,table,storage_areas,4
1,table,storage_areas,5
1,table,storage_areas,5
1,table,storage_areas,14
1,table,storage_areas,14
2,custom_page,1,13
2,field,containers.containers_id,7
2,field,containers.containers_id,7
2,field,containers.containers_id,10
2,field,containers.containers_id,10
2,field,containers.containers_id,11
2,field,containers.containers_id,11
2,field,containers.containers_id,12
2,field,containers.containers_id,12
2,field,containers.containers_id,15
2,field,containers.containers_id,15
2,field,containers.contents_contents_id,7
2,field,containers.contents_contents_id,7
2,field,containers.contents_contents_id,10
2,field,containers.contents_contents_id,10
2,field,containers.contents_contents_id,12
2,field,containers.contents_contents_id,12
2,field,containers.contents_contents_id,15
2,field,containers.contents_contents_id,15
2,field,containers.name,7
2,field,containers.name,7
2,field,containers.name,10
2,field,containers.name,10
2,field,containers.name,11
2,field,containers.name,11
2,field,containers.name,12
2,field,containers.name,12
2,field,containers.name,15
2,field,containers.name,15
2,field,containers.shelves_shelves_id,7
2,field,containers.shelves_shelves_id,7
2,field,containers.shelves_shelves_id,10
2,field,containers.shelves_shelves_id,10
2,field,containers.shelves_shelves_id,12
2,field,containers.shelves_shelves_id,12
2,field,containers.shelves_shelves_id,15
2,field,containers.shelves_shelves_id,15
2,field,containers.shelves_shelving_units_shelving_units_id,7
2,field,containers.shelves_shelving_units_shelving_units_id,7
2,field,containers.shelves_shelving_units_shelving_units_id,10
2,field,containers.shelves_shelving_units_shelving_units_id,10
2,field,containers.shelves_shelving_units_shelving_units_id,12
2,field,containers.shelves_shelving_units_shelving_units_id,12
2,field,containers.shelves_shelving_units_shelving_units_id,15
2,field,containers.shelves_shelving_units_shelving_units_id,15
2,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,7
2,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,7
2,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,10
2,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,10
2,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,12
2,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,12
2,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,15
2,field,containers.shelves_shelving_units_storage_areas_rooms_rooms_id,15
2,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,7
2,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,7
2,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,10
2,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,10
2,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,12
2,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,12
2,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,15
2,field,containers.shelves_shelving_units_storage_areas_storage_areas_id,15
2,field,contents.contents_id,7
2,field,contents.contents_id,7
2,field,contents.contents_id,10
2,field,contents.contents_id,10
2,field,contents.contents_id,11
2,field,contents.contents_id,11
2,field,contents.contents_id,12
2,field,contents.contents_id,12
2,field,contents.contents_id,15
2,field,contents.contents_id,15
2,field,contents.descr,7
2,field,contents.descr,7
2,field,contents.descr,10
2,field,contents.descr,10
2,field,contents.descr,11
2,field,contents.descr,11
2,field,contents.descr,12
2,field,contents.descr,12
2,field,contents.descr,15
2,field,contents.descr,15
2,field,contents.picture,7
2,field,contents.picture,7
2,field,contents.picture,10
2,field,contents.picture,10
2,field,contents.picture,12
2,field,contents.picture,12
2,field,contents.picture,15
2,field,contents.picture,15
2,field,rooms.name,7
2,field,rooms.name,7
2,field,rooms.name,10
2,field,rooms.name,10
2,field,rooms.name,11
2,field,rooms.name,11
2,field,rooms.name,12
2,field,rooms.name,12
2,field,rooms.name,15
2,field,rooms.name,15
2,field,rooms.rooms_id,7
2,field,rooms.rooms_id,7
2,field,rooms.rooms_id,10
2,field,rooms.rooms_id,10
2,field,rooms.rooms_id,11
2,field,rooms.rooms_id,11
2,field,rooms.rooms_id,12
2,field,rooms.rooms_id,12
2,field,rooms.rooms_id,15
2,field,rooms.rooms_id,15
2,field,shelves.name,7
2,field,shelves.name,7
2,field,shelves.name,10
2,field,shelves.name,10
2,field,shelves.name,11
2,field,shelves.name,11
2,field,shelves.name,12
2,field,shelves.name,12
2,field,shelves.name,15
2,field,shelves.name,15
2,field,shelves.shelves_id,7
2,field,shelves.shelves_id,7
2,field,shelves.shelves_id,10
2,field,shelves.shelves_id,10
2,field,shelves.shelves_id,11
2,field,shelves.shelves_id,11
2,field,shelves.shelves_id,12
2,field,shelves.shelves_id,12
2,field,shelves.shelves_id,15

[/pre]
 
eugenio

eugenio

Administrator
Staff member
That's strange because the upgrade procedure should have warned you about the duplications, two questions:

1) From which version you were trying to upgrade?

2) Can you paste the results of this query:

SELECT object_permission FROM dadabik_permissions group by id_subject, subject_type_permission, object_type_permission, object_permission, id_permission_type having count(*) > 1

Best,
 
C

christensen.ken@gmail.com

Member
upgrading from 10.4 enterprise to 10.5 enterprise

[pre]
10:32:42 SELECT object_permission FROM dadabik_permissions group by id_subject, subject_type_permission, object_type_permission, object_permission, id_permission_type having count(*) > 1 LIMIT 0, 1000 0 row(s) returned 0.016 sec / 0.000 sec
[/pre]
 
eugenio

eugenio

Administrator
Staff member
Can you check if in your dadabik_permissions table you have any record where subject_type_permission is 'user'?
 
eugenio

eugenio

Administrator
Staff member
No, I don't need the sample, those records are the reason of the problem.

Was your 10.4 a fresh installation or the result of an upgrade? Can you remember the history of upgrades? The table dadabik_installation should contain info about that.
In case it was an upgrade, did the previous upgrades work fine?
 
C

christensen.ken@gmail.com

Member
[pre]
select * from dadabik_installation_tab;
[/pre]


[pre]
'16361', '163615fd4e6eb6a38e', '2020-12-12 10:51:04', 'mysql', '10.4-Manarola', 'enterprise', NULL, 'http://vanadium.periodic-tbl.com/inventory/'

[/pre]

I thought that I originally started this app under 10.3 pro, upgraded to enterprise, then upgraded to 10.4, but the installation_tab data says otherwise. I can't remember precisely, sorry.

I do remember the upgrade from 10.3 to 10.4 went smoothly on whatever apps that I had at the time. Plus, I've started over on this app several times.

The inventory directory in htdocs does have the 'doc' directory for 10.4 enterprise. Also there are files in the htdocs/inventory directory older than the 2020-12-12 shown in the installatiion_tab data, although, as I say this isn't conclusive due to my starting and restarting this app.

Sorry I can't be more precise.
 
eugenio

eugenio

Administrator
Staff member
Hello,
it's difficult to understand how exactly things happened because from your installation tab it seems it's a fresh 10.4 installation with no upgrades.

The thing is that starting from V 10.4 we stopped inserting 'user' permissions in the dadabik_permissions table so I can't understand why you have those records. It seems more an older version not properly upgraded.

My suggestion is to load a backup you made before the last upgrade and to open an email support ticket to have a closer look.

Best,
 
C

christensen.ken@gmail.com

Member
Eugenio,

I think I'm just going to abandon this app. I've been having ideas about improving the db design so I'm probably going to start over ... again.

It's a small app (eight tables) and I've started and revised and changed several versions, so it won't bother me to start again. As I said, I have a better understanding of my requirements now, anyway.

It seems that I've probably screwed thing up somewhere along the way. So let's not waste anymore of your time resolving an issue that probably isn't your fault anyway.

Thanks for your help, but lets just close this thread.

KenC
 
C

christensen.ken@gmail.com

Member
Eugenio,

I am still abandoning this app, as I've changed the data model considerably, but just for grins I deleted the 412 rows from dadabik_permissions that you indicated were the cause of my problem and then re-ran the upgrade.

It took much longer than the other three upgrades that I had previously completed (~~8 min vs 2-3 min), but it did finish successfully and the app appears no worse for the experience <smile>.

Here's the installation_tab data
[pre]
'16361', '163615fd4e6eb6a38e', '2020-12-12 10:51:04', 'mysql', '10.4-Manarola', 'enterprise', 'upgrade_version=10.5-Manarola enterprise~upgrade_time=1611253741~upgrade_dbms=mysql', 'http://vanadium.periodic-tbl.com/inventory/'
[/pre]

Thanks for your help and a great product. I'm sure I screwed up somewhere along the way, I've been copying database schemas left and right and also the htdocs directory structure, so there was plenty of opportunity for me to mess up <wry grin>.

KenC
 
eugenio

eugenio

Administrator
Staff member
Ok, thanks for the additional update and for the appreciation B)

Yes, probably there was something not in the situation expected by the upgrade procedure.

I expected this new result after having deleted those rows but I can't tell if now the files are the correct ones or not since the upgrade procedure was already run once, so yes it's better to start from scratch.

Best,
 
You must log in or register to reply here.
Top