dutchsnowden Posted December 22, 2021 Share Posted December 22, 2021 I downloaded and uploaded the files like 3 times, pretty sure the files are ok, what can I do about these errors? Link to comment Share on other sites More sharing options...
Marc Posted December 22, 2021 Share Posted December 22, 2021 As mentioned in your other ticket, you need to delete that package and download a new one, as that would indicate there are some /applications/cms items that shouldnt be present Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 23, 2021 Author Share Posted December 23, 2021 I downloaded the package many times. Those files ARE MISSING from downloads since I do not bought those apps. So why the upgrade is requesting them at this step? Link to comment Share on other sites More sharing options...
Marc Posted December 23, 2021 Share Posted December 23, 2021 You shouldnt have ant /applications/cms folder at all. Have you got a folder of that name? I notice you have submitted a ticket. Please respond to that ticket and we can take a closer look at this Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 23, 2021 Author Share Posted December 23, 2021 No, all the downloads from client area are MISSING that "cms" folder completely. But upgrade procedure, requests it after UTF8 conversion. Probably sees that I have all those tables populated in my database, not sure what is going on. Link to comment Share on other sites More sharing options...
Marc Posted December 23, 2021 Share Posted December 23, 2021 This is being dealt with on your ticket, but the issue here is that you have IP.Content installed on 3.1 Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 23, 2021 Author Share Posted December 23, 2021 Just for the record, I will write here again, I DO HAVE LICENSE for Pages on 3.1.4. Please let's not go there anymore. Link to comment Share on other sites More sharing options...
Marc Posted December 23, 2021 Share Posted December 23, 2021 11 minutes ago, dutchsnowden said: Just for the record, I will write here again, I DO HAVE LICENSE for Pages on 3.1.4. Please let's not go there anymore. This was not mentioned here, and was left in a private setting. If that is the case, its on another license there, as there is no content licence on that licence being used. We can go through your issue in that ticket, but please be aware until we get that issue resolved, nothing else is going to resolve your problem Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 23, 2021 Author Share Posted December 23, 2021 Sure. I will wait then. The tickets are only through email? Is there a board system to easily track of threads? Link to comment Share on other sites More sharing options...
Marc Posted December 23, 2021 Share Posted December 23, 2021 5 minutes ago, dutchsnowden said: Sure. I will wait then. The tickets are only through email? Is there a board system to easily track of threads? They are through email only Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 29, 2021 Author Share Posted December 29, 2021 On 12/22/2021 at 12:05 PM, Marc Stridgen said: As mentioned in your other ticket, you need to delete that package and download a new one, as that would indicate there are some /applications/cms items that shouldnt be present so now I got new license sorted out. And yet again, I got these errors. what I did. installed brand new ubuntu and all requirements restored a backup database as it is MyISAM converted the database to InnoDB (7h 30mins - I will try reconfiguring some MySQL options but this is painful) started upgrade php memory limit Conversion to UTF-8 step required (took 1h 30m) no errors so far then added into conf_global.php the required rows about UTF-8 as required, then press continue upgrade AND AGAIN I got this. And cannot continue pass it I was expecting to fight the SQL Syntax error later but I am back again at this thing. I think somehow CONVERT-UTF8 procedure is marking somehow the database with something that makes the next step fail like this. +------------------------------------+ | bb_admin_login_logs | | bb_admin_logs | | bb_admin_permission_rows | | bb_announcements | | bb_api_log | | bb_api_users | | bb_attachments | | bb_attachments_type | | bb_badwords | | bb_banfilters | | bb_banners | | bb_bbcode_mediatag | | bb_bulk_mail | | bb_cache_store | | bb_cal_calendars | | bb_cal_events | | bb_captcha | | bb_ccs_attachments_map | | bb_ccs_block_wizard | | bb_ccs_blocks | | bb_ccs_containers | | bb_ccs_custom_database_1 | | bb_ccs_custom_database_2 | | bb_ccs_database_categories | | bb_ccs_database_comments | | bb_ccs_database_fields | | bb_ccs_database_moderators | | bb_ccs_database_modqueue | | bb_ccs_database_notifications | | bb_ccs_database_ratings | | bb_ccs_database_revisions | | bb_ccs_databases | | bb_ccs_folders | | bb_ccs_page_templates | | bb_ccs_page_wizard | | bb_ccs_pages | | bb_ccs_revisions | | bb_ccs_template_blocks | | bb_ccs_template_cache | | bb_chat_log_archive | | bb_content_cache_posts | | bb_content_cache_sigs | | bb_converge_local | | bb_core_applications | | bb_core_hooks | | bb_core_hooks_files | | bb_core_incoming_emails | | bb_core_item_markers | | bb_core_item_markers_storage | | bb_core_like | | bb_core_like_cache | | bb_core_rss_imported | | bb_core_share_links | | bb_core_share_links_caches | | bb_core_share_links_log | | bb_core_soft_delete_log | | bb_core_sys_conf_settings | | bb_core_sys_cp_sessions | | bb_core_sys_lang | | bb_core_sys_lang_words | | bb_core_sys_login | | bb_core_sys_module | | bb_core_sys_settings_titles | | bb_core_uagent_groups | | bb_core_uagents | | bb_custom_bbcode | | bb_dnames_change | | bb_dp3_adv_adverts | | bb_dp3_adv_adverts_types | | bb_dp3_adv_clicks | | bb_dp3_adv_sections | | bb_dp3_adv_templates | | bb_dp3_adv_topics | | bb_email_logs | | bb_emoticons | | bb_error_logs | | bb_faq | | bb_forum_perms | | bb_forum_tracker | | bb_forums | | bb_gallery_albums | | bb_gallery_bandwidth | | bb_gallery_categories | | bb_gallery_comments | | bb_gallery_ecardlog | | bb_gallery_favorites | | bb_gallery_form_fields | | bb_gallery_images | | bb_gallery_media_types | | bb_gallery_ratings | | bb_gallery_upgrade_history | | bb_groups | | bb_ignored_users | | bb_inline_notifications | | bb_installed_mods | | bb_login_methods | | bb_mail_error_logs | | bb_mail_queue | | bb_member_status_actions | | bb_member_status_replies | | bb_member_status_updates | | bb_members | | bb_members_partial | | bb_message_posts | | bb_message_text | | bb_message_topic_user_map | | bb_message_topics | | bb_mobile_notifications | | bb_mod_queued_items | | bb_moderator_logs | | bb_moderators | | bb_openid_temp | | bb_permission_index | | bb_pfields_content | | bb_pfields_data | | bb_pfields_groups | | bb_pm_logs | | bb_polls | | bb_posts | | bb_profile_comments | | bb_profile_friends | | bb_profile_friends_flood | | bb_profile_portal | | bb_profile_portal_views | | bb_profile_ratings | | bb_question_and_answer | | bb_randmsgs | | bb_rc_classes | | bb_rc_comments | | bb_rc_modpref | | bb_rc_reports | | bb_rc_reports_index | | bb_rc_status | | bb_rc_status_sev | | bb_reputation_cache | | bb_reputation_index | | bb_reputation_levels | | bb_rss_export | | bb_rss_import | | bb_rss_imported | | bb_search_keywords | | bb_search_results | | bb_search_sessions | | bb_search_visitors | | bb_seo_meta | | bb_sessions | | bb_skin_cache | | bb_skin_collections | | bb_skin_css | | bb_skin_css_previous | | bb_skin_merge_changes | | bb_skin_merge_session | | bb_skin_replacements | | bb_skin_templates | | bb_skin_templates_cache | | bb_skin_templates_previous | | bb_skin_url_mapping | | bb_spam_service_log | | bb_spider_logs | | bb_statistics | | bb_subscription_currency | | bb_subscription_extra | | bb_subscription_logs | | bb_subscription_methods | | bb_subscription_trans | | bb_subscriptions | | bb_tags_index | | bb_task_logs | | bb_task_manager | | bb_template_sandr | | bb_titles | | bb_topic_ads | | bb_topic_mmod | | bb_topic_ratings | | bb_topic_views | | bb_topics | | bb_tracker | | bb_twitter_connect | | bb_upgrade_history | | bb_upgrade_sessions | | bb_validating | | bb_voters | | bb_warn_logs | | orig_bb_admin_login_logs | | orig_bb_admin_logs | | orig_bb_admin_permission_rows | | orig_bb_announcements | | orig_bb_api_log | | orig_bb_api_users | | orig_bb_attachments | | orig_bb_attachments_type | | orig_bb_badwords | | orig_bb_banfilters | | orig_bb_banners | | orig_bb_bbcode_mediatag | | orig_bb_bulk_mail | | orig_bb_cache_store | | orig_bb_cal_calendars | | orig_bb_cal_events | | orig_bb_captcha | | orig_bb_ccs_attachments_map | | orig_bb_ccs_block_wizard | | orig_bb_ccs_blocks | | orig_bb_ccs_containers | | orig_bb_ccs_custom_database_1 | | orig_bb_ccs_custom_database_2 | | orig_bb_ccs_database_categories | | orig_bb_ccs_database_comments | | orig_bb_ccs_database_fields | | orig_bb_ccs_database_moderators | | orig_bb_ccs_database_modqueue | | orig_bb_ccs_database_notifications | | orig_bb_ccs_database_ratings | | orig_bb_ccs_database_revisions | | orig_bb_ccs_databases | | orig_bb_ccs_folders | | orig_bb_ccs_page_templates | | orig_bb_ccs_page_wizard | | orig_bb_ccs_pages | | orig_bb_ccs_revisions | | orig_bb_ccs_template_blocks | | orig_bb_ccs_template_cache | | orig_bb_chat_log_archive | | orig_bb_content_cache_posts | | orig_bb_content_cache_sigs | | orig_bb_converge_local | | orig_bb_core_applications | | orig_bb_core_hooks | | orig_bb_core_hooks_files | | orig_bb_core_incoming_emails | | orig_bb_core_item_markers | | orig_bb_core_item_markers_storage | | orig_bb_core_like | | orig_bb_core_like_cache | | orig_bb_core_rss_imported | | orig_bb_core_share_links | | orig_bb_core_share_links_caches | | orig_bb_core_share_links_log | | orig_bb_core_soft_delete_log | | orig_bb_core_sys_conf_settings | | orig_bb_core_sys_cp_sessions | | orig_bb_core_sys_lang | | orig_bb_core_sys_lang_words | | orig_bb_core_sys_login | | orig_bb_core_sys_module | | orig_bb_core_sys_settings_titles | | orig_bb_core_uagent_groups | | orig_bb_core_uagents | | orig_bb_custom_bbcode | | orig_bb_dnames_change | | orig_bb_dp3_adv_adverts | | orig_bb_dp3_adv_adverts_types | | orig_bb_dp3_adv_clicks | | orig_bb_dp3_adv_sections | | orig_bb_dp3_adv_templates | | orig_bb_dp3_adv_topics | | orig_bb_email_logs | | orig_bb_emoticons | | orig_bb_error_logs | | orig_bb_faq | | orig_bb_forum_perms | | orig_bb_forum_tracker | | orig_bb_forums | | orig_bb_gallery_albums | | orig_bb_gallery_bandwidth | | orig_bb_gallery_categories | | orig_bb_gallery_comments | | orig_bb_gallery_ecardlog | | orig_bb_gallery_favorites | | orig_bb_gallery_form_fields | | orig_bb_gallery_images | | orig_bb_gallery_media_types | | orig_bb_gallery_ratings | | orig_bb_gallery_upgrade_history | | orig_bb_groups | | orig_bb_ignored_users | | orig_bb_inline_notifications | | orig_bb_installed_mods | | orig_bb_login_methods | | orig_bb_mail_error_logs | | orig_bb_mail_queue | | orig_bb_member_status_actions | | orig_bb_member_status_replies | | orig_bb_member_status_updates | | orig_bb_members | | orig_bb_members_partial | | orig_bb_message_posts | | orig_bb_message_text | | orig_bb_message_topic_user_map | | orig_bb_message_topics | | orig_bb_message_topics_old | | orig_bb_mobile_notifications | | orig_bb_mod_queued_items | | orig_bb_moderator_logs | | orig_bb_moderators | | orig_bb_openid_temp | | orig_bb_permission_index | | orig_bb_pfields_content | | orig_bb_pfields_data | | orig_bb_pfields_groups | | orig_bb_pm_logs | | orig_bb_polls | | orig_bb_posts | | orig_bb_profile_comments | | orig_bb_profile_friends | | orig_bb_profile_friends_flood | | orig_bb_profile_portal | | orig_bb_profile_portal_views | | orig_bb_profile_ratings | | orig_bb_question_and_answer | | orig_bb_randmsgs | | orig_bb_rc_classes | | orig_bb_rc_comments | | orig_bb_rc_modpref | | orig_bb_rc_reports | | orig_bb_rc_reports_index | | orig_bb_rc_status | | orig_bb_rc_status_sev | | orig_bb_reputation_cache | | orig_bb_reputation_index | | orig_bb_reputation_levels | | orig_bb_rss_export | | orig_bb_rss_import | | orig_bb_rss_imported | | orig_bb_search_keywords | | orig_bb_search_results | | orig_bb_search_sessions | | orig_bb_search_visitors | | orig_bb_seo_meta | | orig_bb_sessions | | orig_bb_skin_cache | | orig_bb_skin_collections | | orig_bb_skin_css | | orig_bb_skin_css_previous | | orig_bb_skin_merge_changes | | orig_bb_skin_merge_session | | orig_bb_skin_replacements | | orig_bb_skin_templates | | orig_bb_skin_templates_cache | | orig_bb_skin_templates_previous | | orig_bb_skin_url_mapping | | orig_bb_spam_service_log | | orig_bb_spider_logs | | orig_bb_statistics | | orig_bb_subscription_currency | | orig_bb_subscription_extra | | orig_bb_subscription_logs | | orig_bb_subscription_methods | | orig_bb_subscription_trans | | orig_bb_subscriptions | | orig_bb_tags_index | | orig_bb_task_logs | | orig_bb_task_manager | | orig_bb_template_sandr | | orig_bb_titles | | orig_bb_topic_ads | | orig_bb_topic_mmod | | orig_bb_topic_ratings | | orig_bb_topic_views | | orig_bb_topics | | orig_bb_tracker | | orig_bb_twitter_connect | | orig_bb_upgrade_history | | orig_bb_upgrade_sessions | | orig_bb_validating | | orig_bb_voters | | orig_bb_warn_logs | | x_utf_bb_convert_session | | x_utf_bb_convert_session_tables | +------------------------------------+ I suspect somehow x_utf_bb_tables are culprit, as they contain something that breaks the upgrade. Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 29, 2021 Author Share Posted December 29, 2021 The files that the UPGRADE complains about are missing. They are not in my download. And odd is that it happens BEFORE checking my license settings or something. So basically I assume it gathers info from database and assumes I SHOULD have those files, before checking license. On 12/23/2021 at 1:15 PM, Marc Stridgen said: This is being dealt with on your ticket, but the issue here is that you have IP.Content installed on 3.1 Any idea on how to deal with this? Link to comment Share on other sites More sharing options...
Stuart Silvester Posted December 29, 2021 Share Posted December 29, 2021 10 hours ago, dutchsnowden said: The files that the UPGRADE complains about are missing. They are not in my download. And odd is that it happens BEFORE checking my license settings or something. So basically I assume it gathers info from database and assumes I SHOULD have those files, before checking license. Any idea on how to deal with this? We're still looking at this via the accounts ticket. As noted above, the problem is that your database has Pages/IP.Content installed but your license does not have that application included at this time. I have asked our accounts department a question about this and they'll reply as soon as they can. dutchsnowden 1 Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 29, 2021 Author Share Posted December 29, 2021 (edited) Thank you so much. I am eagerly awaiting for it! I don't use Pages lately (last 3-4 years) but if needed, I can renew that app too if it is easier. Edited December 29, 2021 by dutchsnowden Link to comment Share on other sites More sharing options...
Stuart Silvester Posted December 29, 2021 Share Posted December 29, 2021 If you don't use it, you can uninstall it in 3.1 before upgrading. You shouldn't run into the issue then. Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 29, 2021 Author Share Posted December 29, 2021 I would rather not, as you never know if in the future I will. So better to renew it. Furthermore, I am working currently on a testinstall, I cannot uninstall anything. Just making a procedure for upgrade. As I am sick of thinking I hit such problems on the live server, then wait days to solve them. I want to be able to take it offline 24h, do the upgrade and be back online, knowing all the problems. It is a nightmare. How can I renew that one too? Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 30, 2021 Author Share Posted December 30, 2021 On 12/29/2021 at 12:35 PM, Stuart Silvester said: We're still looking at this via the accounts ticket. As noted above, the problem is that your database has Pages/IP.Content installed but your license does not have that application included at this time. I have asked our accounts department a question about this and they'll reply as soon as they can. We are still waiting for their answer, right? It's just slow because holidays? Asking because it is painful not to be able to do anything. Link to comment Share on other sites More sharing options...
Marc Posted December 30, 2021 Share Posted December 30, 2021 6 minutes ago, dutchsnowden said: We are still waiting for their answer, right? It's just slow because holidays? Asking because it is painful not to be able to do anything. Yes, this would be due to the holidays. Please note, that just because you remove the application on 3.x, ,if you have the license for it you can still install it in the future. My colleagues comment was a way to help you forward Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 30, 2021 Author Share Posted December 30, 2021 (edited) I fully understand and I am thankful for suggestion. However, I am not sure how to do this. I will explain why... I am not willing to touch anything on the main production forum, until I know the duration for it being offline, especially now during holidays when it takes so much to get an answer, added to time zone differences. Chances are I will try, hit a snag and there will be no way back and not knowing how to get it to work from that point. That would mean days/weeks offline. So all I can do for test install is work ONLY with the bare database on a empty brand new OS. Upgrade should not reuse any of old files, so it should work. So no idea how to install/uninstall the 3.1.4 active version on the brand new TESTINSTALL server. I tried upgrading to 3.4 but got hit with another error about empty calendar date, and installation stopped. Edited December 30, 2021 by dutchsnowden Link to comment Share on other sites More sharing options...
Marc Posted December 30, 2021 Share Posted December 30, 2021 You should test your site is fully functional on the test server before you begin an upgrade, as you have no way of knowing its functioning correctly before you begin. Then you should upgrade by uploading files over the original set. If you are not doing it in this manner, you are actually doing this in a manner differently to what is described in our documentation. If you are looking to 'clean up', that can be done after upgrading if needed. So you should be able to uninstall on the test instance also. Note, we do not support 3.x in any way, so support time would not be relevant in this scenario also. Link to comment Share on other sites More sharing options...
dutchsnowden Posted December 30, 2021 Author Share Posted December 30, 2021 I fully understand but chances are I will hit the exact same file check error, regardless of what I do, except uninstall something as you suggested. And I would like not to do that for now. Funny thing is, somehow I got over this step a few times and after introducing license, it mentioned I do not have CMS so that part won't upgrade. But not on this step! Not sure why installer expects to check what files I have before introducing license and knowing what license includes. Make sense? Link to comment Share on other sites More sharing options...
dutchsnowden Posted January 3, 2022 Author Share Posted January 3, 2022 I kindly ask that we somehow solve this issue today? I purchased this on Dec 12 (soon 2 weeks) and I am still not able to get over this step. I do not want to uninstall anything from old to upgrade, but I will pay what is needed to make upgrade work. I understand part is my fault and it was over holidays, but still it is a long period not being able to use my license. Link to comment Share on other sites More sharing options...
Jim M Posted January 3, 2022 Share Posted January 3, 2022 4 hours ago, dutchsnowden said: I kindly ask that we somehow solve this issue today? I purchased this on Dec 12 (soon 2 weeks) and I am still not able to get over this step. I do not want to uninstall anything from old to upgrade, but I will pay what is needed to make upgrade work. I understand part is my fault and it was over holidays, but still it is a long period not being able to use my license. Sorry, your ticket is still open and we are working towards the issue. Due to the holidays and the department your ticket is in was closed, the issue has been delayed longer than normal and for that I apologize. However, as we are back in the office this week, our teams will be working towards a resolution for you. dutchsnowden 1 Link to comment Share on other sites More sharing options...
dutchsnowden Posted January 3, 2022 Author Share Posted January 3, 2022 Do we have an estimate? I really need getting over this step. Link to comment Share on other sites More sharing options...
Jim M Posted January 3, 2022 Share Posted January 3, 2022 4 minutes ago, dutchsnowden said: Do we have an estimate? I really need getting over this step. I am sorry, there is no estimate at this current time. Link to comment Share on other sites More sharing options...
Recommended Posts