We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Question, Error, Runway

Runway error: adding route to master page

Hi,

I have a problem adding a route to a master page - this works just fine when adding a route to a normal page.

From debug, the error is:

UPDATE perch_page_templates SET templateTitle='Sitemap Clubs', optionsPageID='0', templateNavGroups='' WHERE templateID='9'
Setting alert: Your master page has been successfully edited. (success)
INSERT INTO perch_page_routes(templateID,templatePath,routePattern,routeRegExp) VALUES('9','sitemap_clubs.php','/clubs/sitemap.xml','^//clubs/sitemap.xml/?$')
Invalid query: SQLSTATE[HY000]: General error: 1364 Field 'routeOrder' doesn't have a default value

Also, I may be remembering this incorrectly, but I added the route as /clubs/sitemap.xml - didn't Runway automatically strip off the first /? Or am I getting that wrong?

This happens on Runway 3.0.8 and 3.0.9

Duncan Revell

Duncan Revell 78 points

  • 2 years ago

Duncan, in all my Runway routes I always have to leave off the first "/" otherwise it never has worked for me. My paths always require "/" at beginning.

Duncan Revell

Duncan Revell 78 points
Registered Developer

I thought there was a time when that "/" was automatically removed - I could be thinking of something else though. It happens...

Drew McLellan

Drew McLellan 2638 points
Perch Support

Which version of MySQL are you on?

Duncan Revell

Duncan Revell 78 points
Registered Developer

Hi Drew,

pretty recent - MySQL 5.5.5-10.2.8-MariaDB-10.2.8+maria~xenial

Drew McLellan

Drew McLellan 2638 points
Perch Support

This should be fixed in 3.0.10.

Duncan Revell

Duncan Revell 78 points
Registered Developer

Brilliant - thanks Drew, I'll give it a try.