This question has been flagged
2 Replies
5835 Views
loginwin7baseno
Avatar
Krzysztof

Hello there! I need help! I can no longer login to my openerp after updating "base" module... What can i do with this issue? I'm trying to use openerp-server.exe -d DB_NAME -u all but still with no positive result (problem remains). I have edited product.product.tree view for more friendly view for me... where i can find xml file for this view and change this as default (maybe this block my manual update and i can't login?)? What i can now do? Re-install OpenERP and then make update of database, or something else?
I have no idea... The data is very important for me... but i don't have a backup with "realtime" records... only backup with data before 2 weeks agoo.
Please, i need quick help! I can't give invoices i don't know state of my product in stock! Win7, OpenERP 7.0-20130703-231023, web client

Below is the error what i get when i try to log-in:

Nieprawidłowa nazwa użytkownika lub hasło (BAD USERNAME OR PASSWORD)

OpenERP Server Error

Client Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\http.py", line 204, in dispatch

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\controllers\main.py", line 867, in authenticate

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\session.py", line 115, in authenticate

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\session.py", line 30, in proxy_method

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\session.py", line 103, in send

Server Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\web\session.py", line 89, in send

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\netsvc.py", line 292, in dispatch_rpc

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\service\web_services.py", line 433, in dispatch

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\service\web_services.py", line 444, in exp_authenticate

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\pooler.py", line 49, in get_pool

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\pooler.py", line 33, in get_db_and_pool

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\modules\registry.py", line 192, in get

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\modules\registry.py", line 218, in new

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\modules\loading.py", line 341, in load_modules

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\modules\loading.py", line 256, in load_marked_modules

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\modules\loading.py", line 188, in load_module_graph

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\modules\loading.py", line 76, in <lambda>

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\modules\loading.py", line 124, in _load_data

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\tools\convert.py", line 954, in convert_xml_import

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\tools\convert.py", line 847, in parse

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\tools\convert.py", line 814, in _tag_record

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server\openerp\addons\base\ir\ir_model.py", line 963, in _update

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\osv\orm.py", line 4470, in create

File "C:\Program Files (x86)\OpenERP 7.0-20130703-231023\Server\server.\openerp\osv\orm.py", line 1544, in _validate except_orm: ('ValidateError', u'Wyst\u0105pi\u0142 b\u0142\u0105d przy sprawdzaniu pola (p\xf3l) date_start,date_end: You cannot have 2 pricelist versions that overlap!')

Avatar
Discard
Avatar
kaynis
Best Answer

The issue is caused by either you made some changes to a core module or you recently added a module which is not properly coded. Think of the last changes you made and revert back

Avatar
Discard
Krzysztof
Author

previously i had a problem with the currency of exchange rates... i edited it and... the list with rates was not showing right (for records from 1 to 80 was OK, but record 81 (edited item) created a problem - an error occurred, i don't remeber exactly what kind of error but something like this: item XXX does not have a fixed exchange rate - and after that i just updated base module)... how can i restore default exchange rates in my database when i'm unable to login? sorry for my english

kaynis

You error is kind of giving a clue to what has happened. The problem has to do with the pricelists you have. Seem you have to state starts run simultaneously. log into the database and locate in the tables the pricelists table and remove one

Krzysztof
Author

Maybe this is silly question, but i'm not a computer kind guy... how can i log into database? pgAdminIII ?

kaynis

Yes please

Krzysztof
Author

well, i changed duration term of my pricelists... problem still exists. I cannot delete no one, because other records/keys are related to them... can i in some way import all data (stock, invoices, receipts, records from other modules that i use) to another clean database without error?

kaynis

What is the new error on the log? it should change to something else if you have done that

Avatar
Krzysztof
Author Best Answer

The problem was - like the kaynis said - in my pricelists. Deleting them and changing duration did not bring a solution, so... In pgAdmin III i exported my "broken" database in two ways; first: ALL data, tables, triggers, etc - FULL backup later: Only data without pricelists table
Then i imported in new fresh database only structure of my database: schemas, views, tables, etc without any data, and next that allowed me to imported only data with option disable triggers (<--- this is important, without this import is impossible [error with integrity of database]) from backup two, and then i copied default pricelist record to empty pricelist table.

Effect? It work's... i must only create new pricelists.
Thank you kaynis for directing me to the solution!

Avatar
Discard
kaynis

Glad i could help in any little way I can.