You’re offline. This is a read only version of the page.
Hello
I tried to log in with ID and Password when i opened store last week.
but I couldn't log in at all. I log in previous day without any problem.
and I finally knew that all ID and Password was gone away. nothing ID and Password.
Is there anybody who experienced this kind of problem?
I'm not sure but I think it can be kind of virus or system problem.
In short, all ID and Password was removed automatically.
Could you let me know what situation it is?
Best regards,
Peter
*This post is locked for comments
Could be lots of things.
virus
SQL injection
bad spot/block on hard drive
bad index within SQL
one cannot delete all cashiers from within the program, but can with a SQL script
Hi Peter.
This is very strange, as the Cashiers (or other records in the RMS tables) can't be deleted just like that. There must be something or someone deleting the records from the database.
I would suggest this next (depending on what version of SQL you are using): repeat the process of copy an user (ID and password) from another DB and create an SQL Server Profiler Trace over that particular db and/or table "Cashier" (You can use the standard SQL Server Profiler, I'm also using the AnkLab.SqlProfiler). The next time you notice that this happens again, stop the Profiler trace and filter it down to find out who is deleting the cashier records. Please remember not to close the profiler trace, not to stop it, not to turn off the PC and similar...
Hope this helps.
Kind regards, A.
I tried like above. but nothing is in there.
No ID and No Password at all. I do not know why?
It can be happened sometimes?
You think somebody interrupt me?
I mean somebody access my server and delete all of them? is there any other way that this kind of thing can be happened?
Anyway I copied some ID and Password from other DB that i used before and pasted those to current DB. so i recover register somewhat. but it is deleted again completely after one day!
Hi Peter
Okay in that case you need to see which cashiers RMS knows about. Launch SO Admin and connect to your database. Select New - Query and then type
SELECT * FROM CASHIER
This will list all the cashiers, this should help prompt you which cashiers you have available to log in with.
Thanks
Simon
I tried with ID=1 password=Password
but it didn't work at all. T..T
Hi Peter
This is unusual as RMS will not let you delete yourself as the logged in cashier so it is difficult to remove all cashiers via the UI.
Have you tried to log on using the default credentials user ID = 1 and password = Password (note the capital P in the password)?
Cheers
Simon
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (