Any idea why the follwing code may be causing this?
Database error in vBulletin 3.6.7:
Invalid SQL:
SELECT attachment.info_hash, attachment.attachmentid, attachment.userid, attachment.filename, attachment.size , attachment.dateline, attachment.postid, attachment.seeders, attachment.leechers, attachment.completed, post.threadid, post.title
FROM hvc3attachment
LEFT JOIN hvc3post ON attachment.postid = post.postid
WHERE info_hash != '' AND SUBSTRING_INDEX(filename, '.torrent',1) LIKE '%test%'
ORDER BY dateline desc
LIMIT 0, 30;
MySQL Error : Unknown column 'attachment.info_hash' in 'field list'
Error Number : 1054
Date : Monday, October 22nd 2007 @ 06:59:28 PM
Script : http://127.0.0.1/HVC3 Test/vbm/torrents.php
Referrer : http://127.0.0.1/HVC3%20Test/vbm/index.php
IP Address : 127.0.0.1
Username : Krrose27
Classname : vB_Database
$attachment = $db->query_read("
SELECT attachment.info_hash, attachment.attachmentid, attachment.userid, attachment.filename, attachment.size , attachment.dateline, attachment.postid, attachment.seeders, attachment.leechers, attachment.completed, post.threadid, post.title
FROM " . TABLE_PREFIX . "attachment
LEFT JOIN " . TABLE_PREFIX . "post ON attachment.postid = post.postid
WHERE info_hash != '' ".$search."
ORDER BY ".$search_comp." $sort $order
LIMIT " . ($minlimit-1) . ", $perpage
");
