Hi,
any news on this? Not being able to use multiple-choice-questions is very inconvenient. As I see this, my options are:

• downgrade to a version where this bug does not exist. As it appears this must be a version before 6.1.x and I'm afraid of downgrading so far back because of possible database changes on the way from 6.0 (or before) to 6.4.xx
• try to apply the mentioned fix ( bugs.limesurvey.org/view.php?id=19332#c79146 ), although this did not pass some tests

Any advice on how to handle this is welcome!

mmilinovsky wrote:

• try to apply the mentioned fix ( bugs.limesurvey.org/view.php?id=19332#c79146 ), although this did not pass some tests

If i use PG : i surely do this.
And try to help on the test (i clearly not understand too …)

Hi.

I guess I will give up this fix, and start a new LS installation from scratch.

Hi mferraz,

as I understood the problem, it will also occur on a new installation with Postgres, but I may be wrong.

Hi

Yes, what I've meant was a new installation on a MySQL database.

Ah, ok, I understand.

did you try the mentioned fix on your Postgres installation ( github.com/LimeSurvey/LimeSurvey/pull/3686/files )?

No, after two releases that simply made it impossible to use our installation I gave up...PostgreSQL should be removed from Limesurvey support.

I have the last version working with PGSQL.

I tried again, the last version, I'm asked for the database upgrade, and:
An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "user_status" cannot be cast automatically to type integer HINT: You might need to specify "USING user_status::integer".

Hi mferraz,

isn't that a different error as the one in this thread, as this one happens not during installation but when trying to create a multiple choice question?

This is on the login page when the database update is tried.

This is on the login page when the database update is tried.

did you try a completely fresh install or trying to "update/upgrade" your existing install? Because there could be a difference in behavior. Your existing database might be "messed up".

If I would have something to say at Limesurvey, I would probably provide any other database than MySQL as "experimental". But I don't have any say at LS.