[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
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 fine, also > MobileFrontEnd! > > 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. > > I still don't know if this is a bug or a problem with my personal > settings/hosting. I can provide more information if you have any questions. Hi! I tried to make the changes you suggested, but I have not figured out exactly how to create tables... I sent you two pictures through e-mail so you can see them and tell me where I'm wrong. -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 massimiliano.pis...@yahoo.it changed: What|Removed |Added CC||massimiliano.pisani@yahoo.i ||t --- Comment #14 from massimiliano.pis...@yahoo.it --- Hi! I have the same issue, I sent you an email to ask some information -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 ogul oncel changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |WORKSFORME --- Comment #13 from ogul oncel --- 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 fine, also MobileFrontEnd! 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. I still don't know if this is a bug or a problem with my personal settings/hosting. I can provide more information if you have any questions. -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127
--- Comment #12 from ogul oncel ---
Another manifestation of the problem:
"Search around the point with coordinates"
api.php?action=query&list=geosearch&gsradius=1&gscoord=50.923275|6.916073
does not work and returns the following error:
https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
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 =
'0' AND gt_globe = 'earth' AND (gt_page_id = page_id) AND
gt_primary = '1' AND gt_lat_int = '51' AND gt_lon_int =
'7' AND (gt_lat>='50.8333429806') AND
(gt_lat<='51.0132070194') AND (gt_lon>='6.77340540165') AND
(gt_lon<='7.05874059835')
Function:
ApiQueryGeoSearchDb::run
Error: 1176 Key 'gt_spatial'
doesn't exist in table 'mw_geo_tags' (localhost)
"
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}
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.
--
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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127
--- Comment #11 from ogul oncel ---
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. gt_lat_int,gt_lon_int do not show up in sql database. So I
added them manually with my hand through phpmyadmin which eliminated the
warning. Yet I am not sure if I configured it correctly. My configuration for
both are as follows:
type=smallint(6)
null=no
default=none
An example:
{{#coordinates:primary|51|55|29|N|6|55|9|E|}} returns gt_lat_in=519
gt_lot_in=69. It says, data should be by default 1/10th of degree. but x10?
MobileFrontEnd extension is also not working. I think it is to do with the
error here.
--
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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #10 from ogul oncel --- 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 (gt_lat_int,gt_lon_int) mentioned. So there is a contradiction between the actual database and localsettings.php file. Does this ring a bell? -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #9 from ogul oncel --- 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 the error message returns 13 parameters, adding (gt_lat_int,gt_lon_int) at the end which doesn't exist in database table. I think this is the source of trouble but I don't know how or why this is happening. I hope this helps. -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127
--- Comment #8 from ogul oncel ---
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 database via phpmyadmin
mw_geo_killlist
mw_geo_tags
mw_geo_updates
4. Re-installed GeoData Extension
5. Added require once to localsettings.php
6. Updated the software via webupdater. Seen "geo tables created"
7. Logged in and added "{{#coordinates:primary|26|04|N|178|46|E}}" to a page
8. Received the same error:
"A database query error has occurred. This may indicate a bug in the software.
Query:
INSERT INTO `mw_geo_tags`
(gt_page_id,gt_id,gt_lat,gt_lon,gt_globe,gt_primary,gt_dim,gt_type,gt_name,gt_country,gt_region,gt_lat_int,gt_lon_int)
VALUES
('31',NULL,'26.07','178.76667','earth','1','1000',NULL,NULL,NULL,NULL,'261','1788')
Function: GeoDataHooks::doSmartUpdate
Error: 1054 Unknown column 'gt_lat_int' in 'field list' (localhost)"
"Notice: Uncommitted DB writes (transaction from DatabaseBase::query
(WikiPage::pageData)). in /home/username/public_html/includes/db/Database.php
on line 3944"
Any idea, what might be wrong?
--
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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #7 from ogul oncel --- Max, I was trying to learn the process you wrote. I am checking phpmyadmin>structure. There are 2 relevant tables: mw_geo_killlist mw_geo_tags mw_geo_updates with "Browse,Structure,Search,Insert,Empty,Drop" options. Should I "drop" all these files and re-install the GeoData again? -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #6 from ogul oncel --- 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 first installation? There were no tables during first installation and everything I did was fresh and default? Could this be pointing to some other error? -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #5 from Max Semenik --- 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 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #4 from ogul oncel --- 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 report it also said "geo tag table already exists". -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #3 from ogul oncel --- 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 version) $wgGeoDataBackend parameter is not set in localsettings.php. On extension page it says default is "db" and not "solr" so I thought it should be okay? -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 --- Comment #2 from Sam Reed (reedy) --- 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? -- 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
[Bug 62127] GeoData Error Upon Adding Coordinates to a Page: 1054 Unknown column 'gt_lat_int' in 'field list'
https://bugzilla.wikimedia.org/show_bug.cgi?id=62127 Andre Klapper changed: What|Removed |Added CC||aklap...@wikimedia.org Summary|GeoData Extension Database |GeoData Error Upon Adding |Query Error Upon Adding |Coordinates to a Page: 1054 |Coordinates to a Page |Unknown column 'gt_lat_int' ||in 'field list' --- Comment #1 from Andre Klapper --- Thanks for taking the time to report this! Which MediaWiki version, which GeoData version, and which database backend is this about? -- 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
