MySQL Error while staging website

  • Resolved rshrayer

    (@rshrayer)


    4 months ago

    Hey,

    I was creating a staging for my website using Softaculous on cPanel, when I got an error at 95% at the stage of “propagating database” saying the following:

    • Could not make the query numbered : 0
      MySQL Error No : 1146
      MySQL Error : Table ‘**********.FexhIp_blogs’ doesn’t exist

    The asterisks being the target table (the table that the staging website is supposed to be using if the staging would’ve succeeded)

    When talking to my hosting provider, they had told me to remove some files from a large folder of mine on the server since it was over 500GB. I’ve now reduced the folder to just 20GB but the issue persists. I honestly don’t have an idea what could be the problem, since they told me that creating an empty column in the table wouldn’t help either.

    Do you have any ideas?

    Thanks, Ron

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

Viewing 8 replies - 1 through 8 (of 8 total)
  • Moderator bcworkz

    (@bcworkz)

    “FexhIp_blogs” is not a default WP table. Determine which plugin is responsible for it. Try deactivating that plugin and retrying the staging creation.

    While creating an empty column a table will not help, creating an empty table with all of its proper columns with the right formats might help. Export the table from your current DB using phpMyAdmin. You only need to export one line of data since you’ll be making an empty table. Import the file into the staging DB and delete any imported content, leaving an empty table with all the right columns.

    If that doesn’t help, try using a different staging app such as WP Staging plugin, or manually replicating the site.

    Thread Starter rshrayer

    (@rshrayer)

    Do you know how to understand which plugin is it?

    When going on PHPmyadmin, I couldn’t even understand which DB is related to my main webpage…

    Moderator bcworkz

    (@bcworkz)

    Sorry, I’m not aware of what plugin might make such a table. Maybe once you find it through phpMyAdmin the structure or content might give you some clues. N.B. — it’s also possible a theme had created the table, not a plugin. It may not even be a theme or plugin you currently use, but did use in the past.

    You can learn the correct DB for your site from the site’s wp-config.php file. It’s the value defined as DB_NAME.

    Fun fact: You can have multiple individual WP sites within the same DB as long as the $table_prefix assignment in wp-config.php is unique for every site. The default is “wp_”, but it can be nearly any string of characters.

    Thread Starter rshrayer

    (@rshrayer)

    So I did find the DB name in the wp-config.php file.

    Though interestingly, I didn’t find any “Fexhlp_blogs” table, which is quite interesting to me.

    Do you know what could this possibly mean?

    Thread Starter rshrayer

    (@rshrayer)

    Thing I found after a little looking through the wp-config.php file, is that the table prefix is Fexhlp. If that helps, in anyway…

    • This reply was modified 3 months, 4 weeks ago by rshrayer.
    Moderator bcworkz

    (@bcworkz)

    Oh! Is this for a multisite installation? If so, that is a standard default table. Doesn’t really change much, it’s still the same problem. Helps with my understanding of the issue though. I’m more convinced there’s an issue with the export/import process you used. Some tools like that are great for single site installations but are not necessarily reliable with multisite.

    All I can suggest is what I said in the last paragraph of my initial reply. In essence, use a different tool or method.

    Thread Starter rshrayer

    (@rshrayer)

    This isn’t a multisite installation. I’m using Softaculous, provided by the hosting provider.

    I’ll try using a different tool then, as you suggested in the first paragraph.

    Will update. Thanks!

    Thread Starter rshrayer

    (@rshrayer)

    Updating – went well! The site is a little slow, but is ok for my production purposes, considering I have some very large files on the website that were copied to the staging website.

    Thanks!

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

Tags