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.
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