Forum
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, 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.
I thought there was a time when that "/" was automatically removed - I could be thinking of something else though. It happens...
Which version of MySQL are you on?
Hi Drew,
pretty recent -
MySQL 5.5.5-10.2.8-MariaDB-10.2.8+maria~xenialThis should be fixed in 3.0.10.
Brilliant - thanks Drew, I'll give it a try.