Hello,
when i run update.php to upgrade to 6.x-3.3 from 6.x-3.2 version, the following warning errors are reported:

  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'avorio')' at line 1 query: INSERT INTO location_country (code, name) VALUES ('ci', 'Costa d'avorio') in /var/www/xxxxx/sites/all/modules/location/location.install on line 1217.
  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'America')' at line 1 query: INSERT INTO location_country (code, name) VALUES ('vi', 'Isole Vergini degli Stati Uniti d'America') in /var/www/xxxxx/sites/all/modules/location/location.install on line 1217.
  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Elena')' at line 1 query: INSERT INTO location_country (code, name) VALUES ('sh', 'Sant'Elena') in /var/www/xxxxx/sites/all/modules/location/location.install on line 1217.
  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'oceano Indiano')' at line 1 query: INSERT INTO location_country (code, name) VALUES ('io', 'Territorio bitannico dell'oceano Indiano') in /var/www/xxxxx/sites/all/modules/location/location.install on line 1217.
  • warning: array_merge() [function.array-merge]: Argument #2 is not an array in /var/www/xxxxx/update.php on line 173.
  • warning: Invalid argument supplied for foreach() in /var/www/xxxxx/update.php on line 340.

I think that the problem is the "apostrophe" inside some entries in Italian (eg. the English "Ivory Coast" becames "Costa d'Avorio" in italian).
There is a fix/patch or I must upgrade and then insert manually these entries into the db?

Thanks,
Stefano
PS. Sorry for my bad english.

Comments

jacqi.jordan’s picture

I am also experiencing these errors on a fresh install of Drupal 6.28 when updating the Location module from 6.x-3.2 to 6.x-3.3:

warning: array_merge() [function.array-merge]: Argument #2 is not an array in /xxx/xxx/Sites/xxx/update.php on line 173.

warning: Invalid argument supplied for foreach() in /xxx/jxxx/Sites/xxx/update.php on line 340.

Only local images are allowed.

Aceman’s picture

Same for me, I'm Italian too.
While updating I got this error message related to localization of Ivory Coast into Costa D'Avorio
But I can't find the .mysql file used for the import to correct the error.
So I've performed this workaround, I've set default language of my site to English, run the update that was complete successfully, then changed back the default language of my site in Italian.
It worked.

Ezio

legolasbo’s picture

Status: Active » Closed (outdated)

Closing old D6 issues as D6 is end of life