Forums
I just tried an upgrade from Opigno 1.20 to 1.21. I have Drupal 7 and PostgreSQL 9.2.14 on the machine. I did this:
1. Download and extract locally Opigno 1.7 files
2. Put the website into maintenance mode (Configuration -> Development -> Maintenance mode)
3. Transfer all the files (except .htaccess and the folder 'sites')
4. Run update.php
5. Deactivate maintenance mode
I couldn't do #5 because I was locked out as "admin". Had to do this:
su - postgres
psql
UPDATE variable SET value = 'i:0;' WHERE name= 'maintenance_mode';
DELETE FROM cache_bootstrap WHERE cid = 'variables';
DELETE FROM cache WHERE cid = 'variables';
\q
That got the Opigno site back up and running, but crippled. I can sometimes get to the black menu across the top, sometimes not, and the icon keeps going across the full screen.
I now see this:
Type php
Date Thursday, January 14, 2016 - 14:28
User admin
Location /?q=admin
Referrer /update.php?op=results&token=
Message PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "opigno_statistics_user" does not exist LINE 3: opigno_statistics_user opigno_statistics_user ^: SELECT 1 AS expression FROM {opigno_statistics_user} opigno_statistics_user WHERE ( (uid = :db_condition_placeholder_0) AND (month_year = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1451635200 ) in opigno_statistics_app_exit() (line 280 of /var/www/html/opigno/profiles/opigno_lms/modules/opigno/opigno_statistics_app/opigno_statistics_app.module).
Severity error
Hostname
Operations
Opigno LMS 1.21.0
Any recovery from this or must I start over? I have a database backup and an Opigno backup from earlier today, just in case.
Hi we7u.,
Hi we7u.,
Put the backups back again and then replace all files except the sites folder and the .htaccess, and or any other files you added to the root folder.
Go to yoursite/update.php and do the update.
Best regards
In reply to Hi we7u., by James Aparicio
I did exactly that the first
Restored from 7-1.20.0 backups