Hi,
here we go again..
I have smf 1.1.7 & try to install nopaste & i have trouble with creating the table on the db..
Sow i try to create manually the table & execute the query but here i get this message..
My query
CREATE TABLE smf_pastes(
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`cryptid` VARCHAR( 32 ) NOT NULL ,
`name` VARCHAR( 100 ) NOT NULL ,
`uid` INT( 11 ) NOT NULL DEFAULT '0',
`description` TEXT NOT NULL ,
`code` TEXT NOT NULL ,
`tab_length` INT( 1 ) NOT NULL DEFAULT '4',
`code_lang` VARCHAR( 20 ) NOT NULL ,
`time` INT( 20 ) NOT NULL ,
`ip` VARCHAR( 15 ) NOT NULL ,
'hits'INT( 11 ) NULL DEFAULT '0' PRIMARY KEY ( `id` )
) AUTO_INCREMENT =1
The error message
#1064 - 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 ''hits' INT(11) NULL DEFAULT '0'
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1' at line 12
I've checked the primary key but is no options to set PRIMARY KEY to id

Whats wrong?
How to fix this?
PS this time i hope we fix this
