Export function does not include any profile information in the exported data.
As a consequence, the "profile_id" field of the BugData created during import is never initialized, while the database table constraints state that it must be not null.

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

Can someone check if the latest nightly snapshot of MantisBT 1.3.x resolves this issue? Issue 0012013 improved the XML import/export functionality a great deal.

Thanks

I installed the current nightly build to test that, but I can't login into this build:

APPLICATION ERROR #2900
For security reasons MantisBT will not operate when $g_crypto_master_salt is not specified correctly in config_inc.php.
Please use the "Back" button in your web browser to return to the previous page. There you can correct
whatever problems were identified in this error or select another action. You can also click an option
from the menu bar to go directly to a new section.

I cannot find a solution for that. Can someone help me? Than I can test the new Im-/Export.

The latest version of the manual contains information on how to set $g_crypto_master_salt.

Basically just set it to a completely random string (20+ characters) inside config_defaults_inc.pgp

This only occurs to issues that contain the value 0 (zero) in the "profile_id" field. If the field has a different value, it is exported.

The problem is the following code in plugins/XMLImportExport/export.php :
[code]
foreach( $t_columns as $t_element ) {
$t_value = $t_row->$t_element;
if( empty( $t_value ) ) {
continue;
}
[/code]

The empty() function returns FALSE, if the field's value is 0 (zero).

This is an excerpt of the PHP manual, empty() function:
[excerpt]
Returns FALSE if var has a non-empty and non-zero value.

The following things are considered to be empty:

* "" (an empty string)
* 0 (0 as an integer)
* "0" (0 as a string)
* NULL
* FALSE
* array() (an empty array)
* var $var; (a variable declared, but without a value in a class)

[/excerpt]

Thus, variables containing 0 (zero) are considered empty.

This might also be a problem for other fields containing 0 (zero) values.

I modified the code above to:

[code]
foreach( $t_columns as $t_element ) {
$t_value = $t_row->$t_element;
if( strval( $t_value ) == "" ) {
continue;
}
[/code]

and it seems to work, I can not say if there are other problems with this code, though.

It seems that the exporter is currently designed not to export properties that have empty/null values. Thus the importer should be detecting missing fields in the XML file and filling them with default values (taking into account the defaults set in config_defaults_inc.php).

Thus I think the fixes need to be made to the import side of the plugin to resolve this issue?

I stumbled upon this problem, and looked into the DB

I found all my issues have "profile_id" 0, so I just did

"alter table mantis_bug_table change column profile_id profile_id int(7) unsigned default 0;"

and the import worked fine.

This was already fixed in master as part of 0012013

Marking as 'acknowledged' not resolved/closed to track that change gets ported to master-2.0.x branch