Hi there, I am trying to use question2answer.rb importer script to migrate my site to the discourse platform. But I am facing the following error during the migration process. How to fix it? :thinking: I am using the default docker container on a clean ubuntu 18.04. importing users **Traceback**…

Did you set those environment variables? DB_NAME TABLE_PREFIX and so on?

[画像] Ankhamax: DB_HOST ||= ENV[‘DB_HOST’] || “localhost” DB_NAME ||= ENV[‘DB_NAME’] DB_PW ||= ENV[‘DB_PW’] DB_USER ||= ENV[‘DB_USER’] TIMEZONE ||= ENV[‘TIMEZONE’] || “America/Los_Angeles” TABLE_PREFIX ||= ENV[‘TABLE_PREFIX’] || “qa_” I set all environment variables that I quoted above.

What did you set TABLE_PREFIX to?

Sorry. I’m in my logins and didn’t read the code carefully. I’m pretty sure that I wrote that script, but I didn’t see that main all stuff down in the query; I’m sure I didn’t write that. You’ll need to edit the script to have it use the database and prefix that you set in the environment variable…

[画像] Ankhamax: MAIN_APP_DB_NAME = “primary_db” What should I do about this one?

You’ll need to rewrite all of the dB queries.

[画像] pfaffman: You’ll need to rewrite all of the dB queries. I am sorry, Jay. I am not quite sure what you mean by that? Could you please give me some pointers here? I hope that you don’t mean by rewriting the importer script of question2answer. Thanks

Not the whole script, just the database queries, and really just the FROM part. If you have a budget I can fix it for you.

I don’t have much budget but I would like to import small data from my old forum. [画像] pfaffman: If you have a budget I can fix it for you. What do you have in mind?

migration error with question2answer.rb のエラー

製品サポート移行

RGJ (Richard - Communiteq) 2019 年 3 月 6 日午後 1:10 21

I didn’t clean up the code good enough
You need to remove the word NOT on line 95. I have updated the gist.

トピック		返信	表示
Q2a import error Migration	4	665	2019 年 10 月 3 日
Issue for q2a import Migration	6	1581	2019 年 10 月 31 日
Can I transfer from question2answer to discourse Migration	1	94	2024 年 7 月 25 日
Importing from PHP Question2Answer Migration	2	2655	2017 年 11 月 27 日
Plugin causing errors during rebuild Self-hosting	20	2378	2022 年 10 月 11 日

migration error with question2answer.rb のエラー

関連トピック