• Resolved Suresh Shinde

    (@suresh-shinde)


    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\0Js�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’, ”, ‘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)
  • Hi @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.