• Recovering a site with a badly damaged db, For the most part everything runs as it should with the exception of randomly disappearing content. All Images, no matter if I scan them with a recovery tool and add back to media folder, menu’s with disappearing links, etc… This is driving me NUTS!!!!

    Sample of my constantly rapid filling debug log:

    E_NOTICE: unserialize(): Error at offset 93 of 216 bytes in /sites/sites/********/public_html/wp-includes/functions.php on line 649

    E_DEPRECATED: Optional parameter $keyType declared before required parameter $notAfter is implicitly treated as a required parameter in /sites/sites/********/public_html/wp-content/plugins/ssl-zen/ssl_zen/lib/LEOrder.php on line 77

    E_DEPRECATED: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /sites/sites/*******/public_html/wp-includes/formatting.php on line 5397

    E_DEPRECATED: strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated in /sites/sites/******/public_html/wp-includes/functions.php on line 7045

    E_DEPRECATED: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /sites/sites/******/public_html/wp-includes/functions.php on line 2160

    • This topic was modified 1 year, 9 months ago by natekolvek.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi there!

    Usually, damaged databases are quite difficult to restore. This will require hands-on and some expertise to analyze the situation fully and see what could be done. I assume that you have cache on the website, and that’s why some content is appearing/disappearing randomly.

    I’ve found a similar occurrence right here.

    The best option would be to restore. Do you have a database from the time when it was not damaged and was working well? I’d suggest going with the restoration option if possible. If you don’t know how, please contact your hosting provider to get the needed help. Also, you could try this guide, it has some steps that could help you repair the database, though, chances are quite slim.

    If you don’t have a working backup and the latter option does not work, you might need to go over some of the other steps, such as

    • updating the plugins/themes;
    • reinstalling WordPress and starting clean.

    Let me know if this helps, good luck!

    Thread Starter natekolvek

    (@natekolvek)

    The only thing I had to start with besides the wp-content folder was a damaged .wpress file (all in one migration) I was able to extract the sql file from there but the site DB was already in damaged condition at the time this export was made. From there I only imported (with errors) the db and extracted just the tables for WC I found on a article and grabbed the extra WC tables they had not listed for restoration of a few plugins they use. I was able to create a new errorless import of just those tables and have been working from there. The product stuff looks good, all relevant data including extra meta’s imported, all columns detected in wc import correctly. Now I am trying to deal with these errors. I upgraded the DB to MariaDB 10.3 from MySQL 5.7 and removed the SYS db. The site runs on php 8.1 (from 7.4) and am left with these errors that are flooding the debug log and inflating fairly quick. I’ve eliminated some due to wrong syntax (using stackexchange posts, NULL instead of ”) but now I only have the same repeating errors. I can give you an account and install something like wp data access if you would like to look around? I don’t see it as a server misconfig because I would seem it in the logs somewhere so I’m convinced it’s somewhere in the db. the overall issue is menu’s wont save correctly and do things like changing home to a blank widget (along with others) in the menu editor, and images seem to disappear randomly and not return, they also do not display on the front page when changed in wpbakery (comes with template). They are still in the same place in the path, just not in the db. I either have to run an import again or rescan the media folders to add them back. there are over 2000 products so starting totally over was out of the question.

    • This reply was modified 1 year, 9 months ago by natekolvek.
    • This reply was modified 1 year, 9 months ago by natekolvek.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘php 8.1, TONS of unserialize and depreciated errors’ is closed to new replies.