Loading...

XML

Word

Printable

Database:

Any, MySQL
Affected Branches:
MOODLE_21_STABLE
Fixed Branches:
MOODLE_21_STABLE, MOODLE_22_STABLE
Pull from Repository:
git://github.com/rajeshtaneja/moodle.git
Pull Main Branch:
wip-mdl-29254
Pull Main Diff URL:
https://github.com/rajeshtaneja/moodle/compare/master...wip-mdl-29254
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;
Testing Instructions:
Hide

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.
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.

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

has a non-specific relationship to

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

Participants:: Eloy Lafuente (stronk7), Gerard Caulfield, Jason Fowler, Jim Peterson, Juan Segarra Montesinos, Michael de Raadt, Rajesh Taneja, Sam Hemelryk