MySQL Error

Worker Joined: Mar 31, 2004 Posts: 111

does anybody know what this means

Code:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem





ERROR: Unclosed quote @ 198


STR: '


SQL: UPDATE nuke_blocks SET content = CONCAT(content, '&lt;br&gt;&lt;strong&gt;&lt;big&gt;?&lt;/big&gt;&lt;/strong&gt; &lt;a href="modules.php?name=ClearChat"&gt;ClearChat&lt;/a&gt;') WHERE bkey = 'admin'





SQL query: 





UPDATE nuke_blocks SET content = CONCAT(content, '<br><strong><big>?</big></strong> <a href="modules.php?name=ClearChat">ClearChat</a>') WHERE bkey = 'admin' 


MySQL said:  





#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'concat'

i'm trying to upload this into my database

Code:

CREATE TABLE nuke_clearchat


(


id int NOT NULL AUTO_INCREMENT,


username varchar(30),


comment text,


useraddress varchar(20),


date varchar(30),


PRIMARY KEY (id),


UNIQUE id (id)


);





CREATE TABLE nuke_ccerror


(


id int NOT NULL AUTO_INCREMENT,


username varchar(30),


userpw varchar(30),


realuserpw varchar(30),


useraddress varchar(20),


userinfo varchar(100),


date varchar(30),


errornumber varchar(20),


comment text,


PRIMARY KEY (id),


UNIQUE id (id)


);





UPDATE nuke_blocks SET content = CONCAT(content, '<br><strong><big>·</big></strong> <a href="modules.php?name=ClearChat">ClearChat</a>') WHERE bkey = 'admin';

that is what I'm trying to upload can anybody help

thank you

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

I'd suggest executing the statements one at a time so you can trap the error. Without testing it, it looks like the problem is in the nuke_blocks update.

Posted: Fri Dec 23, 2005 9:48 am

Why do you have that "dot" between the "big" and the end of the "big" in your statement? That seems to get translated into a ? I don't know if that could be the problem but it looks suspicious to me.