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

2014-05-08 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #15 from massimiliano.pis...@yahoo.it --- (In reply to ogul oncel from comment #13) Hey Guys! I have noticed that the database does not create gt_spatial INDEX. So I also added it manually. And now everything seems working

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

2014-04-07 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 massimiliano.pis...@yahoo.it changed: What|Removed |Added CC|

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

2014-03-04 Thread 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=querylist=geosearchgsradius=1gscoord=50.923275|6.916073 does not work and returns the

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

2014-03-04 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 ogul oncel ogulon...@gmail.com changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED

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

2014-03-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #5 from Max Semenik maxsem.w...@gmail.com --- Ogul, you'll need to drop that table to let the installer to create it in a proper form. I just checked - GeoData works just fine after installation with default settings. -- You are

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

2014-03-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #6 from ogul oncel ogulon...@gmail.com --- Max, do you mean erasing the table by dropping? Can you tell me how I should properly remove it, I'm not sure how to do it. The thing I don't get is that; why it didn't work properly at

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

2014-03-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #7 from ogul oncel ogulon...@gmail.com --- Max, I was trying to learn the process you wrote. I am checking phpmyadminstructure. There are 2 relevant tables: mw_geo_killlist mw_geo_tags mw_geo_updates with

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

2014-03-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #8 from ogul oncel ogulon...@gmail.com --- Max, the problem is not solved. Here what I have done: 1. Removed require once from localsettings.php 2. Deleted the GeoData folder from extensions 3. Dropped the three tables from

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

2014-03-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #9 from ogul oncel ogulon...@gmail.com --- Additional Information: I checked mw_table_geo_tags. There are only 11 parameters there:(gt_page_id,gt_id,gt_lat,gt_lon,gt_globe,gt_primary,gt_dim,gt_type,gt_name,gt_country,gt_region) But

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

2014-03-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #10 from ogul oncel ogulon...@gmail.com --- Sorry for posting too much here, but I wanted to share what I found for one last time: I checked GeoData/sql/db-backed.sql file in localsettings.php. And there I found the two lost files

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

2014-03-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #11 from ogul oncel ogulon...@gmail.com --- Partial Solution(?): I have recognized that during creation of geo tags table, two rows are omitted all the time. I don't know if it's to do with software or my hosting settings.

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

2014-03-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added CC|

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

2014-03-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #2 from Sam Reed (reedy) s...@reedyboy.net --- Quick glance at the code would suggest you're using the database schema that is used when you use it with solr, rather than using the mysql backend. What is $wgGeoDataBackend set to?

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

2014-03-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #3 from ogul oncel ogulon...@gmail.com --- Thank you for your attention Andre and Sam! My wiki is operated on Godaddy.com hosting. MediaWiki:1.22.3 PHP:5.4.23 (cgi-fcgi) MySQL:5.5.32-cll-lve GeoData: master(latest

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

2014-03-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #4 from ogul oncel ogulon...@gmail.com --- Upon your message, I have deleted the extension, installed again with $wgGeoDataBackend parameter set to 'db' and updated the database again. The errors stay the same. But on the update