Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Import urls from JoomSef 3 to JoomSef 4
(1 viewing) (1) Guest
Support forum for users using free edition of JoomSEF 3 (Joomla 1.5 compatible). These forums are mainly for mutual help between users.

Please note that due to our capacity limitations, we do not monitor these forums regularly.
  • Page:
  • 1
  • 2

TOPIC: Import urls from JoomSef 3 to JoomSef 4

Import urls from JoomSef 3 to JoomSef 4 8 years, 7 months ago #24643

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.

Re: Import urls from JoomSef 3 to JoomSef 4 8 years, 7 months ago #24650

  • dajo
  • NOW ONLINE
  • Posts: 5070
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.
ARTIO Support Team

Re: Import urls from JoomSef 3 to JoomSef 4 8 years, 7 months ago #24655

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?

Re: Import urls from JoomSef 3 to JoomSef 4 8 years, 7 months ago #24656

  • dajo
  • NOW ONLINE
  • Posts: 5070
I'm glad I helped.
It's not needed to put [solved] in the title.
ARTIO Support Team

Re: Import urls from JoomSef 3 to JoomSef 4 7 years, 8 months ago #32539

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...

Re: Import urls from JoomSef 3 to JoomSef 4 7 years, 8 months ago #32544

  • dajo
  • NOW ONLINE
  • Posts: 5070
Hi vlada83, I'll check if the problem still exists and let you know.
ARTIO Support Team
  • Page:
  • 1
  • 2
User Login Empty