Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: I can only create user categories (CID > 10000)  (Read 2776 times)

0 Members and 1 Guest are viewing this topic.

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
I can only create user categories (CID > 10000)
« 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


Logged

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
Re: I can only create user categories (CID > 10000)
« Reply #1 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
Logged

altenae

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 254
Re: I can only create user categories (CID > 10000)
« Reply #2 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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: I can only create user categories (CID > 10000)
« Reply #3 on: November 03, 2011, 05:23:32 pm »

I assume this is the follow-up thread of that thread.

Have a look at your "old" categories table. The auto_increment count was >10000 (for whatever reason) which caused that issue.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.