Announcement

  •  » Requests
  •  » PIWIGO and MYSQL 8.0

#1 2018-10-24 15:04:13

tancred23
Member
2018-10-24
1

PIWIGO and MYSQL 8.0

Hi,

I really like piwigo and want to expand my use of it including using my MySQL innodb cluster (MySQL 8.0.13) for database storage.

However there seems to be several incompatibilities (reserved words, authentication, others? ) between 2.9.4 and MySQL 8.0.

Everything runs fine with 2.9.4 on a standalone MySQL 5.7.19 instance

Downgrading to MySQL 5.7.x on my cluster is not an option

Do any of the upcoming roadmap plans (2.10 or even 3.0) include an upgrade path for 2.9.4 installs to give 8.0 compatibility?

Thanks

Piwigo version:2.9.4
PHP version: 7.0.32
MySQL version: 5.7.19 (and trying to make 8.0.13 work without success)
Piwigo URL: http://

Offline

 

#2 2018-10-24 18:51:38

erAck
Piwigo Team
2015-09-06
281

Re: PIWIGO and MYSQL 8.0

[Github] Piwigo issue #919

Last edited by erAck (2018-10-24 18:52:39)


Running Piwigo at https://erack.net/gallery/

Offline

 

#3 2019-04-04 10:14:02

danibo
Member
Zurich
2009-10-07
41

Re: PIWIGO and MYSQL 8.0

Hallo
I am still on MySql 5.6 and Piwigo 2.9.4 with theme Modus

Piwigo 2.9.4
Betriebssystem: Linux
PHP: 5.6.40 (Info anzeigen) [2019-04-04 02:30:15]
MySQL: 5.6.43 [2019-04-04 10:30:15]
Grafikbibliothek: External ImageMagick 6.7.2-7

My provider urges me to update to MySQL 5.7.

I am little insecure because I was reading some issues with MySQL 5.7 and Piwigo. Are they solved now or do you recommend to wait with the update.

Thank you for a short feedback.
daniel

PS: of couse i have a backup of the whole system ;-)

Offline

 

#4 2019-04-04 10:29:06

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

Re: PIWIGO and MYSQL 8.0

@danibo Piwigo 2.9.4 should work fine on MySQL 5.7 and works perfectly fine on MariaDB 10.1 (that's what we use on Piwigo.com)

The problem is indeed with the new MySQL 8, as mentioned by erAck in [Github] Piwigo issue #919

Offline

 
  •  » Requests
  •  » PIWIGO and MYSQL 8.0

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact