moved to new host installed fresh smf and reloaded old db pretty url not working

[s10dulkar]

moved to new host installed fresh smf and reloaded old db now i am trying to enable pretty url as its already in db. but it gives me error when i try and install mod

Specified key was too long; max key length is 1000 bytes
File: /home/customer/www/samplesite.com/public_html/Packages/temp/SMF2-0/install.php
Line: 39

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0.10. The above error might possibly go away if you execute the latest version of upgrade.php.

what to do now? where can i find upgrade.php and will that solve this issue ?

[vbgamer45]

Please post in the pretty urls topic. Looks like it needs to use a smaller index.

[s10dulkar]

just posted there too