Additionally, there's something wrong with the query you say to run if you switch between the 10 point scale and the up/down vote:
Code:
UPDATE post SET goodrank = '', totalrank = '';
DELETE FROM helpfulanswer;
I get the following error:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'goodrank' in 'field list'
|
And:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM helpfulanswer' at line 2
|