Tasks

[edit] Web site migration

[edit] Upgrade AFJ Wiki to 1.10

• Export database: contents only
• Upload unzipped SQL with BigDump.
  1. Processing file: afjwikidb.sql Starting from line: 8001: Error at the line 8797: INSERT INTO `interwiki` VALUES ('abbenormal', 'http://www.ourpla.net/cgi-bin/pikie.cgi?$1', 0, 0); Query: INSERT INTO `interwiki` VALUES ('abbenormal', 'http://www.ourpla.net/cgi-bin/pikie.cgi?$1', 0, 0); MySQL: Duplicate entry 'abbenormal' for key 1
     • Shouldn't import interwiki table since AFJ didn't use it. Re-export but don't export interwiki, ipblocks, ipblocks_old,objectcache,querycache,querycachetwo,querycache_info,transcache
  2. Processing file: afjwikidb.sql Starting from line: 11001: Error at the line 11398: INSERT INTO `page` VALUES (1, 0, 0x4d61696e5f50616765, , 1317, 0, 0, 0.525039469122, 0x3230303730353039303032343230, 4849, 29); Query: INSERT INTO `page` VALUES (1, 0, 0x4d61696e5f50616765, , 1317, 0, 0, 0.525039469122, 0x3230303730353039303032343230, 4849, 29); MySQL: Duplicate entry '1' for key 1
     • Try using an UPDATE query instead of INSERT - no
  3. Use an INSERT query. Drop cache tables. Create new database, clear all tables, use bigdump with small chunks (500 lines).
     • Error at the line 24549: INSERT INTO `user` VALUES (1, 0x57696b6941646d696e, , 0x3265343237616439653239653762363836643162363932383431653233366632, , , (snippage) 34386564336166, NULL, NULL, NULL, NULL, NULL, 91); MySQL: Column 'user_token' cannot be null

Table	Records	Size
archive	74	32.0 KiB
categorylinks	2,093	400.0 KiB
externallinks	4,557	2.9 MiB
filearchive	0	80.0 KiB
hitcounter	0	0 B
image	573	288.0 KiB
imagelinks	1,466	160.0 KiB
interwiki	177	64.0 KiB
ipblocks	0	96.0 KiB
job	0	32.0 KiB
langlinks	0	32.0 KiB
logging	2,448	1.0 MiB
math	0	16.0 KiB
objectcache	0	32.0 KiB
oldimage	120	96.0 KiB
page	943	256.0 KiB
pagelinks	1,140	144.0 KiB
page_restrictions	0	96.0 KiB
querycache	0	32.0 KiB
querycachetwo	0	64.0 KiB
querycache_info	0	16.0 KiB
recentchanges	1,671	1.0 MiB
redirect	28	32.0 KiB
revision	1,848	832.0 KiB
searchindex	1,195	5.4 MiB
site_stats	1	16.0 KiB
templatelinks	1,277	144.0 KiB
text	24,739	41.5 MiB
trackbacks	0	32.0 KiB
transcache	0	16.0 KiB
user	0	48.0 KiB
user_groups	0	32.0 KiB
user_newtalk	0	48.0 KiB
watchlist	0	32.0 KiB
34 table(s)	44,350	55.0 MiB

[edit] Remaining exoware.com pages

1. sitemap.htm
2. about\QuickLinks.htm
3. about\Traffic.htm
4. TechNotes\MediaWikiExtensionParserDebug.htm
5. TechNotes\MediaWikiPrettyPrinter.htm
6. TechNotes\MediaWikiSideTrips.htm
7. TechNotes\MediaWikiTranscriptExtension.htm
8. TechNotes\MediaWikiTranscripts.htm
9. TechNotes\MediaWikiXmlExtension.htm
10. TechNotes\SaturnsMoons.htm
11. TechNotes\Apollo17\index.htm
12. Apollo17\AS17-35mm.htm
13. Apollo17\AS17-CMP-Transcripts.htm
14. Apollo17\AS17-Fruitcake.htm
15. Apollo17\BlueMarbleCatalogNN.htm
16. Apollo17\BlueMarbleGeometry.htm
17. Apollo17\BlueMarbleOverview.htm
18. Apollo17\BlueMarblePhotography.htm
19. Apollo17\BlueMarblePhotography_Cameras.htm
20. Apollo17\BlueMarblePhotoTimeline.htm
21. Apollo17\BlueMarbleTimeline.htm
22. Apollo17\index.htm
23. Apollo17\MissionTranscriptCollection.htm
24. Apollo17\alsj\Apollo17MissionReport.htm
25. Apollo17\alsj\Apollo17TechDebrief.htm
26. Apollo17\alsj\images17MagSS.htm
27. Apollo17\alsj\images17MagTT.htm
28. Apollo17\alsj\images17MagVV.htm
29. Apollo17\ap17fj\AP17FJ.htm
30. Apollo17\ap17fj\AP17updates.htm
31. Apollo17\ap17fj\AS17Anomalies.htm
32. Apollo17\ap17fj\AS17Flight_01Launch.htm
33. Apollo17\ap17fj\AS17Flight_02EarthOrbit.htm
34. Apollo17\ap17fj\AS17Flight_03TLI.htm
35. Apollo17\ap17fj\AS17Flight_Footnotes.htm

[edit] Migrated pages

1. about\index.htm
2. Exoware\Tech\DirectCommunicationWithHTMLView.htm
3. Exoware\Tech\EnhancedFlatComboControl.htm
4. Exoware\Tech\ImplementingADOPlanDatabase.htm
5. Exoware\Tech\IssuingCommandsToTheHTMLView.htm
6. Exoware\Tech\SettingHTMLViewTextDirectlyFromString.htm
7. Exoware\Tech\UsingCodeGuruHTMLViewAutomationClasses.htm
8. Exoware\Tech\UsingComboBoxControl.htm
9. Exoware\Tech\UsingHTMLViewAutomationClasses.htm
10. TechNotes\ASTranscriptHtmlCss.htm
11. TechNotes\ASTranscriptXML.htm
12. TechNotes\ASTranscriptXSL.htm
13. TechNotes\CommunityServerTabBar.htm
14. TechNotes\ConvergenceInAcademicJargon.htm
15. TechNotes\FpCsMwWebPortal.htm
16. TechNotes\FrontPageWithCommunityServer.htm
17. TechNotes\FrontPageWithMediaWiki.htm
18. TechNotes\KioskModeSLAXBootCD.htm
19. TechNotes\KioskModeSLAXBootCDv1.htm
20. TechNotes\LegendaryPacifistsGuideToHalo2.htm
21. TechNotes\MediaWikiOnASPnix.htm
22. TechNotes\MediaWikiOnAStick.htm
23. TechNotes\MediaWikiOnGoDaddy.htm
24. TechNotes\OnErrorResumeNext.htm
25. TechNotes\PatchItUntilItsRobust.htm
26. TechNotes\SeattleDos.htm
27. TechNotes\WindowsXPRestore.htm

[edit] Subsites

1. Exoware\About.htm
2. Exoware\index.htm
3. Exoware\Tech.htm
4. StyxPyx\index.htm
5. calendars\cafepress\Description - Main.htm
6. calendars\cafepress\Description - Mars (double).htm
7. calendars\cafepress\Description - Mars (small).htm
8. calendars\cafepress\Description - Mugs.htm
9. calendars\cafepress\Description - Robots (small).htm
10. calendars\cafepress\Description - Saturn (double).htm
11. calendars\cafepress\Description - Saturn (small).htm
12. calendars\cafepress\Footer.htm
13. calendars\cafepress\Header.htm
14. calendars\cafepress\_CafePress_old.htm
15. calendars\cafepress\_index_Old.htm

[edit] Archive

1. BlogArchive\index.htm
2. BlogArchive\About\default.html
3. BlogArchive\categories\deals\deals.html
4. BlogArchive\categories\Detour\Detour.html
5. BlogArchive\categories\essays\essays.html
6. BlogArchive\categories\infodip\infodip.html
7. BlogArchive\categories\infoscraper\infoscraper.html
8. BlogArchive\categories\infoscraper\infoscraper_old.html
9. BlogArchive\categories\kidstuff\kidstuff.html
10. BlogArchive\categories\newsstream\news200503.html
11. BlogArchive\categories\newsstream\news200504.html
12. BlogArchive\categories\newsstream\news200504b.html
13. BlogArchive\categories\newsstream\news200505.html
14. BlogArchive\categories\ping\ping.html
15. BlogArchive\categories\tipsAndTricks\tipsAndTricks.html
16. BlogArchive\categories\tools\tools.html
17. BlogArchive\myImages\2005\119723-2304p028-1b.jpg¨folderView=1.html
18. BlogArchive\myImages\2005\2005-0408dwarf-full.jpg¨folderView=1.html
19. BlogArchive\myImages\2005\HideShow.html
20. BlogArchive\stories\2005\03\27\theLegendaryPacifistsGuideToHalo2.html
21. BlogArchive\stories\2005\04\03\saturnsMoonsCassiniImages.html
22. BlogArchive\stories\2005\04\14\opportunitySurfsTheDunes.html

[edit] LM S/CAT

1. LM\index.htm
2. LM\SCATAction.htm
3. LM\SCATCloseLook.htm
4. LM\SCATHistory.htm
5. LM\SCATKellyInterview.htm
6. LM\SCATManufacturing.htm
7. LM\SCATMissions.htm
8. LM\SCATOrganization.htm
9. LM\SCATPhotos.htm
10. LM\SCATPictures.htm
11. LM\SCATSite.htm
12. LM\SCATSystems.htm
13. LM\SCATTest.htm
14. LM\pullo (Original site mirror: 91 pages)

1. LM\pullo\CLOSE_L.HTM
2. LM\pullo\C_L_0.HTM
3. LM\pullo\C_L_0A.HTM
4. LM\pullo\C_L_1.HTM
5. LM\pullo\C_L_11A.HTM
6. LM\pullo\C_L_11B.HTM
7. LM\pullo\C_L_1214.HTM
8. LM\pullo\C_L_124A.HTM
9. LM\pullo\C_L_16A.HTM
10. LM\pullo\C_L_16B.HTM
11. LM\pullo\C_L_1A.HTM
12. LM\pullo\C_L_2.HTM
13. LM\pullo\C_L_2A.HTM
14. LM\pullo\C_L_34.HTM
15. LM\pullo\C_L_5A.HTM
16. LM\pullo\C_L_5B.HTM
17. LM\pullo\C_L_6.HTM
18. LM\pullo\C_L_8A.HTM
19. LM\pullo\C_L_8B.HTM
20. LM\pullo\C_R.HTM
21. LM\pullo\F_L.HTM
22. LM\pullo\f_man0.HTM
23. LM\pullo\F_MAN1.HTM
24. LM\pullo\F_MAN2.HTM
25. LM\pullo\f_man3.htm
26. LM\pullo\f_man4.htm
27. LM\pullo\f_man5.htm
28. LM\pullo\f_man6.htm
29. LM\pullo\f_man7.htm
30. LM\pullo\f_man8.htm
31. LM\pullo\f_man9.htm
32. LM\pullo\F_R.HTM
33. LM\pullo\F_R10.HTM
34. LM\pullo\F_R11.HTM
35. LM\pullo\F_R12.HTM
36. LM\pullo\F_R13.HTM
37. LM\pullo\F_R2A.HTM
38. LM\pullo\F_R2B.HTM
39. LM\pullo\F_R3.HTM
40. LM\pullo\F_R4A.HTM
41. LM\pullo\F_R4B.HTM
42. LM\pullo\F_R5A.HTM
43. LM\pullo\F_R5B.HTM
44. LM\pullo\F_R5C.HTM
45. LM\pullo\F_R6.HTM
46. LM\pullo\F_R7A.HTM
47. LM\pullo\F_R7B.HTM
48. LM\pullo\F_R8.HTM
49. LM\pullo\F_R9.HTM
50. LM\pullo\index.htm
51. LM\pullo\KELLY.HTM
52. LM\pullo\LMMANFC1.HTM
53. LM\pullo\lm_ana1.htm
54. LM\pullo\lm_mis1.htm
55. LM\pullo\lm_patch.htm
56. LM\pullo\MANUF.HTM
57. LM\pullo\man_tex1.HTM
58. LM\pullo\ORG.HTM
59. LM\pullo\pnews1.htm
60. LM\pullo\SCAT_6B.HTM
61. LM\pullo\slide2.htm
62. LM\pullo\SUPP.HTM
63. LM\pullo\s_1.htm
64. LM\pullo\s_10.htm
65. LM\pullo\s_11.htm
66. LM\pullo\s_12.htm
67. LM\pullo\s_13.htm
68. LM\pullo\s_14.htm
69. LM\pullo\s_15.htm
70. LM\pullo\s_16.htm
71. LM\pullo\s_17.htm
72. LM\pullo\s_2.htm
73. LM\pullo\s_3.htm
74. LM\pullo\s_4.htm
75. LM\pullo\s_5.htm
76. LM\pullo\s_6.htm
77. LM\pullo\s_7.htm
78. LM\pullo\s_8.htm
79. LM\pullo\s_9.htm
80. LM\pullo\TEST.HTM
81. LM\pullo\TWOCOL.HTM
82. LM\pullo\t_7_69.htm
83. LM\pullo\t_ace1.htm
84. LM\pullo\t_clean.htm
85. LM\pullo\t_c_w.htm
86. LM\pullo\t_ecs.htm
87. LM\pullo\t_in.htm
88. LM\pullo\t_ocp.htm
89. LM\pullo\t_out.htm
90. LM\pullo\t_plt25.htm
91. LM\pullo\t_work.htm