https://bugzilla.wikimedia.org/show_bug.cgi?id=38330
Maarten Dammers <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #5 from Maarten Dammers <[email protected]> 2012-08-31 19:01:34 UTC --- Elke made the config and database query mysql> SELECT COUNT(*) FROM `monuments_za_(en)`; +----------+ | COUNT(*) | +----------+ | 3549 | +----------+ 1 row in set (0.00 sec) Manual merge works: mysql> REPLACE INTO `monuments_all` (`country`, `lang`, `id`, `adm0`, `adm1`, `adm2`, `adm3`, `adm4`, `name`, `address`, `municipality`, `lat`, `lon`, `lat_int`, `lon_int`, `image`, `source`, `changed`, `monument_article`, `registrant_url` ) -> SELECT 'za' AS `country`, -> 'en' AS `lang`, -> `sitereference` AS `id`, -> 'za' AS `adm0`, -> LOWER(`province_iso`) AS `adm1`, -> `magisterial_district` AS `adm2`, -> `town` AS `adm3`, -> NULL AS `adm4`, -> `site_name` AS `name`, -> `site_name` AS `address`, -> `town` AS `municipality`, -> `lat` AS `lat`, -> `lon` AS `lon`, -> ROUND(`lat` * @granularity) AS `lat_int`, -> ROUND(`lon` * @granularity) AS `lon_int`, -> `image` AS `image`, -> `source` AS `source`, -> `changed` AS `changed`, -> '' AS `monument_article`, -> '' AS `registrant_url` FROM `monuments_za_(en)`; Query OK, 3549 rows affected (1 min 2.07 sec) Records: 3549 Duplicates: 0 Warnings: 0 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
