I can not create tables

I can not create tables

by Тошко Поптолев -
Number of replies: 8
Hi
I want an apology about bad English.
I wished to put the module Book but at me has given the message on a errors.
I have some times made unzip also has removed all at ".../moodle/mod/book", also has then gone to ".../moodle/adminq but to me constantly" gives the message on a errors.
And at me the module "Book" has not appeared
Here I apply the list from a errors. Tell please that is necessary will make.
Thanks
Poptolev
Average of ratings: -
In reply to Тошко Поптолев

Re: I can not create tables

by Tim Allen -
No need to apologize for your English Poptolev, Moodle is an international community!  smile

The first errors are due to the tables already being there - you tried to install more than once I gather.  The second errors I am not sure what the problem is. 

I would suggest you delete the module in Administraion -->  Configuration --> Modules and then delete the files in my_moodle_directory/mod/book.

Then try to install it over again - this usually fixes these kinds of problems.

Good luck,
Tim.
In reply to Tim Allen

Re: I can not create tables

by Тошко Поптолев -
Thanks about a prompt reply.
I do not have module book at Administraion/Configuration/Modules, therefore I from there not to the magician will remove.
If I only to remove a directory Book from moodle/mod/ whether and then will establish again it will turn out.
I have removed from the help "phpMyAdmin"  tables "book..." also has again gone to the administrator. Me has appeared other list from a errors (I apply here)

Poptolev
In reply to Тошко Поптолев

Re: I can not create tables

by Tim Allen -
I found the solution in another thread

It's a problem with the prefix_log_display table which has changed its structure but this hasn't been reflected in the book code.

I have made the necessary changes in the mysql.sql file which I have attached to this post.  Please replace the existing mysql.sql file with this one (in mod/book/db) and then try to delete the tables again and reinstall.  It should work.

Good luck,
Tim. smile


In reply to Tim Allen

Re: I can not create tables

by Mauricio Riveros Barbosa -
Hi - my english is so bad too but the problem looks similar:

I've deleted tables:
drop table  mdl_book;
drop table  mdl_book_chapters;

I erased records from tablemdl_log_display:
delete from mdl_log_display where module='book';

I have replaced the  file mysql.sql _ wich I compare with the original one and look identicals (attached the last one uploaded)

But now the problem is:

(mysql): INSERT INTO mdl_log_display (module, action, mtable, field) VALUES ('book', 'view all', 'book', 'name')  
1062: Duplicate entry 'book-view all' for key 2
      
   


Error

Any ideas?  thanks in advance..
In reply to Mauricio Riveros Barbosa

Re: I can not create tables

by Clarence Prudhoe -

Hi,

Here is what I did to make book_16 work in Moodle_16.

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

In reply to Tim Allen

Re: I can not create tables

by Bhupinder Singh -

Hi Tim and others,

I desparately need help with the book module. I AM HANING ERROS WITH NO SOLUTION BEFORE ME.

MY OS - Windows...

Book 16 Downloaded from CVS.

Erroneously I had used Book_16 to install. There was nothing visible upon logging in inot lesson.

Proceeded to Delete the tables from the database  reslut  --deteleted.

Deleted the entries -- from MDL_LOG_DISPLAY.

Deleted the module from config module and deleted the book_16 module.

Tried to reinstall the book module.

ERROR RECORDED:

"Fatal error: Call to undefined function: execute_sql() in e:\program files\easyphp\www\lms\lib\datalib.php on line 130".

Look for help from all. This is a production server that is to be installed.

Garry

In reply to Tim Allen

Re: I can not create tables

by Michael Penney -

Hi Tim, in your mysql

INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('book', 'view all', 'book', 'name');

was repeated, throwing an error.

I think the attached will work (it did on my 1.6 test installsmile>.

In reply to Tim Allen

Re: I can not create tables

by Bhupinder Singh -

I am having a problem The error I am getting is as under:

"Fatal error: Call to undefined function: execute_sql() in e:\program files\easyphp\www\lms\lib\datalib.php on line 130"

 Look for your help and assistance.

Regards

 

Garry