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.

Sunday, May 15, 2011

DocMan - Nooku - Joomla

As we are preparing a new release of our web site, I found a small post about DocMan a simple but well integrated document management for Joomla.
http://blog.joomlatools.eu/2011/04/sneak-peek-into-docman2-development.html

From there I discovered http://www.nooku.org the new Joomla extension framework. We are not migrating to 1.6 but of course we keep an eye at it.
As we are preparing a new release of our web site, I found a small post about DocMan a simple but well integrated document management for Joomla.
http://blog.joomlatools.eu/2011/04/sneak-peek-into-docman2-development.html

From there I discovered http://www.nooku.org the new Joomla extension framework. We are not migrating to 1.6 but of course we keep an eye at it.

Sunday, April 10, 2011

OpenERP POS Coming...

 Fabien posted a few documents concerning the touchscreen pos in OpenERP.

https://docs.google.com/leaf?id=0B8I9h53mJ-C_MWYwN2QzNDgtMGYwNi00M2QxLTliZDEtMzE2ZDg1MDU5NjE2&sort=name&layout=list&num=50

https://docs.google.com/leaf?id=0B8I9h53mJ-C_MTFlY2M2OTEtY2RjMS00MTFjLTg4M2EtZjg1ZDc0OGFmYWE3&sort=name&layout=list&num=50


Obviously this may help introducing OpenERP into a lot of potential small companies...

Saturday, April 02, 2011

OpenERP 6.0.2 is out - community days

So this is an important bug fix release which is out and I will start testing no later than tomorrow.

April 13 -, we will have the community days in Louvain La Neuve in Belgium. The url below point to the registration application:


http://openerpcommunitypartnersday.eventbrite.com/

Sorry, not publishing more about OpenERP right now. Too much projects and a lot really of work since the start of the week.

Monday, February 21, 2011

Joomla 1.6 - mxed feeling

Joomla 1.6 is finally released. I will not comment on the API changes, I had no time to look at it. For the web site designers two things are important: improved granularity for the access security. And the removal of the section/category classifcation by an unlimited levels of categories.

The last one is great. Things that are so limited (2 levels) are usually poor design. They however usually have their origin in the difficulty to maintain a  tree in SQL.

On the other side, this was not the major issue with Joomla classification. The key issues remain: an article is only in one category and categories applies to article, nothing else...

Modularity is great, but key supporting features need to be in the kernel. Joomla is moving to the right direction but slowly !

Friday, February 04, 2011

Pychecker

I will not discuss the pro and cons of Python vs Java. But I regret everyday my taking care compiler / ide.

Simple syntax error like a missing bracket , a bad function description are enough to get a module unloadable by OpenERP. Things that would be immeidlately noticed with Netbeans online compile consume sometimes hours of vain and frustrating research....


This morning I found a good tool, similar to lint but for Python :
http://pychecker.sourceforge.net/

It really helps...

Tuesday, January 25, 2011

Happy new year... Version 6 of OpenERP finally there

So I am starting 2011 as I finished 2010 - very busy.

The great news is that indeed version 6 of OpenERP is finally out.

For the blog, I will concentrate on OpenERP programming but also functional experience this year.

I wish to all those reading this blog from time to time a very happy 2011 !