Title: SQL error on Migration
Last modified: November 26, 2020

---

# SQL error on Migration

 *  Resolved [saymynameut](https://wordpress.org/support/users/saymynameut/)
 * (@saymynameut)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-migration/)
 * 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](https://wordpress.org/support/users/johnzenausa/)
 * (@johnzenausa)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-migration/#post-13714673)
 * Thanks got your message. Try deactivating and deleting plugin do the transfer
   and then reinstall it.
 *  Plugin Author [johnzenausa](https://wordpress.org/support/users/johnzenausa/)
 * (@johnzenausa)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-migration/#post-13714894)
 * If that’s for a specific table/ box don’t copy it
 *  Plugin Author [johnzenausa](https://wordpress.org/support/users/johnzenausa/)
 * (@johnzenausa)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-migration/#post-13714900)
 * But deleting and reinstall plugin after transfer will work. That error isn’t 
   the plugin directly.
 *  Thread Starter [saymynameut](https://wordpress.org/support/users/saymynameut/)
 * (@saymynameut)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-migration/#post-13718096)
 * Your input has helped me.
 * Thank you
 *  Plugin Author [johnzenausa](https://wordpress.org/support/users/johnzenausa/)
 * (@johnzenausa)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-migration/#post-13718120)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/network-posts-extended_b4775d.svg)
 * [Network Posts Extended](https://wordpress.org/plugins/network-posts-extended/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/network-posts-extended/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/network-posts-extended/)
 * [Active Topics](https://wordpress.org/support/plugin/network-posts-extended/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/network-posts-extended/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/network-posts-extended/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * 5 replies
 * 2 participants
 * Last reply from: [johnzenausa](https://wordpress.org/support/users/johnzenausa/)
 * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/sql-error-on-migration/#post-13718120)
 * Status: resolved