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
Switch to threaded view of this topic Create a new topic Submit Reply
SQL error when editing post (RC3) [message #2866] Mon, 03 June 2002 20:07 Go to next message
ScooterQ is currently offline  ScooterQ   United States
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
Re: SQL error when editing post (RC3) [message #2868 is a reply to message #2866] Mon, 03 June 2002 20:57 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Thanks for the bug report, it was already fixed, but as you can imagine not inside the RC3 release.

FUDforum Core Developer

[Updated on: Mon, 03 June 2002 20:57]

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
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 17:43:56 GMT 2024

Total time taken to generate the page: 0.02096 seconds