Jump to content

Thomas Emme

Clients
  • Posts

    3
  • Joined

  • Last visited

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Everything posted by Thomas Emme

  1. Thank you, Nathan. I've been trying to find the solution to that very same issue. Had to look fairly closely to find the "patch available" item.
  2. Update: Success. Previous "compact" tables are now showing as "dynamic". I entered the following as an SQL query through PHPMyAdmin: SELECT table_name, table_schema, ROW_FORMAT FROM information_schema.tables WHERE engine = 'InnoDB' AND TABLE_SCHEMA = '<YOUR DATABASE NAME>' AND ROW_FORMAT = 'COMPACT' ... then opened a new window to the same DB SQL query page, and copied the following query (adjusting the <compact_table_name> as needed : ALTER TABLE <compact_table_name> ROW_FORMAT=DYNAMIC; After doing this one at a time for the half-dozen or so entries I had to work on, I re-ran the original query (to identify compact row_formats) and came up with nothing. Edit: And the Administrator Notification pointing to "compact" row_format issues, is gone.
  3. I contacted my web host (my site being on a shared server) and they said they couldn't change to tables to Dynamic without altering things for every site on that server. Not what I was intending at all. Something tells me my host is wrong though... especially if the post above was successful in altering individual tables to Dynamic. Unless he's hosting his own? Will spend some time identifying which of my DB tables are not InnoDB powered and try manually resetting them. *After DB backup made*
×
×
  • Create New...