Nodevote malfunction: Help!

No, that doesnt look like your problem. Your problem happens because there is an error in the mysql query, not because you havent placed a previous vote. This happens i believe in your case, because you ORGINALLY had an older nodevote module and then when you paniced, downloaded a NEWER version of nodevote ( one that has the column timestamp in the nodevote table. I bet if you execute this query in mysql: DESCRIBE nodevote; You would find that there is no column timestamp ).

What you need to do is run http://yoursite.com/update.php. That should fix it. I downloaded the recent nodevote module and noticed that he JUST added that value. So your old one did not have timestamp in the table. So u just need to run your update script.

Now for your problem with node terminlogy. If you open nodevote.module and go to line 199, you will see this:

$block_title = array();
  $block_title[] = t('Most voted for nodes');
  $block_title[] = t('Highest rated nodes');
  $block_title[] = t('Most voting users');

Change it to this:

$block_title = array();
  $block_title[] = t('Most voted for nodes');
  $block_title[] = t('Highest Rated Stories');
  $block_title[] = t('Most voting users');

That should fix your problems

And as I always plug: try out my content recommendation engine. Which unfortunently wont work with nodevote, cause it doesnt use votingapi...