Piwigo.org

KungFuJosh · 2016-09-09 05:22:48

Greetings Earthlings,

I've recently switched to a much better server and Piwigo is not fully compatible. The server is using MariaDB (a popular MySQL drop-in replacement), and it gives an error:

Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50630 Library:100027

The workaround is to disable mysql, mysqli, and pdo_mysql and then enable nd_mysql, nd_msqli, and nd_pdo_mysql. However, this shouldn't be necessary.

Thanks,
Josh

Piwigo version: 2.8.2
PHP version: 5.6.x
MySQL version: MariaDB 10.0.027

Last edited by KungFuJosh (2016-09-09 05:23:40)

KungFuJosh · 2016-09-30 04:59:55

Manually editing the migrated database seems to have fixed this issue, but now there are others. Fun!

Zentalquabula · 2016-10-01 10:43:50

Problem is not with Piwigo, nor with MariaDB.

You need to reinstall PHP. It was most likely compiled against MySQL 5.1, whereas MariaDB conforms to MySQL 5.5. While you're at it, might as well go for PHP 7.0.

KungFuJosh · 2016-10-02 01:03:16

As I said above, I fixed it already. But it was actually a database created in MySQL 5.6.3. Piwigo couldn't handle the header difference. Manually changing the version number to reflect MariaDB fixed the problem.

Piwigo doesn't play well with others. Piwigo needs a lot of updates, and it seems like support is basically dead.

plg · 2016-10-02 08:18:02

support is not dead at all :-)

Actually I don't see where Piwigo is involved in your issue here. You have an environment problem regarding PHP and MySQL. Piwigo is doing its job.

KungFuJosh · 2016-10-03 06:12:07

plg wrote:
support is not dead at all :-)

Actually I don't see where Piwigo is involved in your issue here. You have an environment problem regarding PHP and MySQL. Piwigo is doing its job.

This issue didn't matter so much, but Piwigo does have issues with errors. For example, enabling the php APM module will cause the script to die with usort errors in admin. This still doesn't matter so much.

I was referring to more important questions, like removing the use of user_id from the script that nobody responded to. I have a modified version of the script I made where i replaced the use of user_id with pwg_user_id and it integrates beautifully with phpBB that way, and I'm sure it would work better with other scripts as well. I can upload my modified version if you want, but I detailed the changes here: https://www.phpbb.com/community/viewtop … #p14506276

Thanks,
Josh

reddn · 2016-12-24 14:48:37

I run mariadb on freebsd w nginx. No problems.

Piwigo.org

Announcement

#1 2016-09-09 05:22:48

MariaDB Compatibility

#2 2016-09-30 04:59:55

Re: MariaDB Compatibility

#3 2016-10-01 10:43:50

Re: MariaDB Compatibility

#4 2016-10-02 01:03:16

Re: MariaDB Compatibility

#5 2016-10-02 08:18:02

Re: MariaDB Compatibility

#6 2016-10-03 06:12:07

Re: MariaDB Compatibility

plg wrote:

#7 2016-12-24 14:48:37

Re: MariaDB Compatibility

Board footer