Forums

This backend does not support window expressions

My Django API is throwing this error "This backend does not support window expressions". It worked with my local machine, so I was quite confused, until I realized that the mysql version is 5.6 here, as opposed to 8.0 on my local machine. Windows functions are only supported 8.0 and above.

Could I request that my database be upgraded to 8.0 please?

We can upgrade you to 5.7, but 8.0 is not available on PythonAnywhere yet.

We are now able to migrate users to MySQL 8 on request. The migration takes a few minutes plus the time it takes for us to dump and reload your databases on the new server. So larger databases will take longer. Your database will not be available during the migration. You will need to be on either the glastonbury or the haggis system image (https://help.pythonanywhere.com/pages/ChangingSystemImage/), so please make sure that you are on one of those before making the request. Send a request to support@pythonanywhere.com with an indication of a time when it will be convenient for you (between 11am and 6pm UTC on a weekday).