Book Installation Error Messages

Book Installation Error Messages

by Barbara Jean Walsh -
Number of replies: 2
Maybe someone can interpret this for me? Please? What do I need to do to make the Book Module work?

This script generated 2 warnings - Scroll to the first warning

book


(mysql): CREATE TABLE mdl_book ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', summary MEDIUMTEXT NOT NULL, numbering SMALLINT(4) unsigned NOT NULL DEFAULT 0, disableprinting TINYINT(2) unsigned NOT NULL DEFAULT 2, customtitles TINYINT(2) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_book' already exists
 
 
 
 
 


(mysql): ALTER TABLE mdl_book COMMENT='Defines book'
Success


(mysql): CREATE TABLE mdl_book_chapters ( id BIGINT(10) NOT NULL auto_increment, bookid BIGINT(10) unsigned NOT NULL DEFAULT 0, pagenum BIGINT(10) unsigned NOT NULL DEFAULT 0, subchapter BIGINT(10) unsigned NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL DEFAULT '', content LONGTEXT NOT NULL, hidden TINYINT(2) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, importsrc BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_book_chapters' already exists
 
 
 
 
 


(mysql): ALTER TABLE mdl_book_chapters COMMENT='Defines book_chapters'
Success


(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'update', 'book', 'name')
Success


(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'view', 'book', 'name')
Success


(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'view all', 'book', 'name')
Success


(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'print', 'book', 'name')
Success

Average of ratings: -
In reply to Barbara Jean Walsh

Re: Book Installation Error Messages

by Andy Tagliani -
Barbara,

it seems you has the book module installed in the past. So there some tables already exist, see this error warning:

1050: Table 'mdl_book' already exists

If you have access to your server configuration, log in ex. with phpMyAdmin and delete the entries and tables of the book module in the database, then try to install new.

Andy
In reply to Andy Tagliani

Re: Book Installation Error Messages

by Barbara Jean Walsh -
Thank. I did try that. Little by little I'm exploring more into the inner workings. Fortunately, I was able to get SiteGround to look at it and to install the book module for me -- without an additional charge. Hooray!