[SOLVED] G2 issues #3: Can't upgrade Webcam module

Hi,

I've having a few problems with G2 and this is the third (and last) in a set of posts that will list them.

#3: Can't upgrade Webcam module

When I try to upgrade the Webcam module from 0.8.5 to 0.9.3 I get the following error:

Error Detail -
Error (ERROR_STORAGE_FAILURE, ERROR_UNKNOWN)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1190 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 241 (mysqldatabasestorage::execute)
* in modules/webcam/module.inc at line 90 (gallerystorage::execute)
* in modules/core/classes/GalleryModule.class at line 137 (webcammodule::upgrade)
* in modules/core/AdminModules.inc at line 85 (webcammodule::installorupgrade)
* in main.php at line 173 (adminmodulescontroller::handlerequest)
* in main.php at line 79
* in main.php at line 70

Any idea what might cause this? Database structure, possibly?

R.
----

Gallery URL (optional): http://gallery.robinbowes.com
Gallery version: G2 Beta (from CVS) (How do I tell the version no.?)
Webserver (with version): apache 2.0.52
Datatabase (with version): 4.1.7
PHP version (eg 4.2.1): 4.3.10
phpinfo URL (optional):
Graphics Toolkit(s): NetPBM
Operating system: Fedora Core 3
Web browser/version: Firefox
G1 version (for migration bugs):

OK:

mysql error: [1267: Illegal mix of collations (utf8_general_ci,IMPLICIT)
and (latin1_swedish_ci,COERCIBLE) for operation 'concat'] in
EXECUTE("UPDATE g2_Entity
		    SET g_entityType = 'GalleryPhotoItem',
			g_onLoadHandlers = CONCAT(g2_Entity.g_onLoadHandlers, 'WebCam|')
		  WHERE g2_Entity.g_entityType = 'GalleryLiveImage'
		    AND g2_Entity.g_onLoadHandlers IS NOT NULL")

I'm looking into this as I see the same error when upgrading the Random Highlight module.

Update:

This was fixed by setting the default character set and collation for mysql by adding the following lines to the [mysqld] section of /etc/my.cnf:

character_set_server=utf8
collation_server=utf8_general_ci

R.