Moodle
  1. Moodle
  2. MDL-29254

Cannot add new blog entries after update

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.1.1
    • Fix Version/s: 2.1.5, 2.2.2
    • Component/s: Blog
    • Labels:
    • Database:
      Any, MySQL
    • Testing Instructions:
      Hide
      1. Log in as admin
      2. Add new blog entry (Home -> My profile -> Blogs -> Add a new entry)
      3. make sure you don't get any error
      4. Add external blog in your profile http://feeds.feedburner.com/ElBlogDeEnriqueDans (Settings -> Blogs -> External blogs)
      5. Run Cron
      6. make sure you don't get any error
        NOTE: check php error log as well.
      Show
      Log in as admin Add new blog entry (Home -> My profile -> Blogs -> Add a new entry) make sure you don't get any error Add external blog in your profile http://feeds.feedburner.com/ElBlogDeEnriqueDans (Settings -> Blogs -> External blogs) Run Cron make sure you don't get any error NOTE: check php error log as well.
    • Workaround:
      Hide

      Everything gets solved by issuing:

      mysql> alter table mdl_post MODIFY COLUMN summary longtext;
      mysql> alter table mdl_post MODIFY COLUMN content longtext;
      
      Show
      Everything gets solved by issuing: mysql> alter table mdl_post MODIFY COLUMN summary longtext; mysql> alter table mdl_post MODIFY COLUMN content longtext;
    • Affected Branches:
      MOODLE_21_STABLE
    • Fixed Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE
    • Pull Master Branch:
      wip-mdl-29254
    • Rank:
      18796

      Description

      I've done an update from moodle 1.9.12 to moodle 2.1.1

      When I try to add a new entry blog I get an 'Error writing to database'.

      What error log says is something like this:

      [Tue Sep 06 13:48:56 2011] [error] Default exception handler: Error writing to database Debug: Column 'summary' cannot be null
      
      bla,bla,bla... :)
      
       line 186 of /blog/edit.php: call to blog_entry->add()
      , referer: http://moodle2.cleome.uji.es:81/blog/edit.php?action=add
      

      Problem is that after the update column summary and content stays defined as NOT NULL (as defined un my 1.9.x installation).

      I've seen xmldb definition and this two fields are not defined as NOT NULL (in 1.9.x too)... so maybe this problem comes from an earlier update.

      Maybe someone has the same problem...

      Regards

        Issue Links

          Activity

          Juan Segarra Montesinos created issue -
          Michael de Raadt made changes -
          Field Original Value New Value
          Link This issue has a non-specific relationship to MDL-28638 [ MDL-28638 ]
          Michael de Raadt made changes -
          Fix Version/s STABLE backlog [ 10463 ]
          Description I've done an update from moodle 1.9.12 to moodle 2.1.1

          When I try to add a new entry blog I get an 'Error writing to database'.

          What error log says is something like this:

          {noformat}
          [Tue Sep 06 13:48:56 2011] [error] Default exception handler: Error writing to database Debug: Column 'summary' cannot be null

          bla,bla,bla... :)

           line 186 of /blog/edit.php: call to blog_entry->add()
          , referer: http://moodle2.cleome.uji.es:81/blog/edit.php?action=add
          {noformat}

          Problem is that after the update column summary and content stays defined as NOT NULL (as defined un my 1.9.x installation).

          I've seen xmldb definition and this two fields are not defined as NOT NULL (in 1.9.x too)... so maybe this problem comes from an earlier update.

          Everything gets solved by issuing:

          {noformat}
          mysql> alter table mdl_post MODIFY COLUMN summary longtext;
          mysql> alter table mdl_post MODIFY COLUMN content longtext;
          {noformat}

          Maybe someone has the same problem...

          Regards :)
          I've done an update from moodle 1.9.12 to moodle 2.1.1

          When I try to add a new entry blog I get an 'Error writing to database'.

          What error log says is something like this:

          {noformat}
          [Tue Sep 06 13:48:56 2011] [error] Default exception handler: Error writing to database Debug: Column 'summary' cannot be null

          bla,bla,bla... :)

           line 186 of /blog/edit.php: call to blog_entry->add()
          , referer: http://moodle2.cleome.uji.es:81/blog/edit.php?action=add
          {noformat}

          Problem is that after the update column summary and content stays defined as NOT NULL (as defined un my 1.9.x installation).

          I've seen xmldb definition and this two fields are not defined as NOT NULL (in 1.9.x too)... so maybe this problem comes from an earlier update.

          Maybe someone has the same problem...

          Regards :)
          Workaround
          Everything gets solved by issuing:

          {noformat}
          mysql> alter table mdl_post MODIFY COLUMN summary longtext;
          mysql> alter table mdl_post MODIFY COLUMN content longtext;
          {noformat}
          Labels patch triaged
          Jason Fowler made changes -
          Assignee moodle.com [ moodle.com ] Jason Fowler [ phalacee ]
          Jason Fowler made changes -
          Fix Version/s STABLE Sprint 17 [ 11550 ]
          Fix Version/s STABLE backlog [ 10463 ]
          Workaround
          Everything gets solved by issuing:

          {noformat}
          mysql> alter table mdl_post MODIFY COLUMN summary longtext;
          mysql> alter table mdl_post MODIFY COLUMN content longtext;
          {noformat}
          Everything gets solved by issuing:

          {noformat}
          mysql> alter table mdl_post MODIFY COLUMN summary longtext;
          mysql> alter table mdl_post MODIFY COLUMN content longtext;
          {noformat}
          Jason Fowler made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Resolution Duplicate [ 3 ]
          Rajesh Taneja made changes -
          Resolution Duplicate [ 3 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Assignee Jason Fowler [ phalacee ] Rajesh Taneja [ rajeshtaneja ]
          Rajesh Taneja made changes -
          Priority Minor [ 4 ] Blocker [ 1 ]
          Rajesh Taneja made changes -
          Status Reopened [ 4 ] Development in progress [ 3 ]
          Rajesh Taneja made changes -
          Pull Master Diff URL https://github.com/rajeshtaneja/moodle/compare/master...wip-mdl-29254
          Pull Master Branch wip-mdl-29254
          Pull 2.2 Diff URL https://github.com/rajeshtaneja/moodle/compare/MOODLE_22_STABLE...wip-mdl-29254-m22
          Pull 2.1 Branch wip-mdl-29254-m21
          Pull 2.2 Branch wip-mdl-29254-m22
          Pull 2.1 Diff URL https://github.com/rajeshtaneja/moodle/compare/MOODLE_21_STABLE...wip-mdl-29254-m21
          Pull from Repository git://github.com/rajeshtaneja/moodle.git
          Rajesh Taneja made changes -
          Status Development in progress [ 3 ] Waiting for peer review [ 10012 ]
          Rajesh Taneja made changes -
          Testing Instructions # Log in as admin
          # Add new blog entry (My home -> My profile -> Blogs -> Add a new entry)
          # make sure you don't get any error
          # Add external blog in your profile http://feeds.feedburner.com/ElBlogDeEnriqueDans (Settings -> Blogs -> External blogs)
          # Run Cron
          # make sure you don't get any error
          NOTE: check php error log as well.
          Rajesh Taneja made changes -
          Peer reviewer phalacee
          Jason Fowler made changes -
          Original Estimate 0 minutes [ 0 ]
          Remaining Estimate 0 minutes [ 0 ]
          Status Waiting for peer review [ 10012 ] Peer review in progress [ 10013 ]
          Jason Fowler made changes -
          Status Peer review in progress [ 10013 ] Development in progress [ 3 ]
          Rajesh Taneja made changes -
          Status Development in progress [ 3 ] Waiting for integration review [ 10010 ]
          Sam Hemelryk made changes -
          Currently in integration Yes [ 10041 ]
          Sam Hemelryk made changes -
          Status Waiting for integration review [ 10010 ] Integration review in progress [ 10004 ]
          Integrator samhemelryk
          Sam Hemelryk made changes -
          Status Integration review in progress [ 10004 ] Waiting for testing [ 10005 ]
          Fix Version/s 2.1.5 [ 11553 ]
          Fix Version/s 2.2.2 [ 11552 ]
          Michael de Raadt made changes -
          Tester gerry
          Gerard Caulfield made changes -
          Testing Instructions # Log in as admin
          # Add new blog entry (My home -> My profile -> Blogs -> Add a new entry)
          # make sure you don't get any error
          # Add external blog in your profile http://feeds.feedburner.com/ElBlogDeEnriqueDans (Settings -> Blogs -> External blogs)
          # Run Cron
          # make sure you don't get any error
          NOTE: check php error log as well.
          # Log in as admin
          # Add new blog entry (Home -> My profile -> Blogs -> Add a new entry)
          # make sure you don't get any error
          # Add external blog in your profile http://feeds.feedburner.com/ElBlogDeEnriqueDans (Settings -> Blogs -> External blogs)
          # Run Cron
          # make sure you don't get any error
          NOTE: check php error log as well.
          Gerard Caulfield made changes -
          Status Waiting for testing [ 10005 ] Testing in progress [ 10011 ]
          Gerard Caulfield made changes -
          Status Testing in progress [ 10011 ] Tested [ 10006 ]
          Eloy Lafuente (stronk7) made changes -
          Status Tested [ 10006 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Currently in integration Yes [ 10041 ]
          Integration date 23/Feb/12
          Eloy Lafuente (stronk7) made changes -
          Fix Version/s STABLE Sprint 17 [ 11550 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved: