SQL Upload error on site migration

#95536
  • Resolved Richard Tolley

    3 years, 11 months ago

    Rank Math free

    Hello,

    I am migrating a clients site from a staging site to a new host and when I upload the SQL file in myPHPadmin I get the following error. I initially ignored the error and proceed with the migration but when I enter the migrated site I have display errors followed by a critical error. WordPress then sent an email stating that your Rank Math SEO is causing the issue. Please help.

    The sql upload error is as follows:

    SQL query:

    —
    — Indexes for table wp_rank_math_analytics_gsc
    —
    ALTER TABLE wp_rank_math_analytics_gsc
    ADD PRIMARY KEY (id),
    ADD KEY analytics_query (query(768)),
    ADD KEY analytics_page (page),
    ADD KEY clicks (clicks),
    ADD KEY position (position)
    MySQL said: Documentation

    #1709 – Index column size too large. The maximum column size is 767 bytes.

Viewing 1 replies (of 1 total)
  • Uzair

    3 years, 11 months ago

    Hello,

    Thank you for your query and we are so sorry about the trouble this must have caused.

    Can you please disable Rank Math and enable it again?

    If that doesn’t work, please reconnect your Analytics profile at WordPress Dashboard > Rank Math > General Settings > Analytics.

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

    RankBot

    3 years, 10 months ago

    Hello,

    Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

    If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

    Thank you.

Viewing 1 replies (of 1 total)

The ticket ‘SQL Upload error on site migration’ is closed to new replies.