Tuesday, September 20, 2011

OpenERP - ProgrammingError: operator does not exist: integer = boolean

ProgrammingError: operator does not exist: integer = boolean
LINE 1: select name, model from ir_ui_view where (id=false or inheri...
                                                    ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

Well all that crap comes from the fact that an OpenERP object does not have a name... Thus undefined field is false so the error about boolean and then a cast issue in query...

Monday, September 19, 2011

OpenERP - Python - AttributeError: 'tuple' object has no attribute 'copy'

While OpenERP is a time saver for many aspects of writing a DB oriented app. Many aspects of the framework are left to the python and thus the framework.

I spent hours searching for this one...

AttributeError: 'tuple' object has no attribute 'copy'

I am too much use to declarative language like Java... so I still miss some basic reflex... This error was in the definitions of my class object:

lass bemedicalworksheet (osv.osv):
    _name = 'nisf.bemedicalworksheet'
    _columns = {
                'vipowigw': fields.boolean("Wigw"),
                },


well this last coma makes python thinking it is a tuple instead of a dictionnary...

Friday, September 09, 2011

Error 500 installing Joomla on OVH

I have not deployed / moved joomla we site since a while. Zipping and unzipping to another host put me in a permanent http 500 error. My hoster is OVH (very famous in France and Belgium).

The solution:  php script but be readable not writable, the administrator directory must be configured with chmod 755.