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;






2 answers

Hello Thomas -

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


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:


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

Please write info@appfusions.com

Happy Holidays!


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 Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

129 views 3 5
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot