Clearchat.sql error while importing

befuddled_nerd · 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, ' <big>�</big> <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'

persona_non_grata · Joined: Posts: 0

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

befuddled_nerd · New Member Joined: May 09, 2007 Posts: 9

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.

persona_non_grata · Joined: Posts: 0

is it ok now or not ?

befuddled_nerd · New Member Joined: May 09, 2007 Posts: 9

Sorry, not.

persona_non_grata · Joined: Posts: 0

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

befuddled_nerd · New Member Joined: May 09, 2007 Posts: 9

ok, thanks.

befuddled_nerd · New Member Joined: May 09, 2007 Posts: 9

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, ' <big>�</big> <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?

Gremmie · 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.

befuddled_nerd · New Member Joined: May 09, 2007 Posts: 9

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

are there any alternatives?

Gremmie · 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.

persona_non_grata · Joined: Posts: 0

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

befuddled_nerd · New Member Joined: May 09, 2007 Posts: 9

i know you did persona_non_grata, 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.

persona_non_grata · Joined: Posts: 0

no prob befuddled....good luck.