donovan seeks help migrating a large PunBB forum (~45k posts, 3.5k topics) to Discourse, including generating 301 redirects for old query-string URLs, offering 500 USD. [Teddy_H](/t/-/137805/2) suggests using an existing tutorial, but [donovan](/t/-/137805/4) reports failure at ` bundle exec rails server, which endlessly outputs SQL logs. [merefield](/t/-/137805/6) clarifies this is normal — the server runs on port 3000 and should be accessed via browser, while Sidekiq runs separately. After retrying, [donovan](/t/-/137805/14) confirms success but asks how to automate Nginx redirects for 45k+ URLs, noting PunBB IDs don’t match Discourse IDs (e.g., /forum/viewtopic.php?id=3917→/t/hi-from-a-maghrebia-in-the-uk/3548). [RGJ](/t/-/137805/3) offers to complete the job for $500, possibly including hosting, and estimates completion before week’s end, requesting a database dump. [donovan](/t/-/137805/15) emphasizes the redirect challenge, as each post also has unique IDs (e.g., ?pid=46394#p46394`), and seeks automation. merefield reassures that SQL output is expected and not an error, and donovan confirms spending 5 hours waiting unnecessarily before realizing browser access was needed. The thread ends with unresolved redirect automation, highlighting a gap in tutorial clarity for non-Rails users.
Yes, I will be able to do this for $500.
We can also offer you hosting but that’s optional
In order to get started, please make a database dump (and if applicable, a zip file with your uploads / avatars) available via Dropbox, Google Drive, WeTransfer or similar and let me know where to find it.
Teddy, we had success with this tutorial up until this part:
$ bundle exec rails server
Ran the command and it just went on an endless loop outputting database info to screen. Never ran the rails server. That’s why we gave up and decided to get someone else to do it.
That SQL output is just info for the sys admin. It’s just the queries it’s running as part of its processes. It is endless until you stop it. That’s supposed to happen.
You are meant to proceed by connecting to it with a browser.
Ok so I went through the whole process again and got it up and running.
Suggestion for import tutorials: Just adding an extra comment or two to inform non-Rails guys like me what should be happening would save so much hassle. I left this running for 5 hours yesterday when all I needed to do was run Sidekiq in a separate terminal and open the browser.
So my next question is: is there a way to automatically generate an Nginx redirect map for the 45,000+ query string urls from PunBB so I can setup 301’s?