FUDforum: Bug Reports » SQL error when editing post (RC3)

Home » FUDforum Development » Bug Reports » SQL error when editing post (RC3)

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

SQL error when editing post (RC3) [message #2866]

Mon, 03 June 2002 20:07

ScooterQ

Messages: 25
Registered: June 2002
Location: Norcross, GA

Karma: 0

Junior Member

Apologies if this is an old bug, but I haven't been able to find it yet....

If I attempt to edit a post I receive the following error:

Query Failed: UPDATE fud2_thread SET last_post_id=819, last_post_date= WHERE id=813
Reason: You have an error in your SQL syntax near 'WHERE id=813' at line 1
From: /var/www/html/forum/post.php
Server Version: 3.23.49

When I go back and look at the post, however, it has been edited.

If I dig into the code (post.php) it appears that $this->post_stamp does not have a value at line 3847.

if ( $thr->last_post_id <= $this->id ) { 
     Q("UPDATE fud2_thread SET last_post_id=".$this->id.",
        last_post_date=".$this->post_stamp." WHERE id=".$this->thread_id);

I've been able to hack my own copy of this by inserting

$this->post_stamp = __REQUEST_TIMESTAMP__;

on the line above the UPDATE, but it just doesn't seem right. Well, that and it will be overwritten the next time I upgrade. Razz

I'm wondering if anyone else has seen this or if it's something specific to my setup.

RH 7.3
FUDForum 2.0 (RC3)
Apache/1.3.23 (Unix) (Red-Hat/Linux) mod_ssl/2.8.7 OpenSSL/0.9.6b DAV/1.0.3 PHP/4.2.1 mod_perl/1.26
mysql-3.23.49-3

Report message to a moderator