• Resolved lilloabroad

    (@lilloabroad)


    Hallo,
    I am having a (big) problem with my website http://www.sanmatteo.fr
    I was configuring the settings of the plugin and suddenly I could not access the website anymore.
    I maybe configured the wrong settings (DB)?
    What I get now is the wp installation page. I cannot login into the site, I can only install wp again which would mean loosing my data, I assume.
    I could not restore an old version of the site through the server-backup. It doesn’t work.
    Could you please tell me how to fix this problem? The site was on the verge to go online, customer is obviously very unhappy. I have a back up of the wp-config
    Thanks a lot
    Lillo

    https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi Lillo, please read the following documentation. Let me know if you need more help.

    Thank you

    Thread Starter lilloabroad

    (@lilloabroad)

    Hi,
    unfortunately I don’t have a copy of the ht access file,only of the wp-config file.
    What would happen if I install wordpress again? Would I loose the previous configuration and the data? I have back up, not sure if it works
    Thanks a lot
    Silvio

    Thread Starter lilloabroad

    (@lilloabroad)

    The current htaccess

    # BEGIN WordPress
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index\.php$ – [L]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    </IfModule>

    # END WordPress

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, are you now able to access your site?

    Thread Starter lilloabroad

    (@lilloabroad)

    No, the hosting provied told me to re-install wp.
    It did not work.
    I installed wp again. Hopefully I will be able to save the data I backed up.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Where are you up to with your issue? Can you now access your site after you installed WordPress again?

    Thread Starter lilloabroad

    (@lilloabroad)

    I can access the site now, but obviously all files are lost.
    Unfortunately my hosting provider (register.com) did not reply to my ticket yet. Maybe you can help me. I have backed up all files in compressed format tar.gz.
    Do you think it would work if I upload all them via ftp? By doing that, would I overwrite the current files.
    Is this the right way to proceed? The alternative is to write all pages again.
    Thanks a lot
    Silvio

    Hi Silvio,

    The content of pages/posts etc. is not stored on FTP, but in a database. So depending on how you made the reinstall, it might or might not still be there. Did you use the same database name for the reinstall?

    As for the FTP, you usually need to only upload contents of your wp-content folder when you are restoring from backup, but you might want to skip wp-content/plugins/all-in-one-wp-security-and-firewall, if you suspect that the plugin is causing your troubles.

    Cheers,
    Česlav

    Plugin Contributor wpsolutions

    (@wpsolutions)

    Hi Silvio,
    Although you haven’t really provided detailed info regarding which features you activated that may have caused your problem, I will assume that you tried to change your DB prefix.

    Did you take a database backup before you did the changes?

    If so, then you should restore your DB using MySQL. (ask your host provider to help you if you don’t know how)

    After you restore your DB then you should also restore your original wp-config.php file.
    If you don’t have a copy of your original wp-config.php file then edit the existing file and look for the line which says:
    $table_prefix = 'wp_';

    Edit that line to match the prefix of your wp tables BEFORE everything broke.

    Thread Starter lilloabroad

    (@lilloabroad)

    Hi Česlav,
    I made a back-up through der plugin, so yes, I have one (.zip compressed)
    There is a server back up service provided by the hosting. But it doesn’t work. When I restore any db the installation page of wp is displayed and I have to re-install wp.
    The hosting provider (register.it) wrote to me they do not provide any assistance with back-ups.

    Unfortunately, I do not have much experience with MySQL. What should I use? MyPhPAdmin, MySQL Database, MySQL Database wizard or Remote MySQL?
    Do you think you could tell me what I should do?

    I have to say that I never experienced such a low quality assistance by an hosting provider

    Thread Starter lilloabroad

    (@lilloabroad)

    Hi,
    I could upload the DB but I do not see any change in the dashboard. There are still no pages or any other contents there…
    How does it come?
    Silvio

    Thread Starter lilloabroad

    (@lilloabroad)

    Ehi,
    …it worked!
    Many many thanks Česlav!!
    Can I somehow post a comment to “say thank to you”?
    Thanks a lot, let me know…
    Silvio

    Hi Silvio,

    I’m glad you’ve managed to get your site back.

    As for the database management tool, I can recommend Adminer. Unlike phpMyAdmin, Adminer comes in a single file, but it has almost the same functionality and much cleaner interface.

    If you’re going to give the All In One WP Security & Firewall another try, be careful when activating the features. Read all information on the page and perform recommended actions! If you’re going to try to “rename your database prefix”, be sure to make a database backup in advance. As @wpsolutions mentioned above, most likely this was the feature that caused trouble on your website.

    I’m marking the topic as resolved for now, but feel free to open a new one if you have any other problems/questions.

    Greets,
    Česlav

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘WP All in One security problem’ is closed to new replies.