Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
befuddled_nerd
New Member
New Member



Joined: May 09, 2007
Posts: 9

PostPosted: Sat Jun 02, 2007 1:40 pm Reply with quote

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'
 
View user's profile Send private message
hitwalker
Sells PC To Pay For Divorce



Joined:
Posts: 5661

PostPosted: Sat Jun 02, 2007 5:49 pm Reply with quote

well forget about the UPDATE nuke_blocks , does it still gives error then ?
 
View user's profile Send private message
befuddled_nerd







PostPosted: Sat Jun 02, 2007 6:07 pm Reply with quote

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.
 
hitwalker







PostPosted: Sat Jun 02, 2007 6:09 pm Reply with quote

is it ok now or not ?
 
befuddled_nerd







PostPosted: Sun Jun 03, 2007 7:18 am Reply with quote

Sorry, not.
 
hitwalker







PostPosted: Sun Jun 03, 2007 7:32 am Reply with quote

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







PostPosted: Sun Jun 03, 2007 7:35 am Reply with quote

ok, thanks.
 
befuddled_nerd







PostPosted: Sun Jun 03, 2007 7:19 pm Reply with quote

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?
 
Gremmie
Former Moderator in Good Standing



Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Sun Jun 03, 2007 8:49 pm Reply with quote

I don't see any errors in the above.

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

_________________
GCalendar - An Event Calendar for PHP-Nuke
Member_Map - A Google Maps Nuke Module 
View user's profile Send private message
befuddled_nerd







PostPosted: Mon Jun 04, 2007 7:49 am Reply with quote

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







PostPosted: Mon Jun 04, 2007 8:16 am Reply with quote

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.
 
hitwalker







PostPosted: Tue Jun 05, 2007 4:19 am Reply with quote

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







PostPosted: Tue Jun 05, 2007 9:01 am Reply with quote

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.
 
hitwalker







PostPosted: Tue Jun 05, 2007 10:59 am Reply with quote

no prob befuddled....good luck.
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©