Piwigo Bugtracker

Piwigo bug tracker has moved to Github

This bugtracker is kept to provide history on old issues.

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0002155Piwigodatabasepublic2011.01.30 16:442011.02.03 23:00
Assigned Toplg 
PlatformWampServerOSWindows VistaOS Version2.1
Product Version2.2.0RC1 
Target Version2.2.0RC2Fixed in Version2.2.0RC2 
Summary0002155: MySql error on gallery installation with MySql 5.5 and above
DescriptionIf MySql 5.5 or above database is used, Piwigo is unable to perform installation:
[mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM DEFAULT CHARACTER SET utf8' at line 1
CREATE TABLE `piwigo_caddie` ( `user_id` smallint(5) NOT NULL default '0', `element_id` mediumint(8) NOT NULL default '0', PRIMARY KEY (`user_id`,`element_id`) ) TYPE=MyISAM DEFAULT CHARACTER SET utf8;

This is because "TYPE=MyISAM" is not supported any more and have to be replaced by "ENGINE=MyISAM".
Additional Informationhttp://fr.piwigo.org/forum/viewtopic.php?id=19403 [^]
TagsNo tags attached.
Database engine and version
PHP version
Web serverApache 1.3.x
Attached Files

- Relationships

-  Notes
svn (reporter)
2011.02.03 22:59

[Subversion] r9086 by plg on trunk

-----[Subversion commit log]----------------------------------------------------
bug 2155 fixed: for MySQL, use the "ENGINE=MyISAM" syntax instead of the
deprecated "TYPE=MyISAM", so that SQL creation table statements complies
with MySQL 5.5

- Issue History
Date Modified Username Field Change
2011.01.30 16:44 eric New Issue
2011.01.30 16:44 eric browser => any
2011.01.30 16:44 eric Web server => Apache 1.3.x
2011.02.03 22:59 svn Checkin
2011.02.03 22:59 svn Note Added: 0004786
2011.02.03 23:00 plg Assigned To => plg
2011.02.03 23:00 plg Status new => closed
2011.02.03 23:00 plg Resolution open => fixed
2011.02.03 23:00 plg Fixed in Version => 2.2.0RC2
2011.02.03 23:00 plg Target Version => 2.2.0RC2

Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker