Forum opnieuw installeren met back-up database

tvaddict17 · Bericht door **tvaddict17** » 19 feb 2007, 22:03

Support Template

Wat is het probleem? Ik wil het forum compleet herinstalleren, maar wil wel graag alle gegevens (geposte berichten, gebruikers e.d.) bewaren.
Adres van je forum: http://www.topseries.nl/forum/
Modifications op je forum: Veel, vandaar de herinstallatie.
Huidige stijl: Eigen
phpBB versie: 2.0.22

Overige opmerkingen: Door een onbekende reden zijn de installaties van MODs verkeerd gegaan en het forum is een rotzooi waar waarschijnlijk ontzettend veel fouten in zitten. Ik wil graag weten of ik het qua bestanden compleet kan herinstalleren, gewoon beginnen bij de basis van phpBB en dan de huidige database gebruiken. Is dat mogelijk? Is dat veilig? Is daar een tutorial voor? En als het niet kan, hoe kan ik dan het beste mijn gebruikers en posts bewaren?[/size]

special18 · Bericht door **special18** » 19 feb 2007, 22:09

als je niet sql entries gemaakt heb die erg van belang zijn of grote aanpassingen doen, kun je de template map verwijdere en opnieuw uploaden naar je phpbb locatie.

tvaddict17 · Bericht door **tvaddict17** » 19 feb 2007, 22:22

De template map? Ik heb het over het hele forum hé, de bestanden moeten gewoon opnieuw geïnstalleerd worden maar ik wil de SQL gegevens wel meenemen naar het nieuwe forum.

special18 · Bericht door **special18** » 20 feb 2007, 03:25

via phpmyadmin een backup draaien, als u dit niet weet hoe kunt u een reactie achterlaten er zijn ook tools hiervoor om het te doen.

m.v.g jeffrey

Ramon Fincken · Bericht door **Ramon Fincken** » 20 feb 2007, 08:52

s dat mogelijk? Is dat veilig?

Ja
Als je niet precies weet wat je doet is het niet veilig.

Wat ik je aanraad is gewoon een schone phpbb versie te pakken,
je eigen forum stijl naar subSilver terug te zetten en ALLE ( behalve config.php ) bestanden te overschrijven.

Nu is er een redelijke kans dat sommige mods een foutmelding blijven geven, maar dat is meestal snel oplosbaar.

Want...
daar hebben we de "clean tables" mod voor...
http://www.phpbb.com/phpBB/viewtopic.php?t=293867

Die laat je originele velden heel, maar gooit alle MOD velden in je database weg.

Maak ALTIJD een backup van je bestanden en database voordat je ermee aan de slag gaat!

tvaddict17 · Bericht door **tvaddict17** » 23 feb 2007, 15:37

Goed, ik heb dus een back-up en heb besloten het gehele forum gewoon mee te nemen, nu staan de bestanden er al op, maar is de back-up te groot voor MySQL. Als je hem upload zegt phpAdmin dat het bestand te groot is en als je hem opdeelt (zoals volgens de Wiki) dan pakt hij hem niet en kapt hij regels gewoon af. Zijn er behalve het bestand uploaden of gedeeltes in de SQL-query te voeren nog andere mogelijkheden om een .sql bestand in een MySQL database te krijgen?

special18 · Bericht door **special18** » 23 feb 2007, 20:56

tvaddict17 schreef:Goed, ik heb dus een back-up en heb besloten het gehele forum gewoon mee te nemen, nu staan de bestanden er al op, maar is de back-up te groot voor MySQL. Als je hem upload zegt phpAdmin dat het bestand te groot is en als je hem opdeelt (zoals volgens de Wiki) dan pakt hij hem niet en kapt hij regels gewoon af. Zijn er behalve het bestand uploaden of gedeeltes in de SQL-query te voeren nog andere mogelijkheden om een .sql bestand in een MySQL database te krijgen?

via php of direct via je webhost.

m.v.g jeffrey

Bertie · Bericht door **Bertie** » 23 feb 2007, 20:57

php != phpmyadmin
Dus je moet het idd uitvoeren in phpmyadmin of je kan het met bigdump gaan uitvoeren.

tvaddict17 · Bericht door **tvaddict17** » 25 feb 2007, 12:58

Ik probeer dus via de bovengenoemde mogelijkheden mijn back-up in de nieuwe database te zetten, maar nu krijg ik een fout:

Code: Selecteer alles

MySQL: 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 '' at line 1

voor deze query:

Code: Selecteer alles

INSERT INTO `phpbb_topics` VALUES (178,14,'Algemene Informatie',2,1149610408,83,0,0,0,0,1124,1124,0),(3,2,'het algemene opmerkingen en feedback topic',2,11369250163537,40,0,0,1,10,4083,0),(4,1,'Verbeteringen',2,1136980509,605,215,0,0,0,11,4936,0),(5,16,'Nieuwe Gebruikers: Stel je voor!',4,1137005828,4225,38,0,0,1,16,2874,0),(6,2,'Nieuwe Gebruikers: Stel je voor!',4,1137005828,11,1,2,0,0,16,18,5),(7,3,'3.11 The Safe Harbor',2,1137083246,423,10,0,1,0,19,92,0),(8,4,'Veronica Mars seizoen 2',3,1137089917,347,2,0,0,0,22,1043,0),(9,14,'Stopt..!',3,1137090063,511,8,0,0,0,23,881,0),(10,17,'Hot or Not',3,1137091434,3587,180,0,0,0,26,4954,0),(11,18,'Seizoen 1 Algemeen',3,1137091686,722,8,0,0,1,27,3480,0),(122,18,'2.12 We\'re Gonna Be All Right',2,1144237048,123,0,0,0,0,904,904,0),(255,38,'6.17 Twenty-One Is The Loneliest Number',2,1157643300,51,0,0,0,0,1670,1670,0),(145,13,'2.10 The 23rd Psalm',2,1145206382,118,0,0,0,0,962,962,0),(50,2,'Het toevoegen van TV-Series',3,1137524641,5940,75,0,0,1,174,4337,0),(113,33,'Desperate Housewives Game..',3,1143365312,206,2,0,0,0,849,851,0),(121,2,'Forum Regels',2,1144162835,156,0,0,0,2,900,900,0),(152,13,'2.12 Fire + Water',2,1145980862,167,1,0,0,0,980,1007,0),(20,5,'Prison Break Algemeen',3,1137170409,548,11,1,1,0,47,4330,0),(21,14,'Reunion Algemeen',3,1137170479,254,4,0,1,1,48,1715,0),(22,7,'Rome Algemeen',3,1137170554,306,3,0,1,1,49,2559,0),(102,17,'Wat wordt er omschreven?',3,1142096219,1463,99,0,0,0,749,4297,0),(675,1,'Mods',39,1171128972,9,1,0,0,0,4935,4939,0),(221,1,'Updaten',2,1154465460,1729,554,0,0,0,1379,4953,0),(27,20,'08.10 Vaya Con Leos',2,1137243130,188,1,0,0,0,63,65,0),(28,20,'Charmed Algemeen',3,1137267483,487,6,1,1,1,70,1523,0),(29,26,'Braceface Algemeen',3,1137269017,462,3,0,1,1,72,488,0),(103,16,'Foto van jezelf?',3,1142096432,303,5,0,0,0,750,2901,0),(31,30,'Friends Algemeen',3,1137269165,254,4,0,1,1,74,4303,0),(32,22,'Ghost Whisperer Algemeen',3,1137269238,171,0,0,1,1,75,75,0),(153,18,'2.15 Thank You So Much',2,1146059549,105,0,0,0,0,984,984,0),(34,27,'Joan of Arcadia Algemeen',3,1137269464,732,8,0,1,1,77,2214,0),(146,32,'2.15 Penny For Your Thoughts',2,1145217209,122,0,0,0,0,964,964,0),(105,33,'Winares Idols 2006!',3,1142114885,171,1,0,0,0,758,762,0),(104,34,'Acteur/actrice top 10',3,1142096579,683,16,0,0,0,751,4464,0),(188,5,'1.02 Allen',2,1151155828,94,0,0,0,0,1171,1171,0),(39,21,'Twin Peaks Algemeen',3,1137269896,432,5,0,1,1,88,1294,0),(40,31,'Will and Grace Algemeen',3,1137269999,268,2,0,1,1,90,1299,0),(41,3,'Summer\'s Quotes',2,1137270386,153,0,0,0,0,95,95,0),(42,3,'03.12 The Sister Act',2,1137270828,314,6,0,0,0,99,1314,0),(44,5,'Prison Break komt pas weer in Maart',7,1137334242,224,4,0,0,0,127,297,0),(45,35,'Buffy the Vampire Slayer Algemeen',3,1137335385,340,3,0,1,1,130,382,0),(106,3,'03.17 The Journey',3,1142684315,125,0,0,0,0,811,811,0),(48,34,'Serie Top 10',2,1137352865,1290,24,0,0,0,144,4553,0),(49,21,'De beste aflevering...',4,1137436776,198,2,0,0,0,154,1228,0),(51,2,'Corrigeren',2,1137525995,166,0,0,0,1,175,175,0),(52,33,'Huiver mee met The Ghost Whisperer',2,1137526877,131,0,0,0,0,176,176,0),(53,9,'NY: 1.13 Tanglewood',2,1137874744,185,1,0,0,0,209,778,0),(56,31,'Afl.  1.01-1.08',2,1138038961,127,0,0,0,0,238,238,0),(57,1,'Zoekfunctie',2,1138101091,16,7,0,0,0,247,890,0),(58,20,'08.11 Mr. & Mrs. Witch',2,1138128766,227,2,0,0,0,251,1298,0),(59,3,'03.13 The Pot Stirrer',2,1138181072,321,6,0,0,0,277,3983,0),(173,1,'Forum Makeover, Part 2',2,1148739525,18,6,0,0,0,1068,1790,0),(61,30,'Friends Seizoen 1',2,1138200342,539,6,0,0,0,281,1300,0),(62,33,'Malcolm In The Middle en That\'s \'70s Show stoppen',2,1138202044,122,0,0,0,0,282,282,0),(63,33,'Golden Globes Winnaars',2,1138203052,105,0,0,0,0,283,283,0),(64,3,'Anna Stern (Samaire Armstrong)',2,1138215163,281,3,0,0,0,288,2201,0),(65,33,'Friends komen niet meer terug',2,1138268355,123,0,0,0,0,299,299,0),(66,37,'Who\'s Your Daddy?',2,1138268958,10,0,0,0,0,300,300,0),(67,33,'Nieuwe serie: Jericho',2,1138301448,139,0,0,0,0,321,321,0),(68,33,'Nieuwe serie: Presidio Med',2,1138301621,122,0,0,0,0,323,323,0),(69,3,'03.14 The Cliffhanger',2,1138384232,213,2,0,0,0,338,507,0),(70,3,'1.27 The Ties That Bind',2,1138392831,149,6,0,1,0,341,3610,0),(71,37,'Wat kijk jij op het moment..!',31138454137,72,17,0,0,0,350,3338,0),(101,17,'Welke serie wordt er omschreven?',3,1142095955,2336,139,0,0,0,748,4251,0),(73,1,'het algemene verbeterlijstje',2,1138530983,23,0,1,0,0,369,369,0),(74,38,'Gilmore Girls Algemeen',2,1138549144,471,9,0,1,0,372,2691,0),(93,1,'Top Series 2.0',2,1141124543,90,34,0,0,0,626,699,0),(76,1,'Reactiesystemen en Polls',2,1138988495,12,4,0,0,0,415,420,0),(77,1,'Style Scenario\'s',2,1138992731,5,0,0,0,0,421,421,0),(78,3,'Mischa Barton',11,1138995904,267,5,0,0,0,422,430,0),(189,4,'1.02 Credit Where Credit\'s Due',2,1151331867,156,1,0,1,0,1176,2590,0),(80,33,'Mischa Barton',3,1139339619,143,1,0,0,0,505,548,0),(81,3,'03.15 The Heavy Lifting',3,1139339820,510,8,0,0,0,506,1382,0),(187,4,'1.01 Pilot',2,1151144151,113,1,0,1,0,1167,2589,0),(83,3,'Seizoen 4..?',3,1139347336,305,8,0,1,0,509,2535,0),(84,28,'Grey\'s Anatomy Seizoen 1',14,1139493368,284,3,0,0,0,524,1140,0),(85,41,'Algemeen',3,1139598377,290,2,0,1,0,541,1103,0),(87,3,'03.16 The Road Warrior',2,1139655289,242,4,0,0,0,547,744,0),(88,28,'Grey\'s Anatomy seizoen 2',3,1139769061,360,3,0,0,0,568,4732,0),(89,5,'Prison Break komt naar Nederland..!',3,1140028265,141,0,0,0,0,599,599,0),(90,33,'Nieuwe serie: Prison Break',3,1140036471,130,0,0,0,0,603,603,0),(95,17,'Hoe goed ken jij The O.C.?',2,1141231052,5744,203,0,0,0,651,4875,0),(94,1,'Serie van de Maand',2,1141135106,146,53,0,0,0,629,4110,0),(96,42,'Kijkcijfers',2,1141382776,56,0,0,0,0,665,665,0),(98,42,'Samenvattingen',2,1141389684,83,0,0,0,0,667,667,0),(364,1,'TV-Series 1.0',2,1163346696,204,55,0,0,1,2293,2999,0),(107,3,'03.18  The Undertow',3,1142684392,170,3,0,0,0,812,1429,0),(108,3,'03.19 The Secrets and Lies',3,1143137214,482,7,0,0,0,826,1464,0),(109,3,'03.20 The Day After Tomorrow',3,1143137495,229,3,0,0,0,827,1465,0),(110,3,'03.21 The Darkness Before the Dawn',3,1143137585,332,5,0,0,0,828,1549,0),(111,3,'03.22 The College Try',3,1143137727,370,6,0,0,0,829,1607,0),(112,3,'Verklaar jij nog veel goeds voor Seizoen 3?',3,1143138484,165,1,0,1,0,830,844,0),(236,1,'Algemene opmerkingen topic',2,1155916015,157,56,0,0,0,1467,1789,0),(235,13,'1.02 Pilot, Part 2',2,1155915797,81,0,0,0,0,1466,1466,0),(234,13,'1.01 Pilot, Part 1',2,1155904718,61,0,0,0,0,1463,1463,0),(117,5,'1.03 Cell Test',2,1143811396,127,0,0,0,0,861,861,0),(118,13,'2.08 Collision',2,1143882596,112,0,0,0,0,870,870,0),(119,33,'Actrice en presentatrice Frédérique Huydts overleden',2,1144149152,252,2,0,0,0,894,929,0),(120,13,'2.09 What Kate Did',2,1144161475,148,1,0,0,0,899,915,0),(124,43,'Final Destination 3',3,1144528134,165,2,0,0,0,917,2178,0),(125,43,'Scary Movie 4',3,1144528243,204,5,0,0,0,918,2705,0),(126,43,'X-Men: The Last Stand',3,1145116294,134,0,0,0,0,936,936,0),(127,43,'Silent Hill',3,1145116436,182,2,0,0,0,937,1969,0),(128,43,'United 93',3,1145116548,137,4,0,0,0,938,2648,0),(129,43,'Poseidon',3,1145116682,190,9,0,0,0,939,4461,0),(130,43,'Slither',3,1145116785,115,1,0,0,0,940,1257,0),(131,43,'Take the Lead',3,1145116917,139,0,0,0,0,941,941,0),(132,43,'Ultraviolet',3,1145117032,119,0,0,0,0,942,942,0),(133,43,'Cars',3,1145117152,118,4,0,0,0,943,2761,0),(134,43,'When a Stranger Calls',3,1145117271,143,1,0,0,0,944,1255,0),(135,43,'Over the Hedge',3,1145117381,167,2,0,0,0,945,1262,0),(136,43,'Just My Luck',3,1145117507,294,3,0,0,0,946,1111,0),(137,43,'Hills Have Eyes, The',3,1145117609,237,3,0,0,0,947,1271,0),(138,43,'Little Man',3,1145117797,188,2,0,0,0,948,1263,0),(139,43,'The Fast and The Furious Tokyo Drift',3,1145117910,173,2,0,0,0,949,1527,0),(140,43,'Superman Returns',3,1145118034,108,0,0,0,0,950,950,0),(141,43,'Garfield\'s A Tale of Two Kitties',3,1145118155,193,2,0,0,0,951,1970,0),(142,43,'Miami Vice',3,1145118262,124,3,0,0,0,952,4412,0),(143,43,'Lady in the Water',3,1145118376,101,0,0,0,0,953,953,0),(144,43,'Benchwarmers, The',3,1145118531,123,0,0,0,0,954,954,0),(147,33,'Nieuw seizoen Las Vegas',2,1145217906,412,1,0,0,0,965,968,0),(148,18,'2.14 Silly People',2,1145458946,113,0,0,0,0,971,971,0),(149,5,'Riots, Drills and the Devil, Part 1',2,1145626498,145,0,0,0,0,976,976,0),(150,3,'03.23 The Party Favor',3,1145626694,467,8,0,0,0,977,1609,0),(151,33,'The Simple Life 4',3,1145736897,107,0,0,0,0,978,978,0),(154,18,'Wie is jullie favoriete housewive?',2,1146065523,113,2,0,1,0,986,4540,0),(155,28,'2.08 Let It Be',2,1146155181,116,0,0,0,0,991,991,0),(156,33,'The OC is Back!',2,1146157644,129,1,0,0,0,992,2557,0),(157,5,'Riots, Drills and the Devil, Part 2',2,1146233391,164,0,0,0,0,993,993,0),(158,3,'03.24 The Man of The Year',3,1146255582,270,4,0,0,0,996,1643,0),(159,27,'Jaonofarcadia.com schrijft eigen seizoen 3',3,1146256376,264,3,0,0,0,998,1026,0),(160,3,'03.25 The Graduates',3,1146305510,468,10,0,0,0,1003,1731,0),(161,33,'Nieuw Seizoens Overzicht 2006-2007',2,1146326026,240,1,0,0,0,1008,1028,0),(162,33,'Mischa Barton verlaat The O.C.?',3,1146414076,205,5,0,0,0,1014,2641,0),(164,18,'2.16 There Is No Other Way',2,1146645482,93,0,0,0,0,1022,1022,0),(165,28,'2.09 Thanks for the Memories',2,1146645648,174,2,0,0,0,1023,1095,0),(166,9,'4.10 Shattered',2,1146656619,194,2,0,0,0,1027,1045,0),(168,5,'1.08 The Old Head',2,1146820353,155,0,0,0,0,1031,1031,0),(171,13,'2.20 Two For The Road',2,1147078638,154,0,0,0,0,1039,1039,0),(170,13,'2.13 The Long Con',2,1146920479,100,0,0,0,0,1035,1035,0),(172,42,'Nieuwe samenvattingen',2,1148178283,93,1,0,0,0,1050,4287,0),(174,8,'Algemeen',3,1148820241,341,5,0,0,0,1098,1342,0),(175,9,'6.13 Kiss-Kiss, Bye-Bye',2,1149001657,124,0,0,0,0,1113,1113,0),(179,18,'Seizoens Finale: Remember Me',2,1150464112,120,1,0,0,0,1141,1153,0),(180,5,'Prison Break Spoilers',2,1150623892,108,0,0,0,0,1142,1142,0),(181,5,'1.01 Pilot',2,1150635877,126,0,0,0,0,1143,1143,0),(182,61,'Nieuwe serie: Six Degrees',2,1150654113,76,4,0,0,0,1145,4067,0),(183,5,'Prison Break Seizoen 1 DVD US',2,1150654643,159,1,0,0,0,1146,1229,0),(184,28,'1.01 A Hard Day\'s Night',2,1150730394,96,0,0,0,0,1148,1148,0),(185,28,'2.02 The First Cut Is The Deepest',2,1150736553,130,0,0,0,0,1150,1150,0),(186,14,'Nieuwe afleveringen',2,1150984566,209,8,0,0,0,1158,4495,0),(190,4,'1.03 Meet John Smith',2,1151354841,85,1,0,1,0,1177,2605,0),(191,4,'1.05 You Think You Know Somebody',2,1151432618,159,2,0,1,0,1179,1316,0),(192,4,'1.04 The Wrath Of Con',2,1151432951,118,1,0,1,0,1180,1182,0),(193,7,'1.01 The Stolen Eagle',2,1151442760,101,0,0,0,0,1183,1183,0),(194,4,'1.07 The Girl Next Door',2,1151523448,112,0,0,1,0,1187,1187,0),(195,4,'1.11 Silence Of The Lamb',2,1151582446,150,1,0,1,0,1194,1352,0),(196,42,'Nieuwe series: South Park Samenvattingen',2,1151921650,11,0,0,0,0,1198,1198,0),(197,4,'1.22 Leave It To Beaver',2,1152038960,257,4,0,1,0,1200,3468,0),(198,44,'1.04 Spin Cycle',2,1152134217,105,0,0,0,0,1201,1201,0),(199,44,'1.01 Don\'t Tell Me About Your Dreams',2,1152134540,154,1,0,0,0,1204,1999,0),(200,42,'Crime Scene Investigation',2,1152275432,3,0,0,0,0,1209,1209,0),(201,42,'Westenwind',2,1152285797,32,0,0,0,0,1210,1210,0),(202,16,'Nieuwe series gekocht?',2,1152285878,594,43,0,0,0,1211,4752,0),(203,33,'Simple Life fake!',3,1152477489,122,2,0,0,0,1225,1435,0),(204,13,'Lost Algemeen',3,1152477839,81,0,0,0,1,1231,1231,0),(205,42,'Las Vegas',2,1152527346,2,0,0,0,0,1235,1235,0),(206,1,'Januari Maand, Hollandse Maand',2,1152561193,142,55,0,0,0,1238,2878,0),(207,4,'2.01 Normal Is The Watchword',2,1152896022,104,1,0,1,0,1272,4094,0),(208,4,'2.09 My Mother, The Fiend',2,1152989326,214,7,0,1,0,1275,4335,0),(209,4,'2.11 Donut Run',2,1153041900,115,2,0,1,0,1276,4340,0),(210,33,'Lost videogame',3,1153169646,86,0,0,0,0,1286,1286,0),(211,8,'24 seizoen 5 \'waarschijnlijk\' dit najaar weer op RTL 5',3,1153232659,131,0,0,0,0,1287,1287,0),(212,45,'Gooische Vrouwen',3,1153687192,111,1,0,0,0,1301,1302,0),(213,15,'Wat heb jij laatst gedaan?',3,1153687293,89,8,0,0,0,1303,3513,0),(214,15,'Vakantie',3,1153687468,93,3,0,0,0,1305,3459,0),(215,15,'Wat is jou laatste aankoop?',3,1153687645,339,15,0,0,0,1307,4622,0),(216,15,'Waarvoor ben jij aan het sparen?',3,1153687718,213,15,0,0,0,1309,4436,0),(217,15,'Wat ga jij vandaag doen?',3,1153687882,261,11,0,0,0,1311,4396,0),(218,15,'Wat is/zijn je stopwoord/stopwoorden',3,1153688371,95,0,0,0,0,1312,1312,0),(219,4,'1.09 Drinking The Kool-Aid',13,1153932090152,1,0,1,0,1339,1343,0),(220,45,'1.03 Aflevering 3',2,1154083990,109,0,0,0,0,1349,1349,0),(222,1,'TV-Sterren',2,1154465624,25,9,0,0,0,1380,2784,0),(223,42,'Gemiste uitzendingen',2,1154512389,17,0,0,0,0,1381,1381,0),(224,42,'Will & Grace',2,1154533314,5,0,0,0,0,1386,1386,0),(225,37,'Summerland',3,1154696811,20,5,0,0,0,1405,3339,0),(228,42,'Invasion',2,1155203410,4,0,0,0,0,1428,1428,0),(237,13,'1.03 Tabula Rasa',2,1155921324,75,0,0,0,0,1469,1469,0),(230,33,'Rome Seizoen 2',3,1155405497,255,5,0,0,0,1436,2558,0),(238,13,'1.04 Walkabout',2,1155991683,81,0,0,0,0,1475,1475,0),(239,46,'1.10 You Gotta Go There To Come Back',3,1156020716,95,1,0,1,0,1478,2702,0),(240,5,'2.01 Manhunt',3,1156021338,292,12,0,1,0,1479,2180,0),(241,46,'Nieuwtjes',3,1156027804,137,2,0,0,0,1480,1553,0),(283,2,'Belangrijk: SPOILER REGELS',2,1159549649,74,0,0,0,2,1832,1832,0),(244,20,'1.01 Pilot',2,1156784087,91,0,0,0,0,1557,1557,0),(247,43,'Welk liedje vind jij op het moment te gek?',3,1156954179,301,19,0,0,1,1581,4866,0),(246,5,'2.02 Otis',2,1156872958,108,1,0,1,0,1562,2207,0),(248,17,'Puzzel',2,1157120476,3035,156,0,0,0,1589,4905,0),(249,27,'1.01 Pilot',2,1157222829,68,0,0,0,0,1614,1614,0),(250,50,'1.01 Genesis',2,1157293966,187,3,0,1,0,1620,1681,0),(251,27,'1.02 The Fire And The Wood',2,1157351578,61,0,0,0,0,1626,1626,0),(252,27,'1.03 Touch Move',2,1157464680,70,0,0,0,0,1633,1633,0),(253,37,'Heroes 1.01',2,1157293966,2,0,2,0,0,1620,1620,250),(254,1,'Samenvattingen',2,1157575364,32,11,0,0,0,1657,1677,0),(256,5,'2.03 Scan',2,1157649552,98,1,0,1,0,1679,2259,0),(257,52,'1.01 Pilot',2,1157662368,118,4,0,0,0,1687,4055,0),(258,53,'1.01 You Can\'t Miss The Bear',2,1157698747,52,0,0,0,0,1688,1688,0),(259,52,'1.02 	Pretty Woman',2,1157736929,53,1,0,0,0,1691,4268,0),(260,27,'1.04 The Boat',2,1157876126,70,0,0,0,0,1702,1702,0),(261,46,'3.22 The Show Must Go On',3,1157887120,66,4,0,1,0,1707,4949,0),(262,4,'2.20 Look Who\'s Stalking',13,1157998198,84,0,0,0,0,1713,1713,0),(263,14,'1.01 1986',2,1158058159,79,0,0,0,0,1714,1714,0),(264,54,'1.01 Pilot',2,1158147968,68,0,0,0,0,1718,1718,0),(265,4,'2.22 Not Pictured',13,1158151689,276,6,0,0,0,1720,1758,0),(266,5,'2.04 First Down',3,1158160396,84,2,0,1,0,1725,2332,0),(267,55,'1.01 Pilot',3,1158264855,69,2,0,1,0,1746,4926,0),(268,27,'1.08 The Devil Made Me Do It',2,1158495975,50,0,0,0,0,1760,1760,0),(269,52,'1.03 Behind The Orange Curtain',2,1158590993,66,0,0,0,0,1770,1770,0),(270,18,'1.13 Your Fault',2,1158594503,45,0,0,0,0,1771,1771,0),(271,38,'1.01 Pilot',2,1158688872,92,2,0,1,0,1773,2308,0),(272,27,'1.12 Jump',2,1158690709,34,0,0,0,0,1774,1774,0),(273,5,'2.05 Map 1213',2,1158764370,64,1,0,1,0,1775,2495,0),(274,57,'1.01 Pilot',2,1158932323,62,1,0,0,0,1782,1786,0),(276,62,'1.01 Patriarchy',2,1159213191,50,0,0,0,0,1807,1807,0),(277,61,'1.01 Pilot',2,1159277317,55,1,0,0,0,1809,3837,0),(278,5,'2.06 Subdivision',2,1159292410,59,1,0,1,0,1811,2496,0),(279,46,'4.01 The Same Deep Water As You',3,1159526160,100,8,0,0,0,1817,1837,0),(280,27,'Joan of Arcadia Theme',2,1159536152,53,0,0,0,0,1819,1819,0),(281,4,'3.01 Welcome Wagon',2,1159537471,126,2,0,0,0,1823,1879,0),(282,64,'1.02 Fallout',2,1159540781,85,2,0,0,0,1824,1844,0),(284,60,'4.01 Falling Into Place',2,1159550340,59,0,0,0,0,1834,1834,0),(285,28,'3.01 Time Has Come Today',3,1159593448,59,1,0,1,0,1841,4091,0),(286,28,'3.02 I Am A Tree',3,1159593595,65,1,0,1,0,1842,4274,0),(287,28,'3.03 Sometimes a Fantasy',3,1159593713,74,1,0,1,0,1843,4519,0),(288,4,'Nieuwe lead, nieuwe cast',2,1159646759,91,1,0,0,0,1849,1851,0),(289,32,'1.02 Suspicions And Certainties',2,1159720106,39,0,0,0,0,1863,1863,0),(290,32,'1.03 A Couple Of Choices',2,1159801859,33,0,0,0,0,1864,1864,0),(291,50,'1.02 Don\'t Look Back',3,1159906610,95,1,0,1,0,1872,1992,0),(292,5,'2.07 Buried',3,1159906834,84,2,0,1,0,1873,2593,0),(293,46,'4.02 Things I Forgot at Birth',3,1160068228,64,2,0,0,0,1884,1895,0),(294,69,'Afl. 6.02 - Sneeze',2,1160217845,48,0,0,0,0,1900,1900,0),(295,46,'Theme',2,1160302708,82,4,0,0,0,1959,2616,0),(296,17,'Cijfer voor je Creatie(s)',3,1160308534,642,41,0,0,0,1966,4755,0),(297,62,'1.03 Affair  Of State',2,1160472895,39,0,0,0,0,1993,1993,0),(298,50,'1.03 One Giant Leap',2,1160482479,107,3,0,1,0,1995,2018,0),(299,13,'3.02 The Glass Ballerina',2,1160643821,49,0,0,0,0,2011,2011,0),(300,46,'4.03 Good News For All The People Who Love Bad News',2,1160647081,90,6,0,0,0,2012,2021,0),(301,1,'Nieuws Systeem op het forum',2,1160737225,13,3,0,0,0,2023,2034,0),(302,69,'Afl. 6.03 - Wither',2,1160750730,41,0,0,0,0,2029,2029,0),(303,28,'3.04 What I Am',3,1160840564,47,0,0,0,0,2045,2045,0),(304,46,'4.04 Can\'t Stop This Thing We\'ve Started',3,1160904841,57,2,0,0,0,2051,2089,0),(305,18,'3.04 Like It Was',3,1161031654,53,1,0,1,0,2062,4572,0),(306,55,'1.03 Shanghai\'d',3,1161031743,43,0,0,0,0,2063,2063,0),(307,1,'Promotie',2,1161092589,27,8,0,0,0,2067,4786,0),(308,13,'3.03 Further Instructions',2,1161282456,44,0,0,0,0,2086,2086,0),(309,50,'1.04 Collision',3,1161282725,60,0,0,1,0,2088,2088,0),(310,9,'NY: 2.23 Heroes',2,1161286625,59,0,0,0,0,2090,2090,0),(311,28,'1.09 Who\'s Zoomin\' Who?',2,1161437714,45,0,0,0,0,2100,2100,0),(312,28,'2.01 Raindrops Keep Falling On My Head',2,1161454475,51,1,0,1,0,2104,4236,0),(313,28,'3.05 Oh, The Guilt',3,1161531033,35,0,0,0,0,2114,2114,0),(314,55,'1.04 Partners in Crime',3,1161533429,36,0,0,0,0,2115,2115,0),(315,18,'3.02 It Takes Two',2,1161668977,39,1,0,1,0,2117,4161,0),(316,9,'Miami 5.06 	Curse Of The Coffin',2,1161721407,51,0,0,0,0,2119,2119,0),(317,50,'1.05 Hiros',3,1161804295,102,2,0,1,0,2127,2134,0),(318,5,'2.08 Dead Fall',3,1161804457,95,2,0,1,0,2128,2699,0),(319,4,'3.04 	Charlie Don\'t Surf',3,1161804522,109,3,0,0,0,2129,2137,0),(320,46,'4.05 I Love You But I\'ve Chosen Darkness',3,1161865002,64,2,0,0,0,2135,2157,0),(321,13,'3.04 Every Man For Himself',2,1161890369,57,0,0,0,0,2141,2141,0),(323,43,'De dominee',39,1161968555,61,0,0,0,0,2160,2160,0),(324,69,'Afl. 6.05 - Reunion',2,1161968873,54,0,0,1,0,2161,2161,0),(326,3,'4.01 The Avengers',3,1162032299,131,3,0,1,0,2164,2250,0),(327,3,'1.01 Pilot',2,1162045705,78,3,0,1,0,2165,4776,0),(328,3,'1.02 The Model Home',2,1162046019,69,1,0,1,0,2166,3059,0),(329,3,'1.04 The Debut',2,1162130678,108,27,0,1,0,2171,3271,0),(330,3,'1.07 The Escape',2,1162202076,75,1,0,1,0,2174,3277,0),(331,3,'1.08 The Rescue',2,1162202210,74,1,0,1,0,2175,3278,0),(332,3,'1.10 The Perfect Couple',2,1162224029,67,1,0,1,0,2177,3295,0),(333,3,'1.11 The Homecoming',2,1162237304,56,1,0,1,0,2181,3296,0),(334,3,'1.12 The Secret',2,1162237389,65,1,0,1,0,2182,3297,0),(335,62,'1.05 Date Night',2,1162237500,24,0,0,1,0,2183,2183,0),(336,3,'1.13 The Best Chrismukkah Ever',2,1162285689,60,1,0,1,0,2184,3352,0),(337,5,'2.09 Unearthed',3,1162304224,103,2,0,1,0,2185,2971,0),(338,4,'3.05 President Evil',3,1162404256,65,1,0,1,0,2195,2205,0),(339,3,'1.21 The Goodbye Girl',2,1162461715,61,1,0,1,0,2200,3486,0),(340,3,'1.22 The L.A.',2,1162471585,69,1,0,1,0,2204,3487,0),(341,13,'3.05 The Cost Of Living',2,1162482410,40,0,0,1,0,2206,2206,0),(343,3,'Het complete eerste seizoen',2,1162561581,195,7,0,1,1,2211,3404,0),(344,5,'het complete eerste seizoen',39,1162565863,98,4,0,1,0,2213,2221,0),(345,3,'2.01 The Distance',2,1162633622,50,1,0,1,0,2223,3648,0),(346,3,'1.03 The Gamble',2,1162641393,73,1,0,1,0,2224,3060,0),(347,3,'2.02 The Way We Were',2,1162651424,62,1,0,1,0,2226,3649,0),(348,3,'2.03 The New Kids On The Block',2,1162654728,61,1,0,1,0,2229,3650,0),(349,3,'2.04 The New Era',2,1162720231,87,1,0,1,0,2235,3769,0),(350,3,'2.05 The SnO.C.',2,1162748419,77,1,0,1,0,2236,3770,0),(351,3,'4.02 The Gringos',3,1162837244,87,1,0,1,0,2239,2249,0),(352,50,'1.06 Better Halves',3,1162837861,39,0,0,1,0,2240,2240,0),(353,18,'3.07 Bang',3,1162842625,58,0,0,1,0,2241,2241,0),(354,5,'2.10 Rendezvous',3,1162918555,124,6,0,1,0,2242,3497,0),(355,3,'2.07 The Family Ties',2,1162920825,66,1,0,1,0,2243,3773,0),(356,3,'2.08 The Power Of Love',2,1162921033,75,1,0,1,0,2244,3775,0),(357,3,'2.09 The Ex-Factor',2,1162921143,78,1,0,1,0,2245,3798,0),(358,4,'3.06 Hi, Infedelity!',2,1163076229,83,1,0,1,0,2252,2257,0),(359,13,'3.06 I Do',2,1163088523,57,0,0,1,0,2254,2254,0),(360,46,'4.06 Where Did You Sleep Last Night?',3,116309582,91,5,0,1,0,2256,2292,0),(361,71,'1.01 De Ark Van Willy',2,1163274300,61,0,0,1,0,2280,2280,0),(362,72,'1.01 Achttien',2,1163284091,59,0,0,1,0,2284,2284,0),(363,73,'1.01 Pilot',3,1163331982,43,0,0,1,0,2291,2291,0),(365,80,'Studio 60 on the Sunset Strip Algemeen',3,1163366274,68,2,0,0,0,2305,2307,0),(366,38,'1.02 Lorelais First Day At Chilton',3,1163443215,53,0,0,1,0,2310,2310,0),(367,84,'Afl. 2.11',39,1163513003,39,0,0,1,0,2319,2319,0),(368,4,'3.07 Of Vice And Men',2,1163531439,109,4,0,1,0,2322,2330,0),(369,5,'2.11 Bolshoi Booze',2,1163537730,112,5,0,1,0,2325,3961,0),(370,3,'4.03 The Cold Turkey',3,1163777620,49,0,0,1,0,2333,2333,0),(371,3,'4.04 The Metamorphosis',3,1163777763,62,1,0,1,0,2334,3947,0),(372,38,'1.03 Kill Me Now',3,1163853195,36,0,0,1,0,2337,2337,0),(373,38,'1.04 The Deer Hunters',3,1163853270,40,0,0,1,0,2338,2338,0),(374,50,'1.09 Homecoming',3,1164027889,61,1,0,1,0,2350,2366,0),(375,54,'1.13 The Night The Lights Went Out In Vegas',2,1164123283,47,0,0,1,0,2358,2358,0),(376,5,'2.12 Disconnect',2,1164132679,66,1,0,1,0,2362,4155,0),(377,4,'3.08 Lord Of The Pi\'s',2,1164228396,63,3,0,1,0,2368,2372,0),(378,46,'4.08 Nothing Left To Say But Goodbye',3,1164308489,58,2,0,1,0,2371,2378,0),(379,4,'3.09 Spit & Eggs',2,1164311595,117,11,0,1,0,2374,4576,0),(380,28,'3.09 From A Whisper to a Scream',3,1164406501,38,0,0,1,0,2382,2382,0),(381,78,'1.09 Lose the Boss?',3,1164406723,40,0,0,1,0,2383,2383,0),(382,95,'Magnum P.I. Seizoen 1',39,1164478933,42,0,0,1,1,2384,2384,0),(383,95,'1.16    J."Digger" Doyle',39,1164479781,43,0,0,1,0,2385,2385,0),(384,95,'1.17 Beauty Knows No Pain',39,1164577906,40,0,0,1,0,2411,2411,0),(385,1,'Verbeteringen 2007',2,1164651951,176,57,0,0,1,2428,4187,0),(386,9,'CSI: 7.01 Built To Kill, Part 1',2,1164661398,45,0,0,1,0,2432,2432,0),(387,54,'1.23 Always Faithful',2,1164724620,42,0,0,1,0,2437,2437,0),(388,5,'2.13 The Killing Box',3,1164729516,106,3,0,1,0,2441,4322,0),(389,50,'1.10 Six Month\'s Ago',3,1164729878,36,0,0,1,0,2442,2442,0),(390,46,'1.01 Pilot',2,1164749314,40,1,0,1,0,2451,4117,0),(391,4,'Hoogste ratings dit seizoen!',2,1164825306,48,0,0,0,0,2467,2467,0),(392,46,'4.09 Some You Give Away',3,1164872052,76,10,0,1,0,2480,2553,0),(393,46,'4.10 Songs to Live and Die By',3,1164909972,59,6,0,1,0,2482,2692,0),(394,69,'Afl. 6.08 - Static',2,1164913162,41,0,0,1,0,2484,2484,0),(395,3,'2.11 The Second Chance',2,1164913429,48,1,0,1,0,2486,3803,0),(396,50,'1.11 Fallout',3,1164996448,27,1,0,1,0,2497,2571,0),(397,78,'1.10 Fake Plastic Snow',3,1164999220,29,0,0,1,0,2499,2499,0),(398,28,'3.10 Don\'t Stand So Close to Me',3,1165008257,58,2,0,1,0,2502,4660,0),(399,42,'Dharma & Greg',2,1165071005,5,0,0,0,0,2504,2504,0),(400,1,'Nieuws op de site',2,1165071159,14,4,0,0,0,2505,2511,0),(401,62,'1.07 Northern Exposure',2,1165090278,36,0,0,1,0,2510,2510,0),(402,3,'2.14 The Rainy Day Women',2,1165144716,39,1,0,1,0,2523,3805,0),(403,3,'2.15 The Mallpisode',2,1165144854,31,1,0,1,0,2524,3812,0),(404,3,'2.16 The Blaze Of Glory',2,1165145187,40,1,0,1,0,2526,3813,0),(405,50,'1.08 Seven Minutes To Midnight',2,1165148686,30,4,0,1,0,2527,2534,0),(406,96,'Wat is jou leukste personage?',3,1165167209,34,0,0,1,0,2538,2538,0),(407,96,'Waar is Julia?',3,1165167389,25,0,0,0,0,2539,2539,0),(408,96,'Kijk Kinderen Geen Bezwaar Online',3,1165167647,34,1,0,0,0,2540,2541,0),(409,96,'2.28 Jim',3,1165177797,26,0,0,1,0,2544,2544,0),(410,96,'3.11 Proefkamperen',3,1165177908,30,0,0,1,0,2545,2545,0),(411,62,'1.08 Mistakes Were Made, Part 1',2,1165180487,30,0,0,1,0,2547,2547,0),(412,8,'Day 6: 6:00 AM - 7:00 AM',3,1165251935,77,10,0,1,0,2560,4275,0),(413,46,'1.02 The Places You Have Come To Fear The Most',2,1165257244,40,0,0,1,0,2564,2564,0),(414,51,'Afl. 1.01 Mexican Slayride (part 1+2)(pilot)',39,1165328118,40,0,0,1,0,2572,2572,0),(415,51,'Afl. 1.04 Children of Jamestown',39,1165328455,36,0,0,1,0,2574,2574,0),(416,3,'4.06 The Summer Bummer',3,1165353799,65,7,0,1,0,2579,2617,0),(417,3,'4.05 The Sleeping Beauty',3,1165353887,47,0,0,1,0,2580,2580,0),(418,62,'1.09 Mistakes Were Made, Part 2',2,1165413801,51,3,0,1,0,2582,2586,0 ,(419,3,'4.07 The Chrismukk-Huh',3,1165613838,82,9,0,1,0,2607,2709,0),(421,46,'1.03 Are You True?',2,1165675560,35,0,0,1,0,2618,2618,0),(422,4,'1.06 Return Of The Kane',2,1165687275,33,0,0,1,0,2619,2619,0),(423,43,'The Departed',14,1165692688,50,3,0,0,0,2621,4069,0),(424,46,'1.04 Crash Into You',2,1165694875,32,0,0,1,0,2624,2624,0),(425,43,'Step Up',3,1165708276,109,14,0,1,0,2643,2698,0),(426,3,'01 Welcome To The O.C. A Day In The Life',2,1165748568,30,0,0,1,0,2649,2649,0),(427,46,'1.05 All That You Can\'t Leave Behind',2,1165767297,22,0,0,1,0,2652,2652,0),(428,51,'Afl. 1.05 A Small And Deadly War',39,1165865532,35,0,0,1,0,2662,2662,0),(429,46,'1.06 Every Night Is Another Story',2,1165867231,25,1,0,1,0,2663,4670,0),(430,51,'Afl. 1.07 The Rabbit Who Ate Las Vegas',39,1165874657,36,0,0,1,0,2665,2665,0),(431,46,'1.07 Life In A Glass House',2,1165936750,23,0,0,1,0,2667,2667,0),(432,51,'Afl. 1.08 the out-of-towners',39,1165937370,48,0,0,1,0,2669,2669,0),(433,28,'2.27 Losing My Religion',2,1165955388,47,1,0,1,0,2675,2682,0),(434,46,'1.08 The Search For Something More',2,1166027452,27,1,0,1,0,2687,4726,0),(435,46,'1.09 With Arms Outstretched',2,1166111844,28,1,0,1,0,2695,2696,0),(436,46,'1.11 The Living Years',2,1166199218,32,0,0,1,0,2703,2703,0),(437,3,'4.08 The Earth Girls Are Easy',3,1166202860,50,5,0,1,0,2707,2970,0),(438,15,'Kleuter geschorst wegens \'seksuele intimidatie\'',39,1166263311,67,6,0,0,0,2716,2735,0),(439,28,'3.11 Six Days (Part 1)',14,1166295667,105,10,0,1,0,2726,4269,0),(440,46,'1.12 	Crash Course In Polite Conversations',2,1166296992,24,0,0,1,0,2728,2728,0),(441,5,'Seizoen 3???',39,1166309751,78,3,0,1,0,2740,4232,0),(442,42,'Desperate Housewives',2,1166352665,4,0,0,0,0,2742,2742,0),(443,2,'Top Series Stopt Tijdelijk',39,1166356191,119,16,0,0,2,2744,4923,0),(444,15,'Moppen',39,1166357707,78,5,0,0,0,2752,2889,0),(445,17,'Raadsels',39,1166358342,319,66,0,0,0,2754,4658,0),(446,15,'\'Onverzadigbare lust door bedrijfsongeval\'',39,1166359690,55,1,0,0,0,2771,2792,0),(447,15,'Texaanse parlementariër wil blinden laten jagen',39,1166359752,54,4,0,0,0,2773,2785,0),(448,4,'1.08 Like A Virgin',2,1166362854,36,0,0,1,0,2786,2786,0),(449,4,'1.12 Clash Of The Tritons',2,1166370912,41,0,0,1,0,2798,2798,0),(450,4,'1.10 An Echolls Family Christmas',2,1166373005,28,0,0,1,0,2799,2799,0),(451,46,'1.13 Hanging By A Moment',2,1166387272,19,0,0,1,0,2842,2842,0),(452,97,'Geschrapt!',3,1166390003,51,0,0,0,0,2851,2851,0),(453,8,'Seizoen 6 castfoto',3,1166455503,56,5,0,0,0,2866,2882,0),(454,4,'1.13 Lord Of The Bling',2,1166464357,33,0,0,1,0,2883,2883,0),(455,46,'1.14 I Shall Believe',2,1166470905,26,0,0,1,0,2887,2887,0),(456,34,'Album top 10',3,1166551345,38,1,0,0,0,2891,2892,0),(457,34,'Boek top 10',3,1166551722,54,3,0,0,0,2893,2916,0),(458,34,'Site top 5/10',3,1166551826,46,2,0,0,0,2895,4260,0),(459,43,'Wat is jou favoriete genre?',3,1166552167,44,3,0,1,1,2897,2918,0),(460,2,'Verbeteringen 2007',3,1166552675,50,0,1,0,2,2899,2899,0),(461,50,'1.12 Godsend',3,1166648101,45,2,0,1,0,2903,4520,0),(462,46,'Derde seizoen op DVD !!!',14,1166651779,48,8,0,0,0,2904,4878,0),(463,3,'The O.C. om 18.00 op Veronica',3,1166726075,26,2,0,0,0,2939,2966,0),(464,46,'1.15 Suddenly Everything Has Changed',2,1166784690,24,0,0,1,0,2957,2957,0),(465,33,'Titel van het laatste Harry Potter Boek bekend',3,1166977653,61,9,1,0,0,2995,3016,0),(466,46,'1.16 The First Cut Is The Deepest',2,1167001174,27,0,0,1,0,3014,3014,0),(467,46,'1.17 Spirit In The Night',2,1167078132,31,0,0,1,0,3020,3020,0),(468,43,'Welke film heb jij als laatst gezien?',3,1167086496,71,24,0,0,1,3031,3891,0),(469,3,'4.09 The My Two Dads',14,1167099086,131,30,0,1,0,3041,4021,0),(470,37,'What I Like About You',3,1167127868,19,5,0,0,0,3050,4211,0),(471,28,'Grey\'s Anatomy op 8 Januari terug op Net 5',3,1167128269,67,21,0,0,0,3055,3244,0),(472,46,'1.18 To Wish Impossible Things',2,1167139726,19,1,0,1,0,3061,3065,0),(473,3,'1.05 The Outsider',3,1167198312,24,0,0,1,0,3275,3275,0),(474,3,'1.06 The Girlfriend',3,1167198407,15,0,0,1,0,3276,3276,0),(475,46,'1.19 How Can You Be Sure?',2,1167225096,22,0,0,1,0,3292,3292,0),(476,3,'1.09 The Heights',3,1167231395,18,0,0,1,0,3294,3294,0),(477,17,'Hoe ziet jou bureaublad eruit?',3,1167252949,121,27,0,0,0,3299,4372,0),(478,17,'This or That',3,1167253036,253,53,0,0,0,3300,4543,0),(479,17,'Music Chain Game',3,1167253209,119,26,0,0,0,3301,4344,0),(480,17,'Movie Chain Game',3,1167253301,281,69,0,0,0,3302,4877,0),(481,15,'Waar kan je echt niet tegen?',3,1167253497,41,3,0,0,0,3303,4616,0),(482,15,'Hoelang zit jij al online?',3,1167253509,52,7,0,0,0,3304,4363,0),(483,15,'Hoelaat ging jij naar bed?',3,1167253540,89,20,0,0,0,3305,4403,0),(484,15,'Hoelaat werd jij vanochtend wakker?',3,1167253580,93,22,0,0,0,3306,4613,0),(485,15,'Wat staat er in je laatst ontvangen sms?',3,1167253622,43,5,0,0,0,3307,4615,0),(486,46,'1.20 What Is And What Should Never Be',2,1167256402,24,0,0,1,0,3319,3319,0),(487,37,'Dirt',2,1167258609,6,1,0,0,0,3333,3351,0),(488,4,'1.14 Mars vs. Mars',2,1167303426,32,0,0,1,0,3334,3334,0),(489,4,'1.15 Ruskie Business',2,1167304645,36,0,0,1,0,3336,3336,0),(490,4,'1.16 Betty And Veronica',2,1167305033,18,0,0,1,0,3340,3340,0),(491,3,'1.14 The Countdown',3,1167305999,22,1,0,1,0,3353,3361,0),(492,15,'Wat zit er in jouw Ctrl+V?',3,1167306168,69,12,0,0,0,3355,4858,0),(493,15,'Wat zijn jou voornemens?',3,1167306322,49,4,0,0,0,3356,3417,0),(494,4,'1.17 Kanes And Able\'s',2,1167308202,29,0,0,1,0,3358,3358,0),(495,4,'1.18 Weapons Of Class Destruction',2,1167320552,25,0,0,1,0,3387,3387,0),(496,4,'1.19 Hot Dogs',2,1167320822,23,0,0,1,0,3388,3388,0),(497,4,'1.20 M.A.D.',2,1167320993,37,0,0,1,0,3389,3389,0),(498,3,'1.15 	The Third Wheel',3,1167324349,31,0,0,1,0,3402,3402,0),(499,3,'1.16 The Links',3,1167324440,27,0,0,1,0,3403,3403,0),(500,46,'1.21 The Leaving Song',2,1167325607,21,0,0,1,0,3405,3405,0),(501,15,'Wat heb jij gegeten?',3,1167329459,51,7,0,0,0,3430,4410,0),(502,4,'1.21 A Trip To The Dentist',2,1167383327,24,0,0,1,0,3467,3467,0),(503,3,'1.23 The Nana',3,1167489065,19,0,0,1,0,3488,3488,0),(504,3,'1.24 The Proposal',3,1167496446,17,0,0,1,0,3500,3500,0),(505,3,'1.25 The Shower',3,1167496620,19,0,0,1,0,3502,3502,0),(506,1,'Extra hulp',39,1167502587,52,7,0,0,0,3504,4263,0),(507,3,'1.26 The Strip',3,1167511297,25,0,0,1,0,3589,3589,0),(508,17,'Welke film wordt er omschreven ?',14,1167567684,249,57,0,0,0,3655,4907,0),(509,46,'1.22 The Games That Play Us',2,1167655215,22,0,0,1,0,3678,3678,0),(510,46,'2.01 The Desperate Kingdom Of Love',2,1167655369,26,0,0,1,0,3679,3679,0),(511,46,'2.02 The Truth Doesn\'t Make A Noise',2,1167659468,19,0,0,1,0,3697,3697,0),(512,46,'2.03 Near Wild Heaven',2,1167663274,23,0,0,1,0,3701,3701,0),(513,46,'2.04 You Can\'t Always Get What You Want',2,1167666519,25,0,0,1,0,3703,3703,0),(514,46,'2.05 I Will Dare',2,1167731081,25,0,0,1,0,3757,3757,0),(515,46,'2.06 We Might As Well Be Strangers',2,1167740382,23,0,0,1,0,3764,3764,0),(516,3,'2.06 The Chrismukkah That Almost Wasn\'t',3,1167765281,36,1,0,1,0,3771,3774,0),(517,46,'2.07 Let The Reigns Go Loose',2,1167765356,18,0,0,1,0,3772,3772,0),(518,46,'2.08 Truth, Bitter Truth',2,1167771632,17,0,0,1,0,3779,3779,0),(519,46,'2.09 The Trick Is To Keep Breathing',2,1167816744,20,0,0,1,0,3787,3787,0),(520,46,'2.10 Don\'t Take Me For Granted',2,1167816800,21,0,0,1,0,3788,3788,0),(521,3,'2.10 The Accomplice',3,1167836542,15,0,0,1,0,3799,3799,0),(524,46,'2.11 The Heart Brings You Back',2,1167845580,24,0,0,1,0,3804,3804,0),(523,3,'2.12 	The Lonely Hearts Club',3,1167836669,14,0,0,1,0,3801,3801,0),(525,3,'2.13 The Test',3,1167845655,21,0,0,1,0,3806,3806,0),(526,46,'2.12 Between Order And Randomness',2,1167845729,20,0,0,1,0,3807,3807,0),(527,3,'2.17 The Brothers Grim',3,1167891469,28,0,0,1,0,3817,3817,0),(528,3,'2.18 The Risky Business',3,1167891815,18,0,0,1,0,3818,3818,0),(529,3,'2.19 The Rager',3,1167891888,23,0,0,1,0,3819,3819,0),(530,3,'2.20 The O.C. Confidential',3,1167891988,19,0,0,1,0,3820,3820,0),(531,1,'Top 10',39,1167913526,56,18,0,0,0,3847,4034,0),(532,46,'2.13 The Hero Dies In This One',2,1167914556,20,0,0,1,0,3855,3855,0),(533,46,'2.14 Quiet Things That No One Ever Knows',2,1167914778,23,0,0,1,0,3859,3859,0),(53 ,3,'2.21 The Return of the Nana',3,1167915087,24,0,0,1,0,3863,3863,0),(535,46,'2.15 Unopened Letters To The World',2,1167915124,26,0,0,1,0,3864,3864,0),(536,3,'2.22 The Showdown',3,1167918536,23,0,0,1,0,3900,3900,0),(537,99,'Afl. 1.04 Good day at white rock',39,1167919303,23,0,0,1,0,3902,3902,0),(538,99,'Afl. 1.07 Not a Drop to Drink',39,1167919654,26,0,0,1,0,3904,3904,0),(539,46,'2.16 Somewhere A Clock Is Ticking',2,1167920132,17,0,0,1,0,3906,3906,0),(540,3,'2.23 The O.Sea',3,1167922524,23,0,0,1,0,3909,3909,0),(541,3,'2.24 The Dearly Beloved',3,1167925889,33,4,0,1,0,3917,4085,0),(542,3,'3.01 The Aftermath',3,1167929758,40,1,0,1,0,3922,4427,0),(543,46,'2.17 Something I Can Never Have',2,1167935409,21,0,0,1,0,3932,3932,0),(544,46,'2.18 The Lonesome Road',2,1167935507,19,0,0,1,0,3933,3933,0),(545,3,'3.02 The Shape of Things to Come',3,1167936781,39,6,0,1,0,3937,4481,0),(546,46,'2.19 I\'m Wide Awake, It\'s Morning',2,1167941585,25,0,0,1,0,3940,3940,0),(547,3,'3.03 The End of Innocence',3,1167943476,32,1,0,1,0,3943,4531,0),(548,3,'3.04 The Last Waltz',3,1167946658,25,1,0,1,0,3944,4533,0),(549,46,'2.20 Lifetime Piling Up',2,1167947346,24,0,0,1,0,3945,3945,0),(550,46,'2.21 What Could Have Been',2,1167985943,21,0,0,1,0,3946,3946,0),(551,3,'Foutje',3,1168008082,50,8,0,0,0,3948,4090,0),(552,1,'spoilers',39,1168012336,29,7,0,0,0,3957,4010,0),(553,3,'4.10 The French Connection',3,1168014566,57,4,0,1,0,3969,4195,0),(554,78,'1.11 Swag',3,1168017532,17,0,0,1,0,3970,3970,0),(555,17,'Jou collectie',39,1168080791,45,5,0,0,0,3981,4229,0),(556,17,'Welke series keek je "vroeger"????',39,1168081089,44,3,0,0,0,3982,4353,0),(557,46,'2.22 The Tide That Left And Never Came Back, Part 1',2,1168109456,27,0,0,1,0,4006,4006,0),(558,46,'2.23 The Leavers Dance',2,1168109713,24,0,0,1,0,4007,4007,0),(559,46,'Het complete tweede seizoen',2,1168110032,31,0,0,1,0,4008,4008,0),(560,18,'3.01 Listen To The Rain On The Roof',2,1168115736,15,0,0,1,0,4020,4020,0),(561,43,'Wie is de Mol ?',14,1168193484,40,4,0,1,0,4057,4735,0),(562,30,'1.01 Pilot',2,1168269259,6,0,0,1,0,4080,4080,0),(563,30,'1.02 The One With The Sonogram At The End',2,1168269678,5,0,0,1,0,4081,4081,0),(564,30,'1.03 The One With The Thumb',2,1168269773,4,0,0,1,0,4082,4082,0),(565,1,'Series Die Klaar Zijn Voor 2007',2,1168275977,12,0,0,0,0,4088,4088,0),(566,98,'Afl. 1 - Wheel To The Stars - uitzend datum 07-01-2007',39,1168358449,38,4,0,1,0,4095,4174,0),(567,4,'2.02 Driver Ed',2,1168372271,18,0,0,1,0,4105,4105,0),(568,103,'1.01 Pilot',2,1168431648,34,1,0,1,0,4111,4113,0),(569,4,'2.03 Cheatty Cheatty Bang Bang',2,1168500033,25,0,0,1,0,4118,4118,0),(570,4,'2.04 Green-Eyed Monster',2,1168500278,19,0,0,1,0,4119,4119,0),(571,64,'1.01 Pilot',14,1168524687,14,1,0,1,0,4126,4133,0),(572,103,'1.02 Blogan',2,1168548639,22,0,0,1,0,4141,4141,0),(573,8,'Day 6: 7:00 AM - 8:00 AM',3,1168551616,33,1,0,1,0,4142,4264,0),(574,4,'2.05 Blast From The Past',2,1168605572,21,0,0,1,0,4153,4153,0),(575,4,'2.06 Rat Saw God',2,1168605771,23,0,0,1,0,4154,4154,0),(576,100,'Afl. 6.01 -  Lulu\'s Gone Away',39,1168608202,24,0,0,1,0,4156,4156,0),(577,38,'7.02 That\'s What You Get, Folks, For Makin\' Whoopee',2,1168609938,23,1,0,1,0,4157,4175,0),(578,32,'3.01 Four Dreams, Part 1',2,1168617186,17,0,0,1,0,4158,4158,0),(579,32,'3.02 Four Dreams, Part 2',2,1168617268,16,0,0,1,0,4159,4159,0),(580,8,'Day 6: 8:00 AM - 9:00 AM',3,1168626694,17,0,0,1,0,4162,4162,0),(581,4,'2.07 Nobody Puts Baby In A Corner',2,1168627834,22,0,0,1,0,4163,4163,0),(582,8,'Day 6: 9:00 AM - 10:00 AM',3,1168630695,14,0,0,1,0,4164,4164,0),(583,28,'3.12 Six Days (Part 2)',3,1168634034,31,2,0,1,0,4166,4342,0),(584,3,'4.11 The Dream Lover',3,1168634325,32,5,0,1,0,4167,4341,0),(585,16,'Nieuw Hier',159,1168764143,42,6,0,0,0,4196,4230,0),(586,15,'Werknemer crasht showmodel Spyker van bijna 3 ton',39,1168770485,21,2,0,0,0,4202,4205,0),(587,15,'irritanste tv-reclame???',39,1168770894,31,4,0,0,0,4206,4235,0),(588,15,'Luxemburgers willen af van \'Nederlandse\' vlag',39,1168770958,19,1,0,0,0,4207,4208,0),(589,4,'2.08 Ahoy, Mateys!',2,1168781344,21,0,0,1,0,4220,422 ,0),(590,17,'Episode Chain Game',2,1168800392,76,18,0,0,0,4246,4661,0),(591,7,'Het complete tweede seizoen',2,1168800517,8,1,0,0,0,4249,4253,0),(592,104,'1.01 The Wood Is In Danger',2,1168801449,18,0,0,1,0,4254,4254,0),(593,98,'Afl. 2 - Manifest Destiny - uitzend datum 14-01-2007',39,1168885976,48,4,0,1,0,4273,4281,0),(594,1,'pageranks',39,1168963589,67,17,0,0,0,4282,4765,0),(595,38,'7.03 Lorelai\'s First Cotillion',2,1169027491,16,0,0,1,0,4293,4293,0),(596,7,'2.01 Passover',2,1169040423,15,1,0,1,0,4294,4319,0),(597,46,'4.11 Everything In Its Right Place',3,1169122861,39,3,0,1,0,4300,4404,0),(598,46,'4.12 Resolve',3,1169203962,74,14,0,1,0,4320,4708,0),(599,3,'4.12 The Groundhog Day',3,1169207331,49,7,0,1,0,4325,4673,0),(600,3,'4.13 The Case Of The Franks',3,1169207382,54,9,0,1,0,4326,4841,0),(601,5,'Prison Break Seizoen 1 Algemeen',39,1169213737,26,0,0,1,0,4331,4331,0),(602,51,'A-team algemeen',39,1169214129,22,1,1,1,0,4332,4333,0),(603,51,'A-Team Seizoen 1 algemeen',39,1169214363,18,0,0,1,1,4334,4334,0),(604,4,'2.10 One Angry Veronica',2,1169223405,18,0,0,1,0,4339,4339,0),(605,5,'2.14 John Doe',14,1169321107,82,8,0,1,0,4383,4547,0),(606,18,'3.03 A Weekend In The Country',2,1169324533,10,0,0,1,0,4393,4393,0),(607,78,'1.01 Pilot',2,1169374363,15,0,0,1,0,4405,4405,0),(608,78,'1.12 Sofia\'s Choice',3,1169384930,12,0,0,1,0,4415,4415,0),(609,78,'1.13  In or Out',3,1169385043,10,0,0,1,0,4416,4416,0),(610,4,'2.12 Rashard And Wallace Go To White Castle',2,1169391554,20,0,0,1,0,4422,4422,0),(611,4,'2.13 Ain\'t No Magic Mountain High Enough',2,1169391664,19,0,0,1,0,4423,4423,0),(612,4,'2.14 Versatile Toppings',2,1169391860,10,0,0,1,0,4424,4424,0),(613,78,'1.02 The Box And The Bunny',2,1169414649,16,0,0,1,0,4471,4471,0),(614,107,'Seizoen 1',14,1169418949,27,4,0,1,0,4473,4545,0),(615,108,'1.01 Pilot',3,1169477172,16,0,0,1,0,4480,4480,0),(616,98,'Afl. 3 - Dreams & Schemes - Uitzend datum 21-01-2007',39,1169480102,21,0,0,1,0,4484,4484,0),(617,108,'1.02  It\'s Got to Be the Morning After',3,1169480228,12,0,0,1,0,4485,4485,0),(618,108,'1.03 Let Go, Let Golf',3,1169482022,9,0,0,1,0,4486,4486,0),(619,15,'Roepen \'*beep* you\' naar politie geen belediging',39,1169482417,17,1,0,0,0,4487,4488,0),(620,62,'1.10 Light The Lights',2,1169483100,11,0,0,1,0,4489,4489,0),(621,18,'3.13 Come Play Wiz Me',3,1169489944,9,0,0,1,0,4503,4503,0),(622,1,'opgesplitst vanaf onderwerp afleveringen',2,1169499123,8,9,0,0,0,4497,4512,0),(623,110,'Afl. 3.04 - The Guardian',39,1169560179,19,0,0,1,0,4523,4523,0),(624,5,'2.15 The Message',2,1169587058,43,4,0,1,0,4532,4724,0),(625,38,'7.11 Santa\'s Secret Stuff',14,1169645042,5,0,0,1,0,4544,4544,0),(626,8,'Day 6: 10:00 AM - 11:00 AM',3,1169655833,17,0,0,1,0,4548,4548,0),(627,4,'3.10 Show Me The Monkey',2,1169709930,15,1,0,1,0,4556,4564,0),(628,46,'4.13 Pictures of You',3,1169739757,42,8,0,1,0,4560,4922,0),(629,50,'1.13 The Fix',3,1169740078,16,2,0,1,0,4561,4716,0),(630,112,'Afl. 1.01 - First Responders',39,1169824549,49,12,0,1,0,4577,4627,0),(631,38,'7.04 \'S Wonderful, \'S Marvelous',2,1169832916,5,0,0,1,0,4585,4585,0),(632,51,'herhalingen A-team RTL',39,1169842820,23,5,0,0,1,4598,4769,0),(633,108,'1.04 Stuck in Amber',3,1169905049,9,0,0,1,0,4633,4633,0),(634,69,'Afl. 4.21 - Forever',39,1169978161,11,0,0,1,0,4646,4646,0),(635,28,'3.13 Great Expectations',14,1169993995,23,1,0,1,0,4655,4671,0),(636,2,'Nieuwe TVgids, reacties HIER!',39,1170010487,31,4,0,1,2,4664,4691,0),(637,1,'Meer informatie',2,1170011931,67,25,0,0,0,4667,4784,0),(638,98,'Afl. 4 - Hell on Wheels - Uitzend datum 28-01-2007',39,1170090150,19,0,0,1,0,4707,4707,0),(639,50,'1.14 Distractions',3,1170176224,19,2,0,1,0,4717,4852,0),(640,5,'2.16 Chicago',3,1170176314,47,6,0,1,0,4718,4887,0),(641,46,'Music From One Tree Hill',2,1170241061,9,0,0,0,0,4725,4725,0),(642,4,'3.11 Poughkeepsie, Tramps & Thieves',2,1170266870,11,1,0,1,0,4727,4773,0),(643,28,'3.14 Wishin\' and Hopin',3,1170268623,23,3,0,1,0,4728,4763,0),(644,38,'7.12 To whom it may concern',14,1170336094,12,0,0,1,0,4731,4731,0),(645,3,'4.14 The Shake-Up',3,1170428320,33,4,0,1,0,4757,4932,0),(64628,'3.15 Walk on Water (Part 1)',3,1170428574,15,2,0,1,0,4758,4912,0),(647,4,'3.12 There\'s Got to Be a Morning After Pill',3,1170428726,14,1,0,1,0,4759,4895,0),(648,108,'1.05 Denial for a While',3,1170444206,4,0,0,1,0,4766,4766,0),(649,112,'Afl. 1.02 - Stress',39,1170446148,8,0,0,1,0,4767,4767,0),(650,113,'Afl. 2.01 - In naam der liefde',39,1170446846,9,0,0,1,0,4768,4768,0),(651,56,'1.01 Pilot',2,1170530942,9,0,0,1,0,4780,4780,0),(652,17,'Uit welke serie komt dit citaat?',39,1170603398,52,14,0,0,0,4802,4941,0),(653,1,'POLL',39,1170610872,10,3,0,0,0,4803,4822,0),(654,98,'Afl. 5 - Casualties of War - Uitzend datum 04-02-2007',39,1170616420,20,1,0,1,0,4818,4820,0),(655,50,'1.15 Run',3,1170791183,13,0,0,1,0,4853,4853,0),(656,5,'2.17 Bad Blood',14,1170832723,12,1,0,1,0,4860,4888,0),(657,46,'3.01 Like You Like An Arsonist',2,1170852127,5,0,0,1,0,4869,4869,0),(658,46,'3.02 From The Edge Of The Deep Green Sea',2,1170855060,7,0,0,1,0,4870,4870,0),(659,38,'7.13 I\'d rather be in Philadelphia',14,1170857424,4,0,0,1,0,4871,4871,0),(660,46,'3.03 First Day On A Brand New Planet',2,1170858036,7,0,0,1,0,4874,4874,0),(661,46,'3.04 An Attempt To Tip The Scales',2,1170861955,4,0,0,1,0,4880,4880,0),(662,46,'3.05 A Mulititude Of Casualties',2,1170865659,6,0,0,1,0,4885,4885,0),(663,8,'Day 6: 11:00 AM - 12:00 PM',3,1170883495,4,0,0,1,0,4889,4889,0),(664,8,'Day 6: 12:00 PM - 01:00 PM',3,1170883615,4,0,0,1,0,4890,4890,0),(665,46,'4.14 Sad Songs for Dirty Lovers',3,1170957932,10,1,0,1,0,4892,4899,0),(666,113,'Afl. 3.02 - Huurmoord',39,1170959163,8,0,0,1,0,4893,4893,0),(667,4,'3.13 Postgame Mortem',3,1170964230,9,3,0,1,0,4896,4950,0),(668,3,'4.15 The Night Moves',3,1171042015,13,3,0,1,0,4908,4934,0),(669,3,'4.16 The End\'s Not Near, It\'s Here',3,1171042205,2,0,0,1,0,4910,4910,0),(670,28,'3.16 Drowning on Dry Land (Part 2)',3,1171051724,4,0,0,1,0,4913,4913,0),(671,113,'Afl. 3.03 - Het offer',39,1171053194,7,0,0,1,0,4914,4914,0),(672,113,'Afl. 3.04 - De Terugkeer',39,1171053521,7,0,0,1,0,4915,4915,0),(673,46,'3.16 With Tired Eyes, Tired Minds, Tired Souls, We Slept',2,1171054248,10,0,0,1,0,4917,4917,0),(674,112,'Afl. 1.03 - 200th Hour',39,1171101546,9,0,0,1,0,4929,4929,0),(676,47,'Afl. 10.3 - De moord op',39,1171146589,12,0,0,1,0,4937,4937,0);

Ik weet, het is een grote, maar zowel bij import als bigdump krijg ik deze fout. Iemand die weet wat er mis is met de query?

Bericht door **Paul** » 25 feb 2007, 13:19

Geen idee. En ikzelf heb persoonlijk weinig zin om die query met de hand te gaan controleren. Iemand anders mischien?
en anders zul je hem moeten opslitsen in meerdere querys.

tvaddict17 · Bericht door **tvaddict17** » 25 feb 2007, 13:32

Gedaan, heb de query ook al nagekeken e.d., hij gaf eerder namelijk alle fouten aan die er in zaten en die heb ik verbeterd.