Looking again at the error message, I can see this is due to the "list ordering" field in the database, so this tends to indicate there were a lot of rules stored at some point.
This makes me think again of an very early version of 4SEO which had a bug, creating a large number of rules (not visible from the UI). This was solved a year ago but maybe if you tried that version, you may still have that data stored.
As you don't seem to have done a lot of custom work in 4SEO right now, I would advise a full uninstall with data removal and then re-install. The data removal ensures that all database table are deleted, and then re-created afterwards. You will lose any data you have created, including all configuration in 4SEO.
If ok with you:
- go to Configuration | System
- scroll all the way down and enable "Remove all data when uninstalling" under "Data deletion"
- Uninstall 4SEO using the normal Joomla procedure
- download latest version and install again.
weeblr.com / @weeblr