Changing DB type from MySQL to MySQLi after installation

[James Birkett]

If I was originally running mysql database type, then I change the config.php to mysqli instead of mysql (dbtype), but I did this after an install (i.e. when I had members & threads etc) - does this cause any difference? Does the dbtype have to be declared at installation then kept the same?

I know vBulletin has database handlers which is why I presume changing the dbtype mid-way won't affect anything, i'm just looking for some clarification.

[cellarius]

It doesn't matter, you can change that as often as you want. I do that frequently when testing my modifications. MySQLi is not a different database format, it's in fact not even MySQL It's an improved database layer of PHP, and the database does not care what layer you use to access it. MySQLi is object oriented.

See: http://de3.php.net/manual/en/book.mysqli.php

[James Birkett]

MySQLi offers improvements though so that's why I always use it over MySQL. As you say, more object-orientated.

I was just making sure that the change wouldn't affect anything.

EDIT: Seems to affect all of my modifications - I even rebuilt bitfields.

[cellarius]

Yep, I first looked into this when I could not for the life of it track down a database related bug in one of my mods. Took me hours until I thought of testing it with mysqli.

[James Birkett]

I can't see why modifications would affect database handling. It all goes through vBulletin's database handling system so it shouldn't make any effect.

Going to have to see what's causing my errors to appear now the error in all of my modifications is:

Fatal error: Cannot use object of type mysqli_result as array in /home/user/public_html/forum/global.php(607) : eval()'d code(1330) : eval()'d code on line 4

[James Birkett]

Can anyone shed any light on this? Any way to get past this error without reinstalling my modifications?