Hello everybody, we deploy a website for a client in http://investpacific.org/node/1344 and we get the follow error.

Notice: unserialize() [function.unserialize]: Error at offset 3449 of 3503 bytes en views_db_object->load_row() (línea 2005 de /home/webivp/public_html/sites/all/modules/views/includes/view.inc).

How can we avoid this problem?

Regards,

Gustavo

Comments

gcardona’s picture

By the way, my Drupal version is 7.10

Regards,

Gustavo

gcardona’s picture

Solution bug around:

Step 1:
Truncate the tables
drpl_views_display_new
drpl_views_view_new

Step 2:
Export all views manually using Drupal export view from development environment

Step 3:
Import all views manually using Drupal import view in production environment

Enjoy! :-)

andjules’s picture

painful, but seemed to work. thank you.

tomsolo’s picture

Don't need manually export views, here is a quick solution:

1. truncate all cache and views table on prod site.
2. go to admin/structure/views: all custom views erased.
3. on dev site: export only the 2 views table (use REPLACE).
4. Import this the prod site

ta-da-aam- all views work and error message is gone.

cheers

neethu r’s picture

Thanks a lot for the solution, this helped me remove the error from my production site.

The good news is we can do this even if we don't have access to the application database. We need not truncate the tables in database instead just delete the views directly from frontend.

I deleted all non-default views from the production site through admin login and then followed the above mentioned steps 2 & 3 i.e manually importing all views into the production site from the development environment using Drupal export/import view.

Hope this helps!

mustafa.ata’s picture

It works, thumbs up.

Ata

ccaajj’s picture

Gives you a new Report (/admin/reports/variablecheck) that lists invalid variables, and offers to delete them.

In my case, they were all old variables related to the Zen theme, which I had tried way back when the site was in drupal 5!

https://www.drupal.org/project/variablecheck