it seems that sql migration script loses all maps that don't have background defined (or maybe there's some other reason, this is just a guess
)
we had one map with background and one without. after migration, second map was gone.
migration statement refers to background images, so probably maps wihtout bg fail to transfer.
)we had one map with background and one without. after migration, second map was gone.
migration statement refers to background images, so probably maps wihtout bg fail to transfer.
Code:
insert into sysmaps_tmp select s.sysmapid,s.name,s.width,s.height,i.imageid,s.label_type,s.label_location from sysmaps s,images i where s.background=i.name;
Comment