ChiliProject - issue_640_debug.txt

ChiliProject is not maintained anymore. Please be advised that there will be no more updates.

We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.

issue_640_debug.txt

MySQL dump/content of example issue and it's journal - Chris Dähn, 2011-10-07 08:31 am

Download (4.1 kB)

 Problem:  Internal error (see ChiliProject issue #640) when displaying ticket with journal
 Tested with ChiliProject 2.2.0 and 2.3.0 with all plugins disabled and with tickets with+without parents.
 Database was originally created by a Trac migration with ChiliProject 1.5.1, then upgraded to ChiliProject 2.2.0.
 > SELECT * FROM chiliproject.issues WHERE id = 1430 INTO OUTFILE '/tmp/out2.csv' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"';
 ;2;4;"Perl-Scripts für EasyMailImport/Export";"Die EasyMailImportExport Tools sollen durch Perl-Scripte ersetzt werden.
\
+\
 * einarbeiten in Perl
\
 * Entwurf der Struktur der Scripte/Funktionen
\
 * Perl-Script für EasyMailImport erstellen
\
 * Perl-Script für EasyMailExport erstellen
\
 ";"2011-10-07";\N;2;3;5;\N;5;23;"2011-08-19 17:25:08";"2011-10-06 09:58:19";"2011-10-04";0;\N;;;6;9
 > SELECT * FROM journals WHERE journaled_id = 1430 INTO OUTFILE '/tmp/out3.csv' FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"';
 ;1430;5;\N;"2011-08-19 17:25:08";1;"issues";"--- \
 start_date: \
 - \
 - 2011-08-19\
 estimated_hours: \
 - \
 - \
 created_on: \
 - \
 - 2011-08-19 17:25:08 +02:00\
 priority_id: \
 - 4\
 - 3\
 project_id: \
 - 0\
 - 1\
 fixed_version_id: \
 - \
 - 12\
 lft: \
 - \
 - 1\
 lock_version: \
 - 0\
 - 3\
 root_id: \
 - \
 - 1430\
 assigned_to_id: \
 - \
 - 5\
 done_ratio: \
 - 0\
 - 0\
 subject: \
 - \"\"\
 - \"Perl-Scripts f\\xC3\\xBCr EasyMailImport/Export\"\
 updated_on: \
 - \
 - 2011-08-19 17:26:18 +02:00\
 category_id: \
 - \
 - 3\
 tracker_id: \
 - 0\
 - 1\
 due_date: \
 - \
 - \
 parent_id: \
 - \
 - \
 author_id: \
 - 0\
 - 5\
 description: \
 - \
 - \"Die [[EasyMailImportExport]] Tools sollen durch Perl-Scripte ersetzt werden.\\r\\n\\\
   \\r\\n\\\
   * einarbeiten in Perl\\r\\n\\\
   * Entwurf der Struktur der Scripte/Funktionen\\r\\n\\\
   * Perl-Script f\\xC3\\xBCr [[EasyMailImport]] erstellen\\r\\n\\\
   * Perl-Script f\\xC3\\xBCr [[EasyMailExport]] erstellen\\r\\n\"\
 status_id: \
 - 1\
 - 1\
 rgt: \
 - \
 - 2\
 ";"IssueJournal"
 ;1430;1;"";"2011-09-18 21:29:34";1;"changesets";"--- \
 committed_on: \
 - \
 - &id001 2008-02-07 12:24:35.680777 +01:00\
 commit_date: \
 - \
 - *id001\
 comments: \
 - \
 - \"- change ImageManagerSettings object to pointer in main()\"\
 user_id: \
 - \
 - 5\
 revision: \
 - \
 - \"940\"\
 repository_id: \
 - \
 - 1\
 committer: \
 - \
 - kaisler\
 ";"ChangesetJournal"
 ;1430;1;"";"2011-09-19 12:55:39";2;"issues";"--- \
 project_id: \
 - 1\
 - 4\
 fixed_version_id: \
 - 12\
 - \
 category_id: \
 - 3\
 - \
 ";"IssueJournal"
 ;1430;2;"";"2011-09-20 15:31:10";3;"issues";"--- \
 done_ratio: \
 - 25\
 - 0\
 due_date: \
 - 2011-08-24\
 - 2011-09-30\
 ";"IssueJournal"
 ;1430;5;"";"2011-09-22 08:59:23";4;"issues";"--- \
 priority_id: \
 - 3\
 - 5\
 custom_values2: \
 - \"25\"\
 - \"\"\
 done_ratio: \
 - 0\
 - 10\
 status_id: \
 - 1\
 - 2\
 ";"IssueJournal"
 ;1430;5;"";"2011-09-22 16:03:36";5;"issues";"--- \
 done_ratio: \
 - 10\
 - 20\
 ";"IssueJournal"
 ;1430;2;"";"2011-09-23 12:39:23";6;"issues";"--- \
 description: \
 - \"Die [[EasyMailImportExport]] Tools sollen durch Perl-Scripte ersetzt werden.\\r\\n\\\
   \\r\\n\\\
   * einarbeiten in Perl\\r\\n\\\
   * Entwurf der Struktur der Scripte/Funktionen\\r\\n\\\
   * Perl-Script f\\xC3\\xBCr [[EasyMailImport]] erstellen\\r\\n\\\
   * Perl-Script f\\xC3\\xBCr [[EasyMailExport]] erstellen\\r\\n\"\
 - \"Die EasyMailImportExport Tools sollen durch Perl-Scripte ersetzt werden.\\r\\n\\\
   \\r\\n\\\
   * einarbeiten in Perl\\r\\n\\\
   * Entwurf der Struktur der Scripte/Funktionen\\r\\n\\\
   * Perl-Script f\\xC3\\xBCr EasyMailImport erstellen\\r\\n\\\
   * Perl-Script f\\xC3\\xBCr EasyMailExport erstellen\\r\\n\"\
 ";"IssueJournal"
 ;1430;5;"";"2011-09-28 20:03:36";7;"issues";"--- \
 done_ratio: \
 - 20\
 - 40\
 ";"IssueJournal"
 ;1430;5;"";"2011-09-29 20:43:53";8;"issues";"--- \
 done_ratio: \
 - 40\
 - 60\
 ";"IssueJournal"
 ;1430;2;"";"2011-10-04 16:27:03";9;"issues";"--- \
 assigned_to_id: \
 - 5\
 - 2\
 ";"IssueJournal"
 ;1430;2;"";"2011-10-04 16:27:40";10;"issues";"--- \
 start_date: \
 - 2011-08-19\
 - 2011-10-04\
 done_ratio: \
 - 60\
 - 0\
 due_date: \
 - 2011-09-30\
 - 2011-10-07\
 ";"IssueJournal"
 ;1430;2;"";"2011-10-06 09:58:19";11;"issues";"--- \
 assigned_to_id: \
 - 2\
 - 3\
 ";"IssueJournal"