Deploy with Desktop Server error in DB

Hi,

I developed a website using Spirit theme and Upfront builder. The development was done locally using DesktopServer.
When I am trying to deploy at the DB stage (final stage) I am getting an error SQL state 42S02 Table not found 1146 table wordpress.a.wp_posts.

Practically the menu is not appearing at all, the login credentials for the admin is not working and other issues. I tried to export / import manually this table that gives the error but nothing changed although the import was successful.

Any know issues or suggestions.

Thanks & Regards,
Lester

  • Nithin

    Hi Lester Galanis,

    Hope you are doing good today. :slight_smile:

    When I am trying to deploy at the DB stage (final stage) I am getting an error SQL state 42S02 Table not found 1146 table wordpress.a.wp_posts.

    The above error mentions that the table is missing after deploying, hence you are noticing all these anomalies. Are you using the premium version of the DesktopServer to deploy it into your live site? If yes, could you please get in touch with their support, and see what could be causing this?
    https://serverpress.com/contact/

    Other than that, to get this sorted easily, you could use a plugin like Duplicator to move your website from localhost to Live site:
    https://wordpress.org/plugins/duplicator/

    I hope this helps. Please let us know if you still need any further assistance. Have a nice weekend. :slight_smile:

    Best Regards,
    Nithin

  • Nithin

    Hi Lester Galanis,

    Hope you are doing good today. :slight_smile:

    What really surprised me was the SQL file size. Uncompresses was about 70MB for a simple 5-page website. From your experience is this normal? Should I expect if I use upfront that the SQL files will be that "big" ?

    Upfront does save all the changes in the database, so the size of the database will be increased a bit more than normal. However, 70MB of data doesn't sound normal, I tested this in my system on which I have extensively used Upfront, and the total size of the database is only 4MB.

    Not sure what could be the exact cause for this, but you could use a plugin like WP Optimize, which should help you in cleaning the database, and save some space:
    https://wordpress.org/plugins/wp-optimize/

    I hope this works, please let us know if you still need any further assistance. :slight_smile:

    Kind Regards,
    Nithin