Error Oh Error

[amw_drizz]

Okay when i execute this script

CODE

CREATE TABLE `avps` (  `arg` varchar(20) NOT NULL default '',  `value_s` text NOT NULL,  `value_i` int(11) NOT NULL default '0',  `value_u` int(10) unsigned NOT NULL default '0',  PRIMARY KEY  (`arg`) ) TYPE=MyISAM;| CREATE TABLE `bans` (  `id` int(10) unsigned NOT NULL auto_increment,  `added` datetime NOT NULL default '0000-00-00 00:00:00',  `addedby` int(10) unsigned NOT NULL default '0',  `comment` varchar(255) NOT NULL default '',  `FIRST` int(11) default NULL,  `last` int(11) default NULL,  PRIMARY KEY  (`id`),  KEY `first_last` (`first`,`last`) ) TYPE=MyISAM;| CREATE TABLE `categories` (  `id` int(10) unsigned NOT NULL auto_increment,  `name` varchar(30) NOT NULL default '',  `sort_index` int(10) unsigned NOT NULL default '0',  `image` varchar(255) NOT NULL default '',  PRIMARY KEY  (`id`) ) TYPE=MyISAM;| INSERT INTO `categories` (`id`, `name`, `sort_index`, `image`) VALUES (1, 'Games – PC', 1, ''), (2, 'Games –  Console', 2, ''), (3, 'Games – Other', 3, ''), (4, 'Movies – CAM-TS', 4, ''), (5, 'Movies – DVDrip-DivX', 5, ''), (6, 'Movies – Other', 6, ''), (7, 'Music – Top40', 7, ''), (8, 'Music – Album', 8, ''), (9, 'Music – Audiobook', 9, ''), (10, 'Music – Other', 10, ''), (11, 'TV – Adult', 11, ''), (12, 'TV – Kids', 12, ''), (13, 'Apps – PC', 13, ''), (14, 'Apps – PocketPC', 14, ''), (15, 'Apps – Other', 15, ''), (16, 'Porn – Real', 16, ''), (17, 'Porn – Hentai', 17, ''), (18, 'Anime – All', 18, ''), (19, 'Misc', 19, '');| CREATE TABLE `comments` (  `id` int(10) unsigned NOT NULL auto_increment,  `user` int(10) unsigned NOT NULL default '0',  `torrent` int(10) unsigned NOT NULL default '0',  `added` datetime NOT NULL default '0000-00-00 00:00:00',  `text` text NOT NULL,  `ori_text` text NOT NULL,  PRIMARY KEY  (`id`),  KEY `user` (`user`),  KEY `torrent` (`torrent`) ) TYPE=MyISAM;| CREATE TABLE `countries` (  `id` int(10) unsigned NOT NULL auto_increment,  `name` varchar(50) default NULL,  `flagpic` varchar(50) default NULL,  `domain` char(3) default NULL,  PRIMARY KEY (`id`) );| INSERT INTO `countries` (`id`, `name`, `flagpic`, `domain`) VALUES  (1,'Sweden','sweden.gif','SE'),  (2,'United States of America','usa.gif','US'),  (3,'Russia','russia.gif','RU'),  (4,'Finland','finland.gif','FI'),  (5,'Canada','canada.gif','CA'),  (6,'France','france.gif','FR'),  (7,'Germany','germany.gif','DE'),  (8,'China','china.gif','CN'),  (9,'Italy','italy.gif','IT'),  (10,'Denmark','denmark.gif','DK'),  (11,'Norway','norway.gif','NO'),  (12,'United Kingdom','uk.gif','UK'),  (13,'Ireland','ireland.gif','IE'),  (14,'Poland','poland.gif','PL'),  (15,'Netherlands','netherlands.gif','NL'),  (16,'Belgium','belgium.gif','BE'),  (17,'Japan','japan.gif','JP'),  (18,'Brazil','brazil.gif','BR'),  (19,'Argentina','argentina.gif','AR'),  (20,'Australia','australia.gif','AU'),  (21,'New Zealand','newzealand.gif','NZ'),  (23,'Spain','spain.gif','ES'),  (24,'Portugal','portugal.gif','PT'),  (25,'Mexico','mexico.gif','MX'),  (26,'Singapore','singapore.gif','SG'),  (29,'South Africa','southafrica.gif','ZA'),  (30,'South Korea','southkorea.gif','KR'),  (31,'Jamaica','jamaica.gif','JM'),  (32,'Luxembourg','luxembourg.gif','LU'),  (33,'Hong Kong','hongkong.gif','HK'),  (34,'Belize','belize.gif','BZ'),  (35,'Algeria','algeria.gif','DZ'),  (36,'Angola','angola.gif','AO'),  (37,'Austria','austria.gif','AT'),  (38,'Yugoslavia','yugoslavia.gif','YU'),  (39,'Western Samoa','westernsamoa.gif','WS'),  (40,'Malaysia','malaysia.gif','MY'),  (41,'Dominican Republic','dominicanrep.gif','DO'),  (42,'Greece','greece.gif','GR'),  (43,'Guatemala','guatemala.gif','GT'),  (44,'Israel','israel.gif','IL'),  (45,'Pakistan','pakistan.gif','PK'),  (46,'Czech Republic','czechrep.gif','CZ'),  (47,'Serbia','serbia.gif','YU'),  (48,'Seychelles','seychelles.gif','SC'),  (49,'Taiwan','taiwan.gif','TW'),  (50,'Puerto Rico','puertorico.gif','PR'),  (51,'Chile','chile.gif','CL'),  (52,'Cuba','cuba.gif','CU'),  (53,'Congo','congo.gif','CG'),  (54,'Afghanistan','afghanistan.gif','AF'),  (55,'Turkey','turkey.gif','TR'),  (56,'Uzbekistan','uzbekistan.gif','UZ'),  (57,'Switzerland','switzerland.gif','CH'),  (58,'Kiribati','kiribati.gif','KI'),  (59,'Philippines','philippines.gif','PH'),  (60,'Burkina Faso','burkinafaso.gif','BF'),  (61,'Nigeria','nigeria.gif','NG'),  (62,'Iceland','iceland.gif','IS'),  (63,'Nauru','nauru.gif','NR'),  (64,'Slovenia','slovenia.gif','SI'),  (65,'Albania','albania.gif','AL'),  (66,'Turkmenistan','turkmenistan.gif','TM'),  (67,'Bosnia Herzegovina','bosniaherzegovina.gif','BA'),  (68,'Andorra','andorra.gif','AD'),  (69,'Lithuania','lithuania.gif','LT'),  (70,'India','india.gif','IN'),  (71,'Netherlands Antilles','nethantilles.gif','AN'),  (72,'Ukraine','ukraine.gif','UA'),  (73,'Venezuela','venezuela.gif','VE'),  (74,'Hungary','hungary.gif','HU'),  (75,'Romania','romania.gif','RO'),  (76,'Vanuatu','vanuatu.gif','VU'),  (77,'Vietnam','vietnam.gif','VN'),  (78,'Trinidad & Tobago','trinidadandtobago.gif','TT'),  (79,'Honduras','honduras.gif','HN'),  (80,'Kyrgyzstan','kyrgyzstan.gif','KG'),  (81,'Ecuador','ecuador.gif','EC'),  (82,'Bahamas','bahamas.gif','BS'),  (83,'Peru','peru.gif','PE'),  (84,'Cambodia','cambodia.gif','KH'),  (85,'Barbados','barbados.gif','BB'),  (86,'Bangladesh','bangladesh.gif','BD'),  (87,'Laos','laos.gif','LA'),  (88,'Uruguay','uruguay.gif','UY'),  (89,'Antigua Barbuda','antiguabarbuda.gif','AG'),  (90,'Paraguay','paraguay.gif','PY'),  (92,'Union of Soviet Socialist Republics','ussr.gif','SU'),  (93,'Thailand','thailand.gif','TH'),  (94,'Senegal','senegal.gif','SN'),  (95,'Togo','togo.gif','TG'),  (96,'North Korea','northkorea.gif','KP'),  (97,'Croatia','croatia.gif','HR'),  (98,'Estonia','estonia.gif','EE'),  (99,'Colombia','colombia.gif','CO');| CREATE TABLE `files` (  `id` int(10) unsigned NOT NULL auto_increment,  `torrent` int(10) unsigned NOT NULL default '0',  `filename` varchar(255) NOT NULL default '',  `size` bigint(20) unsigned NOT NULL default '0',  PRIMARY KEY  (`id`),  KEY `torrent` (`torrent`) ) TYPE=MyISAM;| CREATE TABLE `guests` (  `ip` varchar(15) NOT NULL default '',  `time` decimal(20,0) unsigned NOT NULL default '0',  PRIMARY KEY  (`ip`),  UNIQUE KEY `IP` (`ip`) ) TYPE=MyISAM;| CREATE TABLE `languages` (  `id` int(10) unsigned NOT NULL auto_increment,  `uri` varchar(255) NOT NULL default '',  `name` varchar(64) NOT NULL default '',  PRIMARY KEY  (`id`) ) TYPE=MyISAM;| INSERT INTO `languages` (`id`, `uri`, `name`) VALUES (1, 'english.lang', 'English'), (2, 'swedish.lang', 'Swedish');| CREATE TABLE `log` (  `id` int(10) unsigned NOT NULL auto_increment,  `added` datetime default NULL,  `txt` text,  PRIMARY KEY  (`id`),  KEY `added` (`added`) ) TYPE=MyISAM;| CREATE TABLE `messages` (  `id` int(10) unsigned NOT NULL auto_increment,  `sender` int(10) unsigned NOT NULL default '0',  `receiver` int(10) unsigned NOT NULL default '0',  `added` datetime default NULL,  `msg` text,  `unread` enum('yes','no') NOT NULL default 'yes',  `poster` bigint(20) unsigned NOT NULL default '0',  PRIMARY KEY  (`id`),  KEY `receiver` (`receiver`) ) TYPE=MyISAM;| CREATE TABLE `peers` (  `id` int(10) unsigned NOT NULL auto_increment,  `torrent` int(10) unsigned NOT NULL default '0',  `peer_id` char(20) binary NOT NULL default '',  `ip` char(64) NOT NULL default '',  `port` smallint(5) unsigned NOT NULL default '0',  `uploaded` bigint(20) unsigned NOT NULL default '0',  `downloaded` bigint(20) unsigned NOT NULL default '0',  `to_go` bigint(20) unsigned NOT NULL default '0',  `seeder` enum('yes','no') NOT NULL default 'no',  `started` datetime NOT NULL default '0000-00-00 00:00:00',  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',  `connectable` enum('yes','no') NOT NULL default 'yes',  PRIMARY KEY  (`id`),  UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),  KEY `torrent` (`torrent`),  KEY `torrent_seeder` (`torrent`,`seeder`),  KEY `last_action` (`last_action`) ) TYPE=MyISAM;| CREATE TABLE `ratings` (  `torrent` int(10) unsigned NOT NULL default '0',  `user` int(10) unsigned NOT NULL default '0',  `rating` tinyint(3) unsigned NOT NULL default '0',  `added` datetime NOT NULL default '0000-00-00 00:00:00',  PRIMARY KEY  (`torrent`,`user`),  KEY `user` (`user`) ) TYPE=MyISAM;| CREATE TABLE `stylesheets` (  `id` int(10) unsigned NOT NULL auto_increment,  `uri` varchar(255) NOT NULL default '',  `name` varchar(64) NOT NULL default '',  PRIMARY KEY  (`id`) ) TYPE=MyISAM;| INSERT INTO `stylesheets` (`id`, `uri`, `name`) VALUES (1, 'silver', 'Silver'), (2, 'dark', 'Dark'), (3, 'phptracker', 'phpTracker+'), (4, 'torrenttrader', 'TT alpha');| CREATE TABLE `torrents` (  `id` int(10) unsigned NOT NULL auto_increment,  `info_hash` blob default NULL,  `name` varchar(255) NOT NULL default '',  `filename` varchar(255) NOT NULL default '',  `save_as` varchar(255) NOT NULL default '',  `search_text` text NOT NULL,  `descr` text NOT NULL,  `ori_descr` text NOT NULL,  `category` int(10) unsigned NOT NULL default '0',  `size` bigint(20) unsigned NOT NULL default '0',  `added` datetime NOT NULL default '0000-00-00 00:00:00',  `type` enum('single','multi') NOT NULL default 'single',  `numfiles` int(10) unsigned NOT NULL default '0',  `comments` int(10) unsigned NOT NULL default '0',  `views` int(10) unsigned NOT NULL default '0',  `hits` int(10) unsigned NOT NULL default '0',  `times_completed` int(10) unsigned NOT NULL default '0',  `leechers` int(10) unsigned NOT NULL default '0',  `seeders` int(10) unsigned NOT NULL default '0',  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',  `visible` enum('yes','no') NOT NULL default 'yes',  `banned` enum('yes','no') NOT NULL default 'no',  `owner` int(10) unsigned NOT NULL default '0',  `numratings` int(10) unsigned NOT NULL default '0',  `ratingsum` int(10) unsigned NOT NULL default '0',  `nfo` text,  PRIMARY KEY  (`id`),  UNIQUE KEY `info_hash` (`info_hash`(20)),  KEY `owner` (`owner`),  KEY `visible` (`visible`),  KEY `category_visible` (`category`,`visible`),  FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`) ) TYPE=MyISAM;| CREATE TABLE `users` (  `id` int(10) unsigned NOT NULL auto_increment,  `username` varchar(40) NOT NULL default '',  `password` varchar(40) NOT NULL default '',  `secret` varchar(20) binary NOT NULL default '',  `email` varchar(80) NOT NULL default '',  `status` enum('pending','confirmed') NOT NULL default 'pending',  `added` datetime NOT NULL default '0000-00-00 00:00:00',  `last_login` datetime NOT NULL default '0000-00-00 00:00:00',  `last_access` datetime NOT NULL default '0000-00-00 00:00:00',  `editsecret` varchar(20) binary NOT NULL default '',  `privacy` enum('strong','normal','low') NOT NULL default 'normal',  `stylesheet` int(10) default '1',  `language` varchar(20) NOT NULL default '1',  `info` text,  `acceptpms` enum('yes','no') NOT NULL default 'yes',  `ip` varchar(15) NOT NULL default '',  `class` tinyint(3) unsigned NOT NULL default '0',  `avatar` varchar(100) NOT NULL default '',  `uploaded` bigint(20) unsigned NOT NULL default '0',  `downloaded` bigint(20) unsigned NOT NULL default '0',  `ircnick` varchar(30) NOT NULL default '',  `ircpass` varchar(30) NOT NULL default '',  `title` varchar(30) NOT NULL default '',  `donated` int(5) unsigned NOT NULL default '0',  `country` int(10) unsigned NOT NULL default '0',  `notifs` varchar(100) NOT NULL default '',  `enabled` varchar(10) NOT NULL default 'Yes',  `modcomment` varchar(100) default NULL,  `gender` varchar(6) NOT NULL default '',  `client` varchar(25) NOT NULL default '',  `age` int(3) NOT NULL default '0',  PRIMARY KEY  (`id`),  UNIQUE KEY `username` (`username`),  KEY `status_added` (`status`,`added`),  KEY `ip` (`ip`),  KEY `uploaded` (`uploaded`),  KEY `downloaded` (`downloaded`),  KEY `country` (`country`) ) TYPE=MyISAM PACK_KEYS=0;

I get errors when it used to work fine

[peterlaursen]

QUOTE

CREATE TABLE `avps` ( `arg` varchar(20) NOT NULL default '', `value_s` text NOT NULL, `value_i` int(11) NOT NULL default '0', `value_u` int(10) unsigned NOT NULL default '0', PRIMARY KEY  (`arg`) ) TYPE=MyISAM;|

How did the | – character get in there ? (there are a lot of them).

What are the errors that you get ?

[Author]

Posts