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

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

بواسطة - Ixbalanque Millan
عدد الردود: 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?
متوسط التقييمات: -
رداً على Ixbalanque Millan

Re: exabis e-Portfolio-Module

بواسطة - Kelly Kungle
No solution yet. I think the tables need updated, but I am not sure how to do that.
رداً على Kelly Kungle

Re: exabis e-Portfolio-Module

بواسطة - 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
رداً على Ixbalanque Millan

Re: exabis e-Portfolio-Module

بواسطة - Vedran Mušica
OK, so we have one step confirmed - it is error in Moodle that uses Postgres...

Any info?
رداً على Vedran Mušica

Re: exabis e-Portfolio-Module

بواسطة - 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

مبتسم good luck
رداً على Vedran Mušica

Re: exabis e-Portfolio-Module

بواسطة - 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