FUDforum: Bug Reports » can create threads, but unable to reply to them

Home » FUDforum Development » Bug Reports » can create threads, but unable to reply to them

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

can create threads, but unable to reply to them [message #4215]

Thu, 18 July 2002 13:38

ben!

Messages: 7
Registered: July 2002

Karma:

Junior Member

So yeah, i can create threads, but when it comes to replying, no dice, due to the following error:

I'm running PostgreSQL 7.2.1 on a hacked-up RedHat box, with PHP 4.2.1 and Apache 2.0.39.

Now, i did just notice that i compiled my PHP against an older version of PostgreSQL, and i'm rebuilding it as we speak....

query failed: %( INSERT INTO fud21_ftvt_1060317709 (thread_id,forum_id,page,tmp) SELECT fud21_thread.id, fud21_thread.forum_id, 4294967294, CASE WHEN is_sticky='Y' AND (fud21_msg.post_stamp+fud21_thread.orderexpiry>1026999181 OR fud21_thread.orderexpiry=0) THEN 4294967294 ELSE fud21_thread.last_post_date END AS sort_order_fld FROM fud21_thread INNER JOIN fud21_msg ON fud21_thread.root_msg_id=fud21_msg.id WHERE forum_id=1 AND fud21_msg.approved='Y' ORDER BY sort_order_fld DESC, fud21_thread.last_post_id DESC LIMIT 40, 0 )% because %( LAST_ERROR: ERROR: dtoi4: integer out of range )%Query Failed: INSERT INTO fud21_ftvt_1060317709 (thread_id,forum_id,page,tmp) SELECT fud21_thread.id, fud21_thread.forum_id, 4294967294, CASE WHEN is_sticky='Y' AND (fud21_msg.post_stamp+fud21_thread.orderexpiry>1026999181 OR fud21_thread.orderexpiry=0) THEN 4294967294 ELSE fud21_thread.last_post_date END AS sort_order_fld FROM fud21_thread INNER JOIN fud21_msg ON fud21_thread.root_msg_id=fud21_msg.id WHERE forum_id=1 AND fud21_msg.approved='Y' ORDER BY sort_order_fld DESC, fud21_thread.last_post_id DESC LIMIT 40, 0
Reason: LAST_ERROR: ERROR: dtoi4: integer out of range
From: /home/httpd/html/bored/index.php
Server Version:

Report message to a moderator

[Message index]

		can create threads, but unable to reply to them By: ben! on Thu, 18 July 2002 13:38
		Re: can create threads, but unable to reply to them By: ben! on Thu, 18 July 2002 14:01
		Re: can create threads, but unable to reply to them By: ben! on Thu, 18 July 2002 14:10
		Re: can create threads, but unable to reply to them By: Ilia on Thu, 18 July 2002 15:23
		Re: can create threads, but unable to reply to them By: ben! on Thu, 18 July 2002 15:52
		Re: can create threads, but unable to reply to them By: Ilia on Thu, 18 July 2002 15:59

Previous Topic:	No sticky posts/announcements
Next Topic:	Date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 03:36:08 GMT 2024

Total time taken to generate the page: 0.04184 seconds