Closed taniwallach closed 4 years ago
Coding error -- probably related to the reformatting needed for introformat in the database.
This also give the error: https://test1.webwork.maa.org/moodle/course/view.php?id=5
Every textarea field in Moodle as a related introformat field to help internal validation and display filtering function work properly, and of course... enable a different type of textarea editor to the users. It seems, the upgrade process missed fixing it in the schema. and you should probably modify it manually in the db table mdl_data, see: https://github.com/moodle/moodle/blob/master/mod/data/db/install.xml#L13
Also, maybe: https://tracker.moodle.org/browse/MDL-23204
Also interesting: https://tracker.moodle.org/browse/MDL-49101
I did fix this. The $introformat problem was solved (hacked) manually as you describe. And the hacks that I did to the schema worked pretty well for the forums attached to UsingWW. The forums that are not working so well are the older ones which were attached to the AIM course from 2007. I hadn’t created that course before I did the original import of the database and while all of the contents of the posts uploaded fine, the links between posts and discussions got messed up and I haven’t been able to hack a fix.
Starting fresh and upgrading step by step is the sensible thing to do at this point. It requires switching php simultaneously since moodle 1.9 only runs on php 5 and moodle 3.8 only runs on php 7 (sigh). Serves us right for not updating moodle constantly (if it’s not broke don’t fix it. :-( )
Thanks for your help.
Take care,
Mike
On Feb 18, 2020, at 9:40 AM, Nadav Kavalerchik notifications@github.com wrote:
Every textarea field in Moodle as a related introformat field to help internal validation and display filtering function work properly, and of course... enable a different type of textarea editor to the users. It seems, the upgrade process missed fixing it in the schema. and you should probably modify it manually in the db table mdl_data, see: https://github.com/moodle/moodle/blob/master/mod/data/db/install.xml#L13 https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_moodle_moodle_blob_master_mod_data_db_install.xml-23L13&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=s7HtWo8BaGapNBpMbMvV1yJ5tUrDDqcdTctXuejd64k&e= — You are receiving this because you commented. Reply to this email directly, view it on GitHub https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_openwebwork_webwork.maa.org_issues_7-3Femail-5Fsource-3Dnotifications-26email-5Ftoken-3DAAJF27AB73HFUVLZUESCHW3RDPXNJA5CNFSM4KUEBCFKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMCGXNI-23issuecomment-2D587492277&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=EoXVkgZ1GKWDOWB-mxwFVejFhKlODcjGQ2jE0lMNvMk&e=, or unsubscribe https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AAJF27HFGRLXOPUWCXP3MEDRDPXNJANCNFSM4KUEBCFA&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=3b6TqsUJQW6KPq-CgPS7ohHiUIsy0r5CCkifvx7mNpQ&e=.
I completely forgot about the PHP version "challenges" :-(
Anyways, It looks like you are on the right track with this :-) If you get into any more challenges, please let me know.
Best, Nadav
On Tue, Feb 18, 2020 at 6:43 PM Michael Gage notifications@github.com wrote:
I did fix this. The $introformat problem was solved (hacked) manually as you describe. And the hacks that I did to the schema worked pretty well for the forums attached to UsingWW. The forums that are not working so well are the older ones which were attached to the AIM course from 2007. I hadn’t created that course before I did the original import of the database and while all of the contents of the posts uploaded fine, the links between posts and discussions got messed up and I haven’t been able to hack a fix.
Starting fresh and upgrading step by step is the sensible thing to do at this point. It requires switching php simultaneously since moodle 1.9 only runs on php 5 and moodle 3.8 only runs on php 7 (sigh). Serves us right for not updating moodle constantly (if it’s not broke don’t fix it. :-( )
Thanks for your help.
Take care,
Mike
On Feb 18, 2020, at 9:40 AM, Nadav Kavalerchik notifications@github.com wrote:
Every textarea field in Moodle as a related introformat field to help internal validation and display filtering function work properly, and of course... enable a different type of textarea editor to the users. It seems, the upgrade process missed fixing it in the schema. and you should probably modify it manually in the db table mdl_data, see: https://github.com/moodle/moodle/blob/master/mod/data/db/install.xml#L13 < https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_moodle_moodle_blob_master_mod_data_db_install.xml-23L13&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=s7HtWo8BaGapNBpMbMvV1yJ5tUrDDqcdTctXuejd64k&e=
— You are receiving this because you commented. Reply to this email directly, view it on GitHub < https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_openwebwork_webwork.maa.org_issues_7-3Femail-5Fsource-3Dnotifications-26email-5Ftoken-3DAAJF27AB73HFUVLZUESCHW3RDPXNJA5CNFSM4KUEBCFKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMCGXNI-23issuecomment-2D587492277&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=EoXVkgZ1GKWDOWB-mxwFVejFhKlODcjGQ2jE0lMNvMk&e=>, or unsubscribe < https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AAJF27HFGRLXOPUWCXP3MEDRDPXNJANCNFSM4KUEBCFA&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=3b6TqsUJQW6KPq-CgPS7ohHiUIsy0r5CCkifvx7mNpQ&e= .
— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/openwebwork/webwork.maa.org/issues/7?email_source=notifications&email_token=AABYOAH6AGZOMQFPP6LJWDTRDQF23A5CNFSM4KUEBCFKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMCWMPY#issuecomment-587556415, or unsubscribe https://github.com/notifications/unsubscribe-auth/AABYOAFIA2ULE5TWO4ZG6DDRDQF23ANCNFSM4KUEBCFA .
Thanks. I appreciate having someone else to talk to or to at least have an additional eye on the problem when I get stuck.
I’ll keep you informed. The most essential information is preserved if awkward to get at sometimes. There is now less urgency but I will try again to see if I can make the transferred forum work seamlessly.
Take care,
Mike
On Feb 18, 2020, at 11:55 AM, Nadav Kavalerchik notifications@github.com wrote:
I completely forgot about the PHP version "challenges" :-(
Anyways, It looks like you are on the right track with this :-) If you get into any more challenges, please let me know.
Best, Nadav
On Tue, Feb 18, 2020 at 6:43 PM Michael Gage notifications@github.com wrote:
I did fix this. The $introformat problem was solved (hacked) manually as you describe. And the hacks that I did to the schema worked pretty well for the forums attached to UsingWW. The forums that are not working so well are the older ones which were attached to the AIM course from 2007. I hadn’t created that course before I did the original import of the database and while all of the contents of the posts uploaded fine, the links between posts and discussions got messed up and I haven’t been able to hack a fix.
Starting fresh and upgrading step by step is the sensible thing to do at this point. It requires switching php simultaneously since moodle 1.9 only runs on php 5 and moodle 3.8 only runs on php 7 (sigh). Serves us right for not updating moodle constantly (if it’s not broke don’t fix it. :-( )
Thanks for your help.
Take care,
Mike
On Feb 18, 2020, at 9:40 AM, Nadav Kavalerchik notifications@github.com wrote:
Every textarea field in Moodle as a related introformat field to help internal validation and display filtering function work properly, and of course... enable a different type of textarea editor to the users. It seems, the upgrade process missed fixing it in the schema. and you should probably modify it manually in the db table mdl_data, see: https://github.com/moodle/moodle/blob/master/mod/data/db/install.xml#L13 https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_moodle_moodle_blob_master_mod_data_db_install.xml-23L13&d=DwQFaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=8Exw3EgyENb2HbXnPYznCgaYpgJXD_9g3PkTd-mwSVk&s=xHClPBojJypBiFapnA30lt9KICZSN5Ojav-z79Owiq0&e= < https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_moodle_moodle_blob_master_mod_data_db_install.xml-23L13&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=s7HtWo8BaGapNBpMbMvV1yJ5tUrDDqcdTctXuejd64k&e=
— You are receiving this because you commented. Reply to this email directly, view it on GitHub < https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_openwebwork_webwork.maa.org_issues_7-3Femail-5Fsource-3Dnotifications-26email-5Ftoken-3DAAJF27AB73HFUVLZUESCHW3RDPXNJA5CNFSM4KUEBCFKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMCGXNI-23issuecomment-2D587492277&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=EoXVkgZ1GKWDOWB-mxwFVejFhKlODcjGQ2jE0lMNvMk&e=%3E, or unsubscribe < https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AAJF27HFGRLXOPUWCXP3MEDRDPXNJANCNFSM4KUEBCFA&d=DwMCaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=u1Js5VbkvtRNxCH1bUYRaLtePuzCxvEIaRPiUqwcJc4&s=3b6TqsUJQW6KPq-CgPS7ohHiUIsy0r5CCkifvx7mNpQ&e= .
— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/openwebwork/webwork.maa.org/issues/7?email_source=notifications&email_token=AABYOAH6AGZOMQFPP6LJWDTRDQF23A5CNFSM4KUEBCFKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMCWMPY#issuecomment-587556415 https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_openwebwork_webwork.maa.org_issues_7-3Femail-5Fsource-3Dnotifications-26email-5Ftoken-3DAABYOAH6AGZOMQFPP6LJWDTRDQF23A5CNFSM4KUEBCFKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMCWMPY-23issuecomment-2D587556415-253E&d=DwQFaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=8Exw3EgyENb2HbXnPYznCgaYpgJXD_9g3PkTd-mwSVk&s=SIkg4yA3_1Wp5NRTvWT58ZkCPLGL5pOHdYBIN_-1iCk&e=, or unsubscribe https://github.com/notifications/unsubscribe-auth/AABYOAFIA2ULE5TWO4ZG6DDRDQF23ANCNFSM4KUEBCFA https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AABYOAFIA2ULE5TWO4ZG6DDRDQF23ANCNFSM4KUEBCFA-253E&d=DwQFaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=8Exw3EgyENb2HbXnPYznCgaYpgJXD_9g3PkTd-mwSVk&s=Xpyvez77CUyV14jLllD4207Zc9H8FCfLjZRYdJ6JDtw&e= .
— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_openwebwork_webwork.maa.org_issues_7-3Femail-5Fsource-3Dnotifications-26email-5Ftoken-3DAAJF27EBKORHGDMCKSKHGC3RDQHI3A5CNFSM4KUEBCFKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMCYAAY-23issuecomment-2D587563011&d=DwMFaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=8Exw3EgyENb2HbXnPYznCgaYpgJXD_9g3PkTd-mwSVk&s=4mYb_PRjjddXjiXuxV9x_9zdi0GsuZs0RXapdnwn6jw&e=, or unsubscribe https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AAJF27B6SIJBXCKOCMOFYU3RDQHI3ANCNFSM4KUEBCFA&d=DwMFaQ&c=kbmfwr1Yojg42sGEpaQh5ofMHBeTl9EI2eaqQZhHbOU&r=C6Pt5AGtImanmAdcooarL-JZO8M5dSFPfs3VweYXYkE&m=8Exw3EgyENb2HbXnPYznCgaYpgJXD_9g3PkTd-mwSVk&s=ANGq9NzOSZY5TjWEVcDteZJWr434jwOc3EUQj45hw_A&e=.
Fixed by reimporting the database and upgrading one step at a time from moodle 1.9 to 3.8
https://test1.webwork.maa.org/moodle/mod/data/index.php?id=3
https://test1.webwork.maa.org/moodle/mod/data/view.php?d=2&advanced=0&paging&page=1