Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
sound Posted March 25, 2021 Posted March 25, 2021 am I right in saying the post_key column in the posts database table is no longer used for anything? is it ok to empty this column to reduce the size of the table?
Miss_B Posted March 25, 2021 Posted March 25, 2021 3 hours ago, sound said: am I right in saying the post_key column in the posts database table is no longer used for anything? is it ok to empty this column to reduce the size of the table? You would be very wrong. If I were you, I would leave it be. Here you can read about what that column does.
sound Posted March 25, 2021 Author Posted March 25, 2021 thanks but don't have permission to see the link/topic it's been empty for a fair few years now yep?
Miss_B Posted March 28, 2021 Posted March 28, 2021 On 3/25/2021 at 7:42 PM, sound said: thanks but don't have permission to see the link/topic it's been empty for a fair few years now yep? You can read it below. Quote It's for attachments. Logically the code cannot connect attachments to a post ID when it's first uploaded to a non-published post, since the post isn't published yet (and have no post ID). So they use a generated post_key for the attachment table relation instead. sound 1
Recommended Posts