I am getting the error "User already logged in" I have searched this topic and tried several of the fixes with no results. Im using Version 15.2 and SQLlite.
User Already Logged in error
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
thank you so very much,
you are a life saver
thank you so very much,
you are a life saver
thank you so very much,
you are a life saver
you have to log into the sql
Start programs Microsoft SQL server Management Studio Express
Login into SQL Server Management Studio with login in is sa password is Prima123Vera
expand the databases and look for your database
click on new query
Select * from Usession
note the User_ID from the query that you just ran foro example user_id is 123
new query
UPDATE usesession
SET delete_session_ID=0, delete_date=GETDATE()
WHERE user_ID = 123
close the Microsoft SQL server Management Studio Express and log in
Cynthia,
I have a small application that I have created that may help.
If you can PM me with your contact details if you are interested & I can sent it through for you to try.
It allows you to clear old User Sessions, Clear Orphaned Project Sessions & Clear User Passwords.
I have tested it on SQLite and SQL only - not yet tested on Oracle as I don't have an Oracle Install to test against.
Create a copy of the .db file before running to ensure that you have a backup first.
Regards,
Steven