PostgreSQL Error (2.7.3) [message #28941] |
Sat, 19 November 2005 22:34 |
azaroth
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 #28982 is a reply to message #28961] |
Tue, 22 November 2005 22:07 |
azaroth
Messages: 4 Registered: November 2005
Karma: 0
|
Junior Member |
|
|
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 #29186 is a reply to message #29181] |
Sat, 03 December 2005 01:18 |
Ilia
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 |
CombatWombat
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
|
|
|
|
|
|
|