Have you run updateniceurls.php ?

What I recall is doing this in the upgrade from 4.0 to 4.0.1:

echo "Adding ezurlalias_migration schema"
mysql -u $user --password=$password $db < extension/ezurlaliasmigration/sql/mysql/schema.sql
echo "Creating migration table"
php5 extension/ezurlaliasmigration/scripts/migrate.php --create-migration-table
echo "migrating url aliases"
php5 extension/ezurlaliasmigration/scripts/migrate.php --migrate
mysql -u $user --password=$password $db -e "UPDATE ezurlalias SET is_imported=0; TRUNCATE ezurlalias_ml;"
echo "Updating nice urls"
/usr/bin/php5 bin/php/updateniceurls.php --import --fetch-limit=100 -s $siteaccess
php extension/ezurlaliasmigration/scripts/migrate.php --restore

But, FYI if you plan on upgrading this to beyond 4.2, then you can do the migration at 4.2 - if I recall correctly the migration was somewhat hosed until 4.1.x.

I've gone through the process several times and created this script based on these instructions.

echo "Step 1b: Move distribution files..."
mv /www/www.garproducts.com www.garproducts.com-4.0.0
mv /www/ezpublish-4.0.1/ www.garproducts.com
 
echo "Step 1c: Fix file permissions ..."
chown -R apache:apache /www/www.garproducts.com
find /www/www.garproducts.com/ -type d -exec chmod 755 {} \;
find /www/www.garproducts.com/ -type f -exec chmod 644 {} \;
service httpd restart
 
cd /www/www.garproducts.com
 
echo "Step 1d: Fix remote ID's ..."
php update/common/scripts/4.0/fixobjectremoteid.php --mode=a
 
echo "Step 2: Upgrade database to 4.0.1..."
mysql -u root $mydb < update/database/mysql/4.0/dbupdate-4.0.0-to-4.0.1.sql
 
echo "Step 3a: Enable ezurlaliasmigration ..."
sed -i -e "s/\[ExtensionSettings\]/ExtensionSettings\nActiveExtensions[]=ezurlaliasmigration/g" settings/override/site.ini.append.php
 
echo "Step 3b: Regenerate autoload arrays ..."
php bin/php/ezpgenerateautoloads.php --extension
 
echo "Step 3c: Create migration table ..."
mysql -u root $mydb < extension/ezurlaliasmigration/sql/mysql/schema.sql
 
echo "Step 3d: Transfer URL aliases ..."
php extension/ezurlaliasmigration/scripts/migrate.php --migrate
mysql -u root $mydb -e "TRUNCATE ezurlalias_ml;"
php bin/php/updateniceurls.php
php extension/ezurlaliasmigration/scripts/migrate.php --restore
 
echo "Step 3e: VAT Update ..."
php update/common/scripts/4.0/updatevatcountries.php
 
echo "Step 4: Update httpd.conf ..."
sed -i -e "s/RewriteRule content\/treemenu\/?$ \/index_treemenu.php \[L\]/RewriteRule content\/treemenu\/? \/index_treemenu.php [L]/g" /etc/httpd/conf/httpd.conf_old
 
echo "Step 5: Clear caches .."
php bin/php/ezcache.php --clear-all --purge
service httpd restart

Modified on Thursday 19 July 2012 4:50:43 pm by Jordan Ryan

Quote from Steven E Bailey :

But, FYI if you plan on upgrading this to beyond 4.2, then you can do the migration at 4.2 - if I recall correctly the migration was somewhat hosed until 4.1.x.

So you would recommend skipping the entire section 3 in http://doc.ez.no/eZ-Publish/Upgrading/Upgrading-to-4.0/from-4.0.x-to-4.0.y?

It's been a long time... but as near as I can remember and tell from the cryptic comments I left, is that I skipped steps 3-7 when upgrading to 4.0.3 and applied them later

Here is the script I was using:

https://github.com/leidentech/ez-...l-tools/blob/master/convertscript.sh

Your mileage may vary depending on your setup etc. etc.

It may also break on the sdk stuff.  I added that later and it may not work with earlier versions of ezpublish.

Edit: changed the link to the github repo.

Modified on Tuesday 05 February 2013 8:22:57 pm by Steven E Bailey