Printable View
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?
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 ?Quote:
Originally Posted by admin
WHY did this happen?
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.
If you can't get it working, PM me phpMyAdmin login details, i can fix it.Quote:
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`)
);