Update hubzilla database schema command?

Australia, Sat, 30 May 2020 14:18:54 +1000

Is there an easy way to update hubzilla database schema? I just did an upgrade and it didn't happen because I used git pull and now util/udall thinks it's all fine and wont do it?

I can see item.llink and item.plink are using CHAR instead of TEXT in structure, I know this isn't major but I would like to add this to my list of updating steps so I don't forget and relearn updating hubzilla every few months.

!Hubzilla Support Forum

Mario Vavti

Sun, 31 May 2020 06:48:22 +1000

Hi there, this change to the schema has been done without updating existing installations because its consequences are really minor and the update would take ages to complete for most installations. You can do the update manualy if you like...

Sun, 31 May 2020 12:37:17 +1000

I had to remove the index on llink, does that mean llink doesn't use an index anymore? i can't add one to TEXT column
#1170 - BLOB/TEXT column 'llink' used in key specification without a key length

Mario Vavti

Sun, 31 May 2020 15:53:49 +1000

llink and plink do not need an index because we never look for them. You can safely remove the index...