[RedDevil]

Ok fixed it.

First I created a new VB4 database (basically a new testsite)

Second I exported the usercss tables

Third I dropped the damaged usercss table in main database

I then readded using the query below. If your tables have a prefix then change name in red.

CREATE TABLE `usercss` (
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `selector` varchar(30) NOT NULL DEFAULT '',
  `property` varchar(30) NOT NULL DEFAULT '',
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`userid`,`selector`,`property`),
  KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;