O’Co DOO

When I transfer all my joomla 1.0’s content to 1.5,I found that the title alias was not transfered.I use the sh404SEF component to rewrite my site URL using the title alias as the SEF URL,so this is a big problem!

But fortunately,I find the way so solve this problem.

In PhpMyAdmin:

1,chose the jos_content table,copy it structure and data to jos_content_bak.

2,rename alias to alias2.

3,add 1 field named alias after the id field.

4, execute:

UPDATE (jos_content LEFT JOIN jos_content_bak ON jos_content.`id` = jos_content_bak.`id`)
SET jos_content.`alias`= jos_content_bak.`title_alias`

5,what’s more?that’s all!