Moodle
  1. Moodle
  2. MDL-25501

Upgrade fails for wikis with the same title

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0.2
    • Component/s: Wiki (2.x)
    • Labels:
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      Hi Petr,

      Hope you enjoyed your time in Perth and had a safe flight back home.

      When performing an upgrade on a Moodle 1.9 site to 2.0 I received the following error.

      =====

      Debug info: Duplicate entry '46-2. Trauma penetrating chest trauma-324' for key 2
      INSERT into mdl_wiki_pages (subwikiid, title, cachedcontent, timecreated, timemodified, userid, pageviews)
      SELECT s.id, p.pagename, ?, p.created, p.lastmodified, p.userid, p.hits
      FROM mdl_wiki_pages_old p
      LEFT OUTER JOIN mdl_wiki_entries_old e ON e.id = p.wiki
      LEFT OUTER JOIN mdl_wiki_subwikis s
      ON s.wikiid = e.wikiid AND s.groupid = e.groupid AND s.userid = e.userid
      WHERE p.version = (
      SELECT max(po.version)
      FROM mdl_wiki_pages_old po
      WHERE p.pagename = po.pagename and
      p.wiki = po.wiki
      )
      [array (
      0 => '*reparse needed*',
      )]

      Stack trace:

      • line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
      • line 672 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 187 of /mod/wiki/db/upgrade.php: call to mysqli_native_moodle_database->execute()
      • line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
      • line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
      • line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
      • line 290 of /admin/index.php: call to upgrade_noncore()

      Regards,

      Mark

        Gliffy Diagrams

          Issue Links

            Activity

            Hide
            Petr Skoda added a comment -

            Ah! I saw something similar before, assigning to Dongsheng. Hopefully it will be easy to fix now. Thanks!

            Show
            Petr Skoda added a comment - Ah! I saw something similar before, assigning to Dongsheng. Hopefully it will be easy to fix now. Thanks!
            Hide
            Mark Nelson added a comment -

            after speaking to Dongsheng regarding wikis this is not a fix .. my install process did succeed but the wiki tables became useless

            Show
            Mark Nelson added a comment - after speaking to Dongsheng regarding wikis this is not a fix .. my install process did succeed but the wiki tables became useless
            Hide
            Dongsheng Cai added a comment -

            Notes on Wiki tables:
            In moodle 1.9
            there are wiki_entries and wiki_pages table. wiki_entries stores page info including groupid, userid and pagename, wiki_pages stores the page history.
            In moodle 2
            we have wiki_subwikis, wiki_pages, and wiki_versions. wiki_subwikis joins wiki instance id, groupid and userid, wiki_pages cached latest page content, it uses subwikiid to join wiki id, userid in wiki_pages table the current author of it (who lately modified the wiki page), wiki_versions stores the history.

            Show
            Dongsheng Cai added a comment - Notes on Wiki tables: In moodle 1.9 there are wiki_entries and wiki_pages table. wiki_entries stores page info including groupid, userid and pagename, wiki_pages stores the page history. In moodle 2 we have wiki_subwikis, wiki_pages, and wiki_versions. wiki_subwikis joins wiki instance id, groupid and userid, wiki_pages cached latest page content, it uses subwikiid to join wiki id, userid in wiki_pages table the current author of it (who lately modified the wiki page), wiki_versions stores the history.
            Hide
            Helen Foster added a comment -

            Please see linked issue for a further report of this problem.

            Show
            Helen Foster added a comment - Please see linked issue for a further report of this problem.
            Hide
            Mark Nelson added a comment -

            I got very confused solving this issue as everytime I re-attempted the install I would get duplicate entries as the install had partially completed earlier and I had forgotten to clear the table.

            The issue is with duplicate entries already existing in the database prior to the install process. Solution? Besides preventing this from happening, it is to delete any duplicates or rename the article. Either option is better than the install failing.

            Also, the fact this has happened more than once shows it is possible to add duplicate wikis to the table even though they share the same key 2, so maybe it's just safer to have this check in on the install?

            Show
            Mark Nelson added a comment - I got very confused solving this issue as everytime I re-attempted the install I would get duplicate entries as the install had partially completed earlier and I had forgotten to clear the table. The issue is with duplicate entries already existing in the database prior to the install process. Solution? Besides preventing this from happening, it is to delete any duplicates or rename the article. Either option is better than the install failing. Also, the fact this has happened more than once shows it is possible to add duplicate wikis to the table even though they share the same key 2, so maybe it's just safer to have this check in on the install?
            Hide
            Dongsheng Cai added a comment -

            I don't have mark's db to perform full upgrade, but I create a script to test upgrade on wiki_pages wiki_entries and wiki tables.

            But I cannot find the duplicated entry here (duplicated entries means same swid, pagename and userid)

            Show
            Dongsheng Cai added a comment - I don't have mark's db to perform full upgrade, but I create a script to test upgrade on wiki_pages wiki_entries and wiki tables. But I cannot find the duplicated entry here (duplicated entries means same swid, pagename and userid)
            Hide
            Dongsheng Cai added a comment -

            To use the script
            1. create a new database
            2. copy your moodle 1.9 mdl_wiki_pages mdl_wiki_pages mdl_wiki_entries and mdl_wiki to the new db
            3. rename them to mdl_wiki_pages_old mdl_wiki_entries_old, or you can comment out the renaming code in my script
            4. move the script to moodle dirroot, then run it to see if you still got the key conflict.

            Show
            Dongsheng Cai added a comment - To use the script 1. create a new database 2. copy your moodle 1.9 mdl_wiki_pages mdl_wiki_pages mdl_wiki_entries and mdl_wiki to the new db 3. rename them to mdl_wiki_pages_old mdl_wiki_entries_old, or you can comment out the renaming code in my script 4. move the script to moodle dirroot, then run it to see if you still got the key conflict.
            Hide
            Dongsheng Cai added a comment -

            I am not sure what is 'key 2' here, moodle created three keys on that table, primary key for id, wikiidgroupiduserid for ('subwikiid', 'title', 'userid') and a foreign key to reference subwiki.id. But there is not key to make title unique. Can you please run 'show keys from mdl_wiki_pages' in moodle 2 db?

            Show
            Dongsheng Cai added a comment - I am not sure what is 'key 2' here, moodle created three keys on that table, primary key for id, wikiidgroupiduserid for ('subwikiid', 'title', 'userid') and a foreign key to reference subwiki.id. But there is not key to make title unique. Can you please run 'show keys from mdl_wiki_pages' in moodle 2 db?
            Hide
            Koen Roggemans added a comment -

            Hi Donghsheng,
            If you need a life database to experiment with, just ask. Only requirement is use it carefully and confidentially.
            It's 109MB zipped and contains several hundreds of wiki's.

            Show
            Koen Roggemans added a comment - Hi Donghsheng, If you need a life database to experiment with, just ask. Only requirement is use it carefully and confidentially. It's 109MB zipped and contains several hundreds of wiki's.
            Hide
            Dongsheng Cai added a comment -

            It is similar with MDL-25430, but MDL-25430 is related to key mdl_wikipage_subtituse_uix, resolved by fixing userid or deleting bad data.

            Show
            Dongsheng Cai added a comment - It is similar with MDL-25430 , but MDL-25430 is related to key mdl_wikipage_subtituse_uix, resolved by fixing userid or deleting bad data.
            Hide
            Dongsheng Cai added a comment -

            Hi, Koen

            Thanks, before I test on your db, can you please run 'show keys from mdl_wiki_pages' on your moodle 2 db? just to make sure which key prevent inserting new data.

            Show
            Dongsheng Cai added a comment - Hi, Koen Thanks, before I test on your db, can you please run 'show keys from mdl_wiki_pages' on your moodle 2 db? just to make sure which key prevent inserting new data.
            Hide
            Koen Roggemans added a comment -

            I'm afraid I can't get your script doing anything, Dongsheng. Blank page - no changes in the database.

            Show
            Koen Roggemans added a comment - I'm afraid I can't get your script doing anything, Dongsheng. Blank page - no changes in the database.
            Hide
            Dongsheng Cai added a comment -

            Hi, Koen

            Do you have phpmyadmin installed on your server? if you do, can you please run on your moodle 2 website 'show keys from mdl_wiki_pages' (I suppose your db prefix is mdl_)

            Show
            Dongsheng Cai added a comment - Hi, Koen Do you have phpmyadmin installed on your server? if you do, can you please run on your moodle 2 website 'show keys from mdl_wiki_pages' (I suppose your db prefix is mdl_)
            Hide
            Koen Roggemans added a comment -

            Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
            mdl_wiki_pages_old 0 PRIMARY 1 id A 16054 NULL NULL BTREE
            mdl_wiki_pages_old 1 wiki_pages_uk 1 pagename A 1337 NULL NULL BTREE
            mdl_wiki_pages_old 1 wiki_pages_uk 2 version A 8027 NULL NULL BTREE
            mdl_wiki_pages_old 1 wiki_pages_uk 3 wiki A 16054 NULL NULL BTREE
            mdl_wiki_pages_old 1 mdl_wikipage_wik_ix 1 wiki A 729 NULL NULL BTREE

            Show
            Koen Roggemans added a comment - Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment mdl_wiki_pages_old 0 PRIMARY 1 id A 16054 NULL NULL BTREE mdl_wiki_pages_old 1 wiki_pages_uk 1 pagename A 1337 NULL NULL BTREE mdl_wiki_pages_old 1 wiki_pages_uk 2 version A 8027 NULL NULL BTREE mdl_wiki_pages_old 1 wiki_pages_uk 3 wiki A 16054 NULL NULL BTREE mdl_wiki_pages_old 1 mdl_wikipage_wik_ix 1 wiki A 729 NULL NULL BTREE
            Hide
            Dongsheng Cai added a comment -

            Hi, Koen

            This is the old wiki table which is renamed by moodle.
            Can you please email me how to get your db? I guarantee I will use it only for testing and will remove it from my test server after testing.

            BTW, is koen at roggemans dot net your email?

            Thanks.

            Show
            Dongsheng Cai added a comment - Hi, Koen This is the old wiki table which is renamed by moodle. Can you please email me how to get your db? I guarantee I will use it only for testing and will remove it from my test server after testing. BTW, is koen at roggemans dot net your email? Thanks.
            Hide
            Koen Roggemans added a comment -

            yes it is - send to your moodletracker e-mail

            Show
            Koen Roggemans added a comment - yes it is - send to your moodletracker e-mail
            Hide
            Dongsheng Cai added a comment -

            Hi all

            Thanks for Koen's db dump, I found out it was the bad records in 1.9 db, in group mode, old 1.9 wiki failed to bump page version. I will write a separate script to fix it, I am not sure if I should include this in moodle 2 upgrade script, because another wiki fail case was caused by invalid userid.

            Show
            Dongsheng Cai added a comment - Hi all Thanks for Koen's db dump, I found out it was the bad records in 1.9 db, in group mode, old 1.9 wiki failed to bump page version. I will write a separate script to fix it, I am not sure if I should include this in moodle 2 upgrade script, because another wiki fail case was caused by invalid userid.
            Hide
            Dongsheng Cai added a comment -

            Hi, all

            I upgraded Koen's db to 2.0 today, created a script to fix the wiki history, will see how it goes on Koen's real website.

            Show
            Dongsheng Cai added a comment - Hi, all I upgraded Koen's db to 2.0 today, created a script to fix the wiki history, will see how it goes on Koen's real website.
            Hide
            Koen Roggemans added a comment -

            With a lot of help, we managed to trace down a few problems:
            1) upgrade_set_timeout() at the beginning of wiki_upgrade_migrate_versions() is not having effect. We had to move it to within the loop.
            2) Detected that some records within the loop spend mins to be processed.
            3) Traced the problem down to some old binary contents in DB trying to be converted
            4) should wiki_ewiki_2_html() generate filtered contents? or unfiltered ones?
            5) to save some cycles, wiki_ewiki_2_html() also should not using caching at all.

            Show
            Koen Roggemans added a comment - With a lot of help, we managed to trace down a few problems: 1) upgrade_set_timeout() at the beginning of wiki_upgrade_migrate_versions() is not having effect. We had to move it to within the loop. 2) Detected that some records within the loop spend mins to be processed. 3) Traced the problem down to some old binary contents in DB trying to be converted 4) should wiki_ewiki_2_html() generate filtered contents? or unfiltered ones? 5) to save some cycles, wiki_ewiki_2_html() also should not using caching at all.
            Hide
            Koen Roggemans added a comment -

            is it better to split this problem to a/several separate reports?

            Show
            Koen Roggemans added a comment - is it better to split this problem to a/several separate reports?
            Hide
            Dongsheng Cai added a comment -

            Koen

            > 3) Traced the problem down to some old binary contents in DB trying to be converted
            Can be ignored, we had the same problems when we upgrade moodle.org

            > 4) should wiki_ewiki_2_html() generate filtered contents? or unfiltered ones?
            Filtered contents

            > 5) to save some cycles, wiki_ewiki_2_html() also should not using caching at all.
            And please disable htmlpurifier if its slow to process, when I try to upgrade your db, I turn off the moodle filters and htmlpurifier to get it upgraded.

            Show
            Dongsheng Cai added a comment - Koen > 3) Traced the problem down to some old binary contents in DB trying to be converted Can be ignored, we had the same problems when we upgrade moodle.org > 4) should wiki_ewiki_2_html() generate filtered contents? or unfiltered ones? Filtered contents > 5) to save some cycles, wiki_ewiki_2_html() also should not using caching at all. And please disable htmlpurifier if its slow to process, when I try to upgrade your db, I turn off the moodle filters and htmlpurifier to get it upgraded.
            Hide
            Koen Roggemans added a comment -

            Hi Dongsheng
            3) is a problem, since the upgrade crashes on it. How to work around?
            5) I'll try disabling it

            Show
            Koen Roggemans added a comment - Hi Dongsheng 3) is a problem, since the upgrade crashes on it. How to work around? 5) I'll try disabling it
            Hide
            Dongsheng Cai added a comment -

            Koen

            > 3) is a problem, since the upgrade crashes on it. How to work around?

            Can you post the error message here please?

            Show
            Dongsheng Cai added a comment - Koen > 3) is a problem, since the upgrade crashes on it. How to work around? Can you post the error message here please?
            Hide
            Koen Roggemans added a comment -

            Default exception handler: Error writing to database Debug: Data too long for column 'rawtext' at row 1\nINSERT INTO mdl_cache_filters (filter,version,md5key,rawtext,timemodified) VALUES(?,?,?,?,?)\n[array (\n 0 => 'tex',\n 1 => 1,\n 2 => '20e62681a4158704426b9302d82374bb',\n 3 => '\r\r\r\r\n</p>\n\n\n<p>\nLLLLLLLLLLLLLLLLLLLLL<strong>`````</strong>_<sup></sup>]]]]\\\\\\\\\\\\\\\\KKKKKKKJJJJIIIIIHHHHGGGGG666655UUVVVVVVUUUTTTTSSSSRRRRAAAAAAA@@@@?????>>>><tt></tt>=<b></b>))ZZ[[[[[ZZZYYYYXXXXWWWWFFFFFFFEEEEEDDDDCCCCCBBBB0000//PPQQQQQPPPOOOONNNNMMMM<<<<<<<;;;;:::::999988888$$$##\

            Tue Dec 14 11:38:21 2010] [error] [client 192.168.0.164] page 5156 version 1, referer: https://testelo.ritacollege.be/admin/

            And if you look in mdl_wiki_pages_old->id = 5156 you'll see there is a large binary file.

            Show
            Koen Roggemans added a comment - Default exception handler: Error writing to database Debug: Data too long for column 'rawtext' at row 1\nINSERT INTO mdl_cache_filters (filter,version,md5key,rawtext,timemodified) VALUES(?,?,?,?,?)\n [array (\n 0 => 'tex',\n 1 => 1,\n 2 => '20e62681a4158704426b9302d82374bb',\n 3 => '\r\r\r\r\n</p>\n\n\n<p>\nLLLLLLLLLLLLLLLLLLLLL<strong>`````</strong>_<sup></sup>] ]]]\\\\\\\\\\\\\\\\KKKKKKKJJJJIIIIIHHHHGGGGG666655UUVVVVVVUUUTTTTSSSSRRRRAAAAAAA@@@@?????>>>><tt></tt>=<b></b>))ZZ[[[[[ZZZYYYYXXXXWWWWFFFFFFFEEEEEDDDDCCCCCBBBB0000//PPQQQQQPPPOOOONNNNMMMM<<<<<<<;;;;:::::999988888$$$##\ Tue Dec 14 11:38:21 2010] [error] [client 192.168.0.164] page 5156 version 1, referer: https://testelo.ritacollege.be/admin/ And if you look in mdl_wiki_pages_old->id = 5156 you'll see there is a large binary file.
            Hide
            Mark Nelson added a comment -

            I have also received that error on update.

            "Debug info: Data too long for column 'tomissingpage' at row 1
            INSERT INTO mdl_wiki_links (subwikiid,frompageid,tomissingpage) VALUES(?,?,?)
            [array (
            0 => '40',
            1 => '40',
            2 => '.<personal data removed>',
            )]"

            Stack trace:

            • line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
            • line 853 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
            • line 895 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
            • line 302 of /mod/wiki/locallib.php: call to mysqli_native_moodle_database->insert_record()
            • line 274 of /mod/wiki/locallib.php: call to wiki_refresh_page_links()
            • line 208 of /mod/wiki/db/upgrade.php: call to wiki_refresh_cachedcontent()
            • line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            • line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            • line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            • line 290 of /admin/index.php: call to upgrade_noncore()

            I changed the datatype to 'text' rather than varchar(255) to bypass this error.

            Show
            Mark Nelson added a comment - I have also received that error on update. "Debug info: Data too long for column 'tomissingpage' at row 1 INSERT INTO mdl_wiki_links (subwikiid,frompageid,tomissingpage) VALUES(?,?,?) [array ( 0 => '40', 1 => '40', 2 => '.<personal data removed>', )]" Stack trace: line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown line 853 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 895 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw() line 302 of /mod/wiki/locallib.php: call to mysqli_native_moodle_database->insert_record() line 274 of /mod/wiki/locallib.php: call to wiki_refresh_page_links() line 208 of /mod/wiki/db/upgrade.php: call to wiki_refresh_cachedcontent() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() I changed the datatype to 'text' rather than varchar(255) to bypass this error.
            Hide
            Jody Paul added a comment -

            Same/similar problem with failing upgrade from 1.9.10+ (Build: 20101222) with debug info regarding "Duplicate entry ... for key 'mdl_wikipage_subtituse_uix'"

            The main issues are that once this upgrade fails, mdl_wiki_pages is in a crashed state, and the remaining upgrade cannot complete.

            Additional context provided below: the initial failure and the subsequent inability to recover.

            mod_wiki

            Adding new fields to wiki table
            Renaming old wiki module tables
            Installing new wiki module tables
            Migrating group type wiki instance: The Deadline Wiki
            Migrating student type wiki instance: Personal Wiki
            Migrating group type wiki instance: Shared Wiki
            Migrating student type wiki instance: Personal Wiki - CS4260
            Migrating group type wiki instance: CASE Tools Wiki
            Migrating group type wiki instance: Examples of Good UI
            Migrating group type wiki instance: Recurrence Relations - Exam-style Questions
            Migrating group type wiki instance: Algorithm Analysis Fundamentals - Exam-Style Questions
            Migrating group type wiki instance: Spring 2007 Wiki
            Migrating group type wiki instance: Software Engineering Resources
            Migrating student type wiki instance: Personal Wiki - CS4260
            Migrating group type wiki instance: Solving Recurrence Relations
            Migrating student type wiki instance: Personal Wiki - CS4260
            Migrating group type wiki instance: Textbook Wiki
            Migrating group type wiki instance: Formal Proposal Wiki
            Migrating group type wiki instance: Exam Reference Sheet
            Migrating group type wiki instance: Policies
            Migrating group type wiki instance: CASE Tools Wiki
            Migrating group type wiki instance: Software Engineering Resources
            Migrating group type wiki instance: Requirements Specification
            Migrating group type wiki instance: Policies
            Migrating group type wiki instance: Textbook Comments
            Migrating group type wiki instance: Policies
            Migrating group type wiki instance: Software Engineering Resources
            Migrating group type wiki instance: Group Wiki
            Migrating group type wiki instance: CS3210 Final Exam Reference Wiki
            Migrating group type wiki instance: Textbook Comments
            Migrating group type wiki instance: SRS Management Wiki
            Migrating group type wiki instance: Antibugging Wiki
            Migrating group type wiki instance: Examples of Good UI
            Migrating group type wiki instance: Project 1 - Group Wiki
            Migrating group type wiki instance: Project 1 - Group Wiki
            Migrating group type wiki instance: Project 2 - Group Wiki
            Migrating group type wiki instance: Project 2 - Group Wiki
            Migrating group type wiki instance: Project 2 - The SIX Wiki
            Migrating group type wiki instance: Project 2 - MSCD USE Wiki
            Migrating group type wiki instance: Project 2 - SCOPE Wiki
            Migrating group type wiki instance: Project 2 - JOIST Wiki
            Migrating group type wiki instance: Project 1 - Group Wiki
            Migrating group type wiki instance: Project 2 - GroupZ Wiki
            Migrating group type wiki instance: Examples of Good UI
            Migrating group type wiki instance: Project 1 - Deliverables
            Migrating group type wiki instance: Group Wiki
            Migrating student type wiki instance: Daily Activity Log
            Migrating student type wiki instance: Daily Activity Log
            Migrating group type wiki instance: Group Wiki
            Migrating group type wiki instance: Project 2 - Group Wiki
            Migrating group type wiki instance: Project 1 - Group Wiki
            Migrating group type wiki instance: Group Wiki
            Migrating group type wiki instance: Project 1 - Group Wiki
            Migrating student type wiki instance: Personal Wiki
            Migrating group type wiki instance: Shared Wiki
            Migrating student type wiki instance: Daily Activity Log
            Migrating old wikis to new wikis
            Migrating old entries to new subwikis
            Migrating old pages to new pages
            Error writing to database

            More information about this error

            Debug info: Duplicate entry '172-http://img152.imageshack.us/img152/4208/computerey1.th.jpg-2' for key 'mdl_wikipage_subtituse_uix'
            INSERT into mdl_wiki_pages (subwikiid, title, cachedcontent, timecreated, timemodified, userid, pageviews)
            SELECT s.id, p.pagename, ?, p.created, p.lastmodified, p.userid, p.hits
            FROM mdl_wiki_pages_old p
            LEFT OUTER JOIN mdl_wiki_entries_old e ON e.id = p.wiki
            LEFT OUTER JOIN mdl_wiki_subwikis s
            ON s.wikiid = e.wikiid AND s.groupid = e.groupid AND s.userid = e.userid
            WHERE p.version = (
            SELECT max(po.version)
            FROM mdl_wiki_pages_old po
            WHERE p.pagename = po.pagename and
            p.wiki = po.wiki
            )
            [array (
            0 => '*reparse needed*',
            )]
            Stack trace:
            line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
            line 682 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
            line 187 of /mod/wiki/db/upgrade.php: call to mysqli_native_moodle_database->execute()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()

            ===== Check of mdl_wiki_pages using phpmyadmin =====

            Error
            SQL query:

            SHOW FULL FIELDS FROM `mdl_wiki_pages` ;

            MySQL said:

            #144 - Table './moodle20test/mdl_wiki_pages' is marked as crashed and last (automatic?) repair failed

            ===== Attempt to re-start moodle =====

            Upgrading to new version
            You are logged in as Jody Paul (Logout)
            mod_wiki

            Migrating old pages to new pages
            Error writing to database

            More information about this error

            Debug info: Table './moodle20test/mdl_wiki_pages' is marked as crashed and last (automatic?) repair failed
            INSERT into mdl_wiki_pages (subwikiid, title, cachedcontent, timecreated, timemodified, userid, pageviews)
            SELECT s.id, p.pagename, ?, p.created, p.lastmodified, p.userid, p.hits
            FROM mdl_wiki_pages_old p
            LEFT OUTER JOIN mdl_wiki_entries_old e ON e.id = p.wiki
            LEFT OUTER JOIN mdl_wiki_subwikis s
            ON s.wikiid = e.wikiid AND s.groupid = e.groupid AND s.userid = e.userid
            WHERE p.version = (
            SELECT max(po.version)
            FROM mdl_wiki_pages_old po
            WHERE p.pagename = po.pagename and
            p.wiki = po.wiki
            )
            [array (
            0 => '*reparse needed*',
            )]
            Stack trace:
            line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
            line 682 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
            line 187 of /mod/wiki/db/upgrade.php: call to mysqli_native_moodle_database->execute()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()

            Show
            Jody Paul added a comment - Same/similar problem with failing upgrade from 1.9.10+ (Build: 20101222) with debug info regarding "Duplicate entry ... for key 'mdl_wikipage_subtituse_uix'" The main issues are that once this upgrade fails, mdl_wiki_pages is in a crashed state, and the remaining upgrade cannot complete. Additional context provided below: the initial failure and the subsequent inability to recover. mod_wiki Adding new fields to wiki table Renaming old wiki module tables Installing new wiki module tables Migrating group type wiki instance: The Deadline Wiki Migrating student type wiki instance: Personal Wiki Migrating group type wiki instance: Shared Wiki Migrating student type wiki instance: Personal Wiki - CS4260 Migrating group type wiki instance: CASE Tools Wiki Migrating group type wiki instance: Examples of Good UI Migrating group type wiki instance: Recurrence Relations - Exam-style Questions Migrating group type wiki instance: Algorithm Analysis Fundamentals - Exam-Style Questions Migrating group type wiki instance: Spring 2007 Wiki Migrating group type wiki instance: Software Engineering Resources Migrating student type wiki instance: Personal Wiki - CS4260 Migrating group type wiki instance: Solving Recurrence Relations Migrating student type wiki instance: Personal Wiki - CS4260 Migrating group type wiki instance: Textbook Wiki Migrating group type wiki instance: Formal Proposal Wiki Migrating group type wiki instance: Exam Reference Sheet Migrating group type wiki instance: Policies Migrating group type wiki instance: CASE Tools Wiki Migrating group type wiki instance: Software Engineering Resources Migrating group type wiki instance: Requirements Specification Migrating group type wiki instance: Policies Migrating group type wiki instance: Textbook Comments Migrating group type wiki instance: Policies Migrating group type wiki instance: Software Engineering Resources Migrating group type wiki instance: Group Wiki Migrating group type wiki instance: CS3210 Final Exam Reference Wiki Migrating group type wiki instance: Textbook Comments Migrating group type wiki instance: SRS Management Wiki Migrating group type wiki instance: Antibugging Wiki Migrating group type wiki instance: Examples of Good UI Migrating group type wiki instance: Project 1 - Group Wiki Migrating group type wiki instance: Project 1 - Group Wiki Migrating group type wiki instance: Project 2 - Group Wiki Migrating group type wiki instance: Project 2 - Group Wiki Migrating group type wiki instance: Project 2 - The SIX Wiki Migrating group type wiki instance: Project 2 - MSCD USE Wiki Migrating group type wiki instance: Project 2 - SCOPE Wiki Migrating group type wiki instance: Project 2 - JOIST Wiki Migrating group type wiki instance: Project 1 - Group Wiki Migrating group type wiki instance: Project 2 - GroupZ Wiki Migrating group type wiki instance: Examples of Good UI Migrating group type wiki instance: Project 1 - Deliverables Migrating group type wiki instance: Group Wiki Migrating student type wiki instance: Daily Activity Log Migrating student type wiki instance: Daily Activity Log Migrating group type wiki instance: Group Wiki Migrating group type wiki instance: Project 2 - Group Wiki Migrating group type wiki instance: Project 1 - Group Wiki Migrating group type wiki instance: Group Wiki Migrating group type wiki instance: Project 1 - Group Wiki Migrating student type wiki instance: Personal Wiki Migrating group type wiki instance: Shared Wiki Migrating student type wiki instance: Daily Activity Log Migrating old wikis to new wikis Migrating old entries to new subwikis Migrating old pages to new pages Error writing to database More information about this error Debug info: Duplicate entry '172- http://img152.imageshack.us/img152/4208/computerey1.th.jpg-2 ' for key 'mdl_wikipage_subtituse_uix' INSERT into mdl_wiki_pages (subwikiid, title, cachedcontent, timecreated, timemodified, userid, pageviews) SELECT s.id, p.pagename, ?, p.created, p.lastmodified, p.userid, p.hits FROM mdl_wiki_pages_old p LEFT OUTER JOIN mdl_wiki_entries_old e ON e.id = p.wiki LEFT OUTER JOIN mdl_wiki_subwikis s ON s.wikiid = e.wikiid AND s.groupid = e.groupid AND s.userid = e.userid WHERE p.version = ( SELECT max(po.version) FROM mdl_wiki_pages_old po WHERE p.pagename = po.pagename and p.wiki = po.wiki ) [array ( 0 => '* reparse needed *', )] Stack trace: line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown line 682 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 187 of /mod/wiki/db/upgrade.php: call to mysqli_native_moodle_database->execute() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() ===== Check of mdl_wiki_pages using phpmyadmin ===== Error SQL query: SHOW FULL FIELDS FROM `mdl_wiki_pages` ; MySQL said: #144 - Table './moodle20test/mdl_wiki_pages' is marked as crashed and last (automatic?) repair failed ===== Attempt to re-start moodle ===== Upgrading to new version You are logged in as Jody Paul (Logout) mod_wiki Migrating old pages to new pages Error writing to database More information about this error Debug info: Table './moodle20test/mdl_wiki_pages' is marked as crashed and last (automatic?) repair failed INSERT into mdl_wiki_pages (subwikiid, title, cachedcontent, timecreated, timemodified, userid, pageviews) SELECT s.id, p.pagename, ?, p.created, p.lastmodified, p.userid, p.hits FROM mdl_wiki_pages_old p LEFT OUTER JOIN mdl_wiki_entries_old e ON e.id = p.wiki LEFT OUTER JOIN mdl_wiki_subwikis s ON s.wikiid = e.wikiid AND s.groupid = e.groupid AND s.userid = e.userid WHERE p.version = ( SELECT max(po.version) FROM mdl_wiki_pages_old po WHERE p.pagename = po.pagename and p.wiki = po.wiki ) [array ( 0 => '* reparse needed *', )] Stack trace: line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown line 682 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 187 of /mod/wiki/db/upgrade.php: call to mysqli_native_moodle_database->execute() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore()
            Hide
            Dongsheng Cai added a comment -

            Hi Jody

            Can you please try the latest patch I just attached, it is trying to detect the duplicated records before insert.

            thanks.

            Show
            Dongsheng Cai added a comment - Hi Jody Can you please try the latest patch I just attached, it is trying to detect the duplicated records before insert. thanks.
            Hide
            Jody Paul added a comment -

            Unsure what I'm doing wrong, but I can't seem to apply the patch. My system is Mac OS X 10.6.5 Here is some terminal transcript info:

            % sudo patch -n 1 < ../wikiupgrade.patch.txt
            patch: **** Only garbage was found in the patch input.

            % uname
            Darwin
            % patch --version
            patch 2.5.8
            % head ../wikiupgrade.patch.txt
            diff --git a/lib/resourcelib.php b/lib/resourcelib.php
            index 82c5eb6..efeac32 100644
            — a/lib/resourcelib.php
            +++ b/lib/resourcelib.php
            @@ -66,6 +66,8 @@ function resourcelib_try_file_migration($filepath, $cmid, $courseid, $component,
            // do not steal protected files!
            return false;
            }
            + if (!$cmid)
            + return false;
            %

            Show
            Jody Paul added a comment - Unsure what I'm doing wrong, but I can't seem to apply the patch. My system is Mac OS X 10.6.5 Here is some terminal transcript info: % sudo patch -n 1 < ../wikiupgrade.patch.txt patch: **** Only garbage was found in the patch input. % uname Darwin % patch --version patch 2.5.8 % head ../wikiupgrade.patch.txt diff --git a/lib/resourcelib.php b/lib/resourcelib.php index 82c5eb6..efeac32 100644 — a/lib/resourcelib.php +++ b/lib/resourcelib.php @@ -66,6 +66,8 @@ function resourcelib_try_file_migration($filepath, $cmid, $courseid, $component, // do not steal protected files! return false; } + if (!$cmid) + return false; %
            Hide
            Dongsheng Cai added a comment -

            Hi, Jody

            run the command below on top level of moodle directory:
            patch -p1 < wikiupgrade.patch

            Show
            Dongsheng Cai added a comment - Hi, Jody run the command below on top level of moodle directory: patch -p1 < wikiupgrade.patch
            Hide
            Jody Paul added a comment -

            Thanks. I am out of town for now and will try this when I return (early next week).

            Show
            Jody Paul added a comment - Thanks. I am out of town for now and will try this when I return (early next week).
            Hide
            Dongsheng Cai added a comment -

            I just submitted a pull request, the new changes upgrade Koen's website without error.

            Please see PULL-95

            Show
            Dongsheng Cai added a comment - I just submitted a pull request, the new changes upgrade Koen's website without error. Please see PULL-95
            Hide
            Koen Roggemans added a comment -

            Hi Dongsheng,
            Thanks for this fix - git stuff, my testmoodle is a CVS installation. I'll try to change that (should be done anyway) and try to test somewhere today.

            Show
            Koen Roggemans added a comment - Hi Dongsheng, Thanks for this fix - git stuff, my testmoodle is a CVS installation. I'll try to change that (should be done anyway) and try to test somewhere today.
            Hide
            Jody Paul added a comment -

            Was able to complete a test upgrade using wikiupgrade.patch – but did appear to lose quite a bit of information from wikis that was accessible under 1.9+

            Show
            Jody Paul added a comment - Was able to complete a test upgrade using wikiupgrade.patch – but did appear to lose quite a bit of information from wikis that was accessible under 1.9+
            Hide
            Dongsheng Cai added a comment -

            Jody

            There are bad records in 1.9, for example invalid userid or version, which cause the problem of "Duplicate entry ... for key 'mdl_wikipage_subtituse_uix'" we either fix the incorrect userid/versionid manually, or ignore the bad records (what the patch does).

            I can help with recover the missing data, but I will need your database the analysis what is wrong in 1.9.

            Show
            Dongsheng Cai added a comment - Jody There are bad records in 1.9, for example invalid userid or version, which cause the problem of "Duplicate entry ... for key 'mdl_wikipage_subtituse_uix'" we either fix the incorrect userid/versionid manually, or ignore the bad records (what the patch does). I can help with recover the missing data, but I will need your database the analysis what is wrong in 1.9.
            Hide
            Jody Paul added a comment -

            Thanks for the offer. Since our semester is starting now, I think we'll hold off on upgrading the full site to 2.0 for a while. Is there anything in particular that I could directly query the database records for that would identify the problematic records? I might be able to clean up the wikis while still running 1.9 so that it's ready for a seamless upgrade.

            Show
            Jody Paul added a comment - Thanks for the offer. Since our semester is starting now, I think we'll hold off on upgrading the full site to 2.0 for a while. Is there anything in particular that I could directly query the database records for that would identify the problematic records? I might be able to clean up the wikis while still running 1.9 so that it's ready for a seamless upgrade.
            Hide
            Martin Dougiamas added a comment -

            Jody if there's any way you can send us your database tables to look at (dongsheng@moodle.com) then it would really help us work out what to test for.

            Show
            Martin Dougiamas added a comment - Jody if there's any way you can send us your database tables to look at (dongsheng@moodle.com) then it would really help us work out what to test for.
            Hide
            Koen Roggemans added a comment - - edited

            The upgrade fails here too, not with a crash anymore, but with a long list of error messages.
            I see several different errors: write to database error, file path error (might be artefact in test environment, but weird that there are so many), bad data found

            EDIT: the file path is wrong of course, since this upgrade comes after the migration of the files to their new location

            I'll copy them here (sorry for the long list ) - but I have apparently no rights to attach a file.

            Migrating group type wiki instance: Vraag 7
            Migrating group type wiki instance: Vraag 8
            Migrating old wikis to new wikis
            Migrating old entries to new subwikis
            Migrating old pages to new pages
            Migrating old history to new history
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 332 of /mod/wiki/db/upgradelib.php: call to debugging()
            line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Error writing to database
            line 308 of /mod/wiki/locallib.php: call to debugging()
            line 277 of /mod/wiki/locallib.php: call to wiki_refresh_page_links()
            line 187 of /mod/wiki/db/upgrade.php: call to wiki_refresh_cachedcontent()
            line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade()
            line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
            line 1352 of /lib/upgradelib.php: call to upgrade_plugins()
            line 290 of /admin/index.php: call to upgrade_noncore()
            Caching content
            Bad data found: internal://Vlamkleuringen.doc
            Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/Vlamkleuringen.doc Please fix the bad file path manually.
            Bad data found: internal://Foto.doc
            Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/Foto.doc Please fix the bad file path manually.
            Bad data found: internal://kleuren_van_vlam.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/kleuren_van_vlam.jpg Please fix the bad file path manually.
            Bad data found: internal://vuurdriehoek.bmp
            Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/vuurdriehoek.bmp Please fix the bad file path manually.
            Bad data found: internal://naamloos.bmp
            Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/naamloos.bmp Please fix the bad file path manually.
            Bad data found: internal://emspectrum.gif
            Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/emspectrum.gif Please fix the bad file path manually.
            Bad data found: internal://schema_licht.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/schema_licht.jpg Please fix the bad file path manually.
            Bad data found: internal://BIOFILM_2.doc
            Expected file path: /var/moodledata/130/moddata/wiki/124/232/Verslag Dan valt tandenpoetsen nog mee.../BIOFILM_2.doc Please fix the bad file path manually.
            Bad data found: internal://Seminarie_Economie_Week_23.doc
            Expected file path: /var/moodledata/89/moddata/wiki/416/802//Seminarie_Economie_Week_23.doc Please fix the bad file path manually.
            Bad data found: internal://Werkmap-aspirine-2.doc
            Expected file path: /var/moodledata/130/moddata/wiki/162/272//Werkmap-aspirine-2.doc Please fix the bad file path manually.
            Bad data found: internal://180px-Aspirin.png
            Expected file path: /var/moodledata/130/moddata/wiki/162/272/Onderwerp en verslag : Aspirine/180px-Aspirin.png Please fix the bad file path manually.
            Bad data found: internal://180px-Aspirin-rod-povray.png
            Expected file path: /var/moodledata/130/moddata/wiki/162/272/Onderwerp en verslag : Aspirine/180px-Aspirin-rod-povray.png Please fix the bad file path manually.
            Bad data found: internal://3D_model_van_Aspirine.doc
            Expected file path: /var/moodledata/130/moddata/wiki/162/272/Onderwerp en verslag : Aspirine/3D_model_van_Aspirine.doc Please fix the bad file path manually.
            Bad data found: internal://Structuurformule_voor_Aspirine.doc
            Expected file path: /var/moodledata/130/moddata/wiki/162/272/Onderwerp en verslag : Aspirine/Structuurformule_voor_Aspirine.doc Please fix the bad file path manually.
            Bad data found: internal://afbeelding1.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/162/273/Onderwerp en verslag : Aspirine/afbeelding1.jpg Please fix the bad file path manually.
            Bad data found: internal://Werkmap-aspirine.doc
            Expected file path: /var/moodledata/130/moddata/wiki/162/273/Onderwerp en verslag : Aspirine/Werkmap-aspirine.doc Please fix the bad file path manually.
            Bad data found: internal://bronnen.doc
            Expected file path: /var/moodledata/130/moddata/wiki/162/273/Onderwerp en verslag : Aspirine/bronnen.doc Please fix the bad file path manually.
            Bad data found: internal://anoogbw.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../anoogbw.gif Please fix the bad file path manually.
            Bad data found: internal://Scannen0002.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../Scannen0002.jpg Please fix the bad file path manually.
            Bad data found: internal://recepfld.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../recepfld.gif Please fix the bad file path manually.
            Bad data found: internal://Zoek_20_20de_20zwarte_20stip_.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../Zoek_20_20de_20zwarte_20stip_.jpg Please fix the bad file path manually.
            Bad data found: internal://hermann1.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../hermann1.gif Please fix the bad file path manually.
            Bad data found: internal://HermExpl.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../HermExpl.gif Please fix the bad file path manually.
            Bad data found: internal://scgrid-redsquares.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../scgrid-redsquares.gif Please fix the bad file path manually.
            Bad data found: internal://sc50.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../sc50.jpg Please fix the bad file path manually.
            Bad data found: internal://fig291.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../fig291.gif Please fix the bad file path manually.
            Bad data found: internal://vissen.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../vissen.gif Please fix the bad file path manually.
            Bad data found: internal://ill-dot.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../ill-dot.jpg Please fix the bad file path manually.
            Bad data found: internal://Map1.xls
            Expected file path: /var/moodledata/130/moddata/wiki/161/276//Map1.xls Please fix the bad file path manually.
            Bad data found: internal://bio_optische_illusie.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../bio_optische_illusie.doc Please fix the bad file path manually.
            Bad data found: internal://gezichtsbedrogvb.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../gezichtsbedrogvb.doc Please fix the bad file path manually.
            Bad data found: internal://Met_kleur_gaat_het_dus_ook.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../Met_kleur_gaat_het_dus_ook.doc Please fix the bad file path manually.
            Bad data found: internal://gezichtsbedrog.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../gezichtsbedrog.gif Please fix the bad file path manually.
            Bad data found: internal://bangelijk_voorbeeld.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../bangelijk_voorbeeld.doc Please fix the bad file path manually.
            Bad data found: internal://gezichtsbedrog.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../gezichtsbedrog.doc Please fix the bad file path manually.
            Bad data found: internal://zeer_raar.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../zeer_raar.doc Please fix the bad file path manually.
            Bad data found: internal://hermann_grid_illusion.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../hermann_grid_illusion.gif Please fix the bad file path manually.
            Bad data found: internal://receptorvelden.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../receptorvelden.gif Please fix the bad file path manually.
            Bad data found: internal://visual_cortex.gif
            Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../visual_cortex.gif Please fix the bad file path manually.
            Bad data found: internal://optische_illusies.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/281/Wiki Een enge oogziekte.../optische_illusies.doc Please fix the bad file path manually.
            Bad data found: internal://gezichtsbedrog.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/281/Wiki Een enge oogziekte.../gezichtsbedrog.doc Please fix the bad file path manually.
            Bad data found: internal://MachBands.doc
            Expected file path: /var/moodledata/130/moddata/wiki/161/281/Wiki Een enge oogziekte.../MachBands.doc Please fix the bad file path manually.
            Bad data found: internal://mengsels_voor_kleuren.doc
            Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/mengsels_voor_kleuren.doc Please fix the bad file path manually.
            Bad data found: internal://Je_hebt_vele_soorten_vuurwerk.doc
            Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/Je_hebt_vele_soorten_vuurwerk.doc Please fix the bad file path manually.
            Bad data found: internal://vuurwerk.hslab.nl.doc
            Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/vuurwerk.hslab.nl.doc Please fix the bad file path manually.
            Bad data found: internal://elektromagnetische_golf.htm
            Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/elektromagnetische_golf.htm Please fix the bad file path manually.
            Bad data found: internal://spectrum-full_1_.png
            Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/spectrum-full_1_.png Please fix the bad file path manually.
            Bad data found: internal://VerslagVuurwerk.doc
            Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/VerslagVuurwerk.doc Please fix the bad file path manually.
            Bad data found: internal://test.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/236/394/Een zomerse vakantiedag.../test.jpg Please fix the bad file path manually.
            Bad data found: internal://thor.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/236/394/Een zomerse vakantiedag.../thor.jpg Please fix the bad file path manually.
            Bad data found: internal://bliksem1.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/236/394/Een zomerse vakantiedag.../bliksem1.jpg Please fix the bad file path manually.
            Bad data found: internal://bliskem2.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/236/394/Een zomerse vakantiedag.../bliskem2.jpg Please fix the bad file path manually.
            Bad data found: internal://400px-Adhesie-Cohesie.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/286/470/verslag : chemiekit/400px-Adhesie-Cohesie.jpg Please fix the bad file path manually.
            Bad data found: internal://virus-human-lytic.gif
            Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/virus-human-lytic.gif Please fix the bad file path manually.
            Bad data found: internal://h5n1.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/h5n1.jpg Please fix the bad file path manually.
            Bad data found: internal://grieppandemie2.gif
            Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/grieppandemie2.gif Please fix the bad file path manually.
            Bad data found: internal://Folder.doc
            Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/Folder.doc Please fix the bad file path manually.
            Bad data found: internal://Se.FolderVogelgriep.doc
            Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/Se.FolderVogelgriep.doc Please fix the bad file path manually.
            Bad data found: internal://BSE.doc
            Expected file path: /var/moodledata/130/moddata/wiki/332/634/Gekke koeien?/BSE.doc Please fix the bad file path manually.
            Bad data found: internal://Gekke_koeien.doc
            Expected file path: /var/moodledata/130/moddata/wiki/332/634/Gekke koeien?/Gekke_koeien.doc Please fix the bad file path manually.
            Bad data found: internal://folder.doc
            Expected file path: /var/moodledata/130/moddata/wiki/332/634/Gekke koeien?/folder.doc Please fix the bad file path manually.
            Bad data found: internal://tt.doc
            Expected file path: /var/moodledata/130/moddata/wiki/332/634/Gekke koeien?/tt.doc Please fix the bad file path manually.
            Bad data found: internal://5_4_a.jpg
            Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../5_4_a.jpg Please fix the bad file path manually.
            Bad data found: internal://Broeikasgastoename1850-2000.png
            Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../Broeikasgastoename1850-2000.png Please fix the bad file path manually.
            Bad data found: internal://Trends_gassen_ozonlaag.png
            Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../Trends_gassen_ozonlaag.png Please fix the bad file path manually.
            Bad data found: internal://foto_sbroeikaseffect.doc
            Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../foto_sbroeikaseffect.doc Please fix the bad file path manually.
            Bad data found: internal://Figuur_1_Concentraties_van_koolstofdioxide_methaan_en_distikstofoxide.doc
            Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../Figuur_1_Concentraties_van_koolstofdioxide_methaan_en_distikstofoxide.doc Please fix the bad file path manually.
            Cleaning wiki table
            Updating comments and tags
            Updating tags itemtype
            Success

            Show
            Koen Roggemans added a comment - - edited The upgrade fails here too, not with a crash anymore, but with a long list of error messages. I see several different errors: write to database error, file path error (might be artefact in test environment, but weird that there are so many), bad data found EDIT: the file path is wrong of course, since this upgrade comes after the migration of the files to their new location I'll copy them here (sorry for the long list ) - but I have apparently no rights to attach a file. Migrating group type wiki instance: Vraag 7 Migrating group type wiki instance: Vraag 8 Migrating old wikis to new wikis Migrating old entries to new subwikis Migrating old pages to new pages Migrating old history to new history Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 332 of /mod/wiki/db/upgradelib.php: call to debugging() line 175 of /mod/wiki/db/upgrade.php: call to wiki_upgrade_migrate_versions() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Error writing to database line 308 of /mod/wiki/locallib.php: call to debugging() line 277 of /mod/wiki/locallib.php: call to wiki_refresh_page_links() line 187 of /mod/wiki/db/upgrade.php: call to wiki_refresh_cachedcontent() line 490 of /lib/upgradelib.php: call to xmldb_wiki_upgrade() line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules() line 1352 of /lib/upgradelib.php: call to upgrade_plugins() line 290 of /admin/index.php: call to upgrade_noncore() Caching content Bad data found: internal://Vlamkleuringen.doc Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/Vlamkleuringen.doc Please fix the bad file path manually. Bad data found: internal://Foto.doc Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/Foto.doc Please fix the bad file path manually. Bad data found: internal://kleuren_van_vlam.jpg Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/kleuren_van_vlam.jpg Please fix the bad file path manually. Bad data found: internal://vuurdriehoek.bmp Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/vuurdriehoek.bmp Please fix the bad file path manually. Bad data found: internal://naamloos.bmp Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/naamloos.bmp Please fix the bad file path manually. Bad data found: internal://emspectrum.gif Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/emspectrum.gif Please fix the bad file path manually. Bad data found: internal://schema_licht.jpg Expected file path: /var/moodledata/130/moddata/wiki/306/518/verslag : in vuur en vlam/schema_licht.jpg Please fix the bad file path manually. Bad data found: internal://BIOFILM_2.doc Expected file path: /var/moodledata/130/moddata/wiki/124/232/Verslag Dan valt tandenpoetsen nog mee.../BIOFILM_2.doc Please fix the bad file path manually. Bad data found: internal://Seminarie_Economie_Week_23.doc Expected file path: /var/moodledata/89/moddata/wiki/416/802//Seminarie_Economie_Week_23.doc Please fix the bad file path manually. Bad data found: internal://Werkmap-aspirine-2.doc Expected file path: /var/moodledata/130/moddata/wiki/162/272//Werkmap-aspirine-2.doc Please fix the bad file path manually. Bad data found: internal://180px-Aspirin.png Expected file path: /var/moodledata/130/moddata/wiki/162/272/Onderwerp en verslag : Aspirine/180px-Aspirin.png Please fix the bad file path manually. Bad data found: internal://180px-Aspirin-rod-povray.png Expected file path: /var/moodledata/130/moddata/wiki/162/272/Onderwerp en verslag : Aspirine/180px-Aspirin-rod-povray.png Please fix the bad file path manually. Bad data found: internal://3D_model_van_Aspirine.doc Expected file path: /var/moodledata/130/moddata/wiki/162/272/Onderwerp en verslag : Aspirine/3D_model_van_Aspirine.doc Please fix the bad file path manually. Bad data found: internal://Structuurformule_voor_Aspirine.doc Expected file path: /var/moodledata/130/moddata/wiki/162/272/Onderwerp en verslag : Aspirine/Structuurformule_voor_Aspirine.doc Please fix the bad file path manually. Bad data found: internal://afbeelding1.jpg Expected file path: /var/moodledata/130/moddata/wiki/162/273/Onderwerp en verslag : Aspirine/afbeelding1.jpg Please fix the bad file path manually. Bad data found: internal://Werkmap-aspirine.doc Expected file path: /var/moodledata/130/moddata/wiki/162/273/Onderwerp en verslag : Aspirine/Werkmap-aspirine.doc Please fix the bad file path manually. Bad data found: internal://bronnen.doc Expected file path: /var/moodledata/130/moddata/wiki/162/273/Onderwerp en verslag : Aspirine/bronnen.doc Please fix the bad file path manually. Bad data found: internal://anoogbw.gif Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../anoogbw.gif Please fix the bad file path manually. Bad data found: internal://Scannen0002.jpg Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../Scannen0002.jpg Please fix the bad file path manually. Bad data found: internal://recepfld.gif Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../recepfld.gif Please fix the bad file path manually. Bad data found: internal://Zoek_20_20de_20zwarte_20stip_.jpg Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../Zoek_20_20de_20zwarte_20stip_.jpg Please fix the bad file path manually. Bad data found: internal://hermann1.gif Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../hermann1.gif Please fix the bad file path manually. Bad data found: internal://HermExpl.gif Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../HermExpl.gif Please fix the bad file path manually. Bad data found: internal://scgrid-redsquares.gif Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../scgrid-redsquares.gif Please fix the bad file path manually. Bad data found: internal://sc50.jpg Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../sc50.jpg Please fix the bad file path manually. Bad data found: internal://fig291.gif Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../fig291.gif Please fix the bad file path manually. Bad data found: internal://vissen.gif Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../vissen.gif Please fix the bad file path manually. Bad data found: internal://ill-dot.jpg Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../ill-dot.jpg Please fix the bad file path manually. Bad data found: internal://Map1.xls Expected file path: /var/moodledata/130/moddata/wiki/161/276//Map1.xls Please fix the bad file path manually. Bad data found: internal://bio_optische_illusie.doc Expected file path: /var/moodledata/130/moddata/wiki/161/276/Wiki Een enge oogziekte.../bio_optische_illusie.doc Please fix the bad file path manually. Bad data found: internal://gezichtsbedrogvb.doc Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../gezichtsbedrogvb.doc Please fix the bad file path manually. Bad data found: internal://Met_kleur_gaat_het_dus_ook.doc Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../Met_kleur_gaat_het_dus_ook.doc Please fix the bad file path manually. Bad data found: internal://gezichtsbedrog.gif Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../gezichtsbedrog.gif Please fix the bad file path manually. Bad data found: internal://bangelijk_voorbeeld.doc Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../bangelijk_voorbeeld.doc Please fix the bad file path manually. Bad data found: internal://gezichtsbedrog.doc Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../gezichtsbedrog.doc Please fix the bad file path manually. Bad data found: internal://zeer_raar.doc Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../zeer_raar.doc Please fix the bad file path manually. Bad data found: internal://hermann_grid_illusion.gif Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../hermann_grid_illusion.gif Please fix the bad file path manually. Bad data found: internal://receptorvelden.gif Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../receptorvelden.gif Please fix the bad file path manually. Bad data found: internal://visual_cortex.gif Expected file path: /var/moodledata/130/moddata/wiki/161/278/Wiki Een enge oogziekte.../visual_cortex.gif Please fix the bad file path manually. Bad data found: internal://optische_illusies.doc Expected file path: /var/moodledata/130/moddata/wiki/161/281/Wiki Een enge oogziekte.../optische_illusies.doc Please fix the bad file path manually. Bad data found: internal://gezichtsbedrog.doc Expected file path: /var/moodledata/130/moddata/wiki/161/281/Wiki Een enge oogziekte.../gezichtsbedrog.doc Please fix the bad file path manually. Bad data found: internal://MachBands.doc Expected file path: /var/moodledata/130/moddata/wiki/161/281/Wiki Een enge oogziekte.../MachBands.doc Please fix the bad file path manually. Bad data found: internal://mengsels_voor_kleuren.doc Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/mengsels_voor_kleuren.doc Please fix the bad file path manually. Bad data found: internal://Je_hebt_vele_soorten_vuurwerk.doc Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/Je_hebt_vele_soorten_vuurwerk.doc Please fix the bad file path manually. Bad data found: internal://vuurwerk.hslab.nl.doc Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/vuurwerk.hslab.nl.doc Please fix the bad file path manually. Bad data found: internal://elektromagnetische_golf.htm Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/elektromagnetische_golf.htm Please fix the bad file path manually. Bad data found: internal://spectrum-full_1_.png Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/spectrum-full_1_.png Please fix the bad file path manually. Bad data found: internal://VerslagVuurwerk.doc Expected file path: /var/moodledata/130/moddata/wiki/193/328/Verslag : Vuurwerk/VerslagVuurwerk.doc Please fix the bad file path manually. Bad data found: internal://test.jpg Expected file path: /var/moodledata/130/moddata/wiki/236/394/Een zomerse vakantiedag.../test.jpg Please fix the bad file path manually. Bad data found: internal://thor.jpg Expected file path: /var/moodledata/130/moddata/wiki/236/394/Een zomerse vakantiedag.../thor.jpg Please fix the bad file path manually. Bad data found: internal://bliksem1.jpg Expected file path: /var/moodledata/130/moddata/wiki/236/394/Een zomerse vakantiedag.../bliksem1.jpg Please fix the bad file path manually. Bad data found: internal://bliskem2.jpg Expected file path: /var/moodledata/130/moddata/wiki/236/394/Een zomerse vakantiedag.../bliskem2.jpg Please fix the bad file path manually. Bad data found: internal://400px-Adhesie-Cohesie.jpg Expected file path: /var/moodledata/130/moddata/wiki/286/470/verslag : chemiekit/400px-Adhesie-Cohesie.jpg Please fix the bad file path manually. Bad data found: internal://virus-human-lytic.gif Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/virus-human-lytic.gif Please fix the bad file path manually. Bad data found: internal://h5n1.jpg Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/h5n1.jpg Please fix the bad file path manually. Bad data found: internal://grieppandemie2.gif Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/grieppandemie2.gif Please fix the bad file path manually. Bad data found: internal://Folder.doc Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/Folder.doc Please fix the bad file path manually. Bad data found: internal://Se.FolderVogelgriep.doc Expected file path: /var/moodledata/130/moddata/wiki/304/522/Weerloos tegen de pandemie?/Se.FolderVogelgriep.doc Please fix the bad file path manually. Bad data found: internal://BSE.doc Expected file path: /var/moodledata/130/moddata/wiki/332/634/Gekke koeien?/BSE.doc Please fix the bad file path manually. Bad data found: internal://Gekke_koeien.doc Expected file path: /var/moodledata/130/moddata/wiki/332/634/Gekke koeien?/Gekke_koeien.doc Please fix the bad file path manually. Bad data found: internal://folder.doc Expected file path: /var/moodledata/130/moddata/wiki/332/634/Gekke koeien?/folder.doc Please fix the bad file path manually. Bad data found: internal://tt.doc Expected file path: /var/moodledata/130/moddata/wiki/332/634/Gekke koeien?/tt.doc Please fix the bad file path manually. Bad data found: internal://5_4_a.jpg Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../5_4_a.jpg Please fix the bad file path manually. Bad data found: internal://Broeikasgastoename1850-2000.png Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../Broeikasgastoename1850-2000.png Please fix the bad file path manually. Bad data found: internal://Trends_gassen_ozonlaag.png Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../Trends_gassen_ozonlaag.png Please fix the bad file path manually. Bad data found: internal://foto_sbroeikaseffect.doc Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../foto_sbroeikaseffect.doc Please fix the bad file path manually. Bad data found: internal://Figuur_1_Concentraties_van_koolstofdioxide_methaan_en_distikstofoxide.doc Expected file path: /var/moodledata/130/moddata/wiki/412/791/Verslag b Eindelijk zon..../Figuur_1_Concentraties_van_koolstofdioxide_methaan_en_distikstofoxide.doc Please fix the bad file path manually. Cleaning wiki table Updating comments and tags Updating tags itemtype Success
            Hide
            Koen Roggemans added a comment -

            I spent some time investigating course 130 (both 1.9 site and upgraded site) where all the errors I can track down happen. There seem to be things wrong in the 1.9 site. Also the course is deserted (no teachers) May be someone hit the reset button and that went wrong, I don't know.

            I suggest to spend no time on this issue, unless there is something to learn there for the broad picture. Especially the write to database errors seem like they shouldn't happen.

            Show
            Koen Roggemans added a comment - I spent some time investigating course 130 (both 1.9 site and upgraded site) where all the errors I can track down happen. There seem to be things wrong in the 1.9 site. Also the course is deserted (no teachers) May be someone hit the reset button and that went wrong, I don't know. I suggest to spend no time on this issue, unless there is something to learn there for the broad picture. Especially the write to database errors seem like they shouldn't happen.
            Hide
            Dongsheng Cai added a comment -

            Koen, thanks for inspection.

            The "write to database errors" error is because there is binary data in the record, it is rejected by database, we didn't display more because when running the upgrade in cli, the binary data dump could kill the terminal.

            Show
            Dongsheng Cai added a comment - Koen, thanks for inspection. The "write to database errors" error is because there is binary data in the record, it is rejected by database, we didn't display more because when running the upgrade in cli, the binary data dump could kill the terminal.
            Hide
            Dongsheng Cai added a comment -

            re-submitted pull request, under review.

            Show
            Dongsheng Cai added a comment - re-submitted pull request, under review.
            Hide
            Eloy Lafuente (stronk7) added a comment -

            After reviewing and some very-basic testing I've integrated this. Tomorrow more complex tests should arrive. Ciao

            Show
            Eloy Lafuente (stronk7) added a comment - After reviewing and some very-basic testing I've integrated this. Tomorrow more complex tests should arrive. Ciao
            Hide
            Petr Skoda added a comment -

            Closing, the patch will be in the next weekly. If there are any remaining problems please file new tracker issues.

            Thanks everybody.

            Show
            Petr Skoda added a comment - Closing, the patch will be in the next weekly. If there are any remaining problems please file new tracker issues. Thanks everybody.

              People

              • Votes:
                11 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: