[Gio Takahashi]

Originally Posted by Cap'n Steve

I'm guessing you had QuoteIt! 1.2 but never upgraded to 2.0, right? I never even considered that situation when I released this version. :ermm: The next version should handle the upgrade better, but until then these queries should fix it:

UPDATE $TPquotes ADD COLUMN (votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0, rating MEDIUMINT(10) NOT NULL DEFAULT 0, average FLOAT(3, 2) NOT NULL DEFAULT 0.00, context VARCHAR(250))

ALTER TABLE $TPquotes ADD INDEX rating

ALTER TABLE $TPquotes ADD INDEX average

Just replace $TP with your table prefix.

a bit of an issue: I had to manually add in the columns because the syntax you gave does not seem to work.

Yes I replaced $TP with the correct table prefixes..well I don't use prefixes at all anyway >>.

none of the queries work at all.