Database table data import issue for sql file format
-
Got error as;
Cannot get geometry object from data you send to the GEOMETRY fieldSQL 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 fieldSetup 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 200Server 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)
The topic ‘Database table data import issue for sql file format’ is closed to new replies.