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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • STABLE backlog
    • 2.0.3
    • Blog
    • CentOS 6.0,php 5.3.2, mysql 5.1, moodle 2.0.3
    • MySQL
    • MOODLE_20_STABLE
    • 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.

      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.

            phalacee Jason Fowler
            yusuke2000 Qiuchengxuan
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.