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

Home » FUDforum Development » Bug Reports » SQL error when editing post (RC3)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
SQL error when editing post (RC3) [message #2866] Mon, 03 June 2002 20:07 Go to previous message
ScooterQ is currently offline  ScooterQ   United States
Messages: 25
Registered: June 2002
Location: Norcross, GA
Karma:
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
[Message index]
 
Read Message
Read Message
Previous Topic: Smiley Management (RC3)
Next Topic: INNER JOIN on mysql 3.22.32 broken?
Goto Forum:
  

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

Current Time: Fri Nov 22 12:00:19 GMT 2024

Total time taken to generate the page: 0.06014 seconds