Problem with Moodle 3.5.2 - latest version

Problem with Moodle 3.5.2 - latest version

by Mimy Lolo -
Number of replies: 4

I made upgrade to Moodle 3.5.2


From 2015. I user Moodle on VPS, before on shared hosting... It was migration of Moodle to VPS.


When I try to import old course content to new course


I go to course > Import > (then I choose one course) click on Import and error, you see this on attachment.

-----

And the same problem when I add new user, then everthing blocked, I have to by VPS Control Panel Reboot system, then OK, user anyway added.

Very strange situation.


Conversion to Barracuda DB done !


PHP 7.2.

---

Help.

Best regards.

(Edited by Howard Miller to remove shouty subject - original submission Thursday, 27 September 2018, 7:15 PM)

Attachment Moodle_error_database_write_read.jpg
Average of ratings: -
In reply to Mimy Lolo

Re: PROBLEM WITH MOODLE 3.5.2 - latest version

by Dave Balch -

To resolve this you'll need more detailed error information - either from the PHP/web server error log, or by enabling debugging messages.

HTH,
Dave.

Average of ratings: Useful (2)
In reply to Dave Balch

Re: PROBLEM WITH MOODLE 3.5.2 - latest version

by Moly Loly -

One problem solved

Barracuda set up.


When I want add new user, it's ok now.

-----

But when I go to option, for example:

Backup course: xxxxxxxxxx

Page path

then:


Error writing to database

More information about this error


https://docs.moodle.org/all/hr/error/moodle/dmlwriteexception


------

Or


option:


ADMINISTRATION

> Import

Find a course to import data from:

I choose one:


then:


Error writing to database
Error reading from database

(attachment)


----

You wanted logs:


]# less /var/log/mysqld.log

150903 17:29:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

150903 17:29:19 [Note] /usr/local/apps/mysql/bin/mysqld (mysqld 5.5.45) starting as process 5090 ...

150903 17:29:19 InnoDB: The InnoDB memory heap is disabled

150903 17:29:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins

150903 17:29:19 InnoDB: Compressed tables use zlib 1.2.3

150903 17:29:19 InnoDB: Initializing buffer pool, size = 128.0M

150903 17:29:19 InnoDB: Completed initialization of buffer pool

150903 17:29:19 InnoDB: highest supported file format is Barracuda.

150903 17:29:19  InnoDB: Waiting for the background threads to start

150903 17:29:20 InnoDB: 5.5.45 started; log sequence number 1595675

150903 17:29:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

150903 17:29:20 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

150903 17:29:20 [Note] Server socket created on IP: '0.0.0.0'.

150903 17:29:20 [Note] Event Scheduler: Loaded 0 events

150903 17:29:20 [Note] /usr/local/apps/mysql/bin/mysqld: ready for connections.

Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

150903 17:29:21 mysqld_safe A mysqld process already exists

150904  7:05:39 [Warning] IP address '117.21.176.20' could not be resolved: Name or service not known

150904  8:23:09 [Warning] IP address '203.195.217.32' could not be resolved: Nam/var/log/mysqld.log

-----

Best regards,

Attachment Moodle_error_database_write_read2.jpg
Average of ratings: -
In reply to Moly Loly

Re: PROBLEM WITH MOODLE 3.5.2 - latest version

by Ken Task -
Picture of Particularly helpful Moodlers

Also check your **web** servers error log(s) .... maybe in /var/log/httpd/

**IF** you see 'Server has gone away' in any entries of the error logs, there is another tweak for MySQL (my.cnf) that's needed .... max_allowed_packet.  Default is 16M ... increase to something higher by adding a line in my.cnf ... max_allowed_packet=32M ... restart MySQL service then try it again.

'spirit of sharing', Ken


Average of ratings: Useful (1)
In reply to Moly Loly

Re: PROBLEM WITH MOODLE 3.5.2 - latest version

by Moly Loly -

Thank you!


This was the solution:


max_allowed_packet=32M ----> change/add in MySQL service.


No more problems with Moodle - latest version: 3.5.2, I mean error writting to database or reading from database.


Best regards!

Average of ratings: -