Moodle

Add new wiki page - error writing to database

Details

  • Type: Bug Bug
  • Status: Closed 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:

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 - The issue is considered finished, the resolution is correct. Issues which are closed should not be reopened.
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 - The issue is considered finished, the resolution is correct. Issues which are closed should not be reopened.
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 - The issue is considered finished, the resolution is correct. Issues which are closed should not be reopened.

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

Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: