Jump to content

File Check errors


dutchsnowden
Go to solution Solved by Marc,

Recommended Posts

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

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.

image.thumb.png.a7836c8c2f639573c537bf3c01a5feff.png

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

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

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.

Link to comment
Share on other sites

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

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

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

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 by dutchsnowden
Link to comment
Share on other sites

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

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

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

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.

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...