[Ted S]

Originally Posted by 1320Nation

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'

Looks like the upgrade script wasn't able to run.

You'll need to manually perform a few queries:

CREATE TABLE IF NOT EXISTS pf_options (
                        optionid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                        title VARCHAR (75) NOT NULL DEFAULT '',
                        fieldtype TINYINT NOT NULL DEFAULT '1',
                        defaultval TINYINT NULL,
                        active TINYINT NOT NULL DEFAULT '1',
                        PRIMARY KEY (optionid),
                        KEY title (title)
                    )

CREATE TABLE IF NOT EXISTS pf_roptions (
                        addedid INT UNSIGNED NOT NULL AUTO_INCREMENT,
                        reviewid INT NOT NULL, 
                        optionid INT NOT NULL,
                        resposnse VARCHAR (75) NOT NULL DEFAULT '',
                        PRIMARY KEY (addedid),
                        KEY optionid (optionid),
                        KEY reviewid (reviewid)
                    )

INSERT INTO activitystreamtype SET packageid = 1, section = 'product', type = 'review', enabled = 1

ALTER TABLE `pf_product` ADD mainphoto_thumb VARCHAR(150) NOT NULL DEFAULT ''

ALTER TABLE `pf_product` ADD mainphoto_small VARCHAR(150) NOT NULL DEFAULT ''

ALTER TABLE `pf_product` ADD uploadimg TINYINT NOT NULL DEFAULT '0'

Be sure to add your table prefixes as needed.