Jump to content

Featured Replies

Posted

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

image.png.a08926226f0600236aad6e1e6ffc7967.pngimage.png.706d26a1b40f63542bba84e43b88cfb4.png

Solved by Marc

Go to solution
  • Solution

I would suggest first of all ensuring all your tables are INNODB, rather than MyISAM. 

  • Author

So I should convert old database to InnoDB before anything else? I could not find such a requirement in any upgrade guide.

 

I am referring to the invision database there. Please check those are INNODB

  • 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?

 

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

  • 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.

 

We would need to deal with this on your ticket. Please see my latest response there

  • Author

Of course.

 

Recently Browsing 0

  • No registered users viewing this page.