Posts made by Howard Miller

Moodle in English -> Installing and upgrading help -> odbc_exec() error after updating to ubuntu 24.04.2 LTS -> odbc_exec() error after updating to ubuntu 24.04.2 LTS

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
I would say your problem is that the mysqli extension has not loaded properly, so adodb looks to be doing something weird.

On Ubuntu, I think all you needed was...

sudo apt install php-mysql

to install the dependencies.
Average of ratings: -

Moodle in English -> Installing and upgrading help -> odbc_exec() error after updating to ubuntu 24.04.2 LTS -> odbc_exec() error after updating to ubuntu 24.04.2 LTS

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Just in case anybody else knows... I'm quite surprised that odbc_exec() is getting run when you have the driver set as mysqli. I would have thought they were mutually exclusive. But I don't know for certain.
 
EDIT:
My dev site is running mariadb, but it definitely doesn't call odbc_exec().
 
My theory is that you're getting the wrong database driver, somehow. But, I don't know the ins and outs of adodb (the database abstractraction Moodle uses). Are you certain that there is not "something else" trying to call a mis-configured odbc connection? For example, an external auth or enrolment plugin?
Average of ratings: -

Moodle in English -> Installing and upgrading help -> odbc_exec() error after updating to ubuntu 24.04.2 LTS -> odbc_exec() error after updating to ubuntu 24.04.2 LTS

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Very weird (and probably not recommended) collation. Shouldn't cause THIS problem.
 
You might also try changing the hostname from 'localhost' to '127.0.0.1'. This forces the connection from a socket to TCP/IP. Sometimes makes a difference. 
Average of ratings: -

Moodle in English -> Assignment -> Huge numbers of convert_submission adhoc tasks

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

I'm not sure if this is an issue...

We're noticing huge numbers of convert_submission adhoc tasks in the logs. Hundreds of thousands per day. 

At any one time, there are only a few hundred in the actual queue but they are constantly re-queuing themselves (or a significant number are) with the message "Conversion still in progress. Requeueing to check again."

I'm not sure if this is a bad thing but the number of adhoc tasks generated is crazy sad

Average of ratings: -