ClawOfWinterfell

I had this exact error message when I forgot to disable the third-party apps/plugins I used. Are you sure you've done this? The upgrade was flawless for me when I remembered to do this key step.

Sorry, it can automatically be corrected provided you remember to disable the apps and plugins. Otherwise, you can't get passed it.

Yes, I do use Redis. I bet this is it. It might explain why both sites have also got licence issues now. 😕 I know, I am not in any rush. I'm going to try to get the live site backup. I just don't want to make it more of a minefield, but I have all the data I need.

Actually, didn't upgrade my live site but the dev. Yet, it has gone all pear shaped. 😱 The live site is a complication of me screwing up somewhere along the way.

Hello, Miss_B. Yes, both versions have their own database. I made sure to change the dev's to point to its database, but for some reason it seems to have caused an issue with the live site. I am seeing similar errors, such as the theme suggesting it's out of date and to run the support tool. Logging into the ACP, it's all just text. I must have missed something, though I had done this process twice before trying to get the dev site to work with the beta of v5 (10) without hiccups to the live site. It's like the applications/plugins aren't enabled and that they are throwing errors. I could get a server log, but most pages are throwing errors now. The ACP throws this error, I have removed any reference to my site or install location. I'm very paranoid about being hacked again. 😞 OutOfRangeException: (0) #0 /home/example/domains/example.com/public_html/applications/nexus/Application.php(226): IPS\Application\_Module::get() #1 /home/example/domains/example.com/public_html/system/Dispatcher/Admin.php(352): IPS\nexus\_Application->acpMenu() #2 /home/example/domains/example.com/public_html/system/Dispatcher/Admin.php(68): IPS\Dispatcher\_Admin->buildMenu() #3 /home/example/domains/example.com/public_html/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Admin->init() #4 /home/example/domains/example.com/public_html/admin/index.php(13): IPS\_Dispatcher::i() #5 {main}

I've done something that has effected the live site.😢 Things seemed okay, but even though I changed the dev sites conf_global to point to the right direction. I've caused issues on the main site. PS. Once upon a time we were promised one upgrade, I never used it. I don't suppose that still exists? 😂 That's a j/k.

Sorry, I remembered only after my last post. I need to disable the plugins, and apps. I'll report back in awhile when I have re-backed up and re-imported everything. I bet this is causing the upgrade issues. 🤦🏻‍♂️

I got a bit further: It's sleep time. Upgrade Status Status: 1 Application: gallery Current Version: 5000012

Next Up: "Table 'prideofn_test.core_content_promote' doesn't exist". I had followed @Gary's advice, but I have since imported the missing part. So, it's in my datbase. No idea why I am getting this error in the upgrader now.

I have located the v5 beta 9.1 files, I'm going to try upload those and see if I can get past this issue. 🙂 I didn't come across it previously, the upgrade process was flawless. So, hopefully this can shed some light on why I can't get past the core_reputation_index.

Thanks, @Gary. I'm encountering "ALTER TABLE `core_reputation_index` ENGINE=InnoDB, ADD KEY `item_lookup` (`rep_class`,`item_id`,`reaction`);" I have followed the steps you provided by deleting the promoted.php file and dropping the 'promote'.

No, I am getting the same message again. ALTER TABLE `core_reputation_index` ENGINE=InnoDB, ADD KEY `item_lookup` (`rep_class`,`item_id`,`reaction`); The database is new. The imported database is from my live site, which is unconnected to any v5 updates. 😞 I switched back to PHP 8.1, as I forgot that it had been changed.

Sorry, you caught me in the process of clearing and re-starting again. I can get past the previous part I said I couldn't in the v5 upgrader, but then I hit a 500-page error.

Initially, I dropped everything in my old database. I have since deleted my development site's database, created a new one, and uploaded the working database of my version 4.7 site. However, I am still getting the same message despite this being a new database. ALTER TABLE `core_reputation_index` ENGINE=InnoDB, ADD KEY `item_lookup` (`rep_class`,`item_id`,`reaction`); The new database has nothing to do with my previous version 5 database. As I said, it's a fresh backup of my live version 4.7.19 site. 😞

I did everything fresh, so I dumped and restored a new backup from my live site. I had v4.19 running fine, so I proceeded to download a fresh set of beta 10 files from the client area. I then uploaded, and tried to install the update. To clarify, you are telling me to dump "ALTER TABLE core_reputation_index DROP KEY item_lookup;"? I don't want to interrupt what you mean incorrectly.

I wish trying to upgrade (fresh) from v4.19 to v5 beta 10 was as straight forward. *Sigh

I'm having issues with the v5 beta 10 upgrader. I am being told to run: ALTER TABLE `core_reputation_index` ENGINE=InnoDB, ADD KEY `item_lookup` (`rep_class`,`item_id`,`reaction`); But I get:

I have started to restore a new backup of my live site, so that I can run the upgrader again. This can be closed. I'll open a new one if I encounter errors. Sorry, it has become too much hassle to remotely try to fix the beta. I also politely note that uploading files six times likely means the issue isn't with missing files. It could be related to folder accessibility or another factor, but it's certainly not due to files being missing unless they aren't in the source.

For Dev sites, use. If you are 100% sure, I have found deleting the payment gateways in the test/dev area to be fine also. I don't think this would be recommended, but the code above didn't work for me due to my environment. It does if you are running NGINX.

I used the init.php from my backup before upgrading to v5. Is this safe? I assumed it would be okay since it was what I originally used. I'm afraid I still can't access the ACP, and the site is completely white. Could you please look at this new error log? It seems different from the first one and longer. Although it all goes over my head, if it turns out to be more of a headache, I'm happy to persist with repeating the upgrade from 4.7 to 5. https://www.noterip.com/view-note?Id=8c7ddb9b-d293-f995-c247-80574a29d375 -- Jim, You and the team work incredibly hard, and I appreciate your efforts. I don't wish to keep bringing things up, but I appreciate your response, apology, and explanation. I was trying my best to resolve the footer issue. I found the error, but I was only told that files were missing. Marc said, "You appear to be missing files and a table according to that message," which led me to check if the files were present. In hindsight, I believe the files were there, and something more complicated was happening. I'm not being difficult, but the response wasn't very detailed. I followed up with what I did, explaining that I uploaded fresh files, and at that stage, the site was still working with the footer error. I acknowledge that I could have been clearer, but when I saw the comment, "Please be respectful to those trying to assist you," about a simple emoji posted in frustration, it felt unjustified. I have documented my responses and what I have been doing. I never say I did something I didn't do, and I think it was clear the issue stemmed from the Beta 10 files I downloaded from the Client Area. I don't want to play the blame game, but I want to be clear that this has caused frustration on my end. I respect the team and love Invision as a product. I appreciate the apology and just want to move forward from this issue. Thank you.

Here's the server log: https://www.noterip.com/view-note?Id=4bdf531f-07c4-aa45-0dad-03c7892a47b6 It's password-protected, and that info is listed in my client area's notes.

I thought Invision might be interested, more so with the issues due to version, that it be bug, and my site only became inaccessible after downloading the v5 Beta 10. I find it weird the white pages and 505 errors came only after trying to make sure that there wasn't any files missing. Again, something which I reported but was overlooked. Why report errors, if dismissing the user or pasting a very generic response which is extremely unhelpful. I get that you guys are busy, I'm not remotely unreasonable but to take offence over frustration was rude. You guys are professionals, if a client isn't clear then please ask to clarify. Whilst I try to make sure I'm clear, I get that it might not come across that way. However, I was going in circles and again this is a place to report bugs and issues. Provided the majority aren't, I suppose that's fine but rudeness can be taken from my point of view too - especially when you repeatedly mention an issue only to be ignored.

I would not want to post any information publicly. Can you please escalate this further up the chain. Any information I am mindful about targeting by hackers.

Nothing I wrote was disrespectful. We're back to the generic responses, I have provided errors and generic replies were given. I have been asked if I had ran the upgrader, I have said my sites inaccessible before. I have mentioned that every step and actions I have taken without any practical support. Please don't try to be patronising, I've been more than fair.

It could be, but the previous download said 5 when I upgraded. I delete all files, so no previous ones are on my laptop. Not the zip's at least. 🙄