Hay Cap'n!
v3.08 allowed the upgrade to go through without error.
Right after install I edited the QuoteIt options but left things as they were.
Then, I clicked on "Moderate Quotes" to take a look (I know we were up to date and there were no quotes to moderate), and I get this error:
Quote:
Invalid SQL:
SELECT quotes.*, user.username, categories.title AS category FROM quotes AS quotes
LEFT JOIN user AS user ON user.userid = quotes.userid
LEFT JOIN quotecategories AS categories ON quotes.categoryid = categories.categoryid
WHERE quotes.approved = 0 LIMIT 5;
MySQL Error : Unknown column 'quotes.categoryid' in 'on clause'
Error Number : 1054
|
I also clicked on "Manage Categories" (i know we haven't made any categories yet, as 2.1 didn't have this correct?" and I get this error:
Quote:
Invalid SQL:
SELECT category.*, COUNT(quotes.quoteid) AS count FROM quotecategories AS category
LEFT JOIN quotes AS quotes ON quotes.categoryid = category.categoryid
GROUP BY category.categoryid ORDER BY category.displayorder ASC;
MySQL Error : Unknown column 'quotes.categoryid' in 'on clause'
Error Number : 1054
|
Help!