Book in 2.3

Book in 2.3

by Nigel Irwin -
Number of replies: 8

Hi when I add a new book resource to a course i get this error whn i go to save.

 

Debug info: Field 'summary' doesn't have a default value
INSERT INTO mdl_book (name,numbering,course,timecreated,timemodified,customtitles) VALUES(?,?,?,?,?,?)
[array (
0 => 'crm',
1 => '1',
2 => '111',
3 => 1343384561,
4 => 1343384561,
5 => 0,
)] 
Error code: dmlwriteexception
Stack trace:
  • line 410 of \lib\dml\moodle_database.php: dml_write_exception thrown
  • line 948 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 990 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
  • line 69 of \mod\book\lib.php: call to mysqli_native_moodle_database->insert_record()
  • line 447 of \course\modedit.php: call to book_add_instance()
 Any suggestions. Have restarted mysql without any difference.
Average of ratings: -
In reply to Nigel Irwin

Re: Book in 2.3

by Nigel Irwin -

OK finally solved this by uninstalling Book activity and allowing it to reinstall itself

In reply to Nigel Irwin

Re: Book in 2.3

by Conrad Allen -

When you uninstall, doesn't it wipe out all the data with it (pre-existing books)?

In reply to Nigel Irwin

Re: Book in 2.3

by Nigel Irwin -

However a question. Is there any way to resize a media file inside the Book?

In reply to Nigel Irwin

Re: Book in 2.3

by Paul Langdon -

Nigel

when I convert from an AVI to an FLV so I can insert it into a book I use the pixel size feature of the free software that I use. 

its really easy and when I set it to 200X200 the video clip fits a treat into the book. When I get into work tomorrow I'll get back on here and tell you the name of the free software I use (it's a cinch to use)

 

Paul