• Registered: 2009-02-10
  • Posts: 11

Topic: Register problem

Hi What should I do with my postgre base when I got this error:

Database reported: ERROR: duplicate key value violates unique constraint "pun_users_pkey"

  • Slavok
  • PunBB Developer
  • Offline
  • From: Russia
  • Registered: 2008-06-11
  • Posts: 889

Re: Register problem

This error means that the forum tried to add new a user upon registration with an existing id. What mods have you got installed?

Slavok's Website

  • Registered: 2009-02-10
  • Posts: 11

Re: Register problem

Is it possible to change value of pun_users_pkey?? I'm using PostgreSql.

This error appear when I tried to add new mod Anti-bot, beacause some Russian Bots (I think) registering on my forum.
I have already installed User Diaries, Users Online and Upload Images and as I remember everything works fine.

Last edited by tomasz (2009-04-02 11:28:34)

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: Register problem

Setting the id count would affect the pkey setting. However, if you haven't suffered this problem previously, I'd be looking at that mod, not altering the DB to work around something which seems broken, as it will break things again if so.

MattF's Website

  • Registered: 2009-02-10
  • Posts: 11

Re: Register problem

heh it's not the mod ;p
I've check and after manualy deleting some users from database I've forgot to change users_seq ;p
I was searching this in users table but it was in main"directory" of database:P
problem solved
thx for Your time.