I can not create tables

I can not create tables

از Тошко Поптолев در
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
میانگین امتیازات:  -
In reply to Тошко Поптолев

Re: I can not create tables

از Tim Allen در
No need to apologize for your English Poptolev, Moodle is an international community!  لبخند

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

از Тошко Поптолев در
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

از 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. لبخند


In reply to Tim Allen

Re: I can not create tables

از 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

از 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

از 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

از 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 installلبخند>.

In reply to Tim Allen

Re: I can not create tables

از 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