Fork me on GitHub
Subscribe 1

Ticket #69 (fixed bug)

Wrong post time in delete.php

  • Created: 2010-07-03 10:05:04
  • Reported by: daris
  • Assigned to: Reines
  • Milestone: 1.4.1
  • Component: database
  • Priority: normal

When you deleting post, it displays topic time instead of post time.

Example:
this post was created Today 17:24:16 but delete page shows

Reply by daris - 2010-06-14 19:26:10
daris
2010-06-14 19:26:10

It just displays topic posted time.

Look for the query:

$result = $db->query('SELECT f.id AS fid, f.forum_name, f.moderators, f.redirect_url, fp.post_replies, fp.post_topics, t.id AS tid, t.subject, t.posted, t.first_post_id, t.closed, p.poster, p.poster_id, p.message, p.hide_smilies FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND p.id='.$id) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());

I think it should be p.posted

History

Reines 2010-07-03 10:07:06

  • Status changed from open to fixed.

Fixed in ebd469d, thanks.

Reines 2010-07-03 10:08:37

Commit ebd469d to fluxbb fluxbb-1.4

Fixing showing incorrect post time when deleting a post, spotted by daris. See #69