Payment - database error

Hi

when i go to Payment in admin module so I can add my paypal information there I get this database error from the Payment mod

_______________________________________________________________

Database error in mysite.com
Query:

SELECT
`tsm`.`id` AS `id`,
`tsm`.`uri` AS `uri`,
`tsm`.`title` AS `title`
FROM `bx_pmt_modules` AS `tm`
LEFT JOIN `sys_modules` AS `tsm` ON `tm`.`uri`=`tsm`.`uri`
ORDER BY `tsm`.`date`

Mysql error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

Found error in the file '/home/xxxxx/public_html/xxxxx/modules/boonex/payment/classes/BxPmtDb.php' at line 311.
Called 'getAll' function with erroneous argument #.

----------------------------------------------------------------------

any Idea why  i'm having this error and how to get it to work

Thank's

Ticket was added : http://www.boonex.com/trac/dolphin/ticket/2211

Thank's for that ShasaE

but any idea how to get it fix so I can get to work

Thank's

make collation as  utf8_general_ci for sys_modules table

I did it but still giving me the same database error

Now is working I found all this  >>> CHARACTER SET utf8 COLLATE utf8_unicode_ci

I have to fix all this

________________________________________________

--

-- Table structure for table `sys_modules`

--

CREATE TABLE IF NOT EXISTS `sys_modules` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`vendor` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`version` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`update_url` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`path` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`uri` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`class_prefix` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`db_prefix` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`dependencies` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

`date` int(11) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `path` (`path`),

UNIQUE KEY `uri` (`uri`),

UNIQUE KEY `class_prefix` (`class_prefix`),

UNIQUE KEY `db_prefix` (`db_prefix`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;

_______________________________________________________________

To this

--

-- Table structure for table `sys_modules`

--

CREATE TABLE IF NOT EXISTS `sys_modules` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`title` varchar(255)  NOT NULL DEFAULT '',

`vendor` varchar(64)  NOT NULL DEFAULT '',

`version` varchar(32)  NOT NULL DEFAULT '',

`update_url` varchar(128)  NOT NULL DEFAULT '',

`path` varchar(255)  NOT NULL DEFAULT '',

`uri` varchar(32)  NOT NULL DEFAULT '',

`class_prefix` varchar(32)  NOT NULL DEFAULT '',

`db_prefix` varchar(32)  NOT NULL DEFAULT '',

`dependencies` varchar(255)  NOT NULL DEFAULT '',

`date` int(11) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `path` (`path`),

UNIQUE KEY `uri` (`uri`),

UNIQUE KEY `class_prefix` (`class_prefix`),

UNIQUE KEY `db_prefix` (`db_prefix`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;

___________________________________________

Thank's  SashaE