Announcement

  •  » Requests
  •  » MariaDB Compatibility

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

KungFuJosh
Member
2016-08-21
28

MariaDB Compatibility

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)

Offline

 

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

KungFuJosh
Member
2016-08-21
28

Re: MariaDB Compatibility

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

Offline

 

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

Zentalquabula
Member
2014-05-10
217

Re: MariaDB Compatibility

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.

Offline

 

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

KungFuJosh
Member
2016-08-21
28

Re: MariaDB Compatibility

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.

Offline

 

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

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13839

Re: MariaDB Compatibility

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.

Offline

 

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

KungFuJosh
Member
2016-08-21
28

Re: MariaDB Compatibility

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

Offline

 

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

reddn
Member
DC, USA
2015-09-29
30

Re: MariaDB Compatibility

I run mariadb on freebsd w nginx.  No problems.

Offline

 
  •  » Requests
  •  » MariaDB Compatibility

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact