Piwigo.org

htsea · 2003-04-01 02:55:27

I got lots of errors when I try to add greater than 255 categories, does anybody know how to fix this?
I tried to change the table size of the "phpwebgallery_images" table but in vain. Please help

plg · 2003-04-01 10:12:12

there is solution for this "limitation" in the french forum. I add it to the english forum :

This is the SQL script to load with PhpMyAdmin (for example)

Code:

ALTER TABLE `phpwebgallery_categories` CHANGE `id_uppercat` `id_uppercat` SMALLINT( 5 ) UNSIGNED DEFAULT NULL; 
ALTER TABLE `phpwebgallery_categories` CHANGE `id` `id` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT; 
ALTER TABLE `phpwebgallery_images` CHANGE `cat_id` `cat_id` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL; 
ALTER TABLE `phpwebgallery_restrictions` CHANGE `cat_id` `cat_id` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL; 
ALTER TABLE `phpwebgallery_waiting` CHANGE `cat_id` `cat_id` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL;

Piwigo.org

Announcement

#1 2003-04-01 02:55:27

Is There A Limitation On Number Of Categories?

#2 2003-04-01 10:12:12

Re: Is There A Limitation On Number Of Categories?

Code:

Board footer