Piwigo.org

julian · 2011-03-25 16:51:34

[mysql error 1062] Duplicate entry '65535' for key 'PRIMARY'

INSERT INTO piwigo_categories
(id,dir,name,site_id,id_uppercat,uppercats,commentable,visible,status,rank,global_rank)
VALUES('64768','Prints_Graphics','Prints Graphics','1','34011','29925,33016,34011,64768','true','true','public','11','1.5.2.11')
, ('64769','2011-02-23','2011-02-23','1','64768','29925,33016,34011,64768,64769','true','true','public','1','1.5.2.11.1')
, ('64770','1','1','1','64769','29925,33016,34011,64768,64769,64770','true','true','public','1','1.5.2.11.1.1')
, ('64771','4','4','1','64769','29925,33016,34011,64768,64769,64771','true','true','public','2','1.5.2.11.1.2')
, ('64772','2','2','1','64769','29925,33016,34011,64768,64769,64772','true','true','public','3','1.5.2.11.1.3')
,
--------------
etc,etc,etc,etc....

#1 my_error /var/www/include/dblayer/functions_mysql.inc.php(88)
#2 pwg_query /var/www/include/dblayer/functions_mysql.inc.php(409)
#3 mass_inserts /var/www/admin/site_update.php(314)
#4 include /var/www/admin.php(159)

ddtddt · 2011-03-25 17:57:53

have you access to admin part ?

jortex696 · 2011-03-25 18:57:40

yes I'm the administrator.
This error comes when trying to synchronize a particular category in all subdirectories.

[img]http://img857.imageshack.us/i/womenr.png/[img]
http://img857.imageshack.us/i/womenr.png/

Last edited by jortex696 (2011-03-25 22:16:23)

plg · 2011-03-25 22:45:19

Hi jortex696,

Well done. You've reached the technical limit in the number of categories with MySQL. 65535 is the biggest number a smallint(5) unsigned can do. Let's change this to a mediumint! In your database manager, perform the following queries:

alter table piwigo_categories modify id mediumint unsigned auto_increment;
alter table piwigo_categories modify id_uppercat mediumint unsigned;
alter table piwigo_group_access modify cat_id mediumint unsigned;
alter table piwigo_history modify category_id mediumint unsigned;
alter table piwigo_image_category modify category_id mediumint unsigned;
alter table piwigo_images modify storage_category_id mediumint unsigned;
alter table piwigo_old_permalinks modify cat_id mediumint unsigned;
alter table piwigo_user_access modify cat_id mediumint unsigned;
alter table piwigo_user_cache_categories modify cat_id mediumint unsigned;

For Piwigo 2.1 only.

jortex696 · 2011-03-25 23:34:36

I have piwigo 2.2 RC2.... ???

plg · 2011-03-25 23:35:18

jortex696 wrote:
I have piwigo 2.2 RC2.... ???

On your live website???

jortex696 · 2011-03-25 23:50:28

yes ... I have a site online ...
and I have another local server, which I use as backup and to test Piwigo updates.

Those interested in viewing something?
This much would have stayed with you and you giving me support?

jortex696 · 2011-03-26 03:52:45

plg wrote:
Hi jortex696,

Well done. You've reached the technical limit in the number of categories with MySQL. 65535 is the biggest number a smallint(5) unsigned can do. Let's change this to a mediumint! In your database manager, perform the following queries:

alter table piwigo_categories modify id mediumint unsigned auto_increment;
alter table piwigo_categories modify id_uppercat mediumint unsigned;
alter table piwigo_group_access modify cat_id mediumint unsigned;
alter table piwigo_history modify category_id mediumint unsigned;
alter table piwigo_image_category modify category_id mediumint unsigned;
alter table piwigo_images modify storage_category_id mediumint unsigned;
alter table piwigo_old_permalinks modify cat_id mediumint unsigned;
alter table piwigo_user_access modify cat_id mediumint unsigned;
alter table piwigo_user_cache_categories modify cat_id mediumint unsigned;
For Piwigo 2.1 only.

------------------------------------------------

You've reached the technical limit in the number of categories with MySQL. 65535

categories: 65535
and
images limit?

plg · 2011-03-27 21:08:45

jortex696 wrote:
images limit?

16,777,215 (16 millions) and with the same kind of SQL queries you can move the limit to 4 billions.

Piwigo.org

Announcement

#1 2011-03-25 16:51:34

Piwigo encountered a non recoverable error

#2 2011-03-25 17:57:53

Re: Piwigo encountered a non recoverable error

#3 2011-03-25 18:57:40

Re: Piwigo encountered a non recoverable error

#4 2011-03-25 22:45:19

Re: Piwigo encountered a non recoverable error

#5 2011-03-25 23:34:36

Re: Piwigo encountered a non recoverable error

#6 2011-03-25 23:35:18

Re: Piwigo encountered a non recoverable error

jortex696 wrote:

#7 2011-03-25 23:50:28

Re: Piwigo encountered a non recoverable error

#8 2011-03-26 03:52:45

Re: Piwigo encountered a non recoverable error

plg wrote:

#9 2011-03-27 21:08:45

Re: Piwigo encountered a non recoverable error

jortex696 wrote:

Board footer