Installation problem....

[mynul]

Hi all there,

I'm trying to install chat in my site but nothing happening!!! When i test it in my LOCAL PC everything works!:) BUT when i try to do it on the SERVER nothing comes at all... The only messege come is - "Chat loading ... Please wait " then done and the FREE CHAT ICON.

Please tell me what is the problem. I tried both file system and MySql container. Both works in my LOCAL PC but fails in SERVER. I'm using Networksolutions Hosting service. I've configured all the necessary configurations for DB, but..........................

you can check it @ http://www.lemon24.com/adda/chat.php

Please help me I need to make it run!!!!

[OldWolf]

After loading it to the site, try a manual rehash: http://www.phpfreechat.net/rehash

[mynul]

I do not c anything...???? How do I REHASH???? you please go to the link I've provided! I don't C anything at all...... just the LOADING message! Please check this link - http://www.lemon24.com/adda/chat.php

Help please !

[OldWolf]

The link I provided is fine, and I understand that your chat isn't loading... please calm down. I'll repeat what I said in my last message: "After loading it to the site, try a MANUAL rehash." Go back to the link I provided and follow the instructions for a manual rehash. If that still doesn't work come back and report the results and I'll continue.

[mynul]

I did what you asked but then I got the following MESSAGES -
*********************************************************************

Warning: mysql_list_dbs() [function.mysql-list-dbs]: Unable to save MySQL query result in /data/17/0/74/37/74689/user/75964/htdocs/lemon24/adda/src/containers/mysql.class.php on line 109

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /data/17/0/74/37/74689/user/75964/htdocs/lemon24/adda/src/containers/mysql.class.php on line 110

Warning: file_get_contents(/data/17/0/74/37/74689/user/75964/htdocs/lemon24/adda/src/../version.txt) [function.file-get-contents]: failed to open stream: No such file or directory in /data/17/0/74/37/74689/user/75964/htdocs/lemon24/adda/src/pfcglobalconfig.class.php on line 976

phpFreeChat cannot be initialized, please correct these errors:

* Mysql container: create database error 'Can't create database 'lemon'; database exists'


*********************************************************************

what to do now????

[OldWolf]

Interesting MESSAGES. What other modifications have you made besides attempting to use the MySQL container... could you please post your chat file's contents?

[mynul]

Please.............!!!!

Here is the link to my source http://lemon24.com/adda.rar

I'm reminding you once again that it is running fine on my LOCAL PC (windows) but failing on the Web SERVER (Linux).

When I 1st tried to use the MySql container I got some Message like -
*********************************************************************************
phpFreeChat cannot be initialized, please correct these errors:

* Mysql container: create table error 'Specified key was too long; max key length is 1000 bytes'
*********************************************************************************
So i had reduced the Mysql variables a little bit (varchar of 50 instead of 60, int of 30 in place of 32 and so on) and the ERROR was not there. but now it is not connecting at all or something else!

Please help me out!!!

[OldWolf]

You really need to take a breath and relax... I am offering you support, no need to freak out.

Your file looks fine assuming you have the proper mysql info there when it's not blanked out.

So, assuming you didn't make changes to anything but chat.php, my next recommendation would be to totally wipe the chat db (remove all the tables) to give the chat another chance to install.

Your solution to the presented mysql may actually be what's causing all the errors, you should never be messing with the variable lengths (thus why your getting errors about the inability to store values... not enough space for them). The error you got was telling you the NAME of the table or one of the fields was too long, not the values.

[mynul]

Ok now I did remove the DB and reinstalled a FRESH copy with MySQL container. Please see what is the problem now!?

here it is - http://www.lemon24.com/chitchat/chat.php

if i keep the default values as -
=========================
$cfg["mysql_fieldtype_server"] = 'varchar(32)';
$cfg["mysql_fieldtype_group"] = 'varchar(64)';
$cfg["mysql_fieldtype_subgroup"] = 'varchar(128)';
$cfg["mysql_fieldtype_leaf"] = 'varchar(128)';
$cfg["mysql_fieldtype_leafvalue"] = 'text';
$cfg["mysql_fieldtype_timestamp"] = 'int(11)';
$cfg["mysql_engine"] = 'MyISAM';
=========================
The DB is not created and -
================================================================
phpFreeChat cannot be initialized, please correct these errors:
* Mysql container: create table error 'Specified key was too long; max key length is 1000 bytes'
================================================================
ERROR comes.

But when i reduce only 2 values -
***************************************************
$cfg["mysql_fieldtype_group"] = 'varchar(50)';
$cfg["mysql_fieldtype_subgroup"] = 'varchar(120)';
***************************************************
The DB is created and the result is there in front of you! (http://www.lemon24.com/chitchat/chat.php)

What to do NEXT???? Loosing hope! if there is a problem then why is it running smoothly on my LOCAL PC????? I think there is some problem with the OS PLATFORM!

My LOCAL PC runs on windows but I have Apache server running on it with PHP5+ and Mysql5. One more thing, the display comes in BROKEN when I browse it with IE 6+. The user online list comes to the bottom.

Please do something!!!!!:(

[mynul]

Hello.........any solution?????