Apparently I do not have an account to report bugs and when I attempt to create one I do not receive the email.
I found and corrected part of my issue. I had assumed the menu item [Import Issues] was for the CSV Import. However, I discovered that is actually for the XML Import/Export plugin and not the CSV Import. Going back through the directions I have now installed it and have the [Import CSV file] menu item.
I can now get to the CSV Import screen and it shows the first couple of rows of the import file correctly. The columns in my import file are: Reporter,Assigned To,Priority,Summary,Category,Description,Additional Information,Product Version,Platform
However, when I click the Import file button I am getting the following error:
Code: Select all
Database query failed. Error received from database was #1265: Data truncated for column 'date_submitted' at row 1 for the query: INSERT INTO mantis_bug_table
( project_id,reporter_id, handler_id,duplicate_id,
priority,severity, reproducibility,status,
resolution,projection, category_id,date_submitted,
last_updated,eta, bug_text_id,
os, os_build,platform, version,build,
profile_id, summary, view_state, sponsorship_total, sticky, fixed_in_version,
target_version, due_date
)
VALUES
( ?,?,?,?,
?,?,?,?,
?,?,?,?,
?,?,?,?,
?,?,?,?,
?,?,?,?,
?,?,?,?).
I have tried adding the column "date_submitted" to my import file and have tried two formats: mm-dd-yyyy & mm/dd/yyyy. I also tried a null value and still get the error.
Any ideas as to what is causing this issue?
I am using:
MantisBT version 1.3.2
CSV Import 1.4.0
Regards,
Ron