View Issue Details

IDProjectCategoryView StatusLast Update
0012123mantisbtplug-inspublic2011-08-05 02:20
Reportercvillard Assigned Todhx  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionduplicate 
Product Version1.2.1 
Summary0012123: Import/Export 1.0 error 401
Description

Testing the Import/Export 1.0 plugin, I did the following :

  • Create a project
  • Create some categories
  • Adding some bugs
  • Exporting these bugs
  • Importing the file produced by the plugin.

I received the error :

APPLICATION ERROR 0000401
Database query failed. Error received from database was #1048: Column 'profile_id' cannot be null 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
( ?,?,?,?,
?,?,?,?,
?,?,?,?,
?,?,?,?,
?,?,?,?,
?,?,?,?,
?,?,?,?).

When I reported the bugs, I didn't select or fill any profile.

The exported XML file is uploaded with this issue.

TagsNo tags attached.
Attached Files
exported_issues.xml (5,187 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<mantis version="1.2.1" urlbase="http://localhost/mantis/" issuelink="#" notelink="~" format="1">
    <issue>
        <id>5</id>
        <project id="1">test</project>
        <reporter id="1">administrator</reporter>
        <handler id="1">administrator</handler>
        <priority id="20">low</priority>
        <severity id="30">text</severity>
        <reproducibility id="70">have not tried</reproducibility>
        <status id="90">closed</status>
        <resolution id="20">fixed</resolution>
        <projection id="10">none</projection>
        <category id="2">categorieTest</category>
        <date_submitted>1274779063</date_submitted>
        <last_updated>1276085105</last_updated>
        <eta id="10">none</eta>
        <view_state id="10">public</view_state>
        <summary>Test_estimated_time</summary>
        <due_date>1</due_date>
        <description>test du champ personnalisé d'entrée du temps estimé pour la résolution</description>
    </issue>
    <issue>
        <id>6</id>
        <project id="1">test</project>
        <reporter id="1">administrator</reporter>
        <priority id="30">normal</priority>
        <severity id="50">minor</severity>
        <reproducibility id="10">always</reproducibility>
        <status id="10">new</status>
        <resolution id="10">open</resolution>
        <projection id="10">none</projection>
        <category id="2">categorieTest</category>
        <date_submitted>1275555116</date_submitted>
        <last_updated>1275924443</last_updated>
        <eta id="10">none</eta>
        <view_state id="10">public</view_state>
        <summary>test due_date</summary>
        <due_date>1</due_date>
        <description>description</description>
    </issue>
    <issue>
        <id>1</id>
        <project id="1">test</project>
        <reporter id="1">administrator</reporter>
        <handler id="1">administrator</handler>
        <priority id="30">normal</priority>
        <severity id="50">minor</severity>
        <reproducibility id="70">have not tried</reproducibility>
        <status id="80">resolved</status>
        <resolution id="20">fixed</resolution>
        <projection id="10">none</projection>
        <category id="2">categorieTest</category>
        <date_submitted>1274455116</date_submitted>
        <last_updated>1274952880</last_updated>
        <eta id="10">none</eta>
        <view_state id="10">public</view_state>
        <summary>premiere demande</summary>
        <due_date>1</due_date>
        <description>description de la premiere demande</description>
        <steps_to_reproduce>jene sais pas encore</steps_to_reproduce>
        <additional_information>rien a ajouté votre honneur !</additional_information>
    </issue>
    <issue>
        <id>2</id>
        <project id="1">test</project>
        <reporter id="1">administrator</reporter>
        <handler id="1">administrator</handler>
        <priority id="30">normal</priority>
        <severity id="60">major</severity>
        <reproducibility id="10">always</reproducibility>
        <status id="40">@40@</status>
        <resolution id="10">open</resolution>
        <projection id="10">none</projection>
        <category id="2">categorieTest</category>
        <date_submitted>1274773155</date_submitted>
        <last_updated>1274773248</last_updated>
        <eta id="10">none</eta>
        <view_state id="10">public</view_state>
        <summary>Deuxième demande</summary>
        <due_date>1</due_date>
        <description>Demande non résolue</description>
    </issue>
    <issue>
        <id>4</id>
        <project id="1">test</project>
        <reporter id="1">administrator</reporter>
        <priority id="30">normal</priority>
        <severity id="80">block</severity>
        <reproducibility id="10">always</reproducibility>
        <status id="10">new</status>
        <resolution id="10">open</resolution>
        <projection id="10">none</projection>
        <category id="2">categorieTest</category>
        <date_submitted>1274773205</date_submitted>
        <last_updated>1274773205</last_updated>
        <eta id="10">none</eta>
        <view_state id="10">public</view_state>
        <summary>Quatrième demande</summary>
        <due_date>1</due_date>
        <description>4eme demande</description>
    </issue>
    <issue>
        <id>3</id>
        <project id="1">test</project>
        <reporter id="1">administrator</reporter>
        <handler id="1">administrator</handler>
        <priority id="30">normal</priority>
        <severity id="80">block</severity>
        <reproducibility id="10">always</reproducibility>
        <status id="50">assigned</status>
        <resolution id="10">open</resolution>
        <projection id="10">none</projection>
        <category id="2">categorieTest</category>
        <date_submitted>1274773182</date_submitted>
        <last_updated>1274773182</last_updated>
        <eta id="10">none</eta>
        <view_state id="10">public</view_state>
        <summary>Troisième demande</summary>
        <due_date>1</due_date>
        <description>troisième demande</description>
    </issue>
</mantis>
exported_issues.xml (5,187 bytes)   

Relationships

duplicate of 0012112 closeddregad XML Import fails: Column 'profile_id' cannot be null 

Activities

KarlReichert

KarlReichert

2010-08-12 08:07

reporter   ~0026293

I can confirm that. This bug is a duplicate of bug 0012112, by the way.