Error 206 The register is not in the database

May 31, 2007 2 Replies

I'm having this major problem I delete the register in the manager and now I can't get logged. I've tried some proceedings I saw in this forum and doesn't work( setting the registers # through the Administrator). Please can someone help !!


Hi Rene

You could run a SQL query to add your register back, but one of the things I've learned about RMS in the few months I've been working with this software is that sometimes there are multiple tables on the database that need to be updated with your queries; my suggestion is to wait and see if more experienced users can add to this disclaimer and suggest additional queries to update other tables I may not be aware of.

In administrator, connect to your database then run select * from register

if the results are blank then you indeed deleted your registers; if there are results then view the number field to determine how to configure your register setting in the register tab in administrator - configuration

if your register table is blank, use this to get back up running BACKUP FIRST

insert into register (description, number) values ('new register', 1);

this will create register number one for you with a register name of "new register", but will have no other register settings; go into store ops manager - database - registers and manually assign your register settings in terms of receipt printers, cash drawers, pole display, etc

h> I'm having this major problem I delete the register in the manager and now I

Thank you very much, that solve my problem I was very worried. Extremely useful information please take note.

Rene

"Rene" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required