• Resolved flaminmad

    (@flaminmad)


    Before installing Optimole plugin, I backed up my wordpress site using WPVivid backup & restore. Then I installed Optimole successfully. Next, I restored my backed up version. But now MOST of my posts and pages are returning 404 errors, and do not show in the WP admin panel. However, I can see the post entries in my WP database using PHPMyAdmin.

    The only pages that do not return 404 errors are those that contained no images. Optimole is an image optimizer plugin, so it seems likely WPVivid conflicts with Optimole.

    Any pointers on how to fix this situation? The data seems to exist in my WP database, but somehow WP admin is not finding it.

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

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support tonyrobins

    (@tonyrobins)

    Hello @flaminmad

    First, we would recommend you to restore the backup without installing the Optimole plugin.

    If pages are normal after the restore, then you can install Optimole and restore again.

    This way we will know whether it’s a plugin conflict issue and offer further suggestions.

    Kind Regards,

    Hi Tony,

    I see this warning in the WPVivid restore log “[2020-08-12 17:32:09][Warning]wpdb”, followed many lines that say “[notice]Drop table if exist”

    Here’s the entire restore log, maybe it you can spot my issue:

    Log created: 2020-08-12 17:25:05
    Type: restore
    [2020-08-12 17:25:05][notice]init restore data
    [2020-08-12 17:25:05][notice]Start restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_all.zip
    [2020-08-12 17:25:05][notice]extract root:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/
    [2020-08-12 17:25:05][notice]start extracting file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_all.zip
    [2020-08-12 17:29:09][notice]extract finished file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_all.zip
    [2020-08-12 17:29:09][notice]Finished restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_all.zip
    [2020-08-12 17:29:10][notice]Start restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_plugin.zip
    [2020-08-12 17:29:10][notice]restore from files:[“\/home\/g61vqqb6xfib\/public_html\/wp-content\/wpvividbackups\/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_plugin.zip”]
    [2020-08-12 17:29:10][notice]start extracting file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_plugin.zip
    [2020-08-12 17:30:17][notice]extract finished file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_plugin.zip
    [2020-08-12 17:30:17][notice]Finished restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_plugin.zip
    [2020-08-12 17:30:19][notice]Start restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_core.zip
    [2020-08-12 17:30:19][notice]restore from files:[“\/home\/g61vqqb6xfib\/public_html\/wp-content\/wpvividbackups\/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_core.zip”]
    [2020-08-12 17:30:19][notice]start extracting file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_core.zip
    [2020-08-12 17:31:09][notice]extract finished file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_core.zip
    [2020-08-12 17:31:09][notice]Finished restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_core.zip
    [2020-08-12 17:31:11][notice]Start restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_uploads.zip
    [2020-08-12 17:31:11][notice]restore from files:[“\/home\/g61vqqb6xfib\/public_html\/wp-content\/wpvividbackups\/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_uploads.zip”]
    [2020-08-12 17:31:11][notice]start extracting file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_uploads.zip
    [2020-08-12 17:31:38][notice]extract finished file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_uploads.zip
    [2020-08-12 17:31:38][notice]Finished restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_uploads.zip
    [2020-08-12 17:31:40][notice]Start restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_themes.zip
    [2020-08-12 17:31:40][notice]restore from files:[“\/home\/g61vqqb6xfib\/public_html\/wp-content\/wpvividbackups\/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_themes.zip”]
    [2020-08-12 17:31:40][notice]start extracting file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_themes.zip
    [2020-08-12 17:31:55][notice]extract finished file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_themes.zip
    [2020-08-12 17:31:55][notice]Finished restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_themes.zip
    [2020-08-12 17:31:56][notice]Start restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_content.zip
    [2020-08-12 17:31:56][notice]restore from files:[“\/home\/g61vqqb6xfib\/public_html\/wp-content\/wpvividbackups\/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_content.zip”]
    [2020-08-12 17:31:56][notice]start extracting file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_content.zip
    [2020-08-12 17:31:56][notice]extract finished file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_content.zip
    [2020-08-12 17:31:56][notice]Finished restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_content.zip
    [2020-08-12 17:31:58][notice]Start restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_db.zip
    [2020-08-12 17:31:58][notice]start extracting file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_db.zip
    [2020-08-12 17:32:09][notice]extract finished file:/home/g61vqqb6xfib/public_html/wp-content/wpvividbackups/whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_db.zip
    [2020-08-12 17:32:09][notice]sql file: whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_db.sql
    [2020-08-12 17:32:09][Warning]wpdb
    [2020-08-12 17:32:09][notice]The test to create table succeeds.
    [2020-08-12 17:32:09][notice]The test to insert into table succeeds.
    [2020-08-12 17:32:09][notice]The test to drop table succeeds.
    [2020-08-12 17:32:09][notice]get max_allowed_packet wpdb
    [2020-08-12 17:32:09][notice]Start import sql file.
    [2020-08-12 17:32:09][notice]old site url:https://whalesfirst.com
    [2020-08-12 17:32:09][notice]old home url:https://whalesfirst.com
    [2020-08-12 17:32:09][notice]old content url:https://whalesfirst.com/wp-content
    [2020-08-12 17:32:09][notice]old upload url:https://whalesfirst.com/wp-content/uploads
    [2020-08-12 17:32:09][notice]old site prefix:wp_
    [2020-08-12 17:32:09][notice]Drop table if exist
    [2020-08-12 17:32:09][notice]Create table wp_commentmeta
    [2020-08-12 17:32:09][notice]Drop table if exist
    [2020-08-12 17:32:09][notice]Create table wp_comments
    [2020-08-12 17:32:09][notice]Drop table if exist
    [2020-08-12 17:32:09][notice]Create table wp_links
    [2020-08-12 17:32:09][notice]Drop table if exist
    [2020-08-12 17:32:09][notice]Create table wp_options
    [2020-08-12 17:32:09][notice]Drop table if exist
    [2020-08-12 17:32:09][notice]Create table wp_postmeta
    [2020-08-12 17:32:10][notice]Drop table if exist
    [2020-08-12 17:32:10][notice]Create table wp_posts
    [2020-08-12 17:32:17][notice]Drop table if exist
    [2020-08-12 17:32:17][notice]Create table wp_term_relationships
    [2020-08-12 17:32:17][notice]Drop table if exist
    [2020-08-12 17:32:17][notice]Create table wp_term_taxonomy
    [2020-08-12 17:32:17][notice]Drop table if exist
    [2020-08-12 17:32:17][notice]Create table wp_termmeta
    [2020-08-12 17:32:17][notice]Drop table if exist
    [2020-08-12 17:32:17][notice]Create table wp_terms
    [2020-08-12 17:32:17][notice]Drop table if exist
    [2020-08-12 17:32:17][notice]Create table wp_usermeta
    [2020-08-12 17:32:17][notice]Drop table if exist
    [2020-08-12 17:32:17][notice]Create table wp_users
    [2020-08-12 17:32:18][notice]Finished restoring whalesfirst.com_wpvivid-5f336e1ec1ae6_2020-08-12-04-20_backup_db.zip
    [2020-08-12 17:32:20][notice]Restore task completed.

    And I did try uninstalling Optimole but got same results with post data in database not being reflected in WP admin panel.

    Plugin Support tonyrobins

    (@tonyrobins)

    Hey @flaminmad

    Now we see. Thanks for your update.

    This can be a database service issue. Please go to WPvivid settings > Advanced settings > Choose PDO in Database Access Method > Save Changes, then try to restore again.

    If the issue still persists, can you please send us a debug zip from the plugin’s Debug tab to help troubleshoot the issue? When sending it, please include a link to this thread so that we can keep track of the details you have posted.

    Thanks,

    All the best

    I took a closer look at my database, and now see that the posts and pages are missing from the database too.

    Also, when trying to download my backups via the WPVivid admin panel, Part 02 shows size 0.

    I believe my data is lost. But it’d be great if we can prevent this from happening to someone else.

    Here’s my a link to my WPVivid Debug log:
    http://dinafisher.com/temp/wpvivid_server_info.json

    Here’s my site info from WPVivid admin panel:
    version 0.9.43
    home_url https://whalesfirst.com
    active_plugins akismet/akismet.php, elementor-pro/elementor-pro.php, elementor/elementor.php, google-analytics-for-wordpress/googleanalytics.php, updraftplus/updraftplus.php, wpvivid-backuprestore/wpvivid-backuprestore.php
    multisite disable
    web_server Apache
    php_version 7.3.20
    mysql_version 5.6.48
    wp_debug false
    language en-US
    upload_max_filesize 32M
    max_execution_time 900
    max_input_vars 1000
    timezone UTC+0
    OS Linux a2plcpnl0907.prod.iad2.secureserver.net 2.6.32-954.3.5.lve1.4.78.el6.x86_64 #1 SMP Thu Mar 26 08:20:27 EDT 2020 x86_64
    memory_current 44.08MB
    memory_peak 44.16MB
    memory_limit 256M
    post_max_size 32M
    allow_url_fopen 1
    safe_mode false
    pcre.backtrack_limit 1000000
    exif support
    xml support
    suhosin not support
    IPTC support
    extensions Core, date, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, gmp, SPL, iconv, pcntl, readline, Reflection, session, standard, shmop, SimpleXML, mbstring, tokenizer, xml, litespeed, bcmath, dom, fileinfo, gd, imagick, imap, inotify, intl, json, exif, mcrypt, mysqli, mysqlnd, PDO, pdo_mysql, pdo_sqlite, Phar, posix, soap, xmlreader, xmlrpc, xmlwriter
    apache_modules mod_rewrite, mod_mime, mod_headers, mod_expires, mod_auth_basic
    pdo_mysql support
    mysql_mode NO_ENGINE_SUBSTITUTION
    PclZip support
    wp_prefix wp_
    fast_cgi Off

    Plugin Support tonyrobins

    (@tonyrobins)

    Thank you @flaminmad

    We are going to check this out soon and will let you know updates.

    All the best

    Plugin Support tonyrobins

    (@tonyrobins)

    Hey @flaminmad

    We just checked your website and seems that you’ve restored it to normal.

    So now, can you please try to take a full backup (db+files) of the site again with the pdo option checked:

    Go to WPvivid settings > Advanced settings > Choose PDO in Database Access Method > Save Changes.

    Then restore the backup on a test site to see if the issue persists.

    Thanks,

    All the best,

    Plugin Support tonyrobins

    (@tonyrobins)

    Hey @flaminmad

    Since we haven’t heard from you for a while, I am going to mark the thread as resolved.

    Please feel free to let us know if you have any further questions.

    Kind Regards,

Viewing 8 replies - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.