Mike456 Posted December 15, 2022 Share Posted December 15, 2022 (edited) Hi guys, So the problem is that I can't update to the latest version as there are some errors in the database, self fix did not repair them. I tried to do it myself, but I don't have any programming background, and I installed the forum using youtube guide. I know how to enter PhP My Admin etc, but I don't know what to do once I'm there and instructions described in forum pop-up do not mean much to me. Would someone be able to guide me step by step to fix this? Thanks! Edited December 15, 2022 by Mike456 Link to comment Share on other sites More sharing options...
opentype Posted December 15, 2022 Share Posted December 15, 2022 In phpMyAdmin, select the database (if it is not selected yet), then go to the tab labelled “SQL”. You will see a field there where you can paste the the UPDATE and the ALTER TABLE code. Then just click OK. Mike456 1 Link to comment Share on other sites More sharing options...
Mike456 Posted December 15, 2022 Author Share Posted December 15, 2022 (edited) Hi opentype, thank you for pointing me in the right direction. I did as you told me, but it did not fix the issue. This is what I got in phpMyAdmin after pasting these 2 tasks in there. Edited December 15, 2022 by Mike456 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 16, 2022 Share Posted December 16, 2022 That is the correct response from mysql you would expect on running those. It should now allow you to do the upgrade. If you are still seeing those issues, please upload a fresh set of files from your client area, and run the upgrader from /admin/upgrade instead as its likely you are seeing a bug there Mike456 1 Link to comment Share on other sites More sharing options...
Mike456 Posted December 16, 2022 Author Share Posted December 16, 2022 Yes I'm having more issues. I tried to upload all the files from client area and run upgrade - but it lists me paths to files in red, and tells me that if these were uploaded correctly then to fix permissions. I fixed permissions and still the same problems. So I decided to run a fresh install, deleted everything and installed forum. But then database does not want to import/work correctly, there is one error saying that calendar table is already in the database. Then when I continue to forum, it's broken, user accounts are not imported etc, forums seem to be imported together with posts, but even ACP does not work as it should and I'm getting errors. I decided to delete everything once more, upload the old backup and use it with old database. Was there some major change to databases in versions 4.x.x? I don't understand what is going on, and why old database (version 4+ too) did not want to work on latest forum? Link to comment Share on other sites More sharing options...
Miss_B Posted December 17, 2022 Share Posted December 17, 2022 12 hours ago, Mike456 said: Yes I'm having more issues. I tried to upload all the files from client area and run upgrade - but it lists me paths to files in red, and tells me that if these were uploaded correctly then to fix permissions. I fixed permissions and still the same problems. So I decided to run a fresh install, deleted everything and installed forum. But then database does not want to import/work correctly, there is one error saying that calendar table is already in the database. Then when I continue to forum, it's broken, user accounts are not imported etc, forums seem to be imported together with posts, but even ACP does not work as it should and I'm getting errors. I decided to delete everything once more, upload the old backup and use it with old database. Was there some major change to databases in versions 4.x.x? I don't understand what is going on, and why old database (version 4+ too) did not want to work on latest forum? When you did a fresh install, did you install the latest version? If you did, you should run the upgrader so the database containing the backup of the previous version should be upgraded too so it can match the forum files version. It is better to not delete everything, because that might cause errors especially with third party plugins/apps that result as installed but their files can not be found. Can you post the error messages that you got as that can help in pinpointing the issues. Mike456 1 Link to comment Share on other sites More sharing options...
Mike456 Posted December 18, 2022 Author Share Posted December 18, 2022 I will come back to this issue in January and post step by step everything that is happening with screenshot included. Thank you guys, Happy Christmas! Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 19, 2022 Share Posted December 19, 2022 Have a good christmas. Absolutely dont attempt the "fresh install" route by the way. There is no such method, and you are likely to make things worse. I would revert that. If you are having issues with the files showing as not changed, thats what needs looking at Mike456 1 Link to comment Share on other sites More sharing options...
Adika Posted December 20, 2022 Share Posted December 20, 2022 (edited) Hello. I have this same issue. When I tried to fix the database myself, it has now made the admin panel and site inaccessible. Any advice? I do not have server access and work through my server host for things outside the admin panel. Currently, I am receiving a message that states Resource Limit Is Reached The website is temporarily unable to service your request as it exceeded resource limit. Please try again later. Edited December 20, 2022 by Adika Mike456 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 20, 2022 Share Posted December 20, 2022 You would need to contact your hosting company regarding this issue. Its likely this is what has been causing you the problems. You are out of resource on your server Mike456 1 Link to comment Share on other sites More sharing options...
Adika Posted December 20, 2022 Share Posted December 20, 2022 12 hours ago, Marc Stridgen said: You would need to contact your hosting company regarding this issue. Its likely this is what has been causing you the problems. You are out of resource on your server Thanks. The host has cleared the resource limit, but now I'm seeing formatting text when I try to access the admin panel: Mike456 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 21, 2022 Share Posted December 21, 2022 If the only thing that has changed is what your hosting changed, I could start off by asking them to check their changes there Mike456 1 Link to comment Share on other sites More sharing options...
Randy Calvert Posted December 21, 2022 Share Posted December 21, 2022 It looks like the host is just serving the raw files instead of parsing PHP properly. The host needs to fix your instance to properly parse PHP files. Mike456 1 Link to comment Share on other sites More sharing options...
Adika Posted December 23, 2022 Share Posted December 23, 2022 On 12/21/2022 at 1:24 PM, Randy Calvert said: It looks like the host is just serving the raw files instead of parsing PHP properly. The host needs to fix your instance to properly parse PHP files. Thank you. I have reached out to them as of this morning with your suggestion. This is far beyond my level of expertise and if it cannot be resolved, I will have to just end my site and let my Invision license expire. It’s been a great run. Mike456 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 27, 2022 Share Posted December 27, 2022 Sorry to hear you feel that way. If you are unsure on hosting items, are you interested in our cloud solution? We can help you get your site moved over for you if needed Mike456 1 Link to comment Share on other sites More sharing options...
Mike456 Posted January 16, 2023 Author Share Posted January 16, 2023 Hi guys, So I'm trying again. Running these 2 commands in SQL did not solve the problem, so I uploaded the latest community files from Client Area. I run url/admin/upgrade and upon sign in I get that (long list of files in applications folder, what should I do now?): Link to comment Share on other sites More sharing options...
Solution teraßyte Posted January 16, 2023 Solution Share Posted January 16, 2023 (edited) Looks like you have the converter application installed but didn't upload the updated files for it. When downloading the zip from your client area there is a checkbox you need to select in order to include the Convert application in the download. Re-download the zip with the checkbox selected and then upload again the files to your server. Once you do that the errors should all go away. Edited January 16, 2023 by teraßyte Mike456 1 Link to comment Share on other sites More sharing options...
Miss_B Posted January 16, 2023 Share Posted January 16, 2023 25 minutes ago, Mike456 said: I run url/admin/upgrade and upon sign in I get that (long list of files in applications folder, what should I do now?): First, make sure that all the files mentioned in that screen are overwritten with those from the latest package. If you still will get the error, you should try and chmodd the aforementioned files. Mike456 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted January 16, 2023 Share Posted January 16, 2023 As mentioned by terabyte there. It looks like the converter checkbox simply hasnt been checked when downloading Mike456 1 Link to comment Share on other sites More sharing options...
Mike456 Posted January 16, 2023 Author Share Posted January 16, 2023 Thank you guys, I did as terabyte said and the forum is upgraded and working now. Once more, thanks for all the posts and support, I would not be able to figure out what to do on my own! Link to comment Share on other sites More sharing options...
Mark H Posted January 16, 2023 Share Posted January 16, 2023 You're welcome, we're glad to hear the problem is resolved and your site is working again. 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts