Working shoutbox for 3.0.7?

[trana]

Does anyone have a sidebar based shoutbox that actually works with 3.0.0.7?

Thanks.

[KW802]

Trana, have you checked the forums yet? People have successfully used the chat hack by GeekyDesigns, the one named BVShoutbox Full, and a few one-offs.

I'd go with the GeekyDesigns one.

[trana]

Yes, and I have installed two different versions. Have you used the Geekydesigns one with 3.0.7? I am getting an error that other people seem to have gotten as well:

Warning: DB_Sql_vb::halt(./includes/functions_log_error.php) [function.halt]: failed to open stream: No such file or directory in c:\Inetpub\wwwroot\forum\includes\db_mysql.php on line 389

Warning: DB_Sql_vb::halt() [function.include]: Failed opening './includes/functions_log_error.php' for inclusion (include_path='.;C:\php5\pear') in c:\Inetpub\wwwroot\forum\includes\db_mysql.php on line 389

BTW: the other script I tried with 3.0.7 is documented here:
http://www.vbadvanced.com/forum/showthread.php?p=46266&highlight=shoutbox#post46266

Several other people have had the same problem, so I'm fairly certain that it is not an install error. I have not received any help with it, so I'll give the Geekydesigns script a shot.

[KW802]

I've installed the GeekyDesigns one on 3.0.7 for a few different clients but... I can't recall if any them were using Windows or PHP 5. Are you getting those errors during the install or trying to run it?






(Disclaimer: When I say "clients" I mean in regards to non-vBadvanced customer clients since the installs I do through vBa are only for the vBa clients versus clients through other affiliations..... I figured I put this disclaimer here pre-emptively before anybody started asking. ;) )

[trana]

I get those errors during the install.

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE language ADD `phrasegroup_shoutbox` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_shoutbox'

mysql error number: 1060

[KW802]

Have you tried installing it multiple times or did you try installing multiple shoutboxes? It's possible that if you tried installing a shoutbox before the GeekyDesigns one then it used the name "shoutbox" already for the name of it's phrasegroup so now when you try to install the GD one it gives an error that it can't create the phrasegroup.

[trana]

I installed it multiple times. That still doesn't explain the DB errors I listed in the 3rd message.

[Cyricx]

Your running the installer, it's trying to add a phrase that is already there, so it gives you the error and stops.

You have those phrases in there. You need to delete all the old shoutbox phrases and then run the installer.

[trana]

You are only looking at the one set of errors.

I get three different sets of errors when going through the install process:

Warning: DB_Sql_vb::halt(./includes/functions_log_error.php) [function.halt]: failed to open stream: No such file or directory in c:\Inetpub\wwwroot\forum\includes\db_mysql.php on line 389

Warning: DB_Sql_vb::halt() [function.include]: Failed opening './includes/functions_log_error.php' for inclusion (include_path='.;C:\php5\pear') in c:\Inetpub\wwwroot\forum\includes\db_mysql.php on line 389

Followed by a window which says:
Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE language ADD `phrasegroup_shoutbox` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_shoutbox'

mysql error number: 1060

Followed by an email sent to me from the administrator with the following:
Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE shoutbox_posts (
`shoutid` BIGINT (255) UNSIGNED DEFAULT '0' AUTO_INCREMENT,
`text` TEXT,
`userid` BIGINT (255) UNSIGNED DEFAULT '0',
`username` VARCHAR (255) DEFAULT '0',
`ip` VARCHAR (25) DEFAULT '0',
`time` BIGINT (20) UNSIGNED DEFAULT '0',
`edittime` BIGINT (20) UNSIGNED DEFAULT '0',
`edituser` VARCHAR (255) DEFAULT '0',
`deleted` TINYINT(1) UNSIGNED DEFAULT '0',
PRIMARY KEY(`shoutid`))
mysql error: Invalid default value for 'shoutid'

mysql error number: 1067

Those look like three different sets of errors to me. The problem with the duplicate phrases is not an issue as it simply overwrites them.

[HeLL]

I get this error:

Warning: halt(): Unable to access ./includes/functions_log_error.php in /home/domains/ddl.hu/html/super/forum/includes/db_mysql.php on line 389

Warning: halt(./includes/functions_log_error.php): failed to open stream: No such file or directory in /home/domains/ddl.hu/html/super/forum/includes/db_mysql.php on line 389

Warning: halt(): Failed opening './includes/functions_log_error.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /home/domains/ddl.hu/html/super/forum/includes/db_mysql.php on line 389

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE vbf_shoutbox_posts (
`shoutid` BIGINT (255) UNSIGNED DEFAULT '0' AUTO_INCREMENT,
`text` TEXT,
`userid` BIGINT (255) UNSIGNED DEFAULT '0',
`username` VARCHAR (255) DEFAULT '0',
`ip` VARCHAR (25) DEFAULT '0',
`time` BIGINT (20) UNSIGNED DEFAULT '0',
`edittime` BIGINT (20) UNSIGNED DEFAULT '0',
`edituser` VARCHAR (255) DEFAULT '0',
`deleted` TINYINT(1) UNSIGNED DEFAULT '0',
PRIMARY KEY(`shoutid`))
mysql error: Invalid default value for 'shoutid'

mysql error number: 1067



How can i fix this????????

best regards: HeLL