Cant upload with upgrade?

[musictvblogger]

ERROR: Unable to execute query

INSERT INTO `process_queue` SET
file='blahblah.mpg',
title ='You, You Blew it Up!',
description='The famous lines put to the famous works courtesy of http://www.mysomain.com',
keywords='damn you',
channels='7|22',
type='public',
user='fooledagain',
user_ip='xx.xxx.xx.xxx',
status=2
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='


I cant upload?

[admin]

Change the table collations to same as that of existing tables. You can do this in phpMyAdmin.

[musictvblogger]

Change the table collations to same as that of existing tables. You can do this in phpMyAdmin.

In "cpanelese" that means open the database, look for ? and change it to ?

WHY did this happen?

[admin]

It seems due to server setup. It work without any problem in cpanel servers.

collations is set my mysql, most servers it is set to latin by default.

We create table with following, with out specifying collations, it is added by your server, that create the problem.

CREATE TABLE `process_queue` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`keywords` varchar(255) NOT NULL,
`channels` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`status` int(2) NOT NULL,
`url` varchar(255) NOT NULL,
`file` varchar(255) NOT NULL,
`vid` int(11) NOT NULL,
`user_ip` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
);

If you can't get it working, PM me phpMyAdmin login details, i can fix it.