## General developer forum

### Databases: MySQL not supported by XMLDB

Databases: MySQL not supported by XMLDB

I did a completely fresh upload of 1.9 (previous version was 1.5). When launching the install process after uploading the files, however, the webpage opened in Firefox with this message in a pink box:

"DB type: MYSQL not supported by XMLDDB"

Reverting to the 1.5 version of Moodle, everything functioned normally. However, I really would like to upgrade as I know there are security issues in older versions of Moodle.

My OS is WinXP, I am using a web host, and the web interface is cPanel. The webhosting help personnel suggested the following:

"This issue seems to be with the non-compatibility of scripts with the existing tables on moodle database.You can refer to http://docs.moodle.org/en/XMLDB_preliminary_notes or support of moodle for the fix."

However I found nothing that referred specifically to this problem/error message, and all-in-all the language used to explain XMLDB/MYSQL compatibility was way beyond me.

Can anyone help?

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB
It definitely does not mean that. MySQL works fine. That is what this web site is running on!

Is it something as simple as that it needs to be 'mysql', not 'MYSQL' in the config file?

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB

Thanks for your reply.  In fact, the spec in the config file is 'mysql', not 'MSQL'.  I copied the previous config file directly to the new one, that's why (I feel) the problem is not with 'mysql' but s.t. new in 1.9 having to do with the XMLDB business.  It's been 2 years since I did an upgrade--has a new line been added to the config file in that time?

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB
Hmm that's odd. Try changing "mysql" to "mysqli" for the dbtype in config.php

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB

Hello again Martin,

Thank you so much for taking the time to answer my plea for help.  Your suggestion, I'm sorry to say, didn't achieve the desired result. The page message was the same.

One thing I noticed though: we keep talking about XMLDB, but actually the screen message says XMLDDB (double 'D').  Do you think that has any bearing on the problem?

Suzanne

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB

It's been a long time since this post was made but I still have this problem and get the same error.

This is preventing me from being able to install any mods/plugins.

Have you found an answer and did that double "D" have anything to do with the problem?

Keith

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB
No, the double D in the error message is just a typo in the error message. (Which I am about to fix.)

However, it is quite useful becuase it makes it easy for me to find the code generating the error message:
 if (!file_exists($CFG->libdir . '/xmldb/classes/generators/' .$CFG->dbtype . '/' . $CFG->dbtype . '.class.php')) { error ('DB Type: ' .$CFG->dbtype . ' not supported by XMLDB');
}
OK, so based on the setting \$CFG->dbtype, let us say that is 'mysql', it is looking for a file called

.../lib/xmldb/classes/generators/mysql/mysql.class.php

So you need to compare exactly what is in your config.php file with what is in the lib/xmldb/classes/generators folder, and see if that makes any sense.

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB

Well, the easiest way to fix this for me was to upgrade to the latest release

I used fantasico in cpanel to upgrade and it worked flawlessly.

By the way I used that double D to find the code as well ;)

Keith

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB
Well, sadly that typo is now fixed.

But perhaps we should consider introducing a different unique typo into every Moodle error message .

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB

About a year ago I decided to upgrade from 1.6 to 1.9. I did one upgrade at a time instead of jumping directly to 1.9... 1.6 to 1.7, then 1.7 to 1.8, then 1.8 to 1.9... It took a little longer, but at each upgrade I checked that everything still seemed to function as it should, then moved on to the next one. This could be a solution you could try.

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB

I'm getting the same error message after copying my production server to a test server.

On both machines, my generators folder only contains "XMLDBGenerator.class.php"

I am NOT receiving the error message on the live server, though the settings are the same in config.php.

Thoughts?

Average of ratings: -
Re: Databases: MySQL not supported by XMLDB

Realized this was occuring on the production server too.  The Theme on the production server made the "notification" message look different, so i missed it.  Dug.

Downloaded 1.9.1 source code.  Copied mysql folder to the generators folder.  Fixed the problem.

Average of ratings: -