[mpascal]

What SQL modifications does the NNTP hack do ?
I got the following error:

nvalid SQL:
SELECT post.*, thread.*,
post.dateline AS postdateline, post.msgid AS postmsgid,
thread.title AS threadtitle, post.visible AS postvisible,
thread.visible AS threadvisible
FROM vb_post as post LEFT JOIN vb_thread as thread
ON (thread.threadid = post.threadid
AND post.userid = thread.postuserid
AND post.postid = thread.firstpostid)
WHERE post.isusenetpost = 0
AND post.postid > 49509
AND thread.forumid = 32

mysql error: Unknown column 'post.msgid' in 'field list'

mysql error number: 1054

Date: Friday 15th of July 2005 03:43:34 PM

I have a field postid but I don't have a field msgid.