Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By gcardona on
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
Drupal version
By the way, my Drupal version is 7.10
Regards,
Gustavo
Problem SOLVED
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! :-)
painful, but seemed to work.
painful, but seemed to work. thank you.
Don't need manually export
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
Delete views directly instead of truncating tables
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!
It works, thumbs up. Ata
It works, thumbs up.
Ata
this module worked for me in D7
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