UWC Export problem using Mediwiki 1.13.4 with Postgresql 8.4

While trying to export I get the below error message using the below properties set. I'm not sure why I'm getting this error, the statement that it lists first is correct and will run as a sql statement. I think though the error really isn't in the first statement but further down. I have to admit that I'm at a loss here.. it would be easier for me to just write the sql for it but I don't really know exactly what the converter is looking for. The db.sql.textdata statement doesn't make any sense to me because wouldn't you need to do an inner join here? Can anybody add some insight here?

2011-12-22 11:32:46,008 ERROR [main] - Problem while running custom SQL: select page_id, page_namespace, page_title, page_latest from mediawiki.page where page_namespace!='8' and page_namespace!='12';

2011-12-22 11:32:46,008 ERROR [main] - Problem while exporting

org.postgresql.util.PSQLException: The column name mediawiki.page.page_latest was not found in this ResultSet.

at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2562)

at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2405)

at com.atlassian.uwc.exporters.MediaWikiExporter.getMediaWikiPages(MediaWikiExporter.java:475)

at com.atlassian.uwc.exporters.MediaWikiExporter.exportMediawiki(MediaWikiExporter.java:231)

at com.atlassian.uwc.exporters.MediaWikiExporter.export(MediaWikiExporter.java:159)

at com.atlassian.uwc.ui.UWCCommandLineInterface.export(UWCCommandLineInterface.java:95)

at com.atlassian.uwc.ui.UWCCommandLineInterface.main(UWCCommandLineInterface.java:48)

db.sql.pagedata=select page_id, page_namespace, page_title, page_latest from mediawiki.page where page_namespace!='8' and page_namespace!='12';

db.sql.textdata=select old_text from mediawiki.pagecontent where old_id = (select rev_text_id from mediawiki.revision where rev_id = 'db.column.textid' );

db.sql.revdata=select rev_text_id from mediawiki.revision where rev_page=db.column.pageid;

db.sql.textiddata=select rev_text_id from mediawiki.revision where rev_id=db.column.textid;

db.column.title=page_title

db.column.namespace=page_namespace

db.column.pageid=page_id

db.column.textid=page_latest

db.column.text=old_text

2 answers

Hello Thomas -

Here's the developer documentation for the UWC at current:

https://studio.plugins.atlassian.com/wiki/display/UWC/UWC+Developer+Documentation

There are many variables in migrations to consider, since it is human-entered content, and always unique at some level. The UWC tool helps, but do not think it is a magic bullet to cover all cases for you. Often it needs to be extended, for a particular migrations' nuances.

This checklist sorts through the main things to consider in your strategy:

https://www.appfusions.com/display/Dashboard/Wiki+Migration+Checklist

If you would like additional assistance to a successful migration, AppFusions is happy to help you.

Please write info@appfusions.com

Happy Holidays!

Ellen

I found my problem, in my exporter properties file I had an extra space after the page_latest value for the db.column.textid property. This is why it couldn't find the column in the sql query. The devs should probably consider doing a trim on these values after they load them to ensure there are no hidden spaces. Note that I copied and pasted these values so it never occured to me that there was a space at the end. Thank you Ellen for pointing me to the source code, had to debug this one to find it.

Great to hear!

CHeers, Ellen

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

174 views 4 8
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you