Thread

I’m working on a complicated upgrade from 1.x to 2.x where one of the columns in the custom channel fields needed to be modified to allow extremely long entries (from TEXT to MEDIUMTEXT). These fields are being truncated during the update. My hunch is that when the upgrade script sets up the new exp_channel_data table it also defaults back to the standard MySQL field types.

Can you provide any advice on where to modify the installer script to prevent this from happening?

Hello Seamus,

I am sorry to hear you are running into this!

You are correct, The update wizard/shell script is changing your MEDIUMTEXT field back to text as part of the conversion process. This then truncates the extra text that is not going to fit into a TEXT field.

You can look through the update scripts to find the one that makes the change and edit it. That’s about as much as I can offer you. Please be aware that modifications to the Database are not supported.

Is there anything else I can help you with?

Cheers,

Thanks for your help. I’ll figure something out. Maybe I can just copy back the longer fields from the 1.x database after the upgrade.

Hello Seamus,

I am sorry I could not offer more help.

Best of luck with the procedure. The Community Help Forum might be a good place to get some tips. Would you like me to move this thread there?

Cheers,

Thanks for the offer, it’s worth a shot…

Hello Seamus,

No worries! Moving the thread over.

Cheers,