SQL error on Migration

  • Resolved saymynameut

    (@saymynameut)


    4 years ago

    Hi,
    I have been trying to migrate my site, but everytime it shows some query problem with network post while importing sql database.

    ————-
    Error
    Static analysis:

    2 errors were found during analysis.

    A symbol name was expected! (near “)” at position 190)
    At least one column definition was expected. (near “)” at position 190)
    SQL query: Copy

    — ——————————————————– — — Stand-in structure for view wp_v_network_posts — (See below for the actual view) — CREATE TABLE wp_v_network_posts ( )

    MySQL said: Documentation

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 8
    ——————-

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author johnzenausa

    (@johnzenausa)

    Thanks got your message. Try deactivating and deleting plugin do the transfer and then reinstall it.

    Plugin Author johnzenausa

    (@johnzenausa)

    If that’s for a specific table/ box don’t copy it

    Plugin Author johnzenausa

    (@johnzenausa)

    But deleting and reinstall plugin after transfer will work. That error isn’t the plugin directly.

    Thread Starter saymynameut

    (@saymynameut)

    Your input has helped me.

    Thank you

    Plugin Author johnzenausa

    (@johnzenausa)

    Okay let me know of further problems.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘SQL error on Migration’ is closed to new replies.