Error 206 The register is not in the database

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 !!

Reply to
Rene
Loading thread data ...

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

Reply to
convoluted

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

Rene

"Rene" wrote:

Reply to
Rene

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.