Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted December 22, 20213 yr Doing a drytest upgrade of my board. Convert goes just fine, until I get to this error below. How can I resolve this issue? The conversion just stopes and nothing else happens. My old database is MyISAM. Upgrading from 3.1.4 -> 4.6.9 Error: Specified key was too long; max key length is 1000 bytes File: /system/Db/Db.php Line: 198 serverError @ app.js?v=1:162
December 22, 20213 yr Solution I would suggest first of all ensuring all your tables are INNODB, rather than MyISAM.
December 22, 20213 yr Author So I should convert old database to InnoDB before anything else? I could not find such a requirement in any upgrade guide.
December 22, 20213 yr Author They are not. 3.1.4 is currently running on MyISAM. Is there a requirement somewhere to convert everything IPS table before upgrade to InnoDB?
December 23, 20213 yr We would advise all tables are running on INNODB, yes Could I ask here, are you referring to converting 3.1.4 invision? I ask because this being the case, the issue on your other ticket would likely be that you have had ip.content installed
December 23, 20213 yr Author Marc, yes. I am an old client. Already settled with your colleagues about that. Yes, it is Invision 3.1.4 and I do have ip.content installed. As far as I know I have more apps bought in the past. Pages, and some others, if not all. I am waiting an answer about the old license from one of your colleagues.
December 23, 20213 yr We would need to deal with this on your ticket. Please see my latest response there