FUDforum: Bug Reports » PostgreSQL Error (2.7.3)

Home » FUDforum Development » Bug Reports » PostgreSQL Error (2.7.3)

Show: Today's Messages :: Polls :: Message Navigator

PostgreSQL Error (2.7.3) [message #28941]

Sat, 19 November 2005 22:34

azaroth

Messages: 4
Registered: November 2005

Karma:

Junior Member

Hi folks.

With the exception of the below issue, I've been really pleased by FudForum over phpBB. It's been easy to use and setup and doesn't require MySQL.

That said, the PostgreSQL support could do with a few tweaks. Every time that the code tries to update a post/thread/forum view, it errors with the following (or similar):

/home/cheshire/cheshire3/www/syrinnia/html/forum/index.php:220
/home/cheshire/cheshire3/www/syrinnia/html/forum/index.php:1090
/home/cheshire/cheshire3/www/syrinnia/html/forum/theme/default/threadt.php:590
/home/cheshire/cheshire3/www/syrinnia/html/forum/index.php:1219
) : ERROR: duplicate key violates unique constraint "fud26_forum_read_i_fu"
Query: INSERT INTO fud26_forum_read (forum_id, user_id, last_view) VALUES (2, 2, 1132438829)
_GET: array ( 't' => 'threadt', 'frm_id' => '2', 'S' => 'a7f63e850b6e5e0eb5dddbf01e40dca1', )

Versions:
Forum: 2.7.3
PostgreSQL: 8.0.3
PHP: 4.4.1
Apache: 2.0.54
OS: Linux 2.6.9, Fedora Core 3

I found the search patch, but haven't been able to find any patch to fix this issue, so for the moment I've just commented out all of the offending lines. Any help would be appreciated.

Many thanks,

-- Azaroth (Rob Sanderson)

Report message to a moderator

[Message index]

		PostgreSQL Error (2.7.3) By: azaroth on Sat, 19 November 2005 22:34
		Re: PostgreSQL Error (2.7.3) By: Ilia on Tue, 22 November 2005 01:54
		Re: PostgreSQL Error (2.7.3) By: azaroth on Tue, 22 November 2005 22:07
		Re: PostgreSQL Error (2.7.3) By: Ilia on Tue, 22 November 2005 23:03
		Re: PostgreSQL Error (2.7.3) By: azaroth on Tue, 22 November 2005 23:08
		Re: PostgreSQL Error (2.7.3) By: Ilia on Thu, 24 November 2005 00:43
		Re: PostgreSQL Error (2.7.3) By: azaroth on Thu, 24 November 2005 15:33
		Re: PostgreSQL Error (2.7.3) By: CombatWombat on Fri, 02 December 2005 21:20
		Re: PostgreSQL Error (2.7.3) By: Ilia on Sat, 03 December 2005 01:18
		Re: PostgreSQL Error (2.7.3) By: CombatWombat on Sat, 03 December 2005 01:21
		Re: PostgreSQL Error (2.7.3) By: Ilia on Sat, 03 December 2005 01:24
		Re: PostgreSQL Error (2.7.3) By: CombatWombat on Sat, 03 December 2005 01:25
		Re: PostgreSQL Error (2.7.3) By: Ilia on Sat, 03 December 2005 01:28
		Re: PostgreSQL Error (2.7.3) By: CombatWombat on Sat, 03 December 2005 01:37

Previous Topic:	Error - mass email
Next Topic:	Group Permissions inheritance issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 07:07:44 GMT 2024

Total time taken to generate the page: 0.04177 seconds