Hello,
joomla: 1.0.15
serveur web: apache 2.0.52
php: 4.3.9
DB: 4.1.7
sef:2.3.1

I updated the SEF from 1.4.0 version to 2.3.1. when I click view/edit urls this gives me the following error:
Unknown column 'Itemid' in 'where clause' SQL=SELECT * FROM jos_redirection WHERE `newurl` != '' AND `Itemid` = 5 ORDER BY `oldurl` LIMIT 0,50
I also have another error that occurs when I click on the button view / edit 301 urls:
Table 'mydb.jos_sefmoved' doesn't exist SQL=SELECT * FROM jos_sefmoved ORDER BY `old` LIMIT 0,50

visibly the database was not updated. how to update the database preserving the existing data tables ?

Thank you

Salma

Add the Itemid field manually then. It is an integer field.