[havefun]

Originally posted by Anitah
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?

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

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

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

hope this helps!