Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Admin Login Probs After Upgrade
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

mrjamin
Starting Member

United Kingdom
11 Posts

Posted - 20 December 2004 :  10:20:53  Show Profile
Hi All,

I've just upgraded my Snitz Forum from 3.3.05 to 3.4.05, and for some reason I can no longer login as the admin user. Using the previously working username/password combo returns a "Your username and/or password were incorrect" error.

The previous version of the forum is still running and the login details work fine for that one. Any suggestions would be most welcome.

I'm using Access as the database.

Ben C.

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 December 2004 :  10:25:59  Show Profile  Send ruirib a Yahoo! Message
Are you using two different databases, one for each version? Did you get the message that the upgrade completed without errors? How did it go?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 20 December 2004 :  10:26:08  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
what rurib said lol

-Stim

Edited by - Da_Stimulator on 20 December 2004 10:26:42
Go to Top of Page

tpingree
Starting Member

USA
4 Posts

Posted - 20 December 2004 :  13:24:36  Show Profile
quote:
Originally posted by mrjamin

Hi All,

I've just upgraded my Snitz Forum from 3.3.05 to 3.4.05, and for some reason I can no longer login as the admin user. Using the previously working username/password combo returns a "Your username and/or password were incorrect" error.

The previous version of the forum is still running and the login details work fine for that one. Any suggestions would be most welcome.

I'm using Access as the database.

Ben C.

Go to Top of Page

tpingree
Starting Member

USA
4 Posts

Posted - 20 December 2004 :  13:26:21  Show Profile
I'm also having problems logging on as admin user. I logged on a few days ago and everything was fine, then all of the sudden my user name and password are denied. I have not updated anything. Any suggestions or help is appreciated.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 December 2004 :  14:02:17  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by tpingree

I'm also having problems logging on as admin user. I logged on a few days ago and everything was fine, then all of the sudden my user name and password are denied. I have not updated anything. Any suggestions or help is appreciated.


What do you mean 'denied'? What is the message you get?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts

Posted - 20 December 2004 :  14:02:30  Show Profile  Visit PeeWee.Inc's Homepage
Have a look in the DB and see if the username you input is the same as within the DB

De Priofundus Calmo Ad Te Damine
Go to Top of Page

tpingree
Starting Member

USA
4 Posts

Posted - 20 December 2004 :  15:18:45  Show Profile
quote:
Originally posted by ruirib

quote:
Originally posted by tpingree

I'm also having problems logging on as admin user. I logged on a few days ago and everything was fine, then all of the sudden my user name and password are denied. I have not updated anything. Any suggestions or help is appreciated.


What do you mean 'denied'? What is the message you get?


Your username and/or password was incorrect.
Go to Top of Page

tpingree
Starting Member

USA
4 Posts

Posted - 20 December 2004 :  15:21:08  Show Profile
quote:
Originally posted by PeeWee.Inc

Have a look in the DB and see if the username you input is the same as within the DB


I don't know where the DB resides. I don't mean to sound stupid . . . the person who set this up for me has since left the company. I work in sales support for my company and maintain the Web site where our sales reps will access this forum. Where might I access the database? Thanks so much for your help!
Go to Top of Page

mrjamin
Starting Member

United Kingdom
11 Posts

Posted - 21 December 2004 :  08:35:22  Show Profile
quote:

Are you using two different databases, one for each version? Did you get the message that the upgrade completed without errors? How did it go?



I'm using two different databases. The original 3.3.05 was copied to a new folder with the 3.4.05 files. The upgrade was then performed using new folder/setup.asp. The upgrade seemed to be completed successfully, except for the following error:

Error: 80040E37 Table 'FORUM_MEMBERS_PENDING' does not exist.
strUpdateSql: DROP TABLE FORUM_MEMBERS_PENDING

Ben C.
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts

Posted - 21 December 2004 :  08:55:32  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
quote:
I don't know where the DB resides.


Look at the connection string in config.asp. It should tell you the type and location of the database.

Don't post the connection or path to the database here.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

mrjamin
Starting Member

United Kingdom
11 Posts

Posted - 23 December 2004 :  05:55:11  Show Profile
Hi,

The connection string information is all correct. As I mentioned, it's an Access database. The path is correct to the updated database, and viewing the front-end works absolutely fine. The problem is that when I try and login as the admin user, I get an "incorrect username/password" error, even though the details are correct and the only thing that's changed is that the database has been upgraded. If if use the old installation with the old database, the login details work fine.

Ben C.
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts

Posted - 23 December 2004 :  10:42:37  Show Profile  Visit PeeWee.Inc's Homepage
Make a new user, then edit config.asp to make that user the super admin. When this is done you can check to see if the "old" admin was still set as a Admin or if that setting somehow got reset.


Const intAdminMemberID = 6


Edit the number to the new users memberID.

De Priofundus Calmo Ad Te Damine
Go to Top of Page

mrjamin
Starting Member

United Kingdom
11 Posts

Posted - 29 December 2004 :  07:02:30  Show Profile
[quote] Make a new user, then edit config.asp to make that user the super admin. When this is done you can check to see if the "old" admin was still set as a Admin or if that setting somehow got reset.

Const intAdminMemberID = 6

[/url]

Thanks for the suggestion, but that was one of the first things I tried. The new install won't allow new users to be created either - it throws an error:

Microsoft JET Database Engine error '80004005'

Field 'FORUM_MEMBERS.M_SIG' cannot be a zero-length string.

/dlmovie/forum3/register.asp, line 568

Of course, not being able to access the admin area means that I can't check if the signature option is enabled/disabled.

Ben C.
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts

Posted - 29 December 2004 :  13:59:53  Show Profile  Visit PeeWee.Inc's Homepage
You can edit that via the DB.

De Priofundus Calmo Ad Te Damine
Go to Top of Page

mrjamin
Starting Member

United Kingdom
11 Posts

Posted - 06 January 2005 :  20:02:13  Show Profile
Good point

That managed to sort out the ASP error. Unfortunately it still won't let me login as admin. I've changed the value of "intAdminMemberID" in config.asp to that of the new user. The user can login normally without a problem, but is not recognised as the admin (i.e. no "admin options" link after login, nor is login allowed via admin_home.asp).

Is there anything that needs to be done to make the forum "initialise" changes to config.asp?

Ben C.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.58 seconds. Powered By: Snitz Forums 2000 Version 3.4.07