To downgrade a module:
After you install an "older" version of the module into alfresco.war, when you start alfresco it will throw an error saying downgrading modules is not supported and not start.
To "fix" this problem, connect to your database (mine was a MySQL DB) and run these SQL commands(at your own risk, after you have backed up your DB
)
1. This is so you know what the qname_id means in the latter tables:
2. Dig deeper into the 101 and 102 qname_ids:
3. See what modules they are:
4. update the DB. You should by now have Alfresco down, and your database backed up!
5. Verify the glory of our achievement 😎 :
After you install an "older" version of the module into alfresco.war, when you start alfresco it will throw an error saying downgrading modules is not supported and not start.
To "fix" this problem, connect to your database (mine was a MySQL DB) and run these SQL commands(at your own risk, after you have backed up your DB
)1. This is so you know what the qname_id means in the latter tables:
mysql> SELECT * FROM alf_qname WHERE alf_qname.id IN (34, 59, 62, 101, 102 );
+—–+———+——-+——————+
| id | version | ns_id | local_name |
+—–+———+——-+——————+
| 34 | 1 | 3 | name |
| 59 | 1 | 5 | container |
| 62 | 1 | 5 | store_root |
| 101 | 1 | 8 | currentVersion |
| 102 | 1 | 8 | installedVersion |
+—–+———+——-+——————+
5 rows in set (0.00 sec)
2. Dig deeper into the 101 and 102 qname_ids:
mysql> SELECT node_id, qname_id, locale_id, string_value FROM alf_node_properties WHERE qname_id IN (101, 102) ORDER BY node_id;
+———+———-+———–+————–+
| node_id | qname_id | locale_id | string_value |
+———+———-+———–+————–+
| 2345995 | 101 | 1 | 2.1.13 |
| 2345995 | 102 | 1 | 2.1.13 |
| 3216313 | 101 | 1 | 2.4.0 |
| 3216313 | 102 | 1 | 2.4.0 |
| 3216314 | 101 | 1 | 2.4.0 |
| 3216314 | 102 | 1 | 2.4.0 |
| 3216315 | 101 | 1 | 2.4.0 |
| 3216315 | 102 | 1 | 2.4.0 |
+———+———-+———–+————–+
8 rows in set (0.00 sec)
3. See what modules they are:
mysql> SELECT node_id, qname_id, locale_id, string_value FROM alf_node_properties WHERE node_id IN (3216313, 3216314, 3216315) ;
+———+———-+———–+——————-+
| node_id | qname_id | locale_id | string_value |
+———+———-+———–+——————-+
| 3216313 | 34 | 1 | content-********* |
| 3216313 | 101 | 1 | 2.4.0 |
| 3216313 | 102 | 1 | 2.4.0 |
| 3216314 | 34 | 1 | ******-content |
| 3216314 | 101 | 1 | 2.4.0 |
| 3216314 | 102 | 1 | 2.4.0 |
| 3216315 | 34 | 1 | ******-alfresco |
| 3216315 | 101 | 1 | 2.4.0 |
| 3216315 | 102 | 1 | 2.4.0 |
+———+———-+———–+——————-+
9 rows in set (0.00 sec)
4. update the DB. You should by now have Alfresco down, and your database backed up!
mysql> UPDATE alf_node_properties SET string_value = '2.1.1' WHERE node_id = 3216315 AND qname_id IN (101, 102);
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0
5. Verify the glory of our achievement 😎 :
mysql> SELECT node_id, qname_id, locale_id, string_value FROM alf_node_properties WHERE node_id = 3216315 ;
+———+———-+———–+—————–+
| node_id | qname_id | locale_id | string_value |
+———+———-+———–+—————–+
| 3216315 | 34 | 1 | ******-alfresco |
| 3216315 | 101 | 1 | 2.1.1 |
| 3216315 | 102 | 1 | 2.1.1 |
+———+———-+———–+—————–+
3 rows in set (0.00 sec)
