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
    • Rank (Obsolete):
      15643

      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

        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: