Moodle
  1. Moodle
  2. MDL-33607

Add new wiki page - error writing to database

        Details

        • Type: Bug Bug
        • Status: Closed
        • Priority: Blocker Blocker
        • Resolution: Fixed
        • Affects Version/s: 2.3
        • Fix Version/s: 2.1.7, 2.2.4
        • Component/s: Wiki (2.x)
        • Labels:
          None
        • Testing Instructions:
          Hide

          1. Add a new wiki activity
          2. Default format: HTML; Force format: Select
          3. Save a display
          4. Add some content to first page and include a word or phrase in [[double square brackets]]
          5. Save
          6. Select the red italicised text in [[double square brackets]]
          7. Make sure you don't get any error and can create page

          Show
          1. Add a new wiki activity 2. Default format: HTML; Force format: Select 3. Save a display 4. Add some content to first page and include a word or phrase in [ [double square brackets] ] 5. Save 6. Select the red italicised text in [ [double square brackets] ] 7. Make sure you don't get any error and can create page
        • Affected Branches:
          MOODLE_23_STABLE
        • Fixed Branches:
          MOODLE_21_STABLE, MOODLE_22_STABLE
        • Pull from Repository:
        • Pull Master Branch:
          wip-mdl-33607
        • Pull Master Diff URL:
        • Rank:
          41547

          Description

          Hi,

          I couldn't find a relevant 2.3 QA test for this but just came across this.

          Error writing to database

          Debug info: Duplicate entry '1-0-0' for key 'mdl_wikisubw_wikgrouse_uix'
          INSERT INTO mdl_wiki_subwikis (wikiid,groupid,userid) VALUES(?,?,?)
          [array (
          0 => '1',
          1 => '0',
          2 => '0',
          )]
          Error code: dmlwriteexception
          Stack trace:
          line 416 of /lib/dml/moodle_database.php: dml_write_exception thrown
          line 952 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
          line 994 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
          line 104 of /mod/wiki/locallib.php: call to mysqli_native_moodle_database->insert_record()
          line 950 of /mod/wiki/pagelib.php: call to wiki_add_subwiki()
          line 115 of /mod/wiki/create.php: call to page_wiki_create->create_page()

          —

          Steps to replicate:

          1. Add a new wiki activity
          2. Default format: HTML; Force format: Select
          3. Save a display
          4. Add some content to first page and include a word or phrase in [[double square brackets]]
          5. Save
          6. Select the red italicised text in [[double square brackets]]

            Issue Links

            has been marked as being related by

            Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-35146 Restore of wiki fails with unique constraint violation

            • Minor - Minor loss of function where workaround is possible
            • Closed
            is a regression caused by

            Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-30478 Wiki groups wierd behaviour

            • Major - Major loss of function, incorrect output
            • Closed
            is duplicated by

            Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-33491 Wiki module does not work if you activate the force format option

            • Major - Major loss of function, incorrect output
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              Roger Myers added a comment -

              I have the same problem.

              Running:
              MOODLE version 2.2.2
              PHP version 5.3.6.13.3.7
              MYSQL Version 5.1.62.0.0.11.10.1
              UBUNTU 11.10

              I am about to update everything. Will post back if this fixes

              regards

              Roger Myers

              Show
              Roger Myers added a comment - I have the same problem. Running: MOODLE version 2.2.2 PHP version 5.3.6.13.3.7 MYSQL Version 5.1.62.0.0.11.10.1 UBUNTU 11.10 I am about to update everything. Will post back if this fixes regards Roger Myers
              Hide
              Permalink
              Roger Myers added a comment -

              Updated UBUNTU server to 12.04 - still not working!

              Help

              Show
              Roger Myers added a comment - Updated UBUNTU server to 12.04 - still not working! Help
              Hide
              Permalink
              Rajesh Taneja added a comment - - edited

              Thanks for reporting this issue Roger and Chad.

              Note:
              Currently we don't set userid in wiki_subwikis, will open another issue to understand what is happening there.

              Show
              Rajesh Taneja added a comment - - edited Thanks for reporting this issue Roger and Chad. Note: Currently we don't set userid in wiki_subwikis, will open another issue to understand what is happening there.
              Hide
              Permalink
              Jason Fowler added a comment -

              code looks good, good to go

              Show
              Jason Fowler added a comment - code looks good, good to go
              Hide
              Permalink
              Dan Poltawski added a comment -

              Just linking MDL-30478, as seems likely to be a regession frm that.

              Show
              Dan Poltawski added a comment - Just linking MDL-30478 , as seems likely to be a regession frm that.
              Hide
              Permalink
              Dan Poltawski added a comment -

              Thanks Raj.

              I've integrated and tested this now.

              Show
              Dan Poltawski added a comment - Thanks Raj. I've integrated and tested this now.
              Hide
              Permalink
              Eloy Lafuente (stronk7) added a comment -

              And this has been spread to every git and cvs repository out there, just in time to roll Moodle 2.3beta!

              Thanks! Closing, ciao

              Show
              Eloy Lafuente (stronk7) added a comment - And this has been spread to every git and cvs repository out there, just in time to roll Moodle 2.3beta! Thanks! Closing, ciao

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: