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**…

I believe that I have the right database as I finished importing the database (on Discourse server) using mysql -uroot -p -e 'CREATE DATABASE q2a' mysql -uroot -p q2a < q2a_dump.sql I was able to back up my new database using mysqldump -u username -p database_to_backup > backup_name.sql and I …

That’s the default. Did you change the db_prefix to “primary_dB” for some reason?

It was already included in the importer script as follows. # CHANGE THESE BEFORE RUNNING THE IMPORTER 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_PRE…

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?

migration error with question2answer.rb のエラー

製品サポート移行

pfaffman (Jay Pfaffman) 2019 年 3 月 4 日午後 12:06 2

The users table that it’s looking for does not exist. Do you see a table called “users”? Do you have the right database?

トピック		返信	表示
Q2a import error Migration	4	666	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	2381	2022 年 10 月 11 日

migration error with question2answer.rb のエラー

関連トピック