Home > English, Tech Crunch > Installing modules in OpenERP with PostgreSQL 8.3

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/

Categories: English, Tech Crunch Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: