WordPress.org

1. benstraw
   Member
   Posted 4 years ago #

   I would like to change the field "name" in the wp_terms database from a varchar(55) to something larger, like a varchar(200).

   I know how to do this through phpmyadmin, but i just wanted to post to the community first to see if anybody thinks this is a bad idea, and what gotcha i might run into changing the database schema. This is a change for a site set to go into production next week so I don't want to do anything too risky.

   what problems might i run into... on upgrade, after making the change.... etc?

   my client is using the xlanguage plugin, so the name field sometimes has 3 values, seperated by a | ... so varchar(55) is often inconvenient.

   thanks!

2. vernal
   Member
   Posted 4 years ago #

   Hey there,

   I did hit a problem doing this. I upped the varchar on the link_description from 256 to 1024 (so i could put in longer link descriptions).

   When I upgraded next (from 2.5 to 2.5.1) wordpress reset the scheme and bumped it back down to 256. That ended up truncating all of my descriptions, which I had to then re-import from my backup.

   While I could continue re-importing every time I upgrade, I don't think it is sustainable... such as if there is a major release and they change the schema more significantly I won't be able to squeeze in my descriptions. I think.

   Best,
   Jason

Topic Closed

This topic has been closed to new replies.