[SOLVED]res.partner tables deleted, admin, all users lost. help login?

Question

I wanted to remove the default customers and partners that came with installing the apps in openerp when you load demonstration data. I went to res.partner field in pgAdmin III, view data, all rows, copied the first two rows, which rows are for company data and admin data, deleted all rows in the table through truncate cascaded command, and then attempted pasted the copied two rows in clipboard back into the table. Only one row could copy and that for the company data. That means i lost admin lo

Simplify it! · Accepted Answer

I think that you have to create a new database with no demonstration data. That's the best way. If you have data on the other database then do the same, create a new database and copy the rows that you need to the old database.

NEVER EVER touch the database with pgAdmin if you don't know what you are doing. There are loads of relations between tables that can be affected.

Gustavo · Answer

I think you would rather re-create the database from scratch, creating a new database is faster than rebuilding everything you deleted.

Or you can restore the backup

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Domain for res.partner having which are tagged with users ? Ratkaistu res.partner	2 lokak. 23	8008
Restrict duplicate phone number creation in res_partner odoo 16 res.partner	3 syysk. 23	4717
Insert/update via API trying to create contact with contact image included, not inserting or updating field image_1920 on res.partner res.partner	0 toukok. 23	4335
Bonjour à tous comment faire de telle sort qu'un utilisateur ne voit que ses propres "contact" créé. res.partner	1 toukok. 23	3500
Hello everyone how to make such a fate that a user sees only his own "contact" created Ratkaistu res.partner	1 huhtik. 23	3101

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!