Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-28638

Data too long for column "uniquehash" problem while fetch external blog in cron.php

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.3
    • Fix Version/s: STABLE backlog
    • Component/s: Blog
    • Labels:
    • Environment:
      CentOS 6.0,php 5.3.2, mysql 5.1, moodle 2.0.3
    • Database:
      MySQL
    • Testing Instructions:
      Hide

      Registering my blog in moodle is OK,but after I wrote a new post then do a cronjob this problem occured.I'm sorry that I don't exactly know why this happened.Since I'm using mysql 5.1 it should not be uniquehash value is too long.

      Show
      Registering my blog in moodle is OK,but after I wrote a new post then do a cronjob this problem occured.I'm sorry that I don't exactly know why this happened.Since I'm using mysql 5.1 it should not be uniquehash value is too long.
    • Affected Branches:
      MOODLE_20_STABLE

      Description

      I have a private Chinese blog using date+subject permlink style(http://domian/2011/08/07/SubjectInChinese/) as url and added it into my moodle profile as a external blog,but when updating external blog posts in cron.php this problem occurred, it says "Data too long for column "uniquehash" in row 1" when I enabled showing developing information.If i change permlink to numeric style(http://qiuchengxuan.tk/archives/123) this problem does not occur any more.
      Our moodle database use utf8 as database char set.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  1 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: