This is a parent page to discuss or flag any issues with the migration from Google Sites Classic to this new site.
Permissions
On 29 November 2021, the active players were upgraded to the Editor roles. This was the easiest way to enable comment editing given Word Press’ existing permissions structure.
Known Issues
Content
- The text in some posts and pages changes size at random.
- I’ve fixed a lot of these but feel free to flag any specific pages you spot in the comments below this page
- Specifics:
- Search and replace for the following in the HTML styles via SQL Update – font-size: 10pt;
- Search and replace for the following in the HTML styles via SQL Update – <span style=”font-size: 13.3333px;”>
- Spacing is weird on some pages
- Yes, yes it is…
- Some content not transferred
- There was a specific issue related to posts larger than 32 kBytes in size that had to be moved manually, but I think I have them all.
- However, if you come across a page with a picture of Engineer Erin (below), please note it
- Also if you come across a blank page
- Specifics:
- There are two posts marked A-211, A-211 note comment dependency below.
- This looks to be one of two cases of the old Module Parent pages being uploaded with duplicate content of one of their child posts. See also Module 5/E-002 below – Delete duplicate [DONE]
- The other Module Parents have been repurposed to be children under the Play Summary page. Note the name differences:
- Healthy Play Summary child: …/play/play_module-03-the-argyle-notebook/
- Mod 5 Play Summary child: …/play/module-05-lying-in-the-grras/
- Mod 5 Old Duplicate: …/play_module-05-lying-in-the-grras/ – Delete [DONE]
- A-074 has the same content (and comment) as A-073 [DONE]
- C-177 has the same content (and comment) as C-178, though the post titles are different.
- Replace content of C-178 [DONE]
- Replace comment content of C-178 [DONE]
- C-215 has the same content as C-214 – replace post data [DONE]
- Updated comment [DONE]
- There are two posts marked A-211, A-211 note comment dependency below.
- There was a specific issue related to posts larger than 32 kBytes in size that had to be moved manually, but I think I have them all.
- Posts not displaying or missing
- Missing post 3-187/duplicate 3-186 – replace & fix comments [DONE]
- Missing post 5-074/duplicate 5-073 – replace & fix comments [DONE]
- Missing post 7-033/duplicate 7-032 – replace & fix comments [DONE]
- Missing post 7-090/duplicate 7-089 – replace & fix comments [DONE]
- Missing post 8-437/duplicate 8-436 – replace & fix comments [DONE]
- Missing post 9-328/duplicate 9-327 – replace & fix comments [DONE]
- Missing post 9-329/duplicate 9-328 – replace & fix comments [DONE]
- Missing post 9-330/duplicate 9-329 – replace & fix comments [DONE]
- Missing post 9-331/duplicate 9-330 – replace & fix comments [DONE]
- Missing post 9-346/duplicate 9-345 – replace & fix comments [DONE]
- Missing post A-121/duplicate A-120 – replace & fix comments [DONE]
- Missing post A-259/duplicate A-258 – replace & fix comments [DONE]
- Missing post A-421/duplicate A-420 – replace & fix comments [DONE]
- Missing post A-525/duplicate A-524 – replace & fix comments [DONE]
- Missing post B-024/duplicate B-023 – replace & fix comments [DONE]
- Missing post B-068/duplicate B-067 – replace & fix comments [DONE]
- Missing post B-087/duplicate B-086 – replace & fix comments [DONE]
- Missing post B-338/duplicate B-337 – replace & fix comments [DONE]
- Missing post B-393/duplicate B-392 – replace & fix comments [DONE] NB: This was not showing? [DONE]
- Missing post B-573/duplicate B-572 – replace & fix comments [DONE]
- Missing post C-169/duplicate C-168 – replace & fix comments [DONE]
- Missing post E-242/duplicate E-241-Lia – replace & fix comments [DONE]
- Missing post E-374/duplicate E-373-Lia – replace & fix comments [DONE]
- Missing post E-432/duplicate E-431-Lia – replace & fix comments [DONE]
- Missing post E-433/duplicate E-434-Lia – replace & fix comments [DONE]
- Missing post F-22/duplicate F-23-Oliver – replace & fix comments [DONE]
- 3-004 missing [DONE]
- Added 6 Comments [DONE]
- Posts out of number sequence (not detected at create time)
- Renumber 7-306a [DONE]
- Renumber 7-306b [DONE]
- Renumber 7-306c [DONE]
- Renumber 7-307 [DONE]
- Renumber B-101a [DONE]
- Renumber B-101b [DONE]
- Renumber B-560a [DONE]
- Renumber B-560b [DONE]
- Renumber C-057a [DONE]
- Renumber C-057b [DONE]
- Skipped numbers
- E-124-Lia – Skipped Post added [DONE]
- B-193: Skipped Post added [DONE]
- B-432: Skipped Post added [DONE]
- Comments not attached to correct post added [DONE]
- There were a few of these due to a specific error in the migration, hopefully I got them all, but perhaps not (update – I didn’t)
- Specifics:
- B-147 [DONE]
- 9-018 has B-477’s comment (9-018 is a post without comments) – move comment [DONE]
- B-477 has B-099‘s comment (B-099 is OK) – delete comment [DONE]
- 9-019 has B-503’s comment (9-019 is a post without comments) – move comment [DONE]
- B-503 has B-111’s comment – move comment [DONE]
- B-111 has both comments from 6-067 (6-067 is OK) – Delete comments [DONE]
- 6-065 has F-013-Lia‘s comment, but the original 6-065 is a post without comments – move comment to F-013-Lia [DONE]
- F-013-Lia has A-646’s comment – move comment to A-646 [DONE]
- A-646 has 5-159‘s comment (5-159 is OK) – delete comment [DONE]
- F-004-Oliver has B-196 ‘s comment – move comment to B-196 [DONE]
- F-004-Oliver ‘s comment is not in the DB – re-create comment [DONE]
- B-196 has 8-041‘s comment (8-041 is OK) – delete comment [DONE]
- The duplicate A-211 post (which post name indicates is the former Module 10 parent page) has the comment for B-211 – move comment [DONE]
- B-211 has 8-100‘s comment (8-100 is OK) – delete comment [DONE]
- The former Module 5 parent page has the last 4 comments that belong to E-002 – move comments [DONE]
- E-002 remaining 10 of 14 comments were not located in the site DB – re-create comments [DONE]
- E-002 has 8-212‘s comment (8-212 is OK) – delete comment [DONE]
- A-074 has the same content (and comment) as A-073. [DONE]
- Again, feel free to flag any others in comments to this post
- Large comments could not be transferred automatically and were manually transferred.
- Except for Oliver’s comment on E-001 – add comment [DONE]
- Missing Comments – there is an issue related to more than 5 comments per post not being transferred, this affects the following (note sequence bug not fixed):
- E-201
- Comment #5 updated with correct content [DONE]
- 7 Comments posted for Lia and Oliver by Overlord Frank – 2022-10-07 [DONE]
- 11 Comments posted for Lia and Oliver by Overlord Frank – 2022-10-08 [DONE]
- Re-assign comments to correct author and fix sequence [DONE]
- E-204
- Comment #5 updated with correct content [DONE]
- 3 Comments for Lia and Oliver by Overlord Frank – 2020-10-10 [DONE]
- 2 Comments for Lia and Oliver by Overlord Frank – 2020-10-09 [DONE]
- Re-assign comments to correct author and fix sequence[DONE]
- E-207
- Comment #5 updated with correct content [DONE]
- 3 Comments for Lia and Oliver by Overlord Frank – 2020-10-10 [DONE]
- Re-assign comments to correct author and fix sequence [DONE]
- E-221
- Comment #5 updated with correct content [DONE]
- Re-assign comments to correct author and fix sequence [DONE]
- E-224
- Comment #5 updated with correct content [DONE]
- 3 Comments for Lia and Oliver by Overlord Frank – 2020-10-22 [DONE]
- 1 Comment for Lia by Overlord Frank – 2020-10-21 [DONE]
- Re-assign comments to correct author and fix sequence [DONE]
- E-225
- Comment #5 updated with correct content [DONE]
- 1 Comments for Oliver by Overlord Frank – 2020-10-26 [DONE]
- 1 Comment for Lia by Overlord Frank – 2020-10-24 [DONE]
- Re-assign comments to correct author and fix sequence [DONE]
- E-228
- Comment #5 updated with correct content [DONE]
- 3 Comments for Lia, Oliver and Overlord Frank by Overlord Frank – 2020-10-31 [DONE]
- 18 Comments for Lia and Oliver by Overlord Frank – 2020-10-30 [DONE]
- Re-assign comments to correct author and fix sequence [DONE]
- E-229
- Comment #5 updated with correct content [DONE]
- 1 Comment for Lia by Overlord Frank – 2020-11-02 [DONE]
- Re-assign comments to correct author and fix sequence [DONE]
- E-321
- Comment #5 needs updating with correct content – 2021-11-17 07:48 [DONE]
- 7 Comments for Lia, Oliver and Overlord Frank 2021-01-16 [DONE]
- Re-assign comments to correct author and fix sequence [DONE]
- 3-003
- 1 Comment each for Oliver and Chris [DONE]
- NB: Inserted directly to DB
- E-210
- 8 Comments for Oliver
- 9 Comments for Lia [DONE]
- NB: Inserted directly to DB
- E-201
- Comments out of order
- Multiple comments per page are sometimes shown in incorrect order, this seems to be caused by a combination of Google Sites truncating the date, and at some point, comments were listed in newest-first rather than oldest-first order
- Times seem to be present after 18 October 2020 (post E-222)
- All instances of multiple comments on posts up to post E-222 were re-ordered within their day. Post time was set to 1 minute past midnight for the first post, 2 minutes past midnight for the second post, and so on. Internally, the post time at gmt, which is used for comment ordering was set to 14:00 of the prior day plus 1 minute per post as above.
- In conjunction with the previous repair to missing comments, times were also adjusted to sequence those comments correctly. (Note that where this occurred, those comments may be excluded from the following list.)
- This was done for the following comments:
- 3-001 comment ID 4812 set to 2017-04-19 00:03
- 3-001 comment ID 4841 set to 2017-04-19 00:02
- 3-001 comment ID 4860 set to 2017-04-19 00:01
- 3-002 comment ID 8 set to 2017-04-21 00:02
- 3-002 comment ID 4669 set to 2017-04-21 00:01
- 3-003 comment ID 11 set to 2017-04-24 00:03
- 3-003 comment ID 4670 set to 2017-04-24 00:02
- 3-003 comment ID 4861 set to 2017-04-24 00:01
- 3-004 comment ID 6401 set to 2017-04-25 00:05
- 3-004 comment ID 6400 set to 2017-04-25 00:04
- 3-004 comment ID 6397 set to 2017-04-25 00:03
- 3-004 comment ID 6399 set to 2017-04-25 00:02
- 3-004 comment ID 6398 set to 2017-04-25 00:01
- 3-005 comment ID 4672 set to 2017-05-01 00:03
- 3-005 comment ID 4815 set to 2017-05-01 00:02
- 3-005 comment ID 4843 set to 2017-05-01 00:01
- 3-006 comment ID 15 set to 2017-05-07 00:02
- 3-006 comment ID 4673 set to 2017-05-07 00:01
- 3-131 comment ID 144 set to 2017-10-26 00:04
- 3-131 comment ID 4676 set to 2017-10-26 00:03
- 3-132 comment ID 146 set to 2017-10-26 00:02
- 3-132 comment ID 4878 set to 2017-10-26 00:01
- 3-219 comment ID 231 set to 2017-11-17 00:02
- 3-219 comment ID 4677 set to 2017-11-17 00:01
- 3-243 comment ID 255 set to 2017-11-28 00:02
- 3-243 comment ID 4678 set to 2017-11-28 00:01
- 4-038 comment ID 299 set to 2018-02-02 00:02
- 4-038 comment ID 4680 set to 2018-02-02 00:01
- 4-039 comment ID 300 set to 2018-02-04 00:02
- 4-039 comment ID 4681 set to 2018-02-04 00:01
- 4-098 comment ID 359 set to 2018-05-29 00:02
- 4-098 comment ID 4682 set to 2018-05-29 00:01
- 5-123 comment ID 664 set to 2018-11-03 00:02
- 5-123 comment ID 4685 set to 2018-11-03 00:01
- 5-165 comment ID 769 set to 2019-02-03 00:02
- 5-165 comment ID 4686 set to 2019-02-03 00:01
- 5-169 comment ID 783 set to 2019-02-04 00:02
- 5-169 comment ID 4687 set to 2019-02-04 00:01
- 6-064 comment ID 494 set to 2018-08-28 00:02
- 6-064 comment ID 4688 set to 2018-08-28 00:01
- 6-067 comment ID 500 set to 2018-09-07 00:02
- 6-067 comment ID 4689 set to 2018-09-07 00:01
- 6-239 comment ID 807 set to 2019-02-10 00:02
- 6-239 comment ID 4691 set to 2019-02-10 00:01
- 7-092 comment ID 1137 set to 2019-05-05 00:02
- 7-092 comment ID 4877 set to 2019-05-05 00:01
- 7-115 comment ID 1189 set to 2019-05-31 00:02
- 7-115 comment ID 4692 set to 2019-05-31 00:01
- 7-183 comment ID 1400 set to 2019-08-04 00:02
- 7-183 comment ID 4693 set to 2019-08-04 00:01
- 7-252 comment ID 1575 set to 2019-09-14 00:02
- 7-252 comment ID 4694 set to 2019-09-14 00:01
- 7-290 comment ID 1656 set to 2019-09-25 00:02
- 7-290 comment ID 4696 set to 2019-09-25 00:01
- 7-331 comment ID 1768 set to 2019-10-17 00:02
- 7-331 comment ID 4697 set to 2019-10-17 00:01
- 8-203 comment ID 1347 set to 2019-07-27 00:02
- 8-203 comment ID 4698 set to 2019-07-27 00:01
- 8-324 comment ID 1549 set to 2019-09-07 00:02
- 8-324 comment ID 4699 set to 2019-09-07 00:01
- 9-164 comment ID 2466 set to 2020-03-23 00:03
- 9-165 comment ID 2473 set to 2020-03-23 00:02
- 9-165 comment ID 4702 set to 2020-03-23 00:01
- 9-392 comment ID 3268 set to 2020-06-19 00:02
- 9-392 comment ID 4703 set to 2020-06-19 00:01
- A-315 comment ID 2440 set to 2020-03-20 00:02
- A-315 comment ID 4705 set to 2020-03-20 00:01
- A-656 comment ID 2892 set to 2020-05-08 00:02
- A-656 comment ID 4706 set to 2020-05-08 00:01
- A-720 comment ID 2957 set to 2020-05-14 00:02
- A-720 comment ID 4707 set to 2020-05-14 00:01
- B-320 comment ID 3550 set to 2020-08-05 00:02
- B-320 comment ID 4709 set to 2020-08-05 00:01
- B-563 comment ID 3943 set to 2020-09-11 00:02
- B-563 comment ID 4710 set to 2020-09-11 00:01
- C-229 comment ID 4001 set to 2020-09-16 00:02
- C-229 comment ID 4711 set to 2020-09-16 00:01
- E-001 comment ID 4007 set to 2020-09-18 00:19
- E-001 comment ID 4714 set to 2020-09-18 00:18
- E-001 comment ID 4819 set to 2020-09-18 00:17
- E-001 comment ID 4846 set to 2020-09-18 00:16
- E-001 comment ID 4864 set to 2020-09-18 00:15
- E-014 comment ID 4011 set to 2020-09-19 00:05
- E-014 comment ID 4715 set to 2020-09-19 00:04
- E-014 comment ID 4820 set to 2020-09-19 00:03
- E-014 comment ID 4847 set to 2020-09-19 00:02
- E-014 comment ID 4865 set to 2020-09-19 00:01
- E-200 comment ID 4161 set to 2020-10-07 00:08
- E-200 comment ID 4716 set to 2020-10-07 00:07
- E-200 comment ID 4821 set to 2020-10-07 00:06
- E-200 comment ID 4848 set to 2020-10-07 00:05
- E-200 comment ID 4866 set to 2020-10-07 00:04
- E-203 comment ID 4170 set to 2020-10-09 00:03
- E-203 comment ID 4719 set to 2020-10-09 00:02
- E-203 comment ID 4823 set to 2020-10-09 00:01
- E-204 comment ID 4175 set to 2020-10-10 00:16
- E-204 comment ID 4720 set to 2020-10-10 00:15
- E-204 comment ID 4824 set to 2020-10-10 00:14
- E-204 comment ID 4850 set to 2020-10-10 00:13
- E-204 comment ID 4868 set to 2020-10-10 00:12
- E-205 comment ID 4178 set to 2020-10-10 00:11
- E-205 comment ID 4721 set to 2020-10-10 00:10
- E-205 comment ID 4825 set to 2020-10-10 00:09
- E-206 comment ID 4176 set to 2020-10-10 00:08
- E-206 comment ID 4722 set to 2020-10-10 00:07
- E-206 comment ID 4826 set to 2020-10-10 00:06
- E-207 comment ID 4174 set to 2020-10-10 00:05
- E-207 comment ID 4723 set to 2020-10-10 00:04
- E-207 comment ID 4827 set to 2020-10-10 00:03
- E-207 comment ID 4851 set to 2020-10-10 00:02
- E-207 comment ID 4869 set to 2020-10-10 00:01
- E-210 comment ID 4180 set to 2020-10-11 00:04
- E-210 comment ID 4724 set to 2020-10-11 00:03
- E-211 comment ID 4183 set to 2020-10-11 00:02
- E-211 comment ID 4725 set to 2020-10-11 00:01
- E-213 comment ID 4184 set to 2020-10-12 00:08
- E-213 comment ID 4726 set to 2020-10-12 00:07
- E-214 comment ID 4185 set to 2020-10-12 00:06
- E-214 comment ID 4727 set to 2020-10-12 00:05
- E-215 comment ID 4186 set to 2020-10-12 00:04
- E-215 comment ID 4728 set to 2020-10-12 00:03
- E-216 comment ID 4187 set to 2020-10-12 00:02
- E-216 comment ID 4729 set to 2020-10-12 00:01
- E-218 comment ID 4192 set to 2020-10-13 00:04
- E-218 comment ID 4730 set to 2020-10-13 00:03
- E-219 comment ID 4188 set to 2020-10-13 00:02
- E-219 comment ID 4731 set to 2020-10-13 00:01
- E-220 comment ID 4200 set to 2020-10-16 00:05
- E-220 comment ID 4732 set to 2020-10-16 00:04
- E-220 comment ID 4828 set to 2020-10-16 00:03
- E-220 comment ID 4852 set to 2020-10-16 00:02
- E-221 comment ID 4870 set to 2020-10-16 00:01
- E-221 comment ID 4829 set to 2020-10-17 00:02
- E-221 comment ID 4853 set to 2020-10-17 00:01
- Multiple comments per page are sometimes shown in incorrect order, this seems to be caused by a combination of Google Sites truncating the date, and at some point, comments were listed in newest-first rather than oldest-first order
- Some of the links don’t work
- Indeed they do not, I’ll be looking at the main culprits over the next little while, in the mean time, enjoy the 404 error page
- Broken link audit plugin installed, all links fixed [DONE]
- NB: Several missing images repaired as part of this process
- Also, did you know that if you explicitly link to the 404 page, as above, it always shows as a broken link?
- Broken link audit plugin installed, all links fixed [DONE]
- External Link specifics:
- Video link on 7-324 [DONE]
- Video link on 8-599 [DONE]
- Video link on A-248 [DONE]
- SoundCloud link on 9-315 [DONE]
- Image on Titles and Terms of Address [DONE]
- Video link on 8-317 [DONE]
- Video link on 9-016 [DONE]
- Video link on 6-013 [DONE]
- Video link on 6-340 [DONE]
- SoundCloud link on 8-158 (original unavailable – replaced with YouTube link) [DONE]
- Video link on 8-183 [ABANDONED – Video Deleted]
- Video link on A-204 [DONE]
- Video link on A-276 [DONE]
- Video link on A-744 [DONE]
- Video link on B-308 [DONE]
- Octant map images link to a way station page – remove link
- Octant 1 [DONE]
- Octant 2 [DONE]
- Octant 3 [DONE]
- Octant 4 [DONE]
- Octant 5 [DONE]
- Octant 6 [DONE]
- Octant 7 [DONE]
- Octant 8 [DONE]
- Indeed they do not, I’ll be looking at the main culprits over the next little while, in the mean time, enjoy the 404 error page
- Some of the dates on comments are in the future
- …and that screws up the ‘recent comments’ box on the home page!
- I’ll be fixing that one as a priority [DONE]
E-Mail Advice
- I’m still setting up an email plugin for the new site.
- MailPoet plugin installed [DONE]
- Sending via BlueHost [ABANDONED 2021-05-10]
- Bigpond has blacklisted BlueHost as a spammer, so I can’t use my authorised admin email as the sender…
- Sending via MailPoet [DONE]
- MailPoet wants to know more about my subscriber list source to see if I qualify for their free email deal [DONE]
- Plugin authorised to use MailPoet server [DONE]
- Now needs configuring [DONE]
- Subscription confirmations sent [DONE]
- And testing [DONE]
Project Plan
| ID | Task | Data Field |
| 1 | Refresh archive | |
| 2 | Extract posts and comment block from archive | |
| 3 | Extract Content | 1 |
| 4 | Calculate Post_name | 4 |
| 5 | Calculate post_type | 6 |
| 6 | Calculate temporary post_parent | 7 |
| 7 | Process comment block into DB_Comment using temporary key | |
| 8 | Extract comment comment_author | 8 |
| 9 | Extract comment comment_author for replies | 11 |
| 10 | Insert comment_post_ID (calculate at Extract Time) | 14 |
| 11 | check if comment_type varies with replies (don’t think it doies) | 17 |
| 12 | Save sites pages | |
| 13 | Calculate Post Author | 18 |
| 14 | Calculate Post_date_GMT | 21 |
| 15 | Calculate post comment_count | 24 |
| 16 | Solution for attachments & Google Sites images: | |
| 17 | Build relationship links to categories for posts | |
| 18 | Build INSERT statement for posts | |
| 19 | Insert Posts | |
| 20 | Build INSERT statement for parent comments | |
| 21 | Insert parent comments | |
| 22 | Build INSERT statement for child comments | |
| 23 | Insert child comments | |
| 24 | Calculate post_parent from file hierarchy and DB Post IDs | |
| 25 | Build Update statements | |
| 26 | Update post_parent | 28 |
| 27 | Extract title | 2 |
| 28 | Calculate guid | 5 |
| 29 | Extract comment comment_date | 9 |
| 30 | Extract comment comment_date for replies | 12 |
| 31 | Generate temporary key for commnent_id (extract time) | 15 |
| 32 | Enumerate all authors | |
| 33 | Calculate Post Date | 19 |
| 34 | Calculate post_modified_GMT | 22 |
| 35 | Download attachments from sites | |
| 36 | Build insert statement | |
| 37 | Get Post ID from Database | |
| 38 | Get Comment ID from Database | |
| 39 | Extract Edit Date | 3 |
| 40 | Extract comment comment_content | 10 |
| 41 | Extract comment comment_content for replies | 13 |
| 42 | Use temporary key for comment_parent (extract time) | 16 |
| 43 | Manually create profiles for previous players | |
| 44 | Calculate Comment user_ID | 20 |
| 45 | Calculate comment_date_gmt | 23 |
| 46 | Note replacements | |
| 47 | do lookup for `comment_post_ID` | 25 |
| 48 | Do lookup for `comment_id` | 26 |
| 49 | Build Excel lookup list | |
| 50 | upload retained attachments to file share (overlordfrank.com/sitesrsc ) | |
| 51 | Do lookup for `comment_parent` | 27 |
| 52 | Replace references in post content with new reference | 24.5 |