If you have used JoomSEF or tried to use a very old Joomla 1.0 version of sh404SEF® in legacy mode, you may encounter this error (or similar) in sh404SEF®:
DB function failed with error number 1054
Unknown column 'rank' in 'order clause' SQL=SELECT * FROM jos_redirection WHERE `dateadd` = '0000-00-00' ORDER BY `oldurl`, `rank` ASC LIMIT 0,10
JoomSEF and sh404SEF® share the same name for their redirection tables (jos_redirection), but they don't have the same structure. As Joomsef has left its redirection table behind when you uninstalled it (which is normal), then there is a conflict that we cannot detect through the installer.
To fix the error:
- uninstall sh404SEF®
- using phpmyadmin, delete the jos_redirection table
- install sh404SEF® again
Assistance with technical questions, product inquiries and customer service can be found in our 