Project

General

Profile

Import Issues in Redmine 2.4.3

Added by J BS almost 10 years ago

Hello,

I'm pretty new to REDMINE and I wonder how a list of issues can be imported into Redmine.
I found differents plugins but I couldn't make them works.

I noticed that there was a plugin "redmine_importer"
I know this issue has been discused a lot. I found many topic about this one, but I tried most of the given solutions...

I have installed Redmine through Bitnami. I'm running Redmine on a Windows 7 computer.

Here is my conf:

Environment:
Redmine version 2.4.3.stable
Ruby version 1.9.3-p231 (2012-05-25) [i386-mingw32]
Rails version 3.2.16
Environment production
Database adapter Mysql2

Redmine plugins:
redmine_importer 1.2.2

I can select the input csv file, but when uploading it an internal error is displayed (error 500).

Below is the error I got from the log file:

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'bitnami_redmine.import_in_progresses' doesn't exist: DELETE FROM `import_in_progresses` WHERE (user_id = 1)):

The thing is that I don't understand why this table doesn't exist..

Any idea?

Regards, and thanks you.

Julien.


Replies (2)

RE: Import Issues in Redmine 2.4.3 - Added by Denis Krivoshchekov over 9 years ago

Julien

This is a plugin bug or you don't run 'rake redmine:plugins:migrate RAILS_ENV=...' (instruction from plugin README) for create 'import_in_progresses' table.

I think, any Ruby programmer can help you.

RE: Import Issues in Redmine 2.4.3 - Added by Chetan Malhotra over 7 years ago

J BS wrote:

Hello,

I'm pretty new to REDMINE and I wonder how a list of issues can be imported into Redmine.
I found differents plugins but I couldn't make them works.

I noticed that there was a plugin "redmine_importer"
I know this issue has been discused a lot. I found many topic about this one, but I tried most of the given solutions...

I have installed Redmine through Bitnami. I'm running Redmine on a Windows 7 computer.

Here is my conf:

Environment:
Redmine version 2.4.3.stable
Ruby version 1.9.3-p231 (2012-05-25) [i386-mingw32]
Rails version 3.2.16
Environment production
Database adapter Mysql2

Redmine plugins:
redmine_importer 1.2.2

I can select the input csv file, but when uploading it an internal error is displayed (error 500).

Below is the error I got from the log file:

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'bitnami_redmine.import_in_progresses' doesn't exist: DELETE FROM `import_in_progresses` WHERE (user_id = 1)):

The thing is that I don't understand why this table doesn't exist..

Any idea?

Regards, and thanks you.

Julien.

I too faced this same error. It happens when you drop the redmine table from mysql after installing the redmine_importer and replacing it with a different imported table which does not have the table import_in_progresses that redmine_importer adds during "bundle exec rake redmine:plugins:migrate RAILS_ENV=production".

Resolution: run "bundle exec rake redmine:plugins:migrate RAILS_ENV=production" again

    (1-2/2)