Skip to main content


Hello !Friendica Support,

When updating my instance, I encountered this error message:

Error 1170 occurred while updating the database BLOB/TEXT column 'url' used in key specification without a key length 

The 1469 update of the database structure failed with the following error message: Error occurred while changing the database
ALTER IGNORE TABLE `post-media` MODIFY `url` text NOT NULL COMMENT 'Media URL', MODIFY `size` mediumint unsigned COMMENT 'Media size';


Friendica 'Giant Rhubarb' 2022.09-dev - 1469

#friendica #update #bug #error
Thanks, @Quix0r@github.com is aware of the issue and should be working on a fix.
This entry was edited (2 years ago)
Thank you for your answer. Since my instance is still running, I'll just wait for the fix.
The goal is to prevent "Data is too long for column `url`" errors which stop large media storage, but otherwise it shouldn't affect you if the update wasn't performed.
You mustn't use text when the field is in some unique index.