From: Neill M. <ne...@nl...> - 2013-02-19 14:42:37
|
Hi. I've just upgraded a SMW 1.0.8 instance to 1.8.0.2. When I run SMW_setup.php I get the following errors: Selected storage "SMWSQLStore3" for update! Setting up standard database configuration for SMW ... Selected storage engine is "SMWSQLStore" (or an extension thereof) Checking table `smw_object_ids` ... Table already exists, checking structure ... ... changing type of field smw_id from 'INT(8) UNSIGNED NOT NULL KEY AUTO_INCREMENT' to 'INT(8) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT' ... 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 Query: ALTER TABLE `smw_object_ids` CHANGE `smw_id` `smw_id` INT(8) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST Function: SMWSQLHelpers::updateMySqlField Error: 1068 Multiple primary key defined (localhost) I have run update.php. That throws the same error. This has happened on two instances now. Any ideas? Thanks. |
From: Thomas F. <tho...@gm...> - 2013-02-19 16:12:26
|
Hey all-- I just had the same problem upgrading from SMW 1.8.0.2 to SMW 1.9.X (On branch remotes/origin/1.9.x) -Tom On Tue, Feb 19, 2013 at 9:42 AM, Neill Mitchell <ne...@nl...>wrote: > Hi. > > I've just upgraded a SMW 1.0.8 instance to 1.8.0.2. > > When I run SMW_setup.php I get the following errors: > > Selected storage "SMWSQLStore3" for update! > > Setting up standard database configuration for SMW ... > > Selected storage engine is "SMWSQLStore" (or an extension thereof) > > Checking table `smw_object_ids` ... > Table already exists, checking structure ... > ... changing type of field smw_id from 'INT(8) UNSIGNED NOT NULL KEY > AUTO_INCREMENT' to 'INT(8) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT' > ... 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 > Query: ALTER TABLE `smw_object_ids` CHANGE `smw_id` `smw_id` INT(8) > UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST > Function: SMWSQLHelpers::updateMySqlField > Error: 1068 Multiple primary key defined (localhost) > > I have run update.php. That throws the same error. This has happened on > two instances now. > > Any ideas? > > Thanks. > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_feb > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > |
From: Jeroen De D. <jer...@gm...> - 2013-02-19 17:06:51
|
Hey, > Selected storage "SMWSQLStore3" for update! This means you are running the upgrade script for SQLStore3. If your tables are those of SQLStore2, it will fail in the manner you described. You can follow the migration instructions from SQLStore2 to SQLStore3 or be lazy like me and just php maintenance/SMW_setup.php --delete php maintenance/SMW_setup.php That definitely works :) Cheers -- Jeroen De Dauw http://www.bn2vs.com Don't panic. Don't be evil. -- |
From: Jeroen De D. <jer...@gm...> - 2013-02-19 17:35:58
|
Hey, php maintenance/SMW_setup.php --delete > php maintenance/SMW_setup.php > > That definitely works :) > Huh - apparently not. Looks like I introduced this issue for MySQL setups a some time back while fixing SQLite support :) Should be fixed on master and on the 1.8.x branch now. Cheers -- Jeroen De Dauw http://www.bn2vs.com Don't panic. Don't be evil. -- |
From: Thomas F. <tho...@gm...> - 2013-02-19 22:02:27
|
Thanks Jeroen! 1.8.0.2 -> 1.9 works! On Tue, Feb 19, 2013 at 12:35 PM, Jeroen De Dauw <jer...@gm...>wrote: > Hey, > > php maintenance/SMW_setup.php --delete > > php maintenance/SMW_setup.php > > > > That definitely works :) > > > > Huh - apparently not. Looks like I introduced this issue for MySQL setups a > some time back while fixing SQLite support :) Should be fixed on master and > on the 1.8.x branch now. > > Cheers > > -- > Jeroen De Dauw > http://www.bn2vs.com > Don't panic. Don't be evil. > -- > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_feb > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > |
From: Neill M. <ne...@nl...> - 2013-02-20 11:31:12
|
Hi Jeroen. Yes, just tried the latest master and it is fine now :) Cheers Neill. On 19/02/13 17:35, Jeroen De Dauw wrote: > Hey, > > php maintenance/SMW_setup.php --delete > php maintenance/SMW_setup.php > > That definitely works :) > > > Huh - apparently not. Looks like I introduced this issue for MySQL > setups a some time back while fixing SQLite support :) Should be fixed > on master and on the 1.8.x branch now. > > Cheers > > -- > Jeroen De Dauw > http://www.bn2vs.com > Don't panic. Don't be evil. > -- |
From: Didier H. <did...@sk...> - 2013-02-19 20:17:28
|
I'm trying to get kml export file using semantic-mediawiki results formats, extension Maps and Semantic-Maps. As it works well for googlemaps, I would like to get kml files ! On the examples page for help:kml format there are 2 examples. How do I get the kml export file ? (Not this one from the link "… further results" which is a file without coords nor data). On my wiki I even tried to add the format in "result format settings.php" or by adding $srfgFormats[]= 'kml'; in the localsettings.php ! Any Help configuring ? Have a good day Didier |
From: Didier H. <did...@sk...> - 2013-02-23 07:20:03
|
Thanks for all answers ;-( Perhaps I didn't explain well my problem ! I read more about this Result format on the Talk page of Semantic - Maps … It seems not working ! Can someone give me a website/wiki where KML export to file is working well ??? So I can have a look how they did ! Thank you Didier Houbrechts http://www.aena.be http://dhvg.ckcs-kcs.dyndns.org (online pedigrees for Ckcs & Kcs/Ets) http://dhvg.ckcs-kcs.dyndns.org/mediawiki/index.php/Main_Page (Wiki for Ckcs & Kcs/Ets) http://dhvg.ckcs-kcs.dyndns.org/mediawiki/index.php/UkBreedersOnGoogleMaps Le 19 févr. 2013 à 21:17, Didier Houbrechts a écrit : > I'm trying to get kml export file using semantic-mediawiki results formats, extension Maps and Semantic-Maps. > As it works well for googlemaps, I would like to get kml files ! > On the examples page for help:kml format there are 2 examples. How do I get the kml export file ? (Not this one from the link "… further results" which is a file without coords nor data). > On my wiki I even tried to add the format in "result format settings.php" or by adding $srfgFormats[]= 'kml'; in the localsettings.php ! > > Any Help configuring ? > > Have a good day > Didier > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_feb > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user |