Last modified: 2014-05-24 02:04:26 UTC
Hi, I have the same problem reported in bug 62127, but it is not explained how to set up the tables. The explaniation says only: > > To sum up, the changes I made: > > > > 1. Added gt_lat_int to mw_geo_tags table. > > 2. Added gt_lon_int to mw_geo_tags table. > > 3. Added gt_spatial with 4 columns ( gt_lat_int, gt_lon_int, gt_lon, > > gt_primary ) to mw_geo_tags Indexes. Can anyone tell me what values to use to create the missing tables? type= ? null= ? default= ? Thanks for the help that you give me!
Did you run maintenance/update.php after adding the require_once line to LocalSettings.php, as described at <https://www.mediawiki.org/wiki/Extension:GeoData#Installation>? That should automatically create the geo_tags table if it is missing.
Yes, I followed the instructions but did not make them. Just like in the bug that I mentioned, so I guess the only remedy is to create them manually but I do not know the values...
Heyho! Please run update script again and look at the output. If you have the actual git version for example, there is the statement to create the required table with fields: https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FGeoData/10c5d177c98d59544fc4f3bab414d769f4c14167/sql%2Fdb-backed.sql
Perfect! Now everything works, including MobileFrontend!!! Thank you for the help! For anyone with the same problem, these are the complete instructions to fix the bug: 1. Added gt_lat_int (smallint NOT NULL) to mw_geo_tags table. 2. Added gt_lon_int (smallint NOT NULL) to mw_geo_tags table. 3. Added gt_spatial (index) with 4 columns ( gt_lat_int, gt_lon_int, gt_lon, gt_primary ) to mw_geo_tags Indexes.