MyStop has run into a problem

As some users may be aware, MyStop is currently down, that is, not available to the general public online. 

The reason for this is quite simple, and is to do with a flaw in the way our admin panel handles new databases. When a new database file is uploaded in CSV (comma separated values) format to the database manager, it is routine to select "replace table data with file data", which should overwrite existing entries and replace them with an edited version of the database. 

However, it has been brought to our attention that uploading a new file to the database and supposedly overwriting it does not overwrite the whole thing. Instead, it simply edits and adds new entires - but will not delete new entries. 

Therefore, some services (and certainly not all) that have had timetable changes since launch and today have still been displaying withdrawn journeys that did once operate, but no longer do. 

As a solution, we will now employ the method of completely flushing the database (deleting every entry but keeping column names and layout). This will mean it will now be impossible for deleted journeys to still appear on the departure board. 

Rest assured that we are taking this extremely seriously, and will avoid a repeat in the future. As was routine before, random spot checks on the departure boards each day will occur, but more often. 

We'd like to apologise for the inconvenience. We aim to have MyStop  available again at latest tomorrow morning. 


Right now, we are manually checking and verifying almost 2500 database entries, so please bear with us.

We hope you will all continue to enjoy using the service once it's back up and running. 

The Torbay Bus Routes Team 


***EDIT: as of Tuesday, 29th November, 2011, 20:26, MyStop is back online***