Author |
Topic |
mrjamin
Starting Member
United Kingdom
11 Posts |
Posted - 20 December 2004 : 10:20:53
|
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 |
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 20 December 2004 : 10:26:08
|
what rurib said lol |
-Stim |
Edited by - Da_Stimulator on 20 December 2004 10:26:42 |
|
|
tpingree
Starting Member
USA
4 Posts |
Posted - 20 December 2004 : 13:24:36
|
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.
|
|
|
tpingree
Starting Member
USA
4 Posts |
Posted - 20 December 2004 : 13:26:21
|
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. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 December 2004 : 14:02:17
|
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 |
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 20 December 2004 : 14:02:30
|
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 |
|
|
tpingree
Starting Member
USA
4 Posts |
Posted - 20 December 2004 : 15:18:45
|
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. |
|
|
tpingree
Starting Member
USA
4 Posts |
Posted - 20 December 2004 : 15:21:08
|
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! |
|
|
mrjamin
Starting Member
United Kingdom
11 Posts |
Posted - 21 December 2004 : 08:35:22
|
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. |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
mrjamin
Starting Member
United Kingdom
11 Posts |
Posted - 23 December 2004 : 05:55:11
|
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. |
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 23 December 2004 : 10:42:37
|
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 |
|
|
mrjamin
Starting Member
United Kingdom
11 Posts |
Posted - 29 December 2004 : 07:02:30
|
[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. |
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 29 December 2004 : 13:59:53
|
You can edit that via the DB. |
De Priofundus Calmo Ad Te Damine |
|
|
mrjamin
Starting Member
United Kingdom
11 Posts |
Posted - 06 January 2005 : 20:02:13
|
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. |
|
|
Topic |
|