Bug Trying to update vbcredits getting error Unknown column 'actionid' in 'field list'

[stb74]

Hi

I haven't used vbcredits for a while on my site as I was deciding what direction I wanted to take. I tried to enable and update vbcredits today from 1.2 to 2.0.0 and when I try to inport the product file I get a MYSQL error

Database error in vBulletin 4.1.7:

Invalid SQL:
REPLACE INTO `vb_credits_action` (`actionid`, `title`, `description`, `multiplier`, `parent`, `category`, `global`, `revert`, `cancel`, `rebuild`, `currency`, `referformat`) VALUES ('donate', 'Donate', 'Transferring currency to another user.', '', '', 'accounts', 1, 0, 1, 0, 1, 'member.php?u=');

MySQL Error   : Unknown column 'actionid' in 'field list'
Error Number  : 1054
Request Date  : Monday, October 24th 2011 @ 02:47:40 PM
Error Date    : Monday, October 24th 2011 @ 02:47:43 PM
Script        : http://www.nifootball.co.uk/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.nifootball.co.uk/forum/admincp/plugin.php?do=productadd
IP Address    : 217.137.153.5
Username      : stb74
Classname     : vB_Database
MySQL Version : 5.0.51a-24+lenny3-log

 

[Darkwaltz4]

Run this query:

DROP TABLE `vb_credits_action`

then try importing again

 

[stb74]

Thanks that worked for me.