Issues while creating backup of courses

Issues while creating backup of courses

дэргэд sanjeet bisht -
Хариу нийтлэлийн тоо: 1

Hello,

I was trying to create a backup but didn't succeed from my end.
I read about  3-4 Articles and followed the same steps but my problem didn't solve.
I have activated my debug mode as well but not able to find the Issues where it is.
So can you please see the attached screenshot and share the steps with me.
Moodle version - 3.8

Thanks
Sanjeet

Хавсралт 2020-12-24-19-53-phpstack-470776-1477362.cloudwaysapps.com.png
Хавсралт image_2020_12_24T14_19_15_858Z.png
Хавсралт image_2020_12_24T14_22_58_676Z.png
Үнэлгээний дундаж: -
sanjeet bisht-н хариуд

Re: Issues while creating backup of courses

дэргэд Ken Task -
Particularly helpful Moodlers зураг

The third screen shot ... the one that shows 'error reading from database' has
a 'more information about this error link.

What does that point to ... the url?

Error while sending query packet ... obviously involves database.

The error points to a file:
/lib/dml/mysql_native_moodle_database.php and a line number - 1246


$this->query_start($sql, $params, SQL_QUERY_SELECT);
-> this line is 1246 $result = $this->mysqli->query($rawsql, MYSQLI_STORE_RESULT);
$this->query_end($result);

Suggest a setting for database time outs.
it's related to the number of database requests.
Error while sending a QUERY packet means the server is not ready to send any further database request.

IF you are one a shared hosting setup, there is nothing can do about tweaking DB server config.

What happens when you select 1/2 of the resources/etc. in the course to backup? Does it complete then?

You might need to inquire with hosting provider about the error ... not the fix cause they don't go that deep into supporting applications ... ask about the cause of "sending query packet" error.

'SoS', Ken