Hi,
Thanks (very late) for your answer Baptiste.
I was asking, because i had the same error. But my mysql user already have all needed privilege (including CREATE TEMPORARY TABLES).
So, it's not the solution for me...
Best regards,
Séverin
Re: Potential coding error - existing temptables found when disposing database. Must be dropped!
by Séverin Terrier -
Number of replies: 4
In reply to Séverin Terrier
Re: Potential coding error - existing temptables found when disposing database. Must be dropped!
by Bharath Parlapalli -
Have you solved the issue? if not - i am interested to know if turning on the debugging mode threw any light on your error. I am currently having the same issue and will update here if I find any more info or (hopefully) if i find any solution.
In reply to Bharath Parlapalli
Re: Potential coding error - existing temptables found when disposing database. Must be dropped!
by Séverin Terrier -
Hi,
I think people having this style of issue should really provide much more details, such as which type of backup, for which course, manual or automated, by web or cli, with(out) logs, with(out) user datas...
And tell if it's always the same course (or not).
If it's one course, perhaps have a look at log table(s), to see the number of lines concerned.
You can also try to update MySQL values (connect_timeout, wait_timeout and interactive_timeout) to put (much) more !
Séverin
In reply to Séverin Terrier
Re: Potential coding error - existing temptables found when disposing database. Must be dropped!
by Hittesh Ahuja -
Hi Severin,
I'm facing the same issue when trying to backup a Database activity. I can confirm the activity is not too big as it has only a couple of records. Error i get is :
Existing temptables found ......blah blah blah
My user had SELECT, INSERT, UPDATE, DELETE, DROP ON moodledb.* . Giving it CREATE TEMPORARY TABLES didnt help as i see the same error message in my apache error log.
Anything else I could try ?
In reply to Hittesh Ahuja
Re: Potential coding error - existing temptables found when disposing database. Must be dropped!
by Hittesh Ahuja -
Complete error:
Potential coding error - existing temptables found when disposing database. Must be dropped!,