[SOLVED] PHP OpenChat - Doomed to blow out/abandoned?

[jeffery1493]

Hi PHP readers,

 

Has anyone out there used PHP OpenChat 3.0.2 

http://www.phpopenchat.org/

 

Its a downloadable live chat software utility that runs on PHP of course.

I noticed that their "American" forum sourceforge.net appears to be abandoned, but they are still active in Germany:

http://www.phpopenchat.de/

 

Anyway I had been using their software and incorporating it into my website for about a week when suddenly it bombed with this error:

 

>

Unknown error

Sorry, an error occurred.

at phpopenchat-3.0.2/include/adodb/drivers/adodb-mysql.inc.php:21

[2048] Declaration of ADODB_mysql::MetaDatabases() should be compatible with that of ADOConnection::MetaDatabases()

 

Could not connect to database! Please check your database setup in config.inc.php by using the POC Installer!

>>

 

I looked up this error in Google and found page after page, maybe 200 entries, all with websites which appear to be stuck abandoned at the same error (see below):

 

http://www.google.com/search?client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&channel=s&hl=en&source=hp&q=Declaration+of+ADODB_mysql%3A%3AMetaDatabases%28%29+should+be+compatible+with+that+of+ADOConnection%3A%3AMetaDatabases%28%29&btnG=Google+Search

 

 

I tried writing the PHP OpenChat people in Germany, even wrote personally to some of the programmers (through "Contact Us") and got no replies at all.

I even saw one of the writers was in the forum reading my post yesterday, and he just ignored me or never answered.

I used Babel Fish to translate, although I've heard that just about everyone living in Germany knows English.

 

Is this some kind of doomsday bug?    As far as I know I did nothing at all, just logged in one morning and there it was.  Other people have posted this bug saying the same thing happened to them, but I've never found an answer posted anywhere, just the question and then nothing else.    No idea how I might go about fixing it- but, this really sucks!!!!!

 

:'(

 

 

[jeffery1493]

Just a note- I redownloaded their software again and re-installed a fresh copy from scratch, and the same error comes up now immediately.

 

Its as if some kind of setting changed on my host site, some switch was flipped, but as far as I know I did nothing.

I even generated a new php.ini file, still, the error. 

Bizarre!

 

[jeffery1493]

Thinking maybe ADODB might be corrupted, I tried downloading a new copy of the ADODB drivers for PHP, here:

 

http://sourceforge.net/projects/adodb/files/adodb-php5-only/adodb-510-for-php5/adodb510.tgz/download

 

I found there was a 'drivers' directory that included the file being mentioned. 

I loaded a new copy of PHPOpenChat 3.0.2 and replaced these new downloaded ADODB drivers with the ones they provided (including adodb-mysql.inc.php, just the contents of the drivers directory) and now I am getting this error instead:

>>>>

at /home/public_html/phpopenchat-3.0.2/include/adodb/drivers/adodb-mysql.inc.php:21

[2048] Declaration of ADODB_mysql::SelectLimit() should be compatible with that of ADOConnection::SelectLimit()

 

Could not connect to database! Please check your database setup in config.inc.php by using the POC Installer!

>>>>>

 

 

 

I checked the web as far as I know I'm the only person to get this error that reported it at least as far as Google is concerned.......

 

 

[jeffery1493]

OKAY****************

 

 

I appear to have found out how to fix this bug:

 

First, use the downloaded copy of the adodb files from the link I gave above:

 

http://sourceforge.net/projects/adodb/files/adodb-php5-only/adodb-510-for-php5/adodb510.tgz/download

 

2.  take the .tgz file and put it in the openchat/include directory

3.  unpack the file with:

gunzip -c adodb510.tgz | tar -xvf -

mv adodb adodb_old

mv adodb5 adodb

 

4.  Edit class.Chat.inc

vi class.Chat.inc

Find:

    //create a database object

    $this->db = &NewADOConnection( DATABASE_DRIVER );

 

Replace with:

 

    //create a database object

    $this->db = NewADOConnection( DATABASE_DRIVER );

 

5. Save file, then clear cache and all cookies

6. Re-enter PHP OpenChat.  You may find all of your users are gone.

However, I re-registered new users, and knock on wood- they are all working   

 

 

I hope this is of use to somebody!    Good night.

 

 

 

 

[drkmind]

ok tanks

this really works

tanks

[Odjavel]

Hi,

 

Thanks for your post. I'm trying to install PHPOpenChat on my Fedora 11. I had the same issues at the beginning of your post, and follow your clues. I made all that you indicate, and at the end, when I do this :

 

4.  Edit class.Chat.inc

vi class.Chat.inc

Find:

    //create a database object

    $this->db = &NewADOConnection( DATABASE_DRIVER );

 

Replace with:

 

    //create a database object

    $this->db = NewADOConnection( DATABASE_DRIVER );

 

I have a new issue when I test :

 

Erreur d'analyse XML : aucun élément trouvé

Emplacement : http://192.168.0.5/web/phpopenchat/

Numéro de ligne 2, Colonne 1 :

 

When I check immediately after that test my /var/log/httpd/error_log, I have those following issues :

 

[Fri Jun 18 01:39:59 2010] [error] [client 192.168.0.4] PHP Warning:  include_once() [<a href='function.include'>function.include</a>]: Failed opening '/var/www/html/web/phpopenchat/include/templates/openchat/web.tpl' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/web/phpopenchat/include/class.Template.inc on line 331

[Fri Jun 18 01:40:21 2010] [error] [client 192.168.0.4] PHP Notice:  Undefined offset:  1 in /var/www/html/web/phpopenchat/include/class.Template.inc on line 276

[Fri Jun 18 01:40:21 2010] [error] [client 192.168.0.4] PHP Warning:  include_once(/var/www/html/web/phpopenchat/include/templates/openchat/web.tpl) [<a href='function.include-once'>function.include-once</a>]: failed to open stream: No such file or directory in /var/www/html/web/phpopenchat/include/class.Template.inc on line 331

[Fri Jun 18 01:40:21 2010] [error] [client 192.168.0.4] PHP Warning:  include_once() [<a href='function.include'>function.include</a>]: Failed opening '/var/www/html/web/phpopenchat/include/templates/openchat/web.tpl' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/web/phpopenchat/include/class.Template.inc on line 331

 

 

I've tryied to edit (vim) all the files listed, going to the incriminated lines, but I'm not strong enough to debug myself php scripts. Any help would be appreciated