1 Topic by XuMiX

  • XuMiX
  • Senior Member
  • Offline
  • From: Russia.Novosibirsk.ToStreet()
  • Registered: 2004-05-17
  • Posts: 130

Topic: DB error when trying to add new user group

File: /mnt/dev/www/dev/admin_groups.php
Line: 245

PunBB reported: Unable to fetch group forum permission list

Database reported: ERROR: current transaction is aborted, commands ignored until end of transaction block

I use PostgreSQL 7.4.6 and PunBB 1.2beta

XuMiX's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: DB error when trying to add new user group

I will investigate.

I hate PostgreSQL error handling in PHP. I'm sure that error is actually an error that followed a previous error, so I'll have to setup PostgreSQL to find out which query actually fails.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

3 Reply by XuMiX

  • XuMiX
  • Senior Member
  • Offline
  • From: Russia.Novosibirsk.ToStreet()
  • Registered: 2004-05-17
  • Posts: 130

Re: DB error when trying to add new user group

hm.. i may try to help you, just tell me what to do smile

XuMiX's Website

4 Reply by XuMiX

  • XuMiX
  • Senior Member
  • Offline
  • From: Russia.Novosibirsk.ToStreet()
  • Registered: 2004-05-17
  • Posts: 130

Re: DB error when trying to add new user group

BTW, when i try to update user's status to administrator i get

Bad request. The link you followed is incorrect or outdated.

but the user status is updated.
PS. i have changed the main URL and changed it in admin options before this

XuMiX's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: DB error when trying to add new user group

XuMiX wrote:

BTW, when i try to update user's status to administrator i get

Bad request. The link you followed is incorrect or outdated.

but the user status is updated.
PS. i have changed the main URL and changed it in admin options before this

This has been fixed.

Regarding the PostgreSQL error. Well, if you know any PHP, you could try to determine what goes wrong. I'm almoste certain it isn't the SELECT query that fails. Probably something earlier in admin_groups.php.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: DB error when trying to add new user group

Fixed.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

7 Reply by XuMiX

  • XuMiX
  • Senior Member
  • Offline
  • From: Russia.Novosibirsk.ToStreet()
  • Registered: 2004-05-17
  • Posts: 130

Re: DB error when trying to add new user group

thx a lot

XuMiX's Website

8 Reply by geek

  • geek
  • New Member
  • Offline
  • From: NSK
  • Registered: 2005-01-02
  • Posts: 1

Re: DB error when trying to add new user group

thz to XuM