HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Install step 6 error messages - some tips for future

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#104299 (In Topic #20374)
Avatar

Fan in action

Blank database fresh vhost

Tried to install on a fresh vhost for testing just now using the quick install script and at the page of step 6 a bunch of errors were generated when I clicked to proceeded from step 5.

The settings from the database page step 5 weren't 100% and I redis them and tried again and these were shown.

Deleting the database and trying again worked when I had all the correct info when clicking the proceed without any errors.

The issue is some data in the database gets created before the user gets promoted to go back and correct the rest of the database settings which in turn created this error list when proceeding forward again.

So solutions are to check all settings data first before populating the database or parsing and hiding the output when the user goes back to re-try to create the database tables.

As it was I thought the script did not install properly seeing these messages generated which these messages can be avoided by the above solution. 

All other steps completed fine.

Code


Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 1, '', '', '', 1) [Duplicate entry '1-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 2, '', '', '', 1) [Duplicate entry '2-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 3, '', '', '', 1) [Duplicate entry '3-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 4, '', '', '', 1) [Duplicate entry '4-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 5, '', '', '', 1) [Duplicate entry '5-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 6, '', '', '', 1) [Duplicate entry '6-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 7, '', '', '', 1) [Duplicate entry '7-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 8, '', '', '', 1) [Duplicate entry '8-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 9, '', '', '', 1) [Duplicate entry '9-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('run_multi_moderations', 10, '', '', '', 1) [Duplicate entry '10-run_multi_moderations---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'run_multi_moderations', 1) [Duplicate entry 'run_multi_moderations-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 1, '', '', '', 1) [Duplicate entry '1-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 2, '', '', '', 1) [Duplicate entry '2-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 3, '', '', '', 1) [Duplicate entry '3-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 4, '', '', '', 1) [Duplicate entry '4-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 5, '', '', '', 1) [Duplicate entry '5-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 6, '', '', '', 1) [Duplicate entry '6-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 7, '', '', '', 1) [Duplicate entry '7-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 8, '', '', '', 1) [Duplicate entry '8-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 9, '', '', '', 1) [Duplicate entry '9-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_pt', 10, '', '', '', 1) [Duplicate entry '10-use_pt---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'use_pt', 1) [Duplicate entry 'use_pt-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 1, '', '', '', 1) [Duplicate entry '1-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 2, '', '', '', 1) [Duplicate entry '2-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 3, '', '', '', 1) [Duplicate entry '3-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 4, '', '', '', 1) [Duplicate entry '4-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 5, '', '', '', 1) [Duplicate entry '5-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 6, '', '', '', 1) [Duplicate entry '6-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 7, '', '', '', 1) [Duplicate entry '7-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 8, '', '', '', 1) [Duplicate entry '8-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 9, '', '', '', 1) [Duplicate entry '9-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_personal_topic_posts', 10, '', '', '', 1) [Duplicate entry '10-edit_personal_topic_posts---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'edit_personal_topic_posts', 1) [Duplicate entry 'edit_personal_topic_posts-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 1, '', '', '', 1) [Duplicate entry '1-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 2, '', '', '', 1) [Duplicate entry '2-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 3, '', '', '', 1) [Duplicate entry '3-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 4, '', '', '', 1) [Duplicate entry '4-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 5, '', '', '', 1) [Duplicate entry '5-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 6, '', '', '', 1) [Duplicate entry '6-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 7, '', '', '', 1) [Duplicate entry '7-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 8, '', '', '', 1) [Duplicate entry '8-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 9, '', '', '', 1) [Duplicate entry '9-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_unblind_own_poll', 10, '', '', '', 1) [Duplicate entry '10-may_unblind_own_poll---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'may_unblind_own_poll', 1) [Duplicate entry 'may_unblind_own_poll-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 1, '', '', '', 1) [Duplicate entry '1-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 2, '', '', '', 1) [Duplicate entry '2-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 3, '', '', '', 1) [Duplicate entry '3-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 4, '', '', '', 1) [Duplicate entry '4-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 5, '', '', '', 1) [Duplicate entry '5-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 6, '', '', '', 1) [Duplicate entry '6-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 7, '', '', '', 1) [Duplicate entry '7-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 8, '', '', '', 1) [Duplicate entry '8-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 9, '', '', '', 1) [Duplicate entry '9-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_report_post', 10, '', '', '', 1) [Duplicate entry '10-may_report_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'may_report_post', 1) [Duplicate entry 'may_report_post-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 1, '', '', '', 1) [Duplicate entry '1-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 2, '', '', '', 1) [Duplicate entry '2-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 3, '', '', '', 1) [Duplicate entry '3-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 4, '', '', '', 1) [Duplicate entry '4-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 5, '', '', '', 1) [Duplicate entry '5-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 6, '', '', '', 1) [Duplicate entry '6-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 7, '', '', '', 1) [Duplicate entry '7-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 8, '', '', '', 1) [Duplicate entry '8-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 9, '', '', '', 1) [Duplicate entry '9-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_member_photos', 10, '', '', '', 1) [Duplicate entry '10-view_member_photos---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'view_member_photos', 1) [Duplicate entry 'view_member_photos-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 1, '', '', '', 1) [Duplicate entry '1-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 2, '', '', '', 1) [Duplicate entry '2-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 3, '', '', '', 1) [Duplicate entry '3-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 4, '', '', '', 1) [Duplicate entry '4-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 5, '', '', '', 1) [Duplicate entry '5-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 6, '', '', '', 1) [Duplicate entry '6-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 7, '', '', '', 1) [Duplicate entry '7-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 8, '', '', '', 1) [Duplicate entry '8-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 9, '', '', '', 1) [Duplicate entry '9-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_quick_reply', 10, '', '', '', 1) [Duplicate entry '10-use_quick_reply---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'use_quick_reply', 1) [Duplicate entry 'use_quick_reply-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 1, '', '', '', 1) [Duplicate entry '1-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 2, '', '', '', 1) [Duplicate entry '2-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 3, '', '', '', 1) [Duplicate entry '3-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 4, '', '', '', 1) [Duplicate entry '4-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 5, '', '', '', 1) [Duplicate entry '5-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 6, '', '', '', 1) [Duplicate entry '6-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 7, '', '', '', 1) [Duplicate entry '7-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 8, '', '', '', 1) [Duplicate entry '8-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 9, '', '', '', 1) [Duplicate entry '9-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_profiles', 10, '', '', '', 1) [Duplicate entry '10-view_profiles---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'view_profiles', 1) [Duplicate entry 'view_profiles-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 1, '', '', '', 1) [Duplicate entry '1-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 2, '', '', '', 1) [Duplicate entry '2-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 3, '', '', '', 1) [Duplicate entry '3-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 4, '', '', '', 1) [Duplicate entry '4-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 5, '', '', '', 1) [Duplicate entry '5-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 6, '', '', '', 1) [Duplicate entry '6-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 7, '', '', '', 1) [Duplicate entry '7-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 8, '', '', '', 1) [Duplicate entry '8-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 9, '', '', '', 1) [Duplicate entry '9-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('own_avatars', 10, '', '', '', 1) [Duplicate entry '10-own_avatars---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'own_avatars', 1) [Duplicate entry 'own_avatars-1' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('rename_self', 3, '', '', '', 1) [Duplicate entry '3-rename_self---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'rename_self', 0) [Duplicate entry 'rename_self-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('use_special_emoticons', 3, '', '', '', 1) [Duplicate entry '3-use_special_emoticons---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'use_special_emoticons', 0) [Duplicate entry 'use_special_emoticons-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_any_profile_field', 3, '', '', '', 1) [Duplicate entry '3-view_any_profile_field---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'view_any_profile_field', 0) [Duplicate entry 'view_any_profile_field-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('disable_lost_passwords', 3, '', '', '', 1) [Duplicate entry '3-disable_lost_passwords---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'disable_lost_passwords', 0) [Duplicate entry 'disable_lost_passwords-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('close_own_topics', 3, '', '', '', 1) [Duplicate entry '3-close_own_topics---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'close_own_topics', 0) [Duplicate entry 'close_own_topics-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('edit_own_polls', 3, '', '', '', 1) [Duplicate entry '3-edit_own_polls---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'edit_own_polls', 0) [Duplicate entry 'edit_own_polls-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('double_post', 3, '', '', '', 1) [Duplicate entry '3-double_post---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'double_post', 0) [Duplicate entry 'double_post-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('see_warnings', 3, '', '', '', 1) [Duplicate entry '3-see_warnings---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'see_warnings', 0) [Duplicate entry 'see_warnings-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('see_ip', 3, '', '', '', 1) [Duplicate entry '3-see_ip---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'see_ip', 0) [Duplicate entry 'see_ip-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('may_choose_custom_title', 3, '', '', '', 1) [Duplicate entry '3-may_choose_custom_title---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'may_choose_custom_title', 0) [Duplicate entry 'may_choose_custom_title-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('delete_account', 3, '', '', '', 1) [Duplicate entry '3-delete_account---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'delete_account', 0) [Duplicate entry 'delete_account-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'view_other_pt', 0) [Duplicate entry 'view_other_pt-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('view_poll_results_before_voting', 3, '', '', '', 1) [Duplicate entry '3-view_poll_results_before_voting---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'view_poll_results_before_voting', 0) [Duplicate entry 'view_poll_results_before_voting-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('moderate_personal_topic', 3, '', '', '', 1) [Duplicate entry '3-moderate_personal_topic---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'moderate_personal_topic', 0) [Duplicate entry 'moderate_personal_topic-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('member_maintenance', 3, '', '', '', 1) [Duplicate entry '3-member_maintenance---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'member_maintenance', 0) [Duplicate entry 'member_maintenance-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('probate_members', 3, '', '', '', 1) [Duplicate entry '3-probate_members---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'probate_members', 0) [Duplicate entry 'probate_members-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('warn_members', 3, '', '', '', 1) [Duplicate entry '3-warn_members---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'warn_members', 0) [Duplicate entry 'warn_members-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('control_usergroups', 3, '', '', '', 1) [Duplicate entry '3-control_usergroups---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'control_usergroups', 0) [Duplicate entry 'control_usergroups-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('multi_delete_topics', 3, '', '', '', 1) [Duplicate entry '3-multi_delete_topics---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'multi_delete_topics', 0) [Duplicate entry 'multi_delete_topics-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('show_user_browsing', 3, '', '', '', 1) [Duplicate entry '3-show_user_browsing---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'show_user_browsing', 0) [Duplicate entry 'show_user_browsing-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('see_hidden_groups', 3, '', '', '', 1) [Duplicate entry '3-see_hidden_groups---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'see_hidden_groups', 0) [Duplicate entry 'see_hidden_groups-0' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_gsp (specific_permission, group_id, the_page, module_the_name, category_name, the_value) VALUES ('pt_anyone', 3, '', '', '', 1) [Duplicate entry '3-pt_anyone---' for key 'PRIMARY']<br /> Database query failed: INSERT INTO ocp_sp_list (p_section, the_name, the_default) VALUES ('SECTION_FORUMS', 'pt_anyone', 0) [Duplicate entry 'pt_anyone-0' for key 'PRIMARY']<br />


Last edit: by drguild
Back to the top
 
Posted
Rating:
#104306
Avatar

ocPortal already lets you refresh any step of the installer without getting errors (I just checked the code, and this case definitely is handled).

However, what probably happened here is you had it running twice in parallel - e.g. you refreshed twice, or clicked the button twice, or had an install going on in another tab too.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#104308
Avatar

Fan in action

Strange as I know I was only using 1 tab.

I started the install accidently clicked phpbb then backed out then went ahead with internal.

It was then I had the first area filled and not the second database info area for multi site if it differed for forum.

When I clicked forward I got a notice about the database info clicked back fixed the info then proceeded forward where I saw the errors pop up.

Could have been a freak once off thing but I'll try it a few times on a test vhost later and see what's what.
Back to the top
 
Posted
Rating:
#104309
Avatar

Stripped down, this is the code that is running:

Code

function uninstall_ocf_everytime()
{
   global $OCF_TRUE_PERMISSIONS,$OCF_FALSE_PERMISSIONS;

   foreach ($OCF_TRUE_PERMISSIONS as $permission)
   {
      delete_specific_permission($permission);
   }
   foreach ($OCF_FALSE_PERMISSIONS as $permission)
   {
      delete_specific_permission($permission);
   }
}

/**
 * Install/upgrade OCF.
 *
 * @param  ?float   The version to upgrade from (NULL: fresh install).
 */
function install_ocf($upgrade_from=NULL)
{
   if (is_null($upgrade_from))
   {
      uninstall_ocf_everytime();
   }

   if (is_null($upgrade_from))
   {
      // Add privileges
      global $OCF_TRUE_PERMISSIONS,$OCF_FALSE_PERMISSIONS;
      foreach ($OCF_TRUE_PERMISSIONS as $permission)
      {
         add_specific_permission('SECTION_FORUMS',$permission,true);
      }
      foreach ($OCF_FALSE_PERMISSIONS as $permission)
      {
         add_specific_permission('SECTION_FORUMS',$permission,false,($permission=='view_other_pt'));
      }
   }
}

So you see it deletes any permissions (if they exist), before it creates those same permissions. The listed duplicate permission rows were part of the above. A similar pattern happens in all the modules - delete, then create.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#104425
Avatar

Fan in action

Read your reply when you posted and understood.

Haven't gotten around to checking myself on my server yet but will do sometime out of interest.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: