Clearchat.sql error while importing

New Member Joined: May 09, 2007 Posts: 9

anyone know what this is about? i have been getting this message all day when trying to install clearchat. because my customer is inputing a message and sending yet nothing is showing in the message box, i have been reinstalling this program all morning. anyone have any ideas? i've been reading about something about missing tables? is this correct?

as the site for clearchat says, no tech support for versions above 6.5...i have no help but to ask here.

thanks for reading

Code:

Error





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 @ 158


STR: '


SQL: 





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








SQL query:





UPDATE nuke_blocks SET content = CONCAT(content, '


� ClearChat') WHERE bkey = 'admin';





MySQL said: Documentation


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

Sells PC To Pay For Divorce Joined: Posts: 5661

well forget about the UPDATE nuke_blocks , does it still gives error then ?

Posted: Sat Jun 02, 2007 6:07 pm

REMOVED:
UPDATE nuke_blocks SET content = CONCAT(content, '
� ClearChat') WHERE bkey = 'admin';

Current message generated by MySQL:

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 )
);# MySQL returned an empty result set (i.e. zero rows).
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 )
);# MySQL returned an empty result set (i.e. zero rows).

Many thank yous for helping.

Posted: Sat Jun 02, 2007 6:09 pm

is it ok now or not ?

Posted: Sun Jun 03, 2007 7:18 am

Sorry, not.

Posted: Sun Jun 03, 2007 7:32 am

well i just installed it so no prob...
or contact me by msn

Posted: Sun Jun 03, 2007 7:35 am

ok, thanks.

Posted: Sun Jun 03, 2007 7:19 pm

seems i got the program installed however, messages are still not showing. when i reinstalled clearchat, this is the error message i get:

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) );# MySQL returned an empty result set (i.e. zero rows). 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) );# MySQL returned an empty result set (i.e. zero rows). UPDATE nuke_blocks SET content = CONCAT(content, '<br><strong><big>�</big></strong> <a href="modules.php?name=ClearChat">ClearChat</a>') WHERE bkey = 'admin';# Affected rows: 1

mySQL asks if i want to "edit" or "create php code". by far, this is the strangest thing i have ever encountered.

lastly, i noticed with my new phpMyAdmin version, it asks me for (while importing the file):

browse>language (utf8 is selected)>time out restart transfer..blah blah>compatibility (which i can select different MySQL versions)....

anyone? have an idea what is the problem? could it be that phpbb might have made some changes that wont allow the program to run properly?

registered · Posted: Sun Jun 03, 2007 8:49 pm

I don't see any errors in the above.

phpMyAdmin always has links for editing or creating PHP code from entered SQL.

Posted: Mon Jun 04, 2007 7:49 am

hmmm...odd. so basically, clearchat just wont work then. sad, i heard it was a great instant message chat program.

are there any alternatives?

Posted: Mon Jun 04, 2007 8:16 am

Well except for that one SQL statement where it was trying to update the blocks table, there were no errors at all. I have no experience with that application, so I can't help you.

I used an earlier version of php121 on a nuke site. It worked pretty well. But be advised there are similar instructions for integrating it into Nuke as would seem for ClearChat. Given that you had trouble earlier you might want to post something in the for hire forum and ask someone to integrate either ClearChat or php121 for you.

Posted: Tue Jun 05, 2007 4:19 am

well it iis one of the best and i allways used it...
i offered to help..

Posted: Tue Jun 05, 2007 9:01 am

i know you did hitwalker, i just have to figure it out myself. i can't keep asking people to fix things for me (or my client) or i wont feel like i am doing them service by charging them thousands of dollars for sites you understand i hope. plus, what kind of a 'designer' would i be if i couldn't figure this out for myself or learned how to do it.

thanks very much for the offer though. you generosity is very much appreciated.

Posted: Tue Jun 05, 2007 10:59 am

no prob befuddled....good luck.