set_transient fails if the value has more than 60.000 characters

I found the problem! Everything was ok with the transient, the problem was that I’m using php’s substr() to cut an object property value if exceeds maximum characters. When in that string there was an accented character there was a problem with the encoding. So the serialized collection had an encoding issue at character 60000… I fixed it using substr_mb() and specifying UTF-8 as encoding.

Hard to debug this issue since wpdb doesn’t throw any error when there is an encoding problem.

Related Posts:

  1. Will it break my site if I delete all transient records in wp_options table?
  2. Using transients in conjunction with memcached
  3. Long option names fail silently?
  4. Transient feeds and caching error
  5. Delete transients in website
  6. Storing transients giving database error
  7. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  8. Oracle SQL query for Date format
  9. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  10. Can I have multiple primary keys in a single table?
  11. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  12. get_results using wpdb
  13. Database connection close
  14. How to monitor server for error establishing a database connection
  15. How to create bulk page and content? [closed]
  16. Importing posts from old website to new conflicting post ID’s?
  17. Connect to remote database using Localhost install
  18. remove missing image attachments
  19. Transient RSS feeds in wp_options not removed automatically?
  20. Best way to move live site local
  21. The revisions table in my database is at 70% capacity and growing. What should I do?
  22. WordPress for a very large website
  23. How to ensure data consistency in WordPress
  24. Database location in WordPress
  25. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  26. WP_list_table bulk_action get edit and delete
  27. How to display data from custom table in wordpress database?
  28. Change SQL get_results to search for posts with custom term in custom taxonomy
  29. How to diagnose and keep in check encoding issues?
  30. Add search Value to wp_list_table pagination
  31. stdObject stored in database. How does one convert it to usable format?
  32. I have a table I created, how do I make a form for a user to filter the data?
  33. What ALL can cause “Another update is currently in progress.”? [closed]
  34. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  35. Trigger Plugin database update after git pull
  36. wp_redirection_404 table has grown to 7GB
  37. Does WordPress ever need multiple databases?
  38. Why are no posts showing despite my apparently correct DB restoration?
  39. Cannot update custom database table row
  40. Change WordPress prefix for only one table?
  41. Two websites one database, administrator not working on second website
  42. Multiple wp_options tables to share content across installs
  43. Select two sums with single get_var statement
  44. How to get the SQL of the changes made to the database from an update or upgrade?
  45. Is there a smart way to obtain a list of only some selected user meta data?
  46. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  47. Permit Login if table row exists
  48. Make an Items attribute searchable (taxonomy using existing attribute)
  49. What would Repair and Optimize WordPress Database do?
  50. Store partial database to an archive database time to time
  51. Saving zero as meta value
  52. Migration: Copying database content to a different server
  53. Remove empty rows from the database
  54. Check if post id exist in table than only update instead of inserting new row
  55. Detail explanation of wordpress database fields and metatag list [closed]
  56. How to convert srcset links from https to http?
  57. How to get a list of WordPress default database tables?
  58. Changing order of db results when encoding to JSON
  59. How to transfer from localHost to live but use the already existing database on the server?
  60. Backing up WordPress database and files
  61. Creating and Using Tables in the WordPress Database
  62. How not to display ALL items of a database
  63. Connect a membership plugin to an external database
  64. How to get the records from start with A to G in php and mysql
  65. Storing user’s data on external database on other server
  66. Link multiple user databases together?
  67. is it right choose to connect database in template page directly in WordPress site?
  68. How to insert a value to decimal type field using wpdb->prepare?
  69. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  70. Set a cron job to delete a specific database table table every midnight
  71. Two separate wordpress installations at one domain
  72. Is there a way to edit the WP content database in an admin panel or external page?
  73. SQL database import #1046 error
  74. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  75. error establishing database connection (WAMP + filezilla)
  76. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  77. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  78. How to optimize wp_option table?
  79. How do I update a WordPress wp_postmeta meta_value that contains many options
  80. How can I get $wpdb to show MySQL warnings?
  81. About wp database hooks (error establishing connection)
  82. Database for JQuery Autocomplete field
  83. How to extract some part of WordPress full source code
  84. Create Tables in WordPress
  85. Catchable fatal error in formatting.php
  86. Error establishing a database connection for some files
  87. Hash user emails in database?
  88. WordPress Failed to Login (DB Error)
  89. Share WordPress Database
  90. DB access blocked when initializing WP externally
  91. Saving data to database and exporting to excel
  92. Site does not work right, pages not showing up, even for root admin
  93. ERROR: “Table Prefix” must not be empty
  94. How do you build a database-centric site in WP?
  95. WordPress: Interact with Database Query Data and Login
  96. Attach posts based on category and position
  97. Showing Error(TAble already exist)
  98. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  99. Cant Connect to Database
  100. WordPress database connection failed, while mysql client is working [closed]