[lasto]

in fact i get same error trying any of the queries and they do have the ; on the end

CREATE TABLE " . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;

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 '" . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL aut

IGNORE - dumbo here forgot to remove the table prefix - not sure why that was in there.