Site Broken, autorepair doesnt work

  • erikoteh

    (@erikoteh)


    12 years, 2 months ago

    Hi!,
    First of all i must confess my experience with WP is small, and my knowledge in coding is less than average…
    i was trying a new theme on my multisite WP, For this I created a new SITE IE: /Example . since i didnt liked the theme i decided to just delete the whole site (/example) when in progress i received this error:
    “Error establishing a database connection”.
    And now i cant even browse my root nor anything… i only get that error

    after that i tried the autorepair function only to receive this message:

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.
    wp_posts: Table ‘soldoutf_wolfandrocks2.wp_posts’ doesn’t exist
    wp_comments: Table ‘soldoutf_wolfandrocks2.wp_comments’ doesn’t exist
    wp_links: Table ‘soldoutf_wolfandrocks2.wp_links’ doesn’t exist
    wp_options: Table ‘soldoutf_wolfandrocks2.wp_options’ doesn’t exist
    wp_postmeta: Table ‘soldoutf_wolfandrocks2.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘soldoutf_wolfandrocks2.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘soldoutf_wolfandrocks2.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘soldoutf_wolfandrocks2.wp_term_relationships’ doesn’t exist
    wp_commentmeta: Table ‘soldoutf_wolfandrocks2.wp_commentmeta’ doesn’t exist

    What should i do to fix this?
    I spent HOURS to finish my webpage for my business its going to suck to start all over again… is there any fix???

Viewing 7 replies - 1 through 7 (of 7 total)
  • dcleek

    (@dcleek)

    12 years, 2 months ago

    Can you log into your server with something like phpMyAdmin and verify that the database is still there?

    Thread Starter erikoteh

    (@erikoteh)

    12 years, 2 months ago

    Yeah, i was able to fix it, by reading all the threads and asking the server to make a small rollback..
    They fix the database.
    Nevertheless i lost all my media in my webpage… why did this happened?
    Luckly i made a backup a week ago.

    So, even when i have multiserver.. if i want to try a new template in a new site… i should install wordpress again and don’t mess with the multisite?
    which is the best option here?

    Thread Starter erikoteh

    (@erikoteh)

    12 years, 2 months ago

    I made a new root mysite.com/root1/root2
    and tried to install a new wordpress but its constantly redirecting me to the original wordpress instalation…
    this might be because of the multisite…

    so if i install a new template
    is there anyway for this new template to not mess with my old database?
    like if i import new tables, or stuff…
    which is the best way to handle this

    dcleek

    (@dcleek)

    12 years, 2 months ago

    When WordPress Multisite is enabled, there is no need to install WordPress multiple times. You can have as many sites as you want under one installation with one database. You can add a new site from the Network Admin – Sites – Add New menu.

    If you want a different theme on one of the sites, once you upload/install a new theme in the wp-content/themes folder, the theme needs to be either Network Enabled (from Network Admin – Themes) or Enabled on one of the sites in your Network (from Network Admin – Sites – Edit Site – Themes). Then, you can activate it on the site you want. Otherwise it will be hidden.

    Thread Starter erikoteh

    (@erikoteh)

    12 years, 2 months ago

    Hi Dcleek thanks for your answer!!
    So I get this about multisite instalations.

    Can you help me to solve this problem:

    If i install a new theme on a new site, and import the settings from the demo and stuff, there will be changes to the database… thus, if i regret this theme, or i want to make some changes (I.E delete this site, etc) i will lose some tables at my database again, and its a big mess.
    Is there anyway to solve this? like to use multisite with different databases for each site?

    Maybe im not seeing something coz of my lack of expertise… is there any advice to issue this?

    thank you

    dcleek

    (@dcleek)

    12 years, 2 months ago

    When you add content to a site, that information is stored in the database. If you change themes, the content stays no matter the theme. It only changes the look and how it is displayed. Some things that would change are your widget areas and menus. You’ll need to make sure you know what goes in which widget area and where the menus were displayed. Each theme handles widgets/menus differently.

    If you delete the site, yes those tables will be removed.

    Changing themes should not remove any database tables. However, your new theme may not have all of the same features.

    Try activating a different theme on that same site. Then, if you don’t like it, you can switch back by activating the older theme.

    It might be good to set up a testing environment locally for you to try out your themes before making them live.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 2 months ago

    To clarify one thing, theme options are normally saved in the wp_options table (or in the case of multisite wp_x_options where x is the site ID).

    Those options are only deleted if and when a theme is uninstalled via the WP admin panel. Even then, not all themes delete their options.

    The only ‘loss’ people tend to encounter with theme switching is widgets getting moved around.

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

The topic ‘Site Broken, autorepair doesnt work’ is closed to new replies.