2017-01-02, 07:49 PM
So we converted over from a VB forum. I thought initially that the attachment ids had all gotten broken because lots of attachments would fail when you tried to download one. It turned out that it was because the custom attachment types didn't get carried forward. So I started adding them back and discovered that there's apparently a limit on the file extension length. One of our types, CQCMacroPack, is apparently one or two characters over the limit and so we can't add back that custom attachment type, which means that all of those attachments are stranded.
SQL Error:1406 - Data too long for column 'extension' at row 1Query:INSERT INTO mybb_attachtypes (
Is this limit intentional or just an oversight? Could we possibly get it bumped up a bit? So apparently the extension column is set to VARCHAR(10) in the database. I'm guessing it wouldn't really break any of the code if that was just increased, right?
SQL Error:1406 - Data too long for column 'extension' at row 1Query:INSERT INTO mybb_attachtypes (
name
,mimetype
,extension
,maxsize
,icon
,enabled
,groups
,forums
,avatarfile
) VALUES ('CQCMacroPack','application/octet-stream','CQCMacroPack',180,'images/attachtypes/css.png',1,'-1','-1',0)Is this limit intentional or just an oversight? Could we possibly get it bumped up a bit? So apparently the extension column is set to VARCHAR(10) in the database. I'm guessing it wouldn't really break any of the code if that was just increased, right?