SQL Error on Import

  • gdavis55

    (@gdavis55)


    8 years, 6 months ago

    Hello,

    I have CRP running on my blog of about 900 posts and it’s working fine.

    When I export my database and import it to a new database I get this error:
    #1795 – InnoDB presently supports one FULLTEXT index creation at a time

    The error occurs here:

    SQL query:
    —
    — Indexes for table wp_posts
    —
    ALTER TABLE wp_posts
    ADD PRIMARY KEY (ID), ADD KEY type_status_date (post_type,post_status,post_date,ID), ADD KEY post_parent (post_parent), ADD KEY post_author (post_author), ADD KEY post_name (post_name(191)), ADD FULLTEXT KEY post_related (post_name,post_content), ADD FULLTEXT KEY crp_related (post_title,post_content), ADD FULLTEXT KEY crp_related_title (post_title), ADD FULLTEXT KEY crp_related_content (post_content);

    Is there a way to prevent this error from occurring when I import the database?

    My only thought is to deactivate CRP, move the site, then reactivate it. Is there a better solution?

    I’d like to keep using CRP if possible.

    Thanks,
    Gord

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

Viewing 1 replies (of 1 total)
  • Plugin Author Ajay

    (@ajay)

    8 years, 5 months ago

    You can delete that line and then import the rest of the database and it should work.

    Then in the settings page, you’ll have some queries to run (bottom of page) to regenerate the index

Viewing 1 replies (of 1 total)

The topic ‘SQL Error on Import’ is closed to new replies.