Admin rights disabled after moving site to new host

  • Resolved leradstar

    (@leradstar)


    9 years ago

    Hi,

    I’ve moved my site, something I’ve done many times but this time on database import I encountered some problems one which is listed below
    The site is operational but I cannot save or publish anymore. The textblock is no longer visible and the ability to add images.
    I’ve tried switching to a default theme, disabling all plugins and using the default theme only. I don’t know my way around MySQL and I’ve read elsewhere that I need to create wp_user_roles in the wp_options table.
    Also I need to say I have debugged WP, optimised and repaired the database and nothing works.
    Error with database import:

    MySQL said: Documentation
    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DROP TABLE IF EXISTS wp_my_calendar_categories;
    CREATE TABLE IF NOT EXISTS `wp’ at line 13

    Error detected in WP:

    object from empty value in /home/…../domains/…../public_html/wp-admin/includes/post.php on line 631

    Any suggestions would be greatly appreciated because my hosting guy says this is beyond his scope and service.

    Regards,

Viewing 1 replies (of 1 total)
  • Thread Starter leradstar

    (@leradstar)

    Three months later and no response to my above problem.
    Thank goodness! I got it resolved with All-in-One WP Migration.
    Just a note for moving an existing WP site with content. Backup all posts and pages, export them first before moving files via ftp. When all fails you can always import your data/posts.
    My problem was database specific, the new host couldn’t import all tables.

    It’s resolved and happy that not much was lost.

Viewing 1 replies (of 1 total)
  • The topic ‘Admin rights disabled after moving site to new host’ is closed to new replies.