Insert into log table failed (Moodle2)

Insert into log table failed (Moodle2)

by Stefan Eberhard -
Number of replies: 5

As admin I received this mail from our server:

Insert into log table failed at Monday 20th of December 2010 10:06:57 AM.
It is possible that your disk is full.
The failed query parameters are:

array (
'time' => 1292836017,

'userid' => '434',

'course' => '88',

'ip' => '93.204.250.59',

'module' => 'quiz',

'cmid' => '3381',

'action' => 'continue attempt',

'url' => 'review.php?attempt=329000',

'info' => '1141',

)

The disk can not be full!

Average of ratings: -
In reply to Stefan Eberhard

Re: Insert into log table failed (Moodle2)

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
In reply to Tim Hunt

Re: Insert into log table failed (Moodle2)

by Stefan Eberhard -

Database is OK, checked by me and the ISP. Database ist 350 MB (of 6 GB possible)

 

I use php-myadmin`s repair-function continously

Is it caused by using MyISAM instead of InnoDB?

In reply to Tim Hunt

fixed: Insert into log table failed (Moodle2)

by Stefan Eberhard -

Moodle updates did not change action varchar(15) to action varchar(40)

in mdl_log.

Changed to action varchar(40) with  phpmyadmin. No problems since then

In reply to Stefan Eberhard

Re: fixed: Insert into log table failed (Moodle2)

by Christos Rodosthenous -

I have the same problem on an installation of moodle 2.1.

 

Insert into log table failed at Thursday 18th of August 2011 12:15:17 AM.

 It is possible that your disk is full.

 

The failed query parameters are:

 

array (

  'time' => 1313615717,

  'userid' => '2',

  'course' => '1',

  'ip' => '91.184.220.53',

  'module' => 'library',

  'cmid' => 0,

  'action' => 'mailer',

  'url' => NULL,

  'info' => 'ERROR: SMTP Error: Could not connect to SMTP host.',

)

 

I guess that the problem is 'url'=> NULL .

 

I changed in mdl_log to allow NULL values for url field. I will see if that will do the job.

In reply to Christos Rodosthenous

Re: fixed: Insert into log table failed (Moodle2)

by scott johnson -

Hi,

I installed three Moodle sites at three sister schools. All set up the same.

One school has been emailing me the same error you are getting.

It is mentioning SMTP yet still able to email me. Would appreciate any assistance in reading this error.

HDD has many GB of space left.

 

array (

  'time' => 1313639117,

  'userid' => '2',

  'course' => '1',

  'ip' => '127.0.0.1',

  'module' => 'library',

  'cmid' => 0,

  'action' => 'mailer',

  'url' => NULL,

  'info' => 'ERROR: SMTP Error: Could not authenticate.',

)