Upgrading to Drupal 7.43

By kgordon on 6 Mar 2016 at 04:03 UTC

Prior to upgrading to 7.43 I accessed my website as admin and backed up the DB and the site. I then logged out and used:
/var/www/drupal/#drush vset maintenance_mode 1
/var/www/drupal/#drush cache-clear all
I then used:
/var/www/drupal/#drush vset maintenance_mode 0
/var/www/drupal/#drush cache-clear all
(These all gave the expected message of success.)
I then went back into my website and found the maintenance page still in place. I retried the same command but to no effect.
I then tried:
/var/www/drupal/#drush cron
message "Cron run successful."
/var/www/drupal/#drush vset maintenance_mode 0
message: Maintenance_mode was set to "0".
/var/www/drupal/#drush cache-clear all
message `all` cache was cleared.
Next I decided to check out the DB:
#MySQL -u root -p
>DATABASE robot;
> UPDATE variable SET value = `s:1:"0";` WHERE name = `maintenance_mode`;
ERROR 1054 (42S22) Unknown column...
>quit
Please advise next step.
Regards,
Kevin.

Comments

Upgrading to Drupal 7.43

kgordon commented 6 March 2016 at 20:00

After completing the upgrade are there any DB updates?
/var/www/drupal/drush updatedb
I received a message "No database updates required".
If the database is damaged:
UPDATE variable SET value = `s:1:"0";` WHERE name = `maintenance_mode`;
ERROR 1054 (42S22) Unknown column...
Can I restore the DB outside drupal?
Many thanks,
Kevin

Drupal 7.43 site still down

kgordon commented 7 March 2016 at 06:58

root@kgwebsite:/var/www/drupal# drush status
Drupal version : 7.43
Site URI : http://default
Database driver : mysql
Database username : root
Database name : robot
Database : Connected
Drupal bootstrap : Successful
Drupal user : Anonymous
Default theme : sky
Administration theme : seven
PHP executable : /usr/bin/php
PHP configuration : /etc/php5/cli/php.ini
PHP OS : Linux
Drush version : 6.2.0
Drush configuration :
Drush alias files :
Drupal root : /var/www/drupal
Site path : sites/default
File directory path : sites/default/files
Private file directory path : /usr/local/drupalbackup
Temporary file directory path : /tmp

mysql> USE robot;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE variable SET value = 's:1:"0";' WHERE name = 'maintenance_mode';
Query OK, 0 rows affected (0.09 sec)
Rows matched: 1 Changed: 0 Warnings: 0

The database must be ok.

Upgraded to 7.43 ok? But still no website.

Please recommend some tests.

Kevin