Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
Cosmic Posted December 13, 2021 Posted December 13, 2021 hi there, i wiped out my server including the forums, i've restored the dastbase from a backup, but the forums code doesn't want to run although i have successfully got /forums//admin/install to run and which logged into the database ok as well. i can't get /forums or /forums/admin to run tho. anyone got any ideas please? thanks.
Cosmic Posted December 13, 2021 Author Posted December 13, 2021 hi there, hope somone can help me get my forums going again - thanks
Miss_B Posted December 13, 2021 Posted December 13, 2021 39 minutes ago, dancingbear said: hi there, i wiped out my server including the forums, i've restored the dastbase from a backup, but the forums code doesn't want to run although i have successfully got /forums//admin/install to run and which logged into the database ok as well. i can't get /forums or /forums/admin to run tho. anyone got any ideas please? thanks. What do you mean by forums code does not want to run? Are you getting any errors when you load your forum url? If so, what errors are you getting? How exactly did you go about it? Did you install the latest version of Ipb or the version that corresponds with the database back?
Cosmic Posted December 13, 2021 Author Posted December 13, 2021 yes i mean the forums code doesn't want to run, no visible error at /forums/ the error below at /forums/admin Table 'databasename.ibf_core_sys_conf_settings' doesn't exist uploaded a backup i had of the forums directory, then overwrote that with a fresh download of the most recent forums code.
Randy Calvert Posted December 13, 2021 Posted December 13, 2021 If it says the table does not exist… either: - You are pointing to the wrong database. Did you edit you conf_global.php to specify your database details manually? - You did not restore the database correctly. Do you see the table in phoMyAdmin? - Your backup is corrupt.
Miss_B Posted December 13, 2021 Posted December 13, 2021 1 hour ago, dancingbear said: yes i mean the forums code doesn't want to run, no visible error at /forums/ the error below at /forums/admin Table 'databasename.ibf_core_sys_conf_settings' doesn't exist uploaded a backup i had of the forums directory, then overwrote that with a fresh download of the most recent forums code. The error message means that said table (the one mentioned in the error message) does not exist. When you say you uploaded a backup/restored a backup, was that a database backup, or did you restore/uploaded only the forums files?
Cosmic Posted December 13, 2021 Author Posted December 13, 2021 (edited) thanks for replyng, i'm aware that the message says a table doesn't exist.. the database i'm using is a restore of the mysql files from the disk My datadumps wouldn't import. i've just checked my test install of the foums, using a copy of the database from about a year ago that doesn't have that table either. Edited December 13, 2021 by dancingbear
Randy Calvert Posted December 13, 2021 Posted December 13, 2021 I just checked my live board. That table DOES exist in the most recent version of IPB. You might want to post in the main support forum. This looks to be beyond community (meaning peer to peer) help. By the way... one idea that I had... Do a FRESH install into a DIFFERENT database. Then export/import that table into your restored table. You would have to reset a bunch of preference settings, but that might at least get you back up and running.
Miss_B Posted December 13, 2021 Posted December 13, 2021 57 minutes ago, dancingbear said: thanks for replyng, i'm aware that the message says a table doesn't exist.. the database i'm using is a restore of the mysql files from the disk My datadumps wouldn't import. i've just checked my test install of the foums, using a copy of the database from about a year ago that doesn't have that table either. The backup is from a year ago and for an older version of the forum. If you installed the latest version of Ipb and then restored the backup, you must run the upgrader to bring the database up to date with the forum files. That being said, if you get table does not exist errors from your backup, then the backup most likely is corrupted I am afraid.
Randy Calvert Posted December 13, 2021 Posted December 13, 2021 You mentioned yourdomain.com/admin/install.... Did you try yourdomain.com/admin/upgrade? See if it will take care of catching you up to the correct table data?
Cosmic Posted December 14, 2021 Author Posted December 14, 2021 13 hours ago, Randy Calvert said: I just checked my live board. That table DOES exist in the most recent version of IPB. You might want to post in the main support forum. This looks to be beyond community (meaning peer to peer) help. By the way... one idea that I had... Do a FRESH install into a DIFFERENT database. Then export/import that table into your restored table. You would have to reset a bunch of preference settings, but that might at least get you back up and running. thanks i'll give that a go.
Cosmic Posted December 14, 2021 Author Posted December 14, 2021 16 hours ago, Randy Calvert said: You mentioned yourdomain.com/admin/install.... Did you try yourdomain.com/admin/upgrade? See if it will take care of catching you up to the correct table data? i've tried upgrade, northing happens. 16 hours ago, Randy Calvert said: I just checked my live board. That table DOES exist in the most recent version of IPB. You might want to post in the main support forum. This looks to be beyond community (meaning peer to peer) help. By the way... one idea that I had... Do a FRESH install into a DIFFERENT database. Then export/import that table into your restored table. You would have to reset a bunch of preference settings, but that might at least get you back up and running. cant get a fresh install to work, could someone please post the SQL to create that table.
DawPi Posted December 14, 2021 Posted December 14, 2021 CREATE TABLE IF NOT EXISTS `core_sys_conf_settings` ( `conf_id` int(11) NOT NULL AUTO_INCREMENT, `conf_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `conf_value` mediumtext COLLATE utf8mb4_unicode_ci, `conf_default` text COLLATE utf8mb4_unicode_ci, `conf_keywords` text COLLATE utf8mb4_unicode_ci, `conf_app` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `conf_plugin` bigint(20) UNSIGNED DEFAULT NULL, `conf_report` enum('full','bool') COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`conf_id`), UNIQUE KEY `conf_key` (`conf_key`) ); Don't forget about prefix if you have one. SeNioR- 1
Cosmic Posted December 14, 2021 Author Posted December 14, 2021 thank you, have now created the table and am still getting the error msg, for the same table of the same name as i just created. dammit.
Cosmic Posted December 14, 2021 Author Posted December 14, 2021 i cant get a response from IPB SUPPORt, can anyone give them a nudge please?
Randy Calvert Posted December 14, 2021 Posted December 14, 2021 Community Support is a peer to peer help forum. There is another spot for official IPS help. https://invisioncommunity.com/forums/forum/497-help-support Good luck. 🙂
Marc Posted December 14, 2021 Posted December 14, 2021 1 hour ago, dancingbear said: i cant get a response from IPB SUPPORt, can anyone give them a nudge please? I have just come on here to send a PM to you directly. Please check your spam filters, as we have answered each of your support requests. The issue you have there is a missing table. You would need to restore that from your last backup. As mentioned above by Randy, that is the official support area. You are posting in community support here, which is why you were only getting responses from the community.
Cosmic Posted December 14, 2021 Author Posted December 14, 2021 hi mark, northing in my spam folders. i've restored the table, as shown above.it would be great to get my forums running again. what info do you need from me to check it out, the old access info won't allow you access now , everything has been reset. lets get this fixed, thanks mark.
Marc Posted December 14, 2021 Posted December 14, 2021 You would need to restore it from your own backup, not create from the above. Have you done that?
Cosmic Posted December 14, 2021 Author Posted December 14, 2021 7 minutes ago, Marc Stridgen said: You would need to restore it from your own backup, not create from the above. Have you done that? mark my backup dumps won't unzip without errors, the backup i'm using is a recovery of the msq files on the servers disk (its the best copy i have of the data as my dump files wouldn't load back in - the problem isn't the data right now, the code won't run. its giving a 500 error. any help you can give will be appreciated. .
Marc Posted December 14, 2021 Posted December 14, 2021 The problem is indeed the data. That table still cannot be accessed at all. When you attempted a manual recreation of it, did you ensure you added your prefix as mentioned? I would suggest also contacting your email host to see what us happening with those emails, as they are being sent and you are not receiving them
Cosmic Posted December 14, 2021 Author Posted December 14, 2021 6 minutes ago, Marc Stridgen said: The problem is indeed the data. That table still cannot be accessed at all. When you attempted a manual recreation of it, did you ensure you added your prefix as mentioned? the created table has the prefix - so how do i get past this problem? 6 minutes ago, Marc Stridgen said: I would suggest also contacting your email host to see what us happening with those emails, as they are being sent and you are not receiving them there was a problem with my mail yesterday its working ok, now, thanks
Marc Posted December 14, 2021 Posted December 14, 2021 2 hours ago, dancingbear said: there was a problem with my mail yesterday its working ok, now, thanks I have responded this morning to your ticket. 2 hours ago, dancingbear said: the created table has the prefix - so how do i get past this problem? I would need to get someone to take a closer look, because according to the message there, its not present. Please respond to the ticket and we can get this escalated for you
Cosmic Posted December 14, 2021 Author Posted December 14, 2021 22 hours ago, Randy Calvert said: You mentioned yourdomain.com/admin/install.... Did you try yourdomain.com/admin/upgrade? See if it will take care of catching you up to the correct table data? install appears to login, and seems to do what it should upgrade does nothing but there shouldn't be anything to upgrade for my data. as i did the upgrade thing last time i wiped my forums, last week.
Marc Posted December 14, 2021 Posted December 14, 2021 So not run install. If you are getting install, it sounds like your conf_global isnt intact. Please respond to the ticket as mentioned
Recommended Posts