Installing modules in OpenERP with PostgreSQL 8.3

When using OpenERP 4.2.2. with PostgreSQL 8.3, a few SQL errors appear when installing new modules, with SUBSTRING appearing with dates.

A solution is suggested here (by cornflake on the OpenERP forum). Basically, it consists in replacing all occurences of “substring(date for 7)” by “to_char(date, ‘YYYY-MM’)” in /usr/share/tinyerp-server/addons/

It's only fair to share...Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on TumblrEmail this to someone

Leave a Reply

Your email address will not be published. Required fields are marked *