Short URL enabled/Title Alias missing articles causing problem

I am making the site to use "Short URL"-however, it's not quite working...

There are many articles that were published without Title Alias and I wanted to have the article that does not have the Title Alias to use "Title"

I read here that you will be adding this feature -- would you  please let me know the status of this?  --and would love to make this work...

forum.mamboserver.com/showthread.php?p=1...ght=alias#post118743

I appreciate your help!

Yes it was planned to let it default to title if alias is missing. It was not high priority so I haven't implemented it yet. Will see after I add some more important features.

For now I can just recommend to add all aliases.

thank you for a quick response.

if you know of any hack that can do this, please let me know..

thank you for a quick response.

if you know of any hack that can do this, please let me know..

You can manually copy the contents of the column 'title' into 'title_alias' in the table mos_content.  Just log into mysql and select the database, and issue this command:

alter mos_content set title_alias = title;  <- for mambo
alter jos_content set title_alias = title;  <- for joomla

You can manually copy the contents of the column 'title' into 'title_alias' in the table mos_content.  Just log into mysql and select the database, and issue this command:

alter mos_content set table_alias = title;

Great tip mergemedia.

Thank you.

You can manually copy the contents of the column 'title' into 'title_alias' in the table mos_content.  Just log into mysql and select the database, and issue this command:

alter mos_content set title_alias = title;  <- for mambo
alter jos_content set title_alias = title;  <- for joomla

Couple of questions:

1. Would title alias be easier to use than the Alias & Meta option if I don't need the optional meta data?  Seems easier to me than having to turn off SEF temporarily, copy the URL, then type in an alias - or am I missing something?

2. I tried the above statement to copy title over to title_alias, but got an SQL error:

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'jos_content set title_alias = title' at line 1

I believe I am using MySQL 4.0.27.

Thanks!