My drupal installation has two languages English and Greek, with Greek being the main language. When trying to install the weather module I got a "columns do not match values count" error while the weather-data.inc was getting executed. I noticed that the insert statements had become
db_query("INSERT INTO {weather_icao} (icao, country, name, latitude, longitude) VALUES ('%s', '%s', '%s', %f, %f)", 'LGPZ', 'Greece', 'Aktion Airport', 38,616667, 20,766667);
instead of
db_query("INSERT INTO {weather_icao} (icao, country, name, latitude, longitude) VALUES ('%s', '%s', '%s', %f, %f)", 'LGPZ', 'Greece', 'Aktion Airport', 38.616667, 20.766667);
possibly due to the different decimal notation.
Switching the site language to English fixed the error and installation completed fine.
I just thought of posting this here in case anyone else runs on this problem as it made me head scratching like mad.
Comments
Comment #1
toddy commentedHi,
thanks for the report, I'm closing it now, as I think that this advice is no longer needed.
Regards,
Tobias