Datlist multiple sort not working on live site

silverstripe-4
Tags: #<Tag:0x00007f0843b9ce98>

#1

Silverstripe Version: 4.1.1

Question: Hi all, i got this function in my controller which sorts on deadline first and then on reference. Works fine on my localhost, but when i deploy, navigating to the page says “The requested page cannot be found” (NOT a 404 page, it just echoes it). If i sort only on deadline, it works fine on the live site too. Can someone help me out pls?

Details of your query go here

/public function getMyVacancies() {
        return datalist::create('\pena\myrrha\VacancyPage')
           ->filter([
               'ParentID' => $this->ID,
               'Deadline:GreaterThanOrEqual' => date("Y-m-d")
               ])
            ->sort([
                'Deadline' => 'ASC',
                'Reference' => 'ASC'
            ]);
    }

#2

Could it be that your local mysql version is 5.6 and the one on the servers is 5.7? If so here is the solution: Fixing MySQL 5.7 troubles