[installation & upgrade] Installation and Upgrade could be executed on unsufficient MySQL release #122

Closed
opened 2026-10-04 23:44:05 +02:00 by adam · 0 comments
Owner

Reported by VDigital on 25 Mar 2010 22:04

Version: 2.0.9

French related topic: http://fr.piwigo.org/forum/viewtopic.php?pid=137790#p137790

In the related topic the database configuration includes:
define('PHPWG_INSTALLED', true);

define('PWG_CHARSET', 'iso-8859-1');
define('DB_CHARSET', 'latin1');
define('DB_COLLATE', '');

instead of utf-8
and the result is a lot of failures and undone translations.
See some screenshots in the topic.

Steps to reproduce: Complex to do, need and old MySQL version.
=> Installation and upgrade need to test MySQL Version by a

SHOW VARIABLES;

Do not install or upgrade if version is not at the prereq level.

Piwigo Bugtracker #1536

**Reported by VDigital on 25 Mar 2010 22:04** **Version:** 2.0.9 French related topic: http://fr.piwigo.org/forum/viewtopic.php?pid=137790#p137790 In the related topic the database configuration includes: define(&#039;PHPWG_INSTALLED&#039;, true); define(&#039;PWG_CHARSET&#039;, &#039;iso-8859-1&#039;); define(&#039;DB_CHARSET&#039;, &#039;latin1&#039;); define(&#039;DB_COLLATE&#039;, &#039;&#039;); instead of utf-8 and the result is a lot of failures and undone translations. See some screenshots in the topic. **Steps to reproduce:** Complex to do, need and old MySQL version. =&gt; Installation and upgrade need to test MySQL Version by a SHOW VARIABLES; Do not install or upgrade if version is not at the prereq level. [Piwigo Bugtracker #1536](http://piwigo.org/bugs/view.php?id=1536) <!-- github-sync-id:97226015 -->
adam closed this issue 2026-10-04 23:44:05 +02:00
Sign in to join this conversation.
No labels
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#122