Bug #133: Installation fails on postgres sql - Installation - Chamilo Tracking System

Actions

Copy link

Bug #133

open

Installation fails on postgres sql

Added by Stefaan Vanbillemont almost 14 years ago. Updated about 11 years ago.

Status:

New

Priority:

Normal

Assignee:

Target version:

Chamilo LCMS Connect - Backlog (default)

Start date:

29/10/2009

Due date:

% Done:

Estimated time:

Complexity:

Normal

Description

Reported by Isaac: http://www.dokeosplanet.org/forum/viewtopic.php?f=26&t=882

Related issues 1 (1 open — 0 closed)

Actions

Copy link

Updated by Hans De Bisschop almost 14 years ago

Status changed from New to Assigned
Assignee set to Hans De Bisschop
Priority changed from Normal to High
Target version changed from 3 to 2

Going to have a look at this. Considering we use MDB2 it should work. Without looking a the code, I'm guessing a MySQL-specific query could be the problem.

Actions

Copy link

Updated by Stefaan Vanbillemont almost 14 years ago

Hans,

Do you have an update on this issue? Was it MySQL-specific syntax? It this done?

Actions

Copy link

Updated by Stefaan Vanbillemont over 13 years ago

I tried this with a local postgresql installation just before the holiday. This is not fixed yet.

Actions

Copy link

Updated by Hans De Bisschop over 13 years ago

Priority changed from High to Normal

Stefaan Vanbillemont wrote:

I tried this with a local postgresql installation just before the holiday. This is not fixed yet.

That's why it wasn't marked as "Tested" or "Resolved" yet. There's several issues that prevent postgresql from working correctly. Not all of them can be fixed easily. Not sure full postgresql-support is realistic at this point. I will keep on looking for ways to optimize the database-layer and make things as compatible as possible, but there are some hinderances which might be near impossible to overcome.

The original issue was fixed (MySQL specific code when creating the platform-database) though. If and when there is some progress it'll be posted in this ticket.

Actions

Copy link

Updated by Hans De Bisschop over 13 years ago

% Done changed from 0 to 20

Some more tweaks were implemented recently. Indexes should no longer be a problem, but a few other minor problems still remain. Most should be resolved automatically when the semi-overhaul of the rights management application is finished.

Actions

Copy link