Title: Database table data import issue for sql file format
Last modified: June 24, 2022

---

# Database table data import issue for sql file format

 *  Resolved [Suresh Shinde](https://wordpress.org/support/users/suresh-shinde/)
 * (@suresh-shinde)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/database-table-data-import-issue-for-sql-file-format/)
 * Got error as;
    Cannot get geometry object from data you send to the GEOMETRY 
   field
 * **SQL query:**
 * INSERT INTO `wp_wpgmza` (`id`, `map_id`, `address`, `description`, `pic`, `link`,`
   icon`, `lat`, `lng`, `anim`, `title`, `infoopen`, `category`, `approved`, `retina`,`
   type`, `did`, `other_data`, `latlng`, `sticky`) VALUES
    (1, 1, ‘California’, ”,”,”,”,‘
   36.778261’, ‘-119.4179323999’, ”, ”, ”, ‘0’, 1, 0, 0, ”, ”, ‘\0\0\0\0\0\0\0J`
   s�cB@�`�g��]�’, 0), (2, 2, ‘GB Fairfield Inn & Suites by Marriott (Across from
   Turning Stone Casino) 5280 Willow Place Verona, NY 13478’, ”, ”, ‘[https://www.google.co.in/maps/place/Fairfield+Inn+%26+Suites+Verona/@43.117217,-75.5987797,17z/data=!3m1!4b1!4m2!3m1!1s0x0:0xeb793df77556417b&#8217](https://www.google.co.in/maps/place/Fairfield+Inn+%26+Suites+Verona/@43.117217,-75.5987797,17z/data=!3m1!4b1!4m2!3m1!1s0x0:0xeb793df77556417b&#8217);,”,‘
   43.1175969’, ‘-75.59604289999999’, ‘0’, ”, ‘0’, ‘0’, 1, 0, 0, ”, ”, ‘\0\0\0\0\
   0\0\05�Kj\r�E@ՠ�%�R�’, 0), (3, 3, ‘Hotel Indigo Albany-Latham 254 Wolf Road Latham,’,”,”,”,”,‘
   42.7295831’, ‘-73.79636119999998’, ‘0’, ‘Hotel Indigo Albany-Latham 254 Wolf 
   Road Latham,’, ‘0’, ‘0’, 1, 0, 0, ”, ”, ‘\0\0\0\0\0\0\0n��b]E@js���rR�’, 0);
 * MySQL said: Documentation
    #1416 – Cannot get geometry object from data you send
   to the GEOMETRY field
 * **Setup Details:**
 *     ```
       Extension	mysqli
       Server version	5.7.33-log
       Client version	mysqlnd 7.4.3
       Table prefix	wp_
       Database charset	utf8mb4
       Database collation	utf8mb4_unicode_520_ci
       Max allowed packet size	4194304
       Max connections number	200
       ```
   
 * **Server Details**
    Server architecture Linux 5.13.0-1028-aws x86_64 Web server
   nginx/1.18.0 PHP version 7.4.3 (Supports 64bit values)

Viewing 1 replies (of 1 total)

 *  [stevendebeer](https://wordpress.org/support/users/stevendebeer/)
 * (@stevendebeer)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/database-table-data-import-issue-for-sql-file-format/#post-15778170)
 * Hi [@suresh-shinde](https://wordpress.org/support/users/suresh-shinde/),
 * Thank you so much for getting in touch, we really appreciate your time.
 * Could I kindly ask you to get in touch with us directly via our website?
 * One of our lead developers will need to take a closer look into this issue.
 * Kindest Regards,
    Steven De Beer

Viewing 1 replies (of 1 total)

The topic ‘Database table data import issue for sql file format’ is closed to new
replies.

 * ![](https://ps.w.org/wp-google-maps/assets/icon-256x256.png?rev=3058363)
 * [WP Go Maps (formerly WP Google Maps)](https://wordpress.org/plugins/wp-google-maps/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-google-maps/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-google-maps/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-google-maps/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-google-maps/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-google-maps/reviews/)

## Tags

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

 * 1 reply
 * 2 participants
 * Last reply from: [stevendebeer](https://wordpress.org/support/users/stevendebeer/)
 * Last activity: [3 years, 9 months ago](https://wordpress.org/support/topic/database-table-data-import-issue-for-sql-file-format/#post-15778170)
 * Status: resolved