If I click at "be the first to write a review" get following db error:
Quote:
Database error in vBulletin 4.1.5:
Invalid SQL:
SELECT pf.threadid,pf.title,pf.reviews,pf.rating,pf.price ,pf.short_desc,pf.mfrg,pf.upc,pf.sku,thread.forumi d
FROM vb3_pf_product as pf
JOIN vb3_thread ON pf.threadid = thread.threadid
WHERE productid = '1' AND active = 1;
MySQL Error : Unknown column 'thread.forumid' in 'field list'
Error Number : 1054
|
Also the tools menu is below the product listing and the manufacturer is not visible.
The above error is only if I have in the acp "Create New Thread on Review" set to no.
If it is set to yes I get the message "This feature is not configured yet. Please check back soon." if trying to write a review.
And if I add a forum ID in the acp setting "Review Thread Forum ID" get above db error again.
There are also db errors when clicking at "Manage" in "Manage Product Reviews Forums" (value 0)
Quote:
Database error in vBulletin 4.1.5:
Invalid SQL:
SELECT COUNT(productid) AS count
FROM vb3_pf_product
WHERE pf_product.productid <> 0;
MySQL Error : Unknown column 'pf_product.productid' in 'where clause'
Error Number : 1054
|