(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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.
Printer-friendly version
Send to friend
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
Email: PPadmin@planningplanet.com
Replies