forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: altenae on November 01, 2011, 01:35:03 pm

Title: I can only create user categories (CID > 10000)
Post by: altenae on November 01, 2011, 01:35:03 pm

Hi,

I can only create categories where the cid number is > 10000
So normaly these are user categories.

I have created 3 new categories :

1. cid = 10015  (nu uid=15 exist)
2. cid = 10016  (nu uid=16 exist)
3. cid = 10017

I have this behaviour only with my database.
So there is an issue with the contents of my database.

So far I have not found the reason why this is.
Can someone help me out ???

Attached the database dump

Title: Re: I can only create user categories (CID > 10000)
Post by: altenae on November 01, 2011, 01:51:51 pm

Oke it seems to be a problem of the contents of the Categories table.

If I truncate this table I can create categories the way it should work.
I cannot discover why the contents of the table "Categories" is causing me to only create user galleries (CID > 10000)

Edward

Title: Re: I can only create user categories (CID > 10000)
Post by: altenae on November 01, 2011, 02:43:30 pm

Well this seems to solve the problem (still no idea why)

Export the Categories table values
Truncate the Categories table
Import the Categories values

So the contents is the same....
The solution is the truncate....

I have no idea why, but all works fine now.
I still want to know what and why happended.

Edward

Title: Re: I can only create user categories (CID > 10000)
Post by: Αndré on November 03, 2011, 05:23:32 pm

I assume this is the follow-up thread of that thread (http://forum.coppermine-gallery.net/index.php/topic,73835.0.html).

Have a look at your "old" categories table. The auto_increment count was >10000 (for whatever reason) which caused that issue.