WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Website is now Blank Please Help (14 posts)

  1. methane47
    Member
    Posted 1 year ago #

    Good Evening all. I have a big problem.
    So i've had a WordPress website up and running for a year now and its been fine. It was setup in the root folder directly in \Public

    Today i decided to see about creating a subfolder WordPress Site where I could test new themes.

    I ran the installer in \Public\Trial

    As soon as that finished I tried to access the site and I noticed I was not able to access my root website any more (AAA.com) It was just showing a blank white screen.

    I was now only able to access (AAA.com\Trial) I then went to settings and changed the url for the website back to AAA.com

    But now AAA.com is still blank. I've tried restoring the Public folder, i've tried restoring the Mysql database. But For some reason I am still just seeing a white screen.

    After restoring backups my wp-admin from the root site can see my custom Theme but there is nothing in it. And I cannot see any posts or anything. :(

    Please help me. What can I do to get my main site up and running again.

  2. Krishna
    Volunteer Moderator
    Posted 1 year ago #

    Site URL?

  3. methane47
    Member
    Posted 1 year ago #

    The true site URL?
    anteksxm.com

    I did some messing around and now the page displays a little bit. I dont know if securities are completely screwed or something

  4. Krishna
    Volunteer Moderator
    Posted 1 year ago #

    See if you can login:
    http://anteksxm.com/wp-login.php

  5. methane47
    Member
    Posted 1 year ago #

    Krishna - I can log in fine, access the Management. It all works, the actual content of the website is not working. And I have no idea why not.

    I can go and select the Theme but the theme has no preview and if you go to the actual website itself, you can see all it currently shows is the blue background and a little formatting.

    Is there anything in the database that needs to change to enable it?
    I set permissions for my website to be 755 should they be different anywhere else?
    Is there some text i need to stick in the htaccess file? or wp-config file? to get this to work?

  6. Krishna
    Volunteer Moderator
    Posted 1 year ago #

    Did you check for your posts, media, etc? Don't you have any installed themes? Can you try these?

    And do you have backups? Because your site shows ZERO content, you may need to restore everything from backup.

  7. methane47
    Member
    Posted 1 year ago #

    Ok so what i did now is I restored the Public folder from backup and also restored the database from backup.

    Now the site is visible again and most functions work. But the Database is messed up. When i import the database i get the following error:

    #1062 - Duplicate entry '' for key 'group_system_id'

    The problem here is that the schema has the group system id as UNIQUE. but apparently the data is not unique. Because of this i believe the system does not fully import the database as only the following databases are created:

    wp_commentmeta
    wp_comments
    wp_download_monitor_files
    wp_download_monitor_file_meta
    wp_download_monitor_formats
    wp_download_monitor_log
    wp_download_monitor_relationships
    wp_download_monitor_stats
    wp_download_monitor_taxonomies
    wp_ezpz_ocb_settings
    wp_links
    wp_mappress_maps
    wp_mappress_posts
    wp_media_player_stats
    wp_newsletter
    wp_newsletter_profiles
    wp_ngg_album
    wp_ngg_gallery
    wp_ngg_pictures
    wp_options
    wp_postmeta
    wp_posts
    wp_ps_groups
    wp_ps_group_relationships

    It appeares as if there are a few tables missing, But all my database backups give the same error when importing with PHPMYADMIN.

    So current status is that the site is up again, but somethings do not work like adding users (i assume this is because there is no user database) Anyway to edit the DB-GZ before i import it?

  8. maoski
    Member
    Posted 1 year ago #

    Are you importing to a fresh empty database (no tables) e.g create a database via phpmyadmin then import the backup/tables?

  9. methane47
    Member
    Posted 1 year ago #

    Yes. The first time i did it, i imported into the existing database. Since then I have deleted the database recreated with the same name and imported again, same error.

  10. maoski
    Member
    Posted 1 year ago #

    Longshot but - try another (DB) name - sorry i should of explained more - what would do as a process of elimination is delete database, create a new database with a totally different name, then import backup into it. See if the tables are all imported. change the config file to reflect new database name, if it works that is.

  11. maoski
    Member
    Posted 1 year ago #

    oh i hope you are doing this locally on a test server if not i strongly recommend it

  12. maoski
    Member
    Posted 1 year ago #

    sorry one more thing that i would like to mention, i have download-monitor as-well and it keeps an access log in the database that can get quite large if not flushed periodically. This plays havoc with my hosts PHPmyAdmin export tool and wont let me export a zip file (it exports the file but with no tables) so i have to export as a raw sql file. Could be related?

  13. methane47
    Member
    Posted 1 year ago #

    Actually this website is the website for the company i work for. And i just wanted to make some small changes, I managed to break the entire thing... But anyways ...

    Thanks for the suggestions but I believe i just resolved it.

    Soooooo Here is what i did. So i realized that my backup db import was probably dropping the current Databases everytime it attempted to import.

    So i took a gamble and extracted the db.gz file and opened it in Notepad. From there i located my problem child table (wp_ps_groups) and manually inserted a value for the Group Id field. I then gzipped it back up. And imported it in phpmyadmin. And now everything is up and running again..

    WHEWWWWwwwww....

  14. Krishna
    Volunteer Moderator
    Posted 1 year ago #

    Sorry, I took a break. But I understand that you could make corrections to your database and you are up and running again. Congratulations!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.