prettyurls - TroubleShooting.wiki

[SMFHacks]

Yeah it does you will need to download the mod unzip it.
Find smf2.0/install.zip
and remove this code from it. then rezip it back up.

Code: [Select]

// Create the pretty_urls_cache table
$smcFunc['db_drop_table']('{db_prefix}pretty_urls_cache');
$smcFunc['db_create_table']('{db_prefix}pretty_urls_cache', array(
array('name' => 'url_id', 'type' => 'varchar', 'size' => 255),
array('name' => 'replacement', 'type' => 'varchar', 'size' => 255),
), array(
array('type' => 'primary', 'columns' => array('url_id')),
), array(), 'overwrite');


[GhostHunting]

You did it!!! It works!!!

Thank you so much!!!

[SMFHacks]

Glad you have it working! Still a strange issue.

[GhostHunting]

I have several other SMF installs, how do I upgrade from the old version of Pretty urls to the new version? Is there tutorial somewhere?

Thanks again for your help!

[SMFHacks]

Ideally you uninstall old version then install new when possible.

[GhostHunting]

That gives:

Code: [Select]

HTTP ERROR 500

[SMFHacks]

On uninstall That would be tricky. But most of the updates where just the changes from the sources file.
You can do the replacements just overwrite old files. I would do a backup first

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

[SMFHacks]

Replied on smf forum upgrade.php