Title: globeonetechops's Replies | WordPress.org

---

# globeonetechops

  [  ](https://wordpress.org/support/users/globeonetechops/)

 *   [Profile](https://wordpress.org/support/users/globeonetechops/)
 *   [Topics Started](https://wordpress.org/support/users/globeonetechops/topics/)
 *   [Replies Created](https://wordpress.org/support/users/globeonetechops/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/globeonetechops/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/globeonetechops/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/globeonetechops/engagements/)
 *   [Favorites](https://wordpress.org/support/users/globeonetechops/favorites/)

 Search replies:

## Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] You have an error in your SQL syntax](https://wordpress.org/support/topic/you-have-an-error-in-your-sql-syntax-12/)
 *  Thread Starter [globeonetechops](https://wordpress.org/support/users/globeonetechops/)
 * (@globeonetechops)
 * [11 years ago](https://wordpress.org/support/topic/you-have-an-error-in-your-sql-syntax-12/#post-6147100)
 * This ‘non error’ shows up in yellow:
 * TABLE KEY ERRORS (0)
    A primary key is required on a table to efficiently run
   the update engine. Below is a list of tables and the rows that will need to be
   manually updated. Use the query below to find the data. SELECT [@row](https://wordpress.org/support/users/row/):
   = [@row](https://wordpress.org/support/users/row/) + 1 as row, t.* FROM some_table
   t, (SELECT [@row](https://wordpress.org/support/users/row/) := 0) r No missing
   primary key errors
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] You have an error in your SQL syntax](https://wordpress.org/support/topic/you-have-an-error-in-your-sql-syntax-12/)
 *  Thread Starter [globeonetechops](https://wordpress.org/support/users/globeonetechops/)
 * (@globeonetechops)
 * [11 years ago](https://wordpress.org/support/topic/you-have-an-error-in-your-sql-syntax-12/#post-6147099)
 * I tried the ‘mysqldump’ method, searched for similar support articles (I got 
   the mysqldump suggestion from this support article:
    [https://wordpress.org/support/topic/deploy-errors-you-have-an-error-in-your-sql-syntax?replies=8](https://wordpress.org/support/topic/deploy-errors-you-have-an-error-in-your-sql-syntax?replies=8)
 *  and re-read the documentation.
 * Same errors:
 * STEP2: UPDATE ERRORS (107)
    Errors that show here are the result of queries that
   could not be performed.
 *     ```
       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 'from = "http://53.6.126.120/" WHERE id = "1"' at line 1
       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 'from = "http://53.6.126.120/newsroom/" WHERE id = "4"' at line 1
       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 'from = "http://53.6.126.120/newsroom/" WHERE id = "19"' at line 1
       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 'from = "http://53.6.126.120/newsroom/" WHERE id = "30"' at line 1
       ```
   
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More] You have an error in your SQL syntax](https://wordpress.org/support/topic/you-have-an-error-in-your-sql-syntax-12/)
 *  Thread Starter [globeonetechops](https://wordpress.org/support/users/globeonetechops/)
 * (@globeonetechops)
 * [11 years ago](https://wordpress.org/support/topic/you-have-an-error-in-your-sql-syntax-12/#post-6147057)
 * Query seems to run manually…unsure of error:
 * > mysql> SELECT option_value, autoload FROM`wp_options` WHERE option_id = “174”;
   > 
   > +——————————————————————————————————————————————-+———-+ | option_value | autoload
   > | +——————————————————————————————————————————————-+———-+ | a:3: {s:8:”hostname”;
   > s:41:”ec2-53.6.126.120.compute-1.amazonaws.com/”;s:8:”username”;s:8:”username”;
   > s:15:”connection_type”;s:4:”ftps”;} | yes | +——————————————————————————————————————————————-
   > +———-+

Viewing 3 replies - 1 through 3 (of 3 total)