Btw, it's 5 am here in Melbourne, Australia. :) I need to go and sleep. I have really no idea why the installer cannot find the file, if you have uploaded all the files. Make sure that the shoutbox_config.php is chmod to 777. I have to go now. :) good luck!

thanks!

i will give it a try!
good night! nice dreams...

edit:
i've reinstalled all, deleted the files in mysql
& started again..

don't know why it hasn't worked the first time...

it works now!!! :banana:

Erwin, this is a great hack, thank you. I installed this in a test database and it all went well. Only had to change the chmod to 777 in the shoutbox_config file and all went without a hitch.

The trouble is that I can't seem to get this to work in my regular database. I've installed and uninstalled three times and I am repeatedly coming up with this error message (yes, I deleted the shoutbox files in the database before I reinstalled, yes, I've tried it with the new templates installer, it just gave me more errors...

the error for the original install is as follows:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE `shoutbox` (`id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL default '', `comment` TEXT NOT NULL, `date` VARCHAR(30) NOT NULL default '', PRIMARY KEY (`id`))
mysql error: Table 'shoutbox' already exists

mysql error number: 1050

Date: Friday 27th of September 2002 02:11:05 AM
Script: http://www.mydomain.com/forum/forum/...ll.php?etape=1
Referer: http://www.mydomain.com/forum/admin/...ox_install.php

Is it saying the shoutbox already exists because it somehow connects to the test database? (again, I've repeatedly deleted the forum "home" database and started fresh).

And why does the script show double "forum/forum" ?

Sorry if this doesn't make sense, but I'm confused.


:ermm:

first of all:

i really like this hack!!!
works 4 me fine on 227 :banana:

had some probs so this could help u out!!!

havefun

Thank you, but that didn't solve the problem I'm having in the database.

WHen I run a query, as you said, it returns this error:

Error

SQL-query :

ALTER TABLE user
ADD shoutbox TINYINT DEFAULT 1 not null

MySQL said:

Duplicate column name 'shoutbox'

What seems to be happening is this: if you start the install clean it works, but if for some reason you interrupt the process, delete the templates from your database and start again, it tells you "shoutbox" already exists. I don't see it anywhere, and I don't know what needs to be deleted or where, in order to start with a clean slate.

Anybody?

I suspect all of you are moving from TWT's shoutbox. You need to delete the old table shoutbox and the column shoutbox in the user table using PHPMYADMIN. Then reinstall the database. Each time it says - "duplicate table or column".

Also, you cannot run the installer again and again - it will keep trying to put in the db tables and columns, which it can only do once. To skip to just the templates, use the template installer above.

Erwin, that's exactly what I did - I removed shoutbox and the shoutbox column in PHPMYADMIN. Reinstalled again, got the same 1060 error.

Then using the shoutbox_installer_templates you gave, I get another error:

') mysql error: You have an error in your SQL syntax near ''shoutbox','

I'm completely stumped.

I forgot to mention, above the mysql 1060 error message there is also this:

Warning: chmod failed: Operation not permitted in /home/channelv/mydomain/forum/admin/shoutbox_install.php on line 62

go to PHPMYADMIN on your database:

delete these 3 tables-->

shoutbox
shoutbox_ban
shoutbox_swears

and go to the table "user"
and delete the field shoutbox ...

perhaps you've forgotten to delete "shoutbox" in the table user
that could was the reason for getting the error massage on this
sql-query: ALTER TABLE user
ADD shoutbox TINYINT DEFAULT 1 not null
because it was already there...

had the same, just chmod it to 777 with your upload manager...

hope this helps!

That's what I told him, havefun. :)