TourBuilder Error after Omeka and Curatescape updates

It seems you don’t have the postscript_text column in your Tour database. Based on this old forum post, it seems you’ve had this issue since 2018! This originally happened due to some bad version control in the plugin that has since been addressed. However, if your previous version was one of the ones affected by the bug (and it appears it was), it can be a little tricky to fix.

Option 1: MYSQL

If you’re comfortable with MYSQL, you can just add the required column manually, e.g.:

ALTER TABLE `Tour` ADD COLUMN `postscript_text` text collate utf8_unicode_ci default NULL

Option 2: PHP

If you’re more comfortable editing PHP, you can modify some plugin files. In the code below, from TourBuilderPlugin.php, just change ($oldVersion < '1.4') to (true).

if ($oldVersion < '1.4') {     
      $sql = "ALTER TABLE `$db->Tour` ADD COLUMN `postscript_text` text collate utf8_unicode_ci default NULL";
      $db->query($sql);   	        
}

… so it looks like this:

if (true) {     
      $sql = "ALTER TABLE `$db->Tour` ADD COLUMN `postscript_text` text collate utf8_unicode_ci default NULL";
      $db->query($sql);   	        
}

Then change the version number in plugin.ini to 1.7.21

After saving those changes, you’ll get that green “Upgrade” button again at admin/plugins. Pressing that will run the plugin upgrade hook, which should add the column to your database

Option 3: Start Over

If all else fails, you could just uninstall the plugin (which will erase your two tours, but not the items/stories they contain) and reinstall, then recreate the two tours from scratch. This is by far the easiest and least error prone option. Make sure to make a copy of your text and a list of the items/stories in your tour first.

Sorry about this issue. As I mentioned, it was an old problem that has been fixed for all the versions except, of course, the one you were previously using.