|
I'm (finally!) migrating from SE 1.0 to OSQA for Merspi.com.au and I'm running intro some troubles with /admin/sximporter and importing the StackExchange database dump. Here's the debug error message as below,
Thanks in advance. |
|
I saw a similar (perhaps identical?) issue with sximporter when using PostgreSQL. After moving to MySQL, sximporter ran without incident. If you are using the canned script install @ WebFaction to do the install, you'll need to manually modify the script to use MySQL. By default, it uses PostgreSQL. Correct - I'm using the script install at WebFaction. Is it fairly straight forward to modify the script to use MySQL? Having a look now. Thanks!
(13 Apr '11, 14:25)
James Spittal
At a guess, I just need to change the following line: api.create_db (db_name, pwd,'postgresql' ) to 'mysql'
(13 Apr '11, 14:26)
James Spittal
1
Here's the copy of the modified script for MySQL usage: http://dl.dropbox.com/u/233981/OSQATrunkInstall
(13 Apr '11, 14:51)
James Spittal
|
|
Success! It was a problem with the WebFaction script trying to use Postgresql (which apparently is incompatible with SX Importer from the sound of things.) The fix was to use MySQL instead of Postgres. Script included here to autoinstall with MySQL instead of Postgres: |
At first I thought this could be the problem: http://meta.osqa.net/questions/6023/sximporter-incompatible-with-recent-sx-dumps
But looking at the error message - there's no mention of duplicate users? Hmmmm...