SPChat8.2

Client Joined: Apr 15, 2003 Posts: 466 Location: FL

I tried to update SPChat to the newer version. Upgrade failed.
I removed the old SPChat database and did a reupload. Still no good. I am getting this error:

Quote:

Database error: _SPCHAT_ALTERTABLEFAILED
SQL error: "Duplicate column name 'online_since'" SQL query: "ALTER TABLE nuke_spchat_user ADD online_since INT(11) AFTER msglastcheck;"

I'm no wiz bang on hacking around in there. Someone hold my hand! Please!

Posted: Sun Oct 03, 2004 4:13 pm

Oh c'mon. For you Nuke-Gods it is not that dark in here. I am just timid of php admin. HELP, please?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I have not tried the 8.2 but their installation scripts are usually pretty good. If you dropped all your old chat tables, then you shouldn't be using a script that alters anything. You should be performing a new installation. I would verify that you really dropped all the old tables and then make sure that you perform a new install.

Posted: Sun Oct 03, 2004 8:58 pm

Thank you Raven. I knew someone could turn the light on for me. I get so freaked out doing admin to php that I evidently missed something the first time. I went back and did it all over again and the new install went fine.
Thanks for waking me up---again. RavensScripts