Differences

This shows you the differences between two versions of the page.

--- wiki:fix_for_database_schema_version_2.5.0 [2014/10/31 19:21] – neyron
+++ wiki:fix_for_database_schema_version_2.5.0 [2014/10/31 19:29] – neyron
@@ Line 1: / Line 1: @@
-This fix applies to [[:OAR 2.5.2]] and [[:OAR 2.5.3]], and must be taken into account if upgrading to any later version of OAR (i.e. starting from 2.5.4)
+This fix applies to [[:OAR 2.5.2]] and [[:OAR 2.5.3]], and must be taken into account if upgrading to any later version of OAR (i.e. starting from [[OAR 2.5.4]])
 === Description of the issue ===
-With OAR 2.5.2 and OAR 2.5.3, OAR's database schema version must be 2.5.2 but is actually 2.5.0 in case of a fresh database setup with oar-database.
+With [[OAR 2.5.2]] and [[OAR 2.5.3]], OAR's database schema version must be 2.5.2 but is actually 2.5.0 in case of a fresh database setup with oar-database.
-This unfortunately causes the upgrade of the database to a later version of OAR (e.g. 2.5.4) to report errors.
+This unfortunately causes the upgrade of the database to a later version of OAR (e.g. [[OAR 2.5.4]]) to report an error:
 <code=bash>
 root@server:~# oar-database --check
@@ Line 47: / Line 46: @@
 Check that your jobs table already has a "array_index" column.
-<core bash>
+<code bash>
 $ echo 'select array_index from jobs limit 1;' | mysql -t -u$OARDBUSER -p$OARDBPASSWD $OARDBNAME
 +-------------+
@@ Line 56: / Line 55: @@
 </code>
+If yes, that confirms that the current version of your OAR database is 2.5.2 already and that the schema version is wrong.
-This confirms that the current version of your OAR database is 2.5.2 already.
 Please apply the following command to fix the version:
 <code bash>
 $ echo 'update `schema` set version = "2.5.2";' | mysql -u$OARDBUSER -p$OARDBPASSWD $OARDBNAME