By mikeloyst on

Hey everyone, thanks in advance for the help. Here is my problem

Today I upgraded a drupal 6 installation to drupal 7, should have been a simple upgrade but things did not go as planned.

The site was a drupal 6 acquia drupal install, which uses a customized version of the garland theme.
Long story short, after the update was completed, it tried to continue using the d6 version of garland, and obviously no content is rendering.

So this seemed simple enough, make a quick change in the variable table to make bartik the default theme right?

Well im noticing that the variable table now uses the longblob format, so not quite sure how I'll go about changing the default theme via database

Value for default_theme is 0x733a373a226761726c616e64223b

Any ideas or solutions?

Thanks,
Michael

⋅ Categories: Drupal 7.x

Comments

d_l’s picture

d_l commented

I'm using SQLyog free community edition to inspect MySQL DB for drupal 7.

http://code.google.com/p/sqlyog/downloads/list

But I don't see the format you have posted.

Themes status are in system table .. see "status" column.

jscoble’s picture

jscoble commented

Create a backup of the table as a file.
Open the file in a text editor and you should be able to read the value as a text string instead of the hex values of the string.
From here you can either modify and do a drop/create of table and insert the backed up data or create an update statement.
Run the SQL in a sql client for MySQL.
Mysql.com provides a gui tool that you can use to accomplish the above as long as you have a user that has sufficient permissions to access mysql outside of localhost: http://dev.mysql.com/downloads/workbench/

mikeloyst’s picture

mikeloyst commented

Problem solved, I created a blank installation of drupal to see what the hex value would be for the theme_default row in the variable table.

I then did a quick export, copied the value for theme_default and pasted that into the problem drupal installation.

The problem was that the drupal 7 variable table stores values in HEX.

Example d6 variable table

INSERT INTO `my_database` (`name`, `value`) VALUES
('theme_default', 's:11:"garland";')

Example d7 variable table

INSERT INTO `my_database` (`name`, `value`) VALUES
('theme_default', 0x733a333a22736b79223b);

Thanks for the support!

frank ralf’s picture

frank ralf commented

See Configuring phpMyAdmin to show Drupal 7 BLOB data

vinimini’s picture

vinimini commented

Thanks

lorraine02’s picture

lorraine02 commented

I have meet the same problem , and come here to see the good solution.

majikthise’s picture

majikthise commented

I had similar problems after I made a hash of a subtheme and made it the default. No content, just a load of error messages. D'oh!

Inserting / updating mikeloyst's suggested data directly into the "variable" table didn't seem to help so in the end I thought "I wonder what'd happen if I just deleted the offending row from the 'variable' table altogether?"

I gave it a try, cleared caches and hey presto! A working website once more.

I selected Garland as the default theme in the usual way and that put the missing row back into the database for me.