Error With Upgrade Tool

I have just run the upgrade tool but it failed. When setting up version 7 there is the option of specifiying what prefix to give all tables and stored procedures, in my case I chose to prefix them with "wwf".

The upgrade tool does not search for or ask for this prefix and so failed. I think that it is a fairly simple task to add another form field in the initial page to enter this, or maybe include the "admin/common.asp" file to pick it up.

I am hoping that the upgraded application will use this prefix or else I'm up the creek.

It's a shame, because I like this application very much, and have defended it against rivals.

Finally managed to upgrade (I think) and yes, the prefix isn't included, so had to edit "Const strDbTable" in "setup_options_inc.asp" in the includes folder. It seems to be working now, though not done any proper testing.

I wished too soon!

Trying to login, getting invalid column name in tblAuthor, Password and Salt. Created them manually based on the information in the create tables asp and wont't login saying invalid username/password. Tried to create a new user and got

"Item cannot be found in the collection corresponding to the requested name or ordinal.

/scripts/forum/register.asp, line 886"

It just goes from bad to worse!!!

Edited by Jonathan8146 - 02 May 2006 at 12:27pm

Thanks. I found that variable and edited it but in the end I started from scratch and created new tables, as it is only a test system.

I may try to upgrade the old tables again, but not sure if I'll have the time. If I do I'll let you know how I get on.

Why are your password and salt fields missing??!!

Without these fields, then yes you will get errors in the loginUser() function, which is throwing the error.

Thats impossible, the password field has been there since version 1 back in 2001, and the salt field was added in version 6 back in 2003

Without these fields then no version would run, so I don't no what's going on with your database, unless you modified it in some way to use a different login system.

The password field stores the password for the user since day 1, and without it no-one can login. The salt field stores the salt value for encrypted passwords, also required so users can login.