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
0003103Piwigousers & groupspublic2014.07.24 10:322014.07.25 11:07
Assigned Toplg 
PlatformOSOS Version
Product Version2.6.2 
Target Version2.7.0RC1Fixed in Version2.7.0RC1 
Summary0003103: enlarge user_id
Descriptioncurrent users.id (and all foreign keys *.user_id) are limited to ~30k values (starting from 0).

I have encountered a case with a huge user table, more than 100k users and I had to change all user_id...
TagsNo tags attached.
Database engine and version
PHP version
Web serverApache 1.3.x
Attached Files

- Relationships

-  Notes
svn (reporter)
2014.07.24 10:34

[Subversion] r29072 by plg on trunk

-----[Subversion commit log]----------------------------------------------------
feature 3103: enlarge users.id (and foreign keys user_id, added_by or author_id) from smallint (max 30k) to mediumint unsigned (max 16M)

- Issue History
Date Modified Username Field Change
2014.07.24 10:32 plg New Issue
2014.07.24 10:32 plg Status new => assigned
2014.07.24 10:32 plg Assigned To => plg
2014.07.24 10:32 plg browser => any
2014.07.24 10:32 plg Web server => Apache 1.3.x
2014.07.24 10:34 svn Checkin
2014.07.24 10:34 svn Note Added: 0007522
2014.07.25 11:07 plg Status assigned => closed
2014.07.25 11:07 plg Resolution open => fixed
2014.07.25 11:07 plg Fixed in Version => 2.7.0beta3

Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker