Portfolios: Re: exabis e-Portfolio-Module--postgres error

Portfolios: Re: exabis e-Portfolio-Module--postgres error

by Ixbalanque Millan -
Number of replies: 6
Hi.

I have the same version of Moodle (1.8.4+), and eportafolio version is 2.1.3.

I have the same problem, are you can resolved the problem?
Average of ratings: -
In reply to Ixbalanque Millan

Re: exabis e-Portfolio-Module

by Kelly Kungle -
No solution yet. I think the tables need updated, but I am not sure how to do that.
In reply to Kelly Kungle

Re: exabis e-Portfolio-Module

by Ixbalanque Millan -
I make a test with Moodle in MySQL and works well, after I make the same test with Moodle in Postgres and appeared the error (no external links yet).

I hope that somebody help me
In reply to Ixbalanque Millan

Re: exabis e-Portfolio-Module

by Vedran Mušica -
OK, so we have one step confirmed - it is error in Moodle that uses Postgres...

Any info?
In reply to Vedran Mušica

Re: exabis e-Portfolio-Module

by Ixbalanque Millan -
This function doesn't exist in Postgres, the concatenate format in Postgres is with “ || ”. Thus, on lines 57, 62, 67 of extern.php file, I need to change:

CONCAT_WS(' ⇒ ', bc2.name, bc.name)
to
bc2.name || bc.name AS cname

Skipping the separator on query. That's all, I hope that this help you.

Now, with this you can view the external links.
A friend did the spanish package language.

Thanks Enrique

smile good luck
In reply to Vedran Mušica

Re: exabis e-Portfolio-Module

by Ixbalanque Millan -
The complete answer is:

Respect for the problem with E-portfolio, I have a solution. The problem is with call of function CONCAT_WS(); in extern.php file.

This function doesn't exist in Postgres, the concatenate format in Postgres is with “ || ”. Thus, on lines 57, 62, 67 of extern.php file, I need to change:

CONCAT_WS(' ⇒ ', bc2.name, bc.name)

to

bc2.name || bc.name AS cname

Skipping the separator on query. That's all, I hope that this help you.

Now, with this you can view the external links.


Sorry