I am attempting to backup a course so it can be restored to another moodle server. The backup fails with the message "error/cannot_finish_ui_if_not_setting_ui". The apache error logs shows: "[Wed Feb 16 13:13:33 2011] [error] [client 205.139.16.6] Potential coding error - existing temptables found when disposing database. Must be dropped!, referer: http://sandbox.baaccess.net/moodle/backup/backup.php".
How do I get the backup working?
I am having the same problem, but it is only happening on my top level course. Any insite to this error would be greatly appreciated.
The full error message is:
Backing up SiteName... Default exception handler: Error reading from database Debug: MySQL server has gone away.
SELECT COUNT('x') FROM mdl_backup_ids_temp WHERE backupid = ? AND itemname = ?
[array (
0 => 'string of chars',
1 => 'user',
)]
!!! Error reading from database !!!
Potential coding error -existing temptables found whe disposing database. Must be dropped!
PHP Fatal error: Exception thrown without a stack frame in Unknown on line 0
Not sure if this is the same thing or not but I was getting this error when trying to restore a course created in another Moodle instance.
I turned debugging on and noticed I was getting a permission denied a temp tablespace used when dealing backups. It seems that the installation instructions for MYSQL on this site don't mention granting CREATE TEMPORARY TABLES as a permission needed so I'd left it out. After granting that permission to my moodleuser I was able to complete the restore process.
I would like to confirm that this was exactly the issue with our moodle site. Granting all privileges to moodledbuser on moodledb tables (except for grant option) solved the problem. Unfortunately, Moodle errors were not very helpful in this regard (stating that temporary tables exists rather than they cannot be created).
I have one VERY LARGE course that fails - hangs on a white screen and I did see that same ui message. We are running Moodle 2.0.3 (Build: 20110505). I was able to successfully backup a smaller course today.
Same issue here on Moodle 2.0.3. Backup of a large course fails with just a blank screen.
Same issue as well. Moodle 2.0 RC2 (Build: 20101122). Got it down to a ppt file inserted as a link in a label. The file was uploaded into moodle. The file size is 24mb.
My apache log shows the following
[Tue Jun 14 10:39:19 2011] [error] [client ###.###.###.###] PHP Fatal error: Cannot redeclare class file_picker in /var/www/vhosts/www/html/lib/outputcomponents.php on line 47, referer: https://courses.centenarycollege.edu/backup/backup.php
[Tue Jun 14 10:39:19 2011] [notice] child pid 12379 exit signal Segmentation fault (11)
For anyone who comes across this discussion thread in a search, the good news is that the problem is solved in Moodle 2.2.5 and 2.3.2 onwards (MDL-28346).
Awesome Helen! So helpful!
Hello. What is the next step? I use Moodle 2.3 and I can not backup a specific course. Everyone else is fine.
There any way to fix it manually, or is required to change version?
Thanks, Yuri
Just in case someone comes here who has the Auto Attendance block installed, you must have both the module and block in a course or the backup will fail with this generic error. Caught this by enabling debugging and checking the apache logs ->
Default exception handler: Table "autoattendmod" does not exist
