WORLD MAP IN WRONG DATA FORMAT AND CRASHING SITE

i had the problem with d 7.3.3.3 and now upgraded to d7.3.3.4. same error

i do not know what is causing it. all wmap##### tables crash randomly. shutting down

profile

events

groups

adds

 

i can not afford to have my website crash so users can not use these 4 items.

the only way to fix it is to uninstall worldmaps module.

 

has anyone else had this problem??

if there a fix for this problem??

seems to be the only thing that is not working with the dolphin default code.

Quote · 23 Oct 2017

How are they crashing?

Geeks, making the world a better place
Quote · Bury · 23 Oct 2017

probably some cron job i think. or some hacker that does not like maps.

 

it crashes all modules using worldmaps!

profiles

groups

ads

events

 

not good. as many people need driving directions to these events. like i said wmap??? tables/fields get

crashed. doing a repair on the database does nothing. i do not know if the firewall is causing this. as it is locked to use only the ports boonex told me to use. it works fine, but later on it crashes bringing the whole site down.

 

Quote · 24 Oct 2017

There are several ways a mySQL table can crash.  Sometimes the index gets corrupted.  It should report an error code.

Geeks, making the world a better place
Quote · Bury · 25 Oct 2017

I think the wmap database tables only crash. when i have to reboot my server. so fat 11 days uptime nd no crashes. but ya. they get locked you can not over write them with old backups. something locks them while the server is on. have to manually shut down mysql. then overwrite them then put mysql back up.

Quote · 11d ago

THIS  error with wmap fields happens every time i reboot the server. always.

and the only way to get rid of it is to uninstall world maps. and manually save the data one by one till all the map data is back. no no no even the world maps link to do the locations does not work. at all. it says it does. but does not. this is a serious issue. tonite my server locked up .had to reboot and guess what. the damn wmaps fields crashed the entire website. so i have to uninstall it completely. the build locations link does not work. and i am tired of manaullly adding the map data over and over again. so fix it!@!

Quote · 4d ago

SEEMS  the problem is with the database formats for maps.

 

all my fields are marked as

 

.frm

.MYD

.MYI

 

the fields for the mapping crash problem are

 

.ibd

 

that is the only place in the entire database that has those .ibd data type fiel

 

there is an error in the code that creates these fields. and yes. once again last night crashed again

when you manaully delete all the fields in the database (or uninstall it) the following fields are locked by the running mysql program

 

the two fields in error are

 

bx_wmap_locations.ibd

bx_wmap_parts.ibd

 

these fields should be  .frm .MYD and .MYI

 

they are not. since everything else runs except for these two rogue files that appears to be what is crashing the world maps all the time. shutting down all occurrences of world maps. ie profile/groups/events/adds and world map in the admin section. I need a fix. is there one???

some one help my our with the error fields problem. it is driving my mental every time it crashes.

even overwritting the fields with older fields in backup does not work. I have to manually unistall and delete wmaps to reinstall world maps again. and the old copies refuse to get accepted by the mysql program so i have to manaully fix them by reposting all the parts of the website that are suppose to hold map data. seems the wmap fields are the only ones writing to the database as .idb

 

hopefully some one can fix this soon. thanks.

Quote · 15 Nov 2017

Try to check if there is enough space on all partitions on your server, it could the reason your tables are crashing.

 
Rules → http://www.boonex.com/terms
Quote · 19 Nov 2017

checked already its not. its the .ibd files for maps. it's in the wrong format as the rest of the database tables

 

.frm

.MYD

.MYI

Quote · 30 Nov 2017
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.