Odoo/ OpenERP Common Errors

From last one month started working on OpenERP. While customizing code daily facing one or the other issue. So thought of keeping all of them at one place with solutions for future use and may be can help someone else as well :

1) AttributeError: 'NoneType' object has no attribute '_columns'

Solution : Problem is with your __openerp__.py file. Check depends attribute.

Reference Links :
http://stackoverflow.com/questions/10565288/attributeerror-nonetype-object-has-no-attribute-columns
http://forum.openerp.com/forum/topic24199.html

2) Openerp : new module is not showing into module list?

Solution : If you have developed a new module and it's in the addons folder but still not showing in the module list than follow following steps :

a) Restart OpenERP server by using command :

./openerp-server --addons-path=XXXX/XXXXXXX/addons/ (path of addons directory)

b) Go to the browser and open

localhost:8069 or 127.0.0.1:8069

c) Login into OpenERP; Go to Settings menu; Users; Select your user, edit it and check the check-box of 'Technical Features', save it and reload the web page.

d) Again Go to Settings, you will find two more options under Modules section

• Update Modules List
• Apply Scheduled Upgrades

Click on 'Update Modules list' option. Update modules.

e) Now search your module using 'Installed Modules' option.

That's it.

Reference Links :

http://stackoverflow.com/questions/3994955/openerp-new-module-is-not-showing-into-module-list

3) Model XXX is declared but cannot be added/loaded

Solution : Problem is with xxx model entry in ir_model table.

a) Login to PostgeSQL database using psql or pgAdmin III

b) Run following commands :

Delete from ir_model_constraint where model=(Select id from ir_model where name='xxx');

Delete from ir_model where name='xxx';

Hopefully this will fix your problem.

Reference Links :

http://openerp-community.2306076.n4.nabble.com/Openerp-community-Openerp-table-cleanup-td4642465.html

4) KeyError: 22

Solution: Most of the times this error is due to the wrong way of returning values from function. For more information, please check following reference link:

Reference Link:
http://stackoverflow.com/questions/15102388/how-add-a-function-in-openerp-7/15132719

Many more to come.....