Edgewall Software

Ticket #3779: ticket35.txt

File ticket35.txt, 0.7 KB (added by anonymous, 2 years ago)
Line 
1See [http://firefang.net/projects/firestats/discussion/1/2 discussion]
2
3
4Error output:
5
6    ezSQL (vWP1.25) Debug..
7
8    Last Error -- [You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 16]
9
10    Query [3] -- [CREATE TABLE IF NOT EXISTS wp_firestats_hits ( `id` INTEGER PRIMARY KEY AUTO_INCREMENT , `ip` VARCHAR(40) NOT NULL DEFAULT 'unknown' , `timestamp` DATETIME NOT NULL , `url_id` INTEGER , `referer_id` INTEGER , `useragent_id` INTEGER , `session_id` VARCHAR(30) , `user_id` INTEGER default NULL , `excluded_by_user` TINYINT(1) DEFAULT 0 , `excluded_ip` TINYINT(1) DEFAULT 0 , `excluded_user` TINYINT(1) DEFAULT 0 , UNIQUE(`ip`,`timestamp`,`url_id`,`referer_id`,`useragent_id`) ) ENGINE=InnoDB]
11
12    Query Result..
13
14        No Results