[1320Nation]

Originally Posted by Ted S

Try this version.

I added the file to the forum root and the results are below. However, I reinstalled the other file back in the forum root and it still shows the same error below.

Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
pfp.productid,pfp.title,pfp.rating,pfp.reviews,pfp .price,pfp.threadid,pfp.short_desc,pfp.mainphoto_t humb,DATE_FORMAT(pfp.createddate,'%a %b %D, %Y') as posteddate,
pfc.categoryid,pfc.title as category

FROM vb_pf_product as pfp
LEFT JOIN vb_pf_category as pfc ON pfp.categoryid = pfc.categoryid
WHERE pfp.active = 1


ORDER BY pfp.title desc
LIMIT 0, 25;

MySQL Error : Unknown column 'pfp.mainphoto_thumb' in 'field list'