Scramble user data fails with database error about moodle-local_datacleaner HOT 6 CLOSED

Can you give a complete reproducible set of steps to get this? It looks to me like you started running it, it created the template table, then perhaps killed it and re-ran it? The temp tables should be deleted and the db driver checks that none are still around.

from moodle-local_datacleaner.

This happened the first time I ran it. And there is no table called mdl_temp_table in the database afterwards. The same thing happens if I run it again.

Could it be that the SQL being generated is wrong?

Default exception handler: Error writing to database Debug: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM mdl_temp_table WHERE (1 + (u.id % 83)) = mdl_temp_table.id
            AND ' at line 1

from moodle-local_datacleaner.

Possibly, it may actually be postgres specific sql which is barfing on mysql. If you are able to wrangle a patch together that would be great, or even if you can just amend it to work with mysql and I'll fold that in so it works side by side with postgres.

from moodle-local_datacleaner.

I've changed the query and it seems to be working correctly. Here is the pull request #15.

from moodle-local_datacleaner.

Hi Mikhail,

I just merged it into development branch and I should merge it to master soon.

Thank you for the patch,

Daniel

from moodle-local_datacleaner.

I am closing this issue we believe it has been solved. Feel free to reopen if something comes up.

from moodle-local_datacleaner.