FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » PostgreSQL Error (2.7.3)
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
PostgreSQL Error (2.7.3) [message #28941] Sat, 19 November 2005 22:34 Go to next message
azaroth is currently offline  azaroth   United Kingdom
Messages: 4
Registered: November 2005
Karma: 0
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)
Re: PostgreSQL Error (2.7.3) [message #28961 is a reply to message #28941] Tue, 22 November 2005 01:54 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Fixed in CVS, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7439


FUDforum Core Developer
Re: PostgreSQL Error (2.7.3) [message #28982 is a reply to message #28961] Tue, 22 November 2005 22:07 Go to previous messageGo to next message
azaroth is currently offline  azaroth   United Kingdom
Messages: 4
Registered: November 2005
Karma: 0
Junior Member
Ilia wrote on Mon, 21 November 2005 20:54

Fixed in CVS, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7439


Hi,

I've tried the patch, but it still generates the same sort of errors:
(/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/thread.php:6 26
/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 (5, 2, 1132697110)
_GET: array ( 't' => 'thread', 'frm_id' => '5', 'S' => '7ec2d0bd36f6515c55cffc86e14db04b', )

Is there something else I could try to generate better debugging information for you?

Thanks,

-- Az
Re: PostgreSQL Error (2.7.3) [message #28983 is a reply to message #28982] Tue, 22 November 2005 23:03 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Did you rebuild the theme after applying the patch?

FUDforum Core Developer
Re: PostgreSQL Error (2.7.3) [message #28984 is a reply to message #28983] Tue, 22 November 2005 23:08 Go to previous messageGo to next message
azaroth is currently offline  azaroth   United Kingdom
Messages: 4
Registered: November 2005
Karma: 0
Junior Member

Yup (by editing header.tmpl), and then went and looked in the db.inc file in the theme directory just to be sure.

-- Az
Re: PostgreSQL Error (2.7.3) [message #28995 is a reply to message #28984] Thu, 24 November 2005 00:43 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Can you try this patch please:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7448


FUDforum Core Developer
Re: PostgreSQL Error (2.7.3) [message #29002 is a reply to message #28995] Thu, 24 November 2005 15:33 Go to previous messageGo to next message
azaroth is currently offline  azaroth   United Kingdom
Messages: 4
Registered: November 2005
Karma: 0
Junior Member

I must have messed something up in the original patch, I guess, as the new one works fine.

Many thanks Smile

-- Az
Re: PostgreSQL Error (2.7.3) [message #29181 is a reply to message #28995] Fri, 02 December 2005 21:20 Go to previous messageGo to next message
CombatWombat is currently offline  CombatWombat   United States
Messages: 4
Registered: December 2005
Karma: 0
Junior Member
I have been getting the same error, now i tried replacing the file in the forum with the on linked to above but it does not help. i only get the error when i try to post new messages or view messages created after i upgraded from 2.6.(i dont remember), when i view the messages in non tree mode the messages appear, but at the bottom of the page is that same error, and when i try to vew them after using tree view to get to them that shows up instead of the messages
Re: PostgreSQL Error (2.7.3) [message #29186 is a reply to message #29181] Sat, 03 December 2005 01:18 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Did you rebuild the theme after updating all the files? Check what is the error that is happening via the forum's error log viewer.

FUDforum Core Developer
Re: PostgreSQL Error (2.7.3) [message #29187 is a reply to message #29186] Sat, 03 December 2005 01:21 Go to previous messageGo to next message
CombatWombat is currently offline  CombatWombat   United States
Messages: 4
Registered: December 2005
Karma: 0
Junior Member
I dont know what you mean by rebuild the theme im using the default

i only updated the one file that that link point to


the last 3 errors are

Fri Dec 2 21:11:13 GMT 2005 (/var/www/html/FUDforum2/index.php:220
/var/www/html/FUDforum2/index.php:1090
/var/www/html/FUDforum2/theme/default/thread.php:618
/var/www/html/FUDforum2/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, 1133557873)
_GET: array ( 't' => 'thread', 'frm_id' => '2', 'S' => '78dcb29ab00c5899617a953c179514d7', )
Server Version:
[Referring Page] http://povil.us/FUDforum2/index.php?t=index&S=78dcb29ab00c5899617a953c1 79514d7
Fri Dec 2 21:11:14 GMT 2005 (/var/www/html/FUDforum2/index.php:220
/var/www/html/FUDforum2/index.php:1090
/var/www/html/FUDforum2/theme/default/tree.php:702
/var/www/html/FUDforum2/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, 1133557874)
_GET: array ( 't' => 'tree', 'th' => '134', 'start' => '0', 'S' => '78dcb29ab00c5899617a953c179514d7', )
Server Version:
[Referring Page] http://povil.us/FUDforum2/index.php?t=thread&frm_id=2&S=78dcb29ab00 c5899617a953c179514d7
Sat Dec 3 1:19:35 GMT 2005 (/var/www/html/FUDforum2/index.php:220
/var/www/html/FUDforum2/index.php:1090
/var/www/html/FUDforum2/theme/default/thread.php:618
/var/www/html/FUDforum2/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, 1133572775)
_GET: array ( 't' => 'thread', 'frm_id' => '2', 'S' => '78dcb29ab00c5899617a953c179514d7', 'SQ' => '22f3028f92725b51e71d1e4dbbe013c1', )
Server Version:
[Referring Page] http://povil.us/FUDforum2/index.php?t=index&S=78dcb29ab00c5899617a953c1 79514d7


Re: PostgreSQL Error (2.7.3) [message #29188 is a reply to message #29187] Sat, 03 December 2005 01:24 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Did you replace your db.inc?

FUDforum Core Developer
Re: PostgreSQL Error (2.7.3) [message #29189 is a reply to message #29188] Sat, 03 December 2005 01:25 Go to previous messageGo to next message
CombatWombat is currently offline  CombatWombat   United States
Messages: 4
Registered: December 2005
Karma: 0
Junior Member
yes
Re: PostgreSQL Error (2.7.3) [message #29190 is a reply to message #29189] Sat, 03 December 2005 01:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
And rebuilt the theme afterwards? This error may only occur if you are using the old db.inc that fails to properly spot duplicate key errors.
you need to make sure you using this version of the file:
http://cvs.prohost.org/c/index.cgi/FUDforum/getfile/install/forum_data/sql/ pgsql/db.inc?v=1.75


FUDforum Core Developer
Re: PostgreSQL Error (2.7.3) [message #29191 is a reply to message #29190] Sat, 03 December 2005 01:37 Go to previous message
CombatWombat is currently offline  CombatWombat   United States
Messages: 4
Registered: December 2005
Karma: 0
Junior Member
that worked, i dident realied i needed to rebuild the default theme, i though that azaroth was working on a custom theme
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Error - mass email
Next Topic: Group Permissions inheritance issue
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

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

Total time taken to generate the page: 0.03356 seconds