[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'

[bugzilla-daemon]

https://bugzilla.wikimedia.org/show_bug.cgi?id=62127

--- Comment #12 from ogul oncel <ogulon...@gmail.com> ---
Another manifestation of the problem:

"Search around the point with coordinates"
api.php?action=query&list=geosearch&gsradius=10000&gscoord=50.923275|6.916073
does not work and returns the following error:

<?xml version="1.0"?>
<api>
  <error code="internal_api_error_DBQueryError" info="Exception Caught: A
database error has occurred. Did you forget to run maintenance/update.php after
upgrading?  See:
https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script&#10;Query:
SELECT  page_id,page_namespace,page_title,gt_lat,gt_lon,gt_primary,gt_globe 
FROM `mw_page`,`mw_geo_tags` FORCE INDEX (gt_spatial)   WHERE page_namespace =
&#039;0&#039; AND gt_globe = &#039;earth&#039; AND (gt_page_id = page_id) AND
gt_primary = &#039;1&#039; AND gt_lat_int = &#039;51&#039; AND gt_lon_int =
&#039;7&#039; AND (gt_lat>=&#039;50.8333429806&#039;) AND
(gt_lat<=&#039;51.0132070194&#039;) AND (gt_lon>=&#039;6.77340540165&#039;) AND
(gt_lon<=&#039;7.05874059835&#039;)  &#10;Function:
ApiQueryGeoSearchDb::run&#10;Error: 1176 Key &#039;gt_spatial&#039;
doesn&#039;t exist in table &#039;mw_geo_tags&#039; (localhost)&#10;"
xml:space="preserve">

#0 /home/richardwakefield/public_html/includes/db/Database.php(1039):
DatabaseBase->reportQueryError('Key 'gt_spatial...', 1176, 'SELECT 
page_id...', 'ApiQueryGeoSear...', false)
#1 /home/richardwakefield/public_html/includes/db/Database.php(1496):
DatabaseBase->query('SELECT  page_id...', 'ApiQueryGeoSear...')
#2 /home/richardwakefield/public_html/includes/api/ApiQueryBase.php(274):
DatabaseBase->select(Array, Array, Array, 'ApiQueryGeoSear...', Array, Array)
#3
/home/richardwakefield/public_html/extensions/GeoData/api/ApiQueryGeoSearchDb.php(41):
ApiQueryBase->select('ApiQueryGeoSear...')
#4
/home/richardwakefield/public_html/extensions/GeoData/api/ApiQueryGeoSearch.php(13):
ApiQueryGeoSearchDb->run()
#5 /home/richardwakefield/public_html/includes/api/ApiQuery.php(275):
ApiQueryGeoSearch->execute()
#6 /home/richardwakefield/public_html/includes/api/ApiMain.php(829):
ApiQuery->execute()
#7 /home/richardwakefield/public_html/includes/api/ApiMain.php(380):
ApiMain->executeAction()
#8 /home/richardwakefield/public_html/includes/api/ApiMain.php(351):
ApiMain->executeActionWithErrorHandling()
#9 /home/richardwakefield/public_html/api.php(73): ApiMain->execute()
#10 {main}

</error>
</api>

But, "get a list of coordinates of an article" works well:

You are looking at the HTML representation of the XML format.
HTML is good for debugging, but is unsuitable for application use.
Specify the format parameter to change the output format.
To see the non HTML representation of the XML format, set format=xml.
See the complete documentation, or API help for more information.
<?xml version="1.0"?>
<api>
  <query>
    <normalized>
      <n from="Çevrimiçi_Bilgi_Kaynakları" to="Çevrimiçi Bilgi Kaynakları" />
    </normalized>
    <pages>
      <page pageid="31" ns="0" title="Çevrimiçi Bilgi Kaynakları">
        <coordinates>
          <co lat="50.9233" lon="6.91607" primary="" globe="earth" />
        </coordinates>
      </page>
    </pages>
  </query>
</api>

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l