Errors after upgrade to 7.x-1.21

we7u
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.
James Aparicio

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

we7u

I did exactly that the first

I did exactly that the first time around (minus the restoring backups portion): Extracted the new tarball, REMOVED the .htaccess and sites/* files from the extracted directory, copied the entire tree over the top of my Opigno 1.20 installation, did "chown -R apache:apache" across it, then ran update.php. I had noticed some other issues in the logs prior, having to do with bad SQL statements being issued to PostgreSQL: Am I asking for trouble running on PostgreSQL instead of MySQL? I much prefer Postgres, but is it as well supported by Opigno?
we7u

Restored from 7-1.20.0 backups

I restored my 7-1.20.0 files and database backups after wiping everything and am back up and running again. Am hesitant to try the upgrade to 7-1.21.0 again as I would follow the same instructions and end up with the same results.