Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: I can only create user categories (CID > 10000)  (Read 2875 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.021 seconds with 19 queries.