web_link field only stores 32 characters in issues_ext_launchpad table

[dicortazar]

I guess that this field stores the whole link to the specific issue. In the specific case of Launchpad, this typically contains more than 32 characters, so this should be updated at some point to more than this.

Thus, URLs provided in such field are typically cut after the 32nd character.

Example of this error in the OpenStack database available at http://activity.openstack.org/dash/browser/data/db/tickets.mysql.7z

[jgbarah]

Which size should be adequate, according to what you see in that Launchpad instance?

[sduenas]

To update the web_link columns to the new schema, you have to run the next statements on every Launchpad database:

ALTER TABLE issues_ext_launchpad MODIFY COLUMN web_link VARCHAR(256) default NULL;
ALTER TABLE issues_ext_launchpad MODIFY COLUMN milestone_web_link VARCHAR(256) default NULL;
ALTER TABLE issues_ext_launchpad MODIFY COLUMN web_link_standalone VARCHAR(256) default NULL;