Changes between Version 3 and Version 4 of IppUpgrade

Timestamp:

Nov 18, 2009, 12:32:29 PM (17 years ago)

Author:

dravg.uk.edinburgh

Comment:

Added updating the schema_version in the database

IppUpgrade

@@ -23 +23 @@
   * ./psbuild -dev -extbuild -optimize > & Update.log
   * Check Update.log. It should end with `** psbuild: finished **`
+
+== Troubleshooting after Upgrade ==
+
+While downloading data (see IppDownloadData), if you get an error in the pantasks console like:
+
+{{{
+ -> pxCheckImportVersion (pxtools.c:278): unknown psLib error
+     input file schema_version: 1.1.57 does not match data base: 1.1.56
+ -> importrunMode (stacktool.c:1395): unknown psLib error
+     pxCheckImportVersion failed
+}}}
+
+then you need to adjust the `schema_version` stored in the database. In the following example, I'm assuming the database is `PS1data` owned by the mysql user `ipp` and we need to update to version 1.1.57.
+ * `mysql --user ipp --password`
+  * <enter password>
+  * `show databases;`
+  * `use PS1data;`
+  * `update dbversion set schema_version='1.1.57', updated=CURRENT_TIMESTAMP();
+  * quit;