SQL synax problem

[killa seven]

its phpmyadmin

i also have workbench but in phpmyadmin right now

[TigerC10]

Well, close down the tab or the browser and then bring it up again after a few minutes (just in case).

[killa seven]

its just not going in.. closed it down and retried a couple times

[Marco van Herwaarden]

Are you upgrading the product, or uninstalling/installing?

[killa seven]

uninstalling/installing

building a poll system for a battle hack i am making

finally got it to work after hours of banging my head on the desk lol


heres the code i got away with... i feel stupid because i don't see the difference haha

PHP Code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS ".TABLE_PREFIX."`dbh_victims` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 50 ) NOT NULL ,
`beat` VARCHAR( 50 ) NOT NULL ,
`cscore` INT( 10 ) NOT NULL ,
`oscore` INT( 10 ) NOT NULL,
UNIQUE (`id`)
) ");