MySQL Error: Cannot Set Default for TEXT Column

  • Resolved jayPEG

    (@jaypeg)


    8 months, 2 weeks ago

    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

    (@mguenter)

    8 months, 1 week ago

    Hey @jaypeg !

    Can you please check if the wp_realmedialibrary plugin was successfully created?

    Are you using PRO or free version?

    Thread Starter jayPEG

    (@jaypeg)

    8 months, 1 week ago

    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.