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
GeoVe
0 posts
James Williams
74 posts
Johannes Vandenberg
14 posts
Soheil Barekat
4 posts
Peter Holroyd
51 posts
Neil Atkinson
5 posts
Trian Asmoro
1 posts
Erkan Polater
9 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 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