I am recieving these same errors, I tried the install, un-install, re-install method and it did not work.

Firstly, necromancy is frowned upon.

Secondly, please post the exact error you're getting.

PleegWat wrote:Firstly, necromancy is frowned upon.

Secondly, please post the exact error you're getting.

Sorry, I did a search and that was the post it refered me to.

I am using
PHP: 4.3.11
MySQL: 4.1.7
Here is my error

Code: Select all

Database Error1271: Illegal mix of collations for operation 'concat'
SQL:
UPDATE `roster_menu` SET `config` = CONCAT(`config`,':','b',LAST_INSERT_ID()) WHERE `section` = 'guild' LIMIT 1;
File: lib/dbal/mysql.php
Line: 203
Backtrace (most recent call last):
lib/functions.lib.php
Line: 240
Function Called: backtrace
lib/dbal/mysql.php
Line: 203
Function Called: die_quietly
lib/install.lib.php
Line: 271
Function Called: query
admin/addon_install.php
Line: 512
Function Called: install
Arguments:
1271: Illegal mix of collations for operation 'concat'
Database Error
/home/scott/domains/thefallenones.com/public_html/wow/lib/dbal/mysql.php
203
UPDATE `roster_menu` SET `config` = CONCAT(`config`,':','b',LAST_INSERT_ID()) WHERE `section` = 'guild' LIMIT 1;
admin/addon_install.php
Line: 46
Function Called: processaddon
pages/rostercp.php
Line: 116
Function Called: require_once
Arguments:
/home/scott/domains/thefallenones.com/public_html/wow/admin/addon_install.php
index.php
Line: 83
Function Called: require
Arguments:
/home/scott/domains/thefallenones.com/public_html/wow/pages/rostercp.php


I deleted this because what I posted was not a proper fix and I didn't want to confuse anyone.

Trying re-install as suggested.

That is not a proper fix
The column name `config` is correct

This is a mix of collations error, meaning one column got latin and the other got utf8 somehow
I would suggest removing your Roster database and starting over

I re-installed and am still getting the same error as before.

Both columns are 'utf8_general_ci'

Ok I made a small fix that made the addon load, but it seems this will be a problemwith all the CONCAT commands as I try to actually use the addons.

Everytime that command is used I get a simular error, I am in the process of locating and changing them all as I did this one.

Code: Select all

$this->sql[] = "UPDATE `" . $roster->db->table('menu') . "` SET `config` = CONCAT(CONVERT(`config` USING utf8),CONVERT(':' USING utf8),CONVERT('b' USING utf8),CONVERT(LAST_INSERT_ID() USING utf8)) WHERE `section` = '" . $scope . "' LIMIT 1;";

After checknig the database I can confirm the entry was made..though not sure if correctly.

The first entry was :b8, not sure if the first should be just b8 then the ones folling have a : before them.

Also I am not sure if this problem is only in my version of MySQL or what...

There is another instance of CONCAT in menu.php which i changed to look like this.

Code: Select all

         $query = "SELECT `guild_name`, CONCAT(CONVERT(`region` USING utf8),CONVERT('-' USING utf8),CONVERT(`server` USING utf8)), `guild_id` FROM `" . $roster->db->table('guild') . "`"
               . " ORDER BY `region` ASC, `server` ASC, `guild_name` ASC;";

This fixed my second error I was getting.

I have found CONCAT in a lot more documents and really don't want to spam the forums listing them along with the fixes as I am sure you get the idea by now, unless you want me to fix them all in which case I will.

I did a search on the forums through a bunch of threads and this seems to be a problem plaguing only 4.7.1 MySQL users. If this is the case I am wondering, do the developers plan on implimenting this fix for the sake of the few of us who might be using this version or will we have to offer 3rd-party support and manually patch each future release?