Hi everyone,
that's my first post.
I have the following problem: through the component Jupgrade, I have made the migration from Joomla 1.5.23 to Joomla 1.7.1.
Therefore I should migrate from JoomSEF JoomSEF 3.8.2 to 4.1.1.
But if I try to export url to JoomSEF 3 and import these on version 4, I will return an error: "Unknown column 'metacustom' in 'field list'"
The sql file is less than 200KB.
What should I do to resolve the situation?
Thank you.

Hi,

The easiest solution for now is to add the missing columns to database using phpMyAdmin and running the following SQL (replace {prefix} with your Joomla DB prefix):

ALTER TABLE {prefix}_sefurls ADD COLUMN `metacustom` TEXT, ADD COLUMN `trashed` TINYINT(1) NOT NULL DEFAULT '0';

Then run import (make sure you use the Import button in JoomSEF's Manage SEF URLs page toolbar). After the URLs are imported correctly, run the following SQL to remove the columns again, so you won't have problems updating JoomSEF in future (replace {prefix} with your Joomla DB prefix):

ALTER TABLE {prefix}_sefurls DROP COLUMN `metacustom`, DROP COLUMN `trashed`;

We'll fix this incompatibility in next version.

Thank you so much.
In this way I managed to import all the urls without any problems.
Shall I put [solved] in the title of my post?

I'm glad I helped.
It's not needed to put [solved] in the title.

well i want to make import after upgrade form version 3 to newest version 4, but after 10 month of development it seems you didn´t fix import function, because i have the same error. I don´t think so that by user friendly component i have to make some set-ups in db or somewhere else...

Hi vlada83, I'll check if the problem still exists and let you know.