Title: MySQL Error: Cannot Set Default for TEXT Column
Last modified: July 16, 2025

---

# MySQL Error: Cannot Set Default for TEXT Column

 *  Resolved [jayPEG](https://wordpress.org/support/users/jaypeg/)
 * (@jaypeg)
 * [11 months ago](https://wordpress.org/support/topic/mysql-error-cannot-set-default-for-text-column/)
 * I’m seeing a lot of this in the PHP Error Logs:
 * **WordPress database error: BLOB, TEXT, GEOMETRY or JSON column ‘absolute’ can’t
   have a default value
   Query: ALTER TABLE qad_realmedialibrary ALTER COLUMN `absolute`
   SET DEFAULT ”
   
   From what I’ve read, it is trying to set a `DEFAULT ''` on a `
   TEXT` column. MySQL (especially 5.7+ or 8.x) does not allow default values for`
   TEXT`, `BLOB`, `GEOMETRY`, or `JSON` columns.I’m not certain that this is the
   case, but can you verify?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Contributor [Matthias Günter](https://wordpress.org/support/users/mguenter/)
 * (@mguenter)
 * [10 months, 3 weeks ago](https://wordpress.org/support/topic/mysql-error-cannot-set-default-for-text-column/#post-18567222)
 * Hey [@jaypeg](https://wordpress.org/support/users/jaypeg/) !
 * Can you please check if the `wp_realmedialibrary` plugin was successfully created?
 * Are you using PRO or free version?
 *  Thread Starter [jayPEG](https://wordpress.org/support/users/jaypeg/)
 * (@jaypeg)
 * [10 months, 3 weeks ago](https://wordpress.org/support/topic/mysql-error-cannot-set-default-for-text-column/#post-18567820)
 * Thank you Matthias. 
   Very strange, but I’m no longer seeing any of these errors
   so it must have been a fluke. I did look and see `wp_realmedialibrary` was created
   and it’s the free version. Since I no longer see those in the error logs, I’m
   guessing it was some other issue, but if it returns, I’ll let you know.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘MySQL Error: Cannot Set Default for TEXT Column’ is closed to new replies.

 * ![](https://ps.w.org/real-media-library-lite/assets/icon-256x256.gif?rev=2293211)
 * [Real Media Library: Media Library Folder & File Manager](https://wordpress.org/plugins/real-media-library-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/real-media-library-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/real-media-library-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/real-media-library-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/real-media-library-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/real-media-library-lite/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [jayPEG](https://wordpress.org/support/users/jaypeg/)
 * Last activity: [10 months, 3 weeks ago](https://wordpress.org/support/topic/mysql-error-cannot-set-default-for-text-column/#post-18567820)
 * Status: resolved