I have commited several small fixes into 1.5 compatible version, you can find more info in the readme.txt file.
Current code is not fully compatible with 1.6 codebase, I will update it next week and store it in contrib/book_16 directory.
skodak
You can download the latest alpha for 1.6dev from: http://download.moodle.org/download.php/modules/book_16.zip
Installation:
skodak
Installation:
- do a full db backup, moddata backup and dirroot backup
- upgrade db to 4.1.x
- upgrade moodle to 1.6dev
- delete old mod/book/*.*
- extract downloaded zip from above into your mod/
- rename book_16 to book
- convert site to unicode - expect problems with not iso-8859-1 encodings
skodak
I haven't been able to upgrade to the latest 1.5 version because I am still running 1.5 Moodle, but there is one thing that it would be nice if you could fix it if it hasn't been already but that is to add the ability to hide a chapter when it is first created rather than have to create it and then click on the eye afterwards to hide it.
Sorry mates
I'm feeling kind of stupit right now.
You say it works fine for you, so I think what's the diffrence?
Well it's kind of obvious "the Language".....
So I think I should take look at lang.php and there it is en_utf8 is hardcoded there I think for comparing to others.
So I think, Oh I have to put book.php in en_utf8 also.
To check this I just loaded book.php manually in adminlang, and there it is "error cant find c:\...../lang/en_utf8/book.php".
So this has nothing to do with the wonderful Book mod.
Thought you should know.
Sometimes better to try to use the small peanut op there before asking stupid questions.
Thanks for the replies.
Installing a fresh copy of Book on a copy of Moodle16 (23 may 2006) I get this during install. The error in the mdl_log_display table is caused by a change in this table structure? - It was working fine in a early version of moodle 1.6.
Is this table used for building the log-files or so? Has everyone to change this in his own additional modules?
(mysql): CREATE TABLE mdl_book ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, course INT(10) UNSIGNED NOT NULL DEFAULT '0', name VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL DEFAULT '', numbering TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', disableprinting TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', customtitles TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', timecreated INT(10) UNSIGNED NOT NULL DEFAULT '0', timemodified INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id)) COMMENT='Defines book'
(mysql): CREATE TABLE mdl_book_chapters ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, bookid INT(10) UNSIGNED NOT NULL DEFAULT '0', pagenum INT(10) UNSIGNED NOT NULL DEFAULT '0', subchapter TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', title VARCHAR(255) NOT NULL DEFAULT '', content LONGTEXT NOT NULL DEFAULT '', hidden TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', timecreated INT(10) UNSIGNED NOT NULL DEFAULT '0', timemodified INT(10) UNSIGNED NOT NULL DEFAULT '0', importsrc VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (id)) COMMENT='Defines book_chapters'
(mysql): INSERT INTO mdl_log_display VALUES ('book', 'update', 'book', 'name')
1136: Column count doesn't match value count at row 1
(mysql): INSERT INTO mdl_log_display VALUES ('book', 'view', 'book', 'name')
1136: Column count doesn't match value count at row 1
(mysql): INSERT INTO mdl_log_display VALUES ('book', 'view all', 'book', 'name')
1136: Column count doesn't match value count at row 1
(mysql): INSERT INTO mdl_log_display VALUES ('book', 'print', 'book', 'name')
1136: Column count doesn't match value count at row 1
(mysql): SELECT * FROM mdl_user WHERE id = '2' AND username = 'guest' LIMIT 1
Is this table used for building the log-files or so? Has everyone to change this in his own additional modules?
book
(mysql): CREATE TABLE mdl_book ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, course INT(10) UNSIGNED NOT NULL DEFAULT '0', name VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL DEFAULT '', numbering TINYINT(4) UNSIGNED NOT NULL DEFAULT '0', disableprinting TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', customtitles TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', timecreated INT(10) UNSIGNED NOT NULL DEFAULT '0', timemodified INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id)) COMMENT='Defines book'
Success
(mysql): CREATE TABLE mdl_book_chapters ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, bookid INT(10) UNSIGNED NOT NULL DEFAULT '0', pagenum INT(10) UNSIGNED NOT NULL DEFAULT '0', subchapter TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', title VARCHAR(255) NOT NULL DEFAULT '', content LONGTEXT NOT NULL DEFAULT '', hidden TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', timecreated INT(10) UNSIGNED NOT NULL DEFAULT '0', timemodified INT(10) UNSIGNED NOT NULL DEFAULT '0', importsrc VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (id)) COMMENT='Defines book_chapters'
Success
(mysql): INSERT INTO mdl_log_display VALUES ('book', 'update', 'book', 'name')
1136: Column count doesn't match value count at row 1
Error
(mysql): INSERT INTO mdl_log_display VALUES ('book', 'view', 'book', 'name')
1136: Column count doesn't match value count at row 1
Error
(mysql): INSERT INTO mdl_log_display VALUES ('book', 'view all', 'book', 'name')
1136: Column count doesn't match value count at row 1
Error
(mysql): INSERT INTO mdl_log_display VALUES ('book', 'print', 'book', 'name')
1136: Column count doesn't match value count at row 1
Error
| book tables could NOT be set up successfully! |
(mysql): SELECT * FROM mdl_user WHERE id = '2' AND username = 'guest' LIMIT 1
Changing (in bold) the last lines in the MySQL script seems to solve the problem:
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('bookmark', 'add', 'bookmark', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('bookmark', 'update', 'bookmark', 'name');
INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('bookmark', 'view', 'bookmark', 'name');
By the way, the install procedure does not install the languages files for the module book, is that correct?
It does indeed. I've patched it in my imported mod/book...
http://git.catalyst.net.nz/gitweb?p=moodle-r2.git;a=commitdiff;h=714478e5484686499f2a5cf9f96acf6bca3fbaa7
http://git.catalyst.net.nz/gitweb?p=moodle-r2.git;a=commitdiff;h=714478e5484686499f2a5cf9f96acf6bca3fbaa7
Hi!
I am tried to install Book_16 today and everything seemed fine.
But when I try to add the activity it is listed as modulename instead of book_16 in the pulldown menu and i get the reply "This module type doesn't exist".
Where is the problem ?
Yours Felix
P.S. In the admin module interface it is referenced as book_16 but when entering the settings the heading is also moduklename
I am tried to install Book_16 today and everything seemed fine.
But when I try to add the activity it is listed as modulename instead of book_16 in the pulldown menu and i get the reply "This module type doesn't exist".
Where is the problem ?
Yours Felix
P.S. In the admin module interface it is referenced as book_16 but when entering the settings the heading is also moduklename
Hi Felix,
After you unzip book_16 in /mod/ you have to rename the folder "book_16" to just "book".
If you have already tried to run moodle/admin, then you have to go to the Administration Panel and click configuration/modules/ and find book_16 and delete it. Then you have to use "phpMyAdmin" to drop the book tables from the database.
Then run /moodle/admin/ again to rebuild the database and install "book".
That should fix it.
Clarence
Hi,
That Catalyst patch seems to be obsolete, please look at this bugreport:
http://tracker.moodle.org/browse/MDL-6640
Please, let us try to help each other making the book module up to date
That Catalyst patch seems to be obsolete, please look at this bugreport:
http://tracker.moodle.org/browse/MDL-6640
Please, let us try to help each other making the book module up to date
It sounds like you are working with an older copy of the book module.
Try this one: http://download.moodle.org/modules/book_16.zip
You will most likely need to drop any tables for the older version of the book module from your database
-Steve
Try this one: http://download.moodle.org/modules/book_16.zip
You will most likely need to drop any tables for the older version of the book module from your database
-Steve
Hi Steve,
My test is with a fresh Moodle installation, so it is strange that I am getting error messages like if the old version is installed.
My test was also with the package from:
http://download.moodle.org/modules/book_16.zip
It seems like the sql-file in that package is obsolete too.
Any one else?
My test is with a fresh Moodle installation, so it is strange that I am getting error messages like if the old version is installed.
My test was also with the package from:
http://download.moodle.org/modules/book_16.zip
It seems like the sql-file in that package is obsolete too.
Any one else?
Jens Gammelgaard への返信
Re: Ang: Re: Ang: Re: Book module in 1.6 2 - obsolete!!
- Jean-Pierre Pawlak の投稿
Jean-Pierre Pawlak への返信
Ang: Re: Ang: Re: Ang: Re: Book module in 1.6 2 - obsolete!!
- Jens Gammelgaard の投稿
Jens Gammelgaard への返信
Re: Ang: Re: Ang: Re: Ang: Re: Book module in 1.6 2 - obsolete!!
- Stephen Bourget の投稿
Stephen Bourget への返信
Ang: Re: Ang: Re: Ang: Re: Ang: Re: Book module in 1.6 2 - obsolete!!
- Jens Gammelgaard の投稿
Jens Gammelgaard への返信
Ang: Re: Ang: Re: Ang: Re: Ang: Re: Book module in 1.6 2 - Up to date :-)
- Jens Gammelgaard の投稿
True, Book is an odd Art of Moodle maintenance 
I can only say I have installed 3 fresh Moodles with the latest book_16 code and with Langhoffs' patch. All failed - and I had no such failures with previous versions.
So coders,- could you try out the latest 1.62+?
It could improve Moodles image if the Q&A included the well known modules like the book.
Art,- does your installation run with MySql 4 or version 5? Mine runs version 5.
BR
Jens
I can only say I have installed 3 fresh Moodles with the latest book_16 code and with Langhoffs' patch. All failed - and I had no such failures with previous versions.
So coders,- could you try out the latest 1.62+?
It could improve Moodles image if the Q&A included the well known modules like the book.
Art,- does your installation run with MySql 4 or version 5? Mine runs version 5.
BR
Jens
Hello,
I'm getting the following:
(mysql): INSERT INTO mdl_log_display (module, action, mtable, field) VALUES ('bookmark', 'add', 'bookmark', 'name')
1062: Duplicate entry 'bookmark-add' for key 2
Error
(mysql): INSERT INTO mdl_log_display (module, action, mtable, field) VALUES ('bookmark', 'update', 'bookmark', 'name')
1062: Duplicate entry 'bookmark-update' for key 2
Error
(mysql): INSERT INTO mdl_log_display (module, action, mtable, field) VALUES ('bookmark', 'view', 'bookmark', 'name')
1062: Duplicate entry 'bookmark-view' for key 2
Error
(mysql): INSERT INTO mdl_log_display (module, action, mtable, field) VALUES ('book', 'print', 'book', 'name')
1062: Duplicate entry 'book-print' for key 2
Error
book tables could NOT be set up successfully!
----
also, in one of my courses, Recent Activities block Course Updates, I just noticed this:
Warning: print_recent_activity(/home/mysite/public_html/moodle/mod/book_16/lib.php): failed to open stream: No such file or directory in /home/mysite/public_html/moodle/course/lib.php on line 599
Warning: print_recent_activity(): Failed opening '/home/mysite/public_html/moodle/mod/book_16/lib.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mysite/public_html/moodle/course/lib.php on line 599
I did rename Book_16 to Book.
I tried the mysql that came with the zip as well as with the modifications by Ger. I get similar 'duplicate entry for x key' error messages.
I reinstalled 3 times, each time deleting the tables that were created,, but I don't know enough about this backend stuff to know what the duplicate keys means.
thanks
Simply deleteing via the modules I/F and removing the tables does NOT solve this problem. At least, it didn't for me. I had the same error message about "(mysql): INSERT INTO mdl_log_display (module, action, mtable, field) VALUES ('bookmark', 'update', 'bookmark', 'name') " that the above user had. The system is trying to add records to the mdl_log_display table that are already there. You need to remove them manually. Login to mysql and run the following to delete the tables and remove the offending keys;
drop table mdl_book;
drop table mdl_book_chapters;
delete from mdl_log_display where module = 'book';
That should remove two tables and 4 entries from the mdl_log_display fields.
If you are using php_my_admin, login normally and look for "book" in the field "module" of table "mdl_log_display." Delete the 4 records the system finds.
HIH,
Kevin Metcalf
drop table mdl_book;
drop table mdl_book_chapters;
delete from mdl_log_display where module = 'book';
That should remove two tables and 4 entries from the mdl_log_display fields.
If you are using php_my_admin, login normally and look for "book" in the field "module" of table "mdl_log_display." Delete the 4 records the system finds.
HIH,
Kevin Metcalf
Thankyou Kevin for your instructions on deleting the tables. Even as a novice user I could understand and follow them.
My prob was I installed at book_16, realised the error and renamed the file to book, but hadn't deleted the tables. Just renaming the folder didn't work after the install was already done!
Hi Felix,
Please note that the Book module for 1.6 is now available in Modules and Plugins. As far as I know, the modules download page is due to be removed very soon.
Please note that the Book module for 1.6 is now available in Modules and Plugins. As far as I know, the modules download page is due to be removed very soon.
Hi all,
I've just installed the book_16 module.
I wanted to migrate the database (http://myserver/moodle/admin/utfdbmigrate.php), but I've got this message:
| unicode db migration has already been performed! |
At his time all tables are utf8_general_ci coded, except for mdl_book and mdl_book_chapters that are still latin1_swedish_ci.
Thanks in advance for your help.
