MySQL 5+ issue: mysql_* vs. mysqli_*

[dartar]

MySQL 5+ isn't supported as it requires PHP to use the mysqli extension instead of plain old mysql. I hoped there would be a single file to change this, but there seems to be no database abstraction in this project at all.

-- DavidCarrington

I do not have access to a MySQL 5 server for testing. And judging by the feedback that I see here on Wikka, most other Wikka admins are using older versions of MySQL. However, I do like progress, so I looked at the documentation for the mysqli extension. I don't see any major issue here. It looks like the function calls are the same, they just have a different name. Instead of calling mysql_connect, you call mysqli_connect. Instead of calling mysql_query, you call mysqli_query. So on and so forth.

It seems that we would just have to do a simple version check and call "mysql" functions for older versions, and "mysqli" functions for newer versions. Please correct me if I'm missing something. -- JsnX 26 Nov 2004

I'm running MySQL 5 fine with the mysql_* functions. When you compile PHP, it's your choice to compile the mysql_* or mysqli_* functions. I chose to compile it with mysql_*, which is working fine for me. --BarkerJr

Related tickets: #171

[vincent.fretin@…]

I'm running Wikka 1.1.6.2 with MySQL 5. It works fine except the WantedPages page which gives wrong result. See my bug #309.

[BrianKoontz]

PHP: 5.2.6 MySQL: 5.0.22 WikkaWiki: trunk-1225

All works well with this configuration. I would suggest that the issue is an end-user issue (i.e., how PHP is compiled).