AgileTrack
Put your development on the AgileTrack

Installation Question

After installing the Windows version I get following error:

The databaseversion is out of sync
The mysql databaseversion (1) is out of sync with the expected schema version (15) Do you want to update the database persistence now

After choosing yes nothing happens, it is not possible to login.

What can I do to make it work?

—Posted by ronverzn on Oct 11, 2006


	Forum AgileTrack Client


	Reply

Could you please post more information about your configuration and the problem—e.g. Database Name as specified under "Settings…", version of MySQL you're using, version of Java, etc.

Also, you should have a file called agiletrack-info.log which may contain more information about any error you're experiencing. Please post the relevant portion of the log file. Thanks.

—Posted by Adam Lane on Oct 11, 2006 at 8:06:34 PM

I'm having the same problem.
Java Version 1.5.0 (build 1.5.0_06-b05)
MySQL version 5.0
MySQL is installed on my machine where I am trying to run agile track.

Agile Track Settings:
Conncetion Type: MySQL
MySQL username: root
MySQL Host Address: localhost
MySQL Database name: agiletrack
MySQL Host port: (this is blank)

agiletrack-info.log:
0 [main] INFO : controller.LocalSettings – Check profile 'default'.
0 [main] INFO : controller.LocalSettings – Migrate profile 'default' to new profile format…
0 [main] INFO : controller.LocalSettings – ...existing profile values:
0 [main] INFO : controller.LocalSettings – dbAddress:
15 [main] INFO : controller.LocalSettings – dbName:
15 [main] INFO : controller.LocalSettings – dbPassword:
15 [main] INFO : controller.LocalSettings – dbPort:
15 [main] INFO : controller.LocalSettings – dbUsername:
15 [main] INFO : controller.LocalSettings – httpAddress:
15 [main] INFO : controller.LocalSettings – jsonHttpAddress:
238609 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 1 rows: CREATE DATABASE agiletrack
238671 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `agiletrack_config` (`schema_version` int(11) NOT NULL default '0') TYPE=MyISAM
238671 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 1 rows: INSERT INTO agiletrack_config (schema_version) VALUES (1)
238734 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `issue` (`id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `details` text, `state` varchar(100) NOT NULL default '', `priority` int(11) default '0', `time_estimate` int(11) default '0', `user_id` int(11) default '0', `iteration_id` int(11) default '0', PRIMARY KEY (`id`)) TYPE=MyISAM
238765 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `issue_project` (`id` int(11) NOT NULL default '0', `project_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`,`project_id`)) TYPE=MyISAM
238812 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `issue_time` (`id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `start_time` datetime NOT NULL, `minutes` int(11) NOT NULL default '0') TYPE=MyISAM
238859 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `iteration` (`id` varchar(100) NOT NULL default '', `title` varchar(255) NOT NULL default '', `start_date` date NOT NULL default '0000–00-00', `end_date` date NOT NULL default '0000–00-00', PRIMARY KEY (`id`)) TYPE=MyISAM
238906 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `project` (`id` varchar(100) NOT NULL default '', `title` varchar(255) NOT NULL default '', `details` text, `priority` int(11) default '0', PRIMARY KEY (`id`)) TYPE=MyISAM
238953 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `query` (`id` int(11) NOT NULL default '0', `user_id` int(11) default '0', `title` varchar(255) NOT NULL default '', `search_text` varchar(255) default '', `title_text` tinyint(1) NOT NULL default '0', `details_text` tinyint(1) NOT NULL default '0', `comments_text` tinyint(1) NOT NULL default '0', `projects` varchar(255) default '', `iterations` varchar(255) default '', `users` varchar(255) default '', `states` varchar(255) default '', `priorities` varchar(255) default '', `types` varchar(255) default '', PRIMARY KEY (`id`)) TYPE=MyISAM
239031 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `record` (`id` int(11) NOT NULL default '0', `deleted` tinyint(1) NOT NULL default '0', `modified_date` datetime NOT NULL, `type` varchar(100) NOT NULL default '', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`)) TYPE=MyISAM
239078 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `record_comment` (`id` int(11) NOT NULL default '0', `details` text NOT NULL, `comment_date` datetime NOT NULL, `user_id` int(11) default '0', KEY `RECORD_ID` (`id`)) TYPE=MyISAM
239125 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `record_history` (`id` int(11) NOT NULL default '0', `log_type` varchar(100) NOT NULL default '', `log_details` varchar(255) default '', `log_date` datetime NOT NULL, `user_id` int(11) default '0', KEY `RECORD_ID` (`id`)) TYPE=MyISAM
239171 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `record_state` (`type` varchar(100) NOT NULL default '', `order` int(11) NOT NULL default '0', `state` varchar(100) NOT NULL default '', `next_state` varchar(100) NOT NULL default '') TYPE=MyISAM
239234 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `sequence` (`id_sequence` int(11) NOT NULL default '0') TYPE=MyISAM
239265 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `subtask` (`id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `time_estimate` int(11) default '0', `parent_id` int(11) NOT NULL default '0') TYPE=MyISAM
239312 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `user` (`id` int(11) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `name` varchar(100) NOT NULL default '', `phone` varchar(100) default '', `cell` varchar(100) default '', `email` varchar(100) default '', PRIMARY KEY (`id`)) TYPE=MyISAM
239343 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 1…
239343 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: DELETE FROM `record_state`
239359 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: INSERT INTO `record_state` (`type`, `order`, `state`, `next_state`) VALUES
('Task', 1, 'Prepare', 'Open'),
('Task', 2, 'Open', 'Prepare'),
('Task', 2, 'Open', 'Later'),
('Task', 2, 'Open', 'Complete'),
('Task', 3, 'Later', 'Open'),
('Task', 3, 'Complete', 'Open'),
('Story', 1, 'Prepare', 'Open'),
('Story', 2, 'Open', 'Prepare'),
('Story', 2, 'Open', 'Later'),
('Story', 2, 'Open', 'Implemented'),
('Story', 3, 'Later', 'Open'),
('Story', 3, 'Implemented', 'Open'),
('Defect', 1, 'Prepare', 'Open'),
('Defect', 2, 'Open', 'Prepare'),
('Defect', 2, 'Open', 'Later'),
('Defect', 2, 'Open', 'Fixed'),
('Defect', 2, 'Open', 'Duplicate'),
('Defect', 2, 'Open', 'Not Reproducible'),
('Defect', 2, 'Open', 'Will Not fix'),
('Defect', 2, 'Open', 'Works As Designed'),
('Defect', 3, 'Later', 'Open'),
('Defect', 3, 'Fixed', 'Open'),
('Defect', 3, 'Duplicate', 'Open'),
('Defect', 3, 'Not Reproducible', 'Open'),
('Defect', 3, 'Will Not fix', 'Open'),
('Defect', 3, 'Works As Designed', 'Open')
239359 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 2…
239390 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_sequence` (`id_sequence` int(11) NOT NULL default '0', `issue_id_sequence` int(11) NOT NULL default '0') Type=MyISAM
239437 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_record` (`id` int(11) NOT NULL default '0', `type` varchar(100) NOT NULL default '', `deleted` tinyint(1) NOT NULL default '0', `modified_date` datetime NOT NULL, `name` varchar(255) default NULL, PRIMARY KEY (`id`)) Type=MyISAM
239484 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_comment` (`id` int(11) NOT NULL default '0', `content` text NOT NULL, `comment_date` datetime NOT NULL, `user_id` int(11) default NULL, `issue_id` int(11) default NULL, PRIMARY KEY (`id`)) Type=MyISAM
239531 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_history` (`id` int(11) NOT NULL default '0', `log_type` varchar(100) NOT NULL default '', `log_date` datetime NOT NULL, `user_id` int(11) default NULL, `record_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
239578 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_time` (`id` int(11) NOT NULL default '0', `start_time` datetime NOT NULL, `end_time` datetime NOT NULL, `issue_id` int(11) default NULL, `user_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
239625 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_user` (`id` int(11) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `phone` varchar(100) default '', `cell` varchar(100) default '', `email` varchar(100) default '', PRIMARY KEY (`id`)) Type=MyISAM
239687 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_project` (`id` varchar(100) NOT NULL default '', `description` text, PRIMARY KEY (`id`)) Type=MyISAM
239734 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_iteration` (`id` varchar(100) NOT NULL default '', `start_date` date NOT NULL default '0000–00-00', `end_date` date NOT NULL default '0000–00-00', PRIMARY KEY (`id`)) Type=MyISAM
239781 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_job` ( `id` int(11) NOT NULL default '0', `description` text, `time_estimate` int(11) default NULL, `tested_verified` tinyint(1) NOT NULL default '0', `closed` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
239828 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_issue` (`id` int(11) NOT NULL default '0', `issue_id` int(11) NOT NULL default '0', `state` varchar(100) NOT NULL default '', `importance` int(11) default NULL, `urgency` date default NULL, `user_id` int(11) default NULL, `iteration_id` int(11) default NULL, `project_id` int(11) default NULL, PRIMARY KEY (`id`)) Type=MyISAM
239859 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_subtask` (`id` int(11) NOT NULL default '0', `parent_issue_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
0 [main] INFO : controller.LocalSettings – Check profile 'default'.
47 [main] INFO : controller.LocalSettings – Check profile 'demo'.
12547 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 1…
12547 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: DELETE FROM `record_state`
12563 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: INSERT INTO `record_state` (`type`, `order`, `state`, `next_state`) VALUES
('Task', 1, 'Prepare', 'Open'),
('Task', 2, 'Open', 'Prepare'),
('Task', 2, 'Open', 'Later'),
('Task', 2, 'Open', 'Complete'),
('Task', 3, 'Later', 'Open'),
('Task', 3, 'Complete', 'Open'),
('Story', 1, 'Prepare', 'Open'),
('Story', 2, 'Open', 'Prepare'),
('Story', 2, 'Open', 'Later'),
('Story', 2, 'Open', 'Implemented'),
('Story', 3, 'Later', 'Open'),
('Story', 3, 'Implemented', 'Open'),
('Defect', 1, 'Prepare', 'Open'),
('Defect', 2, 'Open', 'Prepare'),
('Defect', 2, 'Open', 'Later'),
('Defect', 2, 'Open', 'Fixed'),
('Defect', 2, 'Open', 'Duplicate'),
('Defect', 2, 'Open', 'Not Reproducible'),
('Defect', 2, 'Open', 'Will Not fix'),
('Defect', 2, 'Open', 'Works As Designed'),
('Defect', 3, 'Later', 'Open'),
('Defect', 3, 'Fixed', 'Open'),
('Defect', 3, 'Duplicate', 'Open'),
('Defect', 3, 'Not Reproducible', 'Open'),
('Defect', 3, 'Will Not fix', 'Open'),
('Defect', 3, 'Works As Designed', 'Open')
12563 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 2…
0 [main] INFO : controller.LocalSettings – Check profile 'default'.
0 [main] INFO : controller.LocalSettings – Check profile 'demo'.
235746 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 1…
235746 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: DELETE FROM `record_state`
235746 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: INSERT INTO `record_state` (`type`, `order`, `state`, `next_state`) VALUES
('Task', 1, 'Prepare', 'Open'),
('Task', 2, 'Open', 'Prepare'),
('Task', 2, 'Open', 'Later'),
('Task', 2, 'Open', 'Complete'),
('Task', 3, 'Later', 'Open'),
('Task', 3, 'Complete', 'Open'),
('Story', 1, 'Prepare', 'Open'),
('Story', 2, 'Open', 'Prepare'),
('Story', 2, 'Open', 'Later'),
('Story', 2, 'Open', 'Implemented'),
('Story', 3, 'Later', 'Open'),
('Story', 3, 'Implemented', 'Open'),
('Defect', 1, 'Prepare', 'Open'),
('Defect', 2, 'Open', 'Prepare'),
('Defect', 2, 'Open', 'Later'),
('Defect', 2, 'Open', 'Fixed'),
('Defect', 2, 'Open', 'Duplicate'),
('Defect', 2, 'Open', 'Not Reproducible'),
('Defect', 2, 'Open', 'Will Not fix'),
('Defect', 2, 'Open', 'Works As Designed'),
('Defect', 3, 'Later', 'Open'),
('Defect', 3, 'Fixed', 'Open'),
('Defect', 3, 'Duplicate', 'Open'),
('Defect', 3, 'Not Reproducible', 'Open'),
('Defect', 3, 'Will Not fix', 'Open'),
('Defect', 3, 'Works As Designed', 'Open')
235746 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 2…
0 [main] INFO : controller.LocalSettings – Check profile 'default'.
15 [main] INFO : controller.LocalSettings – Check profile 'demo'.
268984 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 1…
268984 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: DELETE FROM `record_state`
269000 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: INSERT INTO `record_state` (`type`, `order`, `state`, `next_state`) VALUES
('Task', 1, 'Prepare', 'Open'),
('Task', 2, 'Open', 'Prepare'),
('Task', 2, 'Open', 'Later'),
('Task', 2, 'Open', 'Complete'),
('Task', 3, 'Later', 'Open'),
('Task', 3, 'Complete', 'Open'),
('Story', 1, 'Prepare', 'Open'),
('Story', 2, 'Open', 'Prepare'),
('Story', 2, 'Open', 'Later'),
('Story', 2, 'Open', 'Implemented'),
('Story', 3, 'Later', 'Open'),
('Story', 3, 'Implemented', 'Open'),
('Defect', 1, 'Prepare', 'Open'),
('Defect', 2, 'Open', 'Prepare'),
('Defect', 2, 'Open', 'Later'),
('Defect', 2, 'Open', 'Fixed'),
('Defect', 2, 'Open', 'Duplicate'),
('Defect', 2, 'Open', 'Not Reproducible'),
('Defect', 2, 'Open', 'Will Not fix'),
('Defect', 2, 'Open', 'Works As Designed'),
('Defect', 3, 'Later', 'Open'),
('Defect', 3, 'Fixed', 'Open'),
('Defect', 3, 'Duplicate', 'Open'),
('Defect', 3, 'Not Reproducible', 'Open'),
('Defect', 3, 'Will Not fix', 'Open'),
('Defect', 3, 'Works As Designed', 'Open')
269000 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 2…
0 [main] INFO : controller.LocalSettings – Check profile 'default'.
31 [main] INFO : controller.LocalSettings – Check profile 'demo'.
713124 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 1…
713156 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: DELETE FROM `record_state`
713156 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: INSERT INTO `record_state` (`type`, `order`, `state`, `next_state`) VALUES
('Task', 1, 'Prepare', 'Open'),
('Task', 2, 'Open', 'Prepare'),
('Task', 2, 'Open', 'Later'),
('Task', 2, 'Open', 'Complete'),
('Task', 3, 'Later', 'Open'),
('Task', 3, 'Complete', 'Open'),
('Story', 1, 'Prepare', 'Open'),
('Story', 2, 'Open', 'Prepare'),
('Story', 2, 'Open', 'Later'),
('Story', 2, 'Open', 'Implemented'),
('Story', 3, 'Later', 'Open'),
('Story', 3, 'Implemented', 'Open'),
('Defect', 1, 'Prepare', 'Open'),
('Defect', 2, 'Open', 'Prepare'),
('Defect', 2, 'Open', 'Later'),
('Defect', 2, 'Open', 'Fixed'),
('Defect', 2, 'Open', 'Duplicate'),
('Defect', 2, 'Open', 'Not Reproducible'),
('Defect', 2, 'Open', 'Will Not fix'),
('Defect', 2, 'Open', 'Works As Designed'),
('Defect', 3, 'Later', 'Open'),
('Defect', 3, 'Fixed', 'Open'),
('Defect', 3, 'Duplicate', 'Open'),
('Defect', 3, 'Not Reproducible', 'Open'),
('Defect', 3, 'Will Not fix', 'Open'),
('Defect', 3, 'Works As Designed', 'Open')
713156 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 2…
0 [main] INFO : controller.LocalSettings – Check profile 'default'.
0 [main] INFO : controller.LocalSettings – Check profile 'demo'.
8953 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 1…
8968 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: DELETE FROM `record_state`
8968 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: INSERT INTO `record_state` (`type`, `order`, `state`, `next_state`) VALUES
('Task', 1, 'Prepare', 'Open'),
('Task', 2, 'Open', 'Prepare'),
('Task', 2, 'Open', 'Later'),
('Task', 2, 'Open', 'Complete'),
('Task', 3, 'Later', 'Open'),
('Task', 3, 'Complete', 'Open'),
('Story', 1, 'Prepare', 'Open'),
('Story', 2, 'Open', 'Prepare'),
('Story', 2, 'Open', 'Later'),
('Story', 2, 'Open', 'Implemented'),
('Story', 3, 'Later', 'Open'),
('Story', 3, 'Implemented', 'Open'),
('Defect', 1, 'Prepare', 'Open'),
('Defect', 2, 'Open', 'Prepare'),
('Defect', 2, 'Open', 'Later'),
('Defect', 2, 'Open', 'Fixed'),
('Defect', 2, 'Open', 'Duplicate'),
('Defect', 2, 'Open', 'Not Reproducible'),
('Defect', 2, 'Open', 'Will Not fix'),
('Defect', 2, 'Open', 'Works As Designed'),
('Defect', 3, 'Later', 'Open'),
('Defect', 3, 'Fixed', 'Open'),
('Defect', 3, 'Duplicate', 'Open'),
('Defect', 3, 'Not Reproducible', 'Open'),
('Defect', 3, 'Will Not fix', 'Open'),
('Defect', 3, 'Works As Designed', 'Open')
8968 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 2…
0 [main] INFO : controller.LocalSettings – Check profile 'default'.
0 [main] INFO : controller.LocalSettings – Check profile 'demo'.

—Kristy

—Posted by Kristy on Oct 25, 2006 at 9:46:07 AM

Looking at the log, the database apparently got partway through the database initialization on the first time and either encountered an error or was killed. That left the database in a bad state that the creation script doesn't now how to recover from. The logging for failures during database creation is only printing a stacktrace to the console so there's no way to see what the error may have been.

So far, I haven't been able to reproduce the error on MySQL 5.0, so there may be some other configuration details that are important. I'm expect that better logging will expose the problem.

To provide better logging, I'm providing a new agiletrack.jar that can be placed in the lib directory to replace the existing agiletrack.jar. It should do a better job of logging database failures. Download it at http://agiletrack.org/download/agiletrack.jar .

As far as correcting the problem goes, try connecting to MySQL and dropping the agiletrack database and try again to see if the error happens again, and gets logged this time. You could also just go to settings and rename the database to somethings like "agiletrack2" to have it create another database and see if an error occurs.

Good luck.

—Posted by Adam Lane on Oct 26, 2006 at 10:23:46 PM

I'm also getting the same issue. I used the jar that you provided. Here's the content of the log file when it fails:

0 [main] INFO : controller.LocalSettings – Check profile 'default'.
0 [main] INFO : controller.LocalSettings – Check profile 'demo'.
9859 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 1 rows: CREATE DATABASE agiletrack
9922 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `agiletrack_config` (`schema_version` int(11) NOT NULL default '0') TYPE=MyISAM
9922 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 1 rows: INSERT INTO agiletrack_config (schema_version) VALUES (1)
9984 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `issue` (`id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `details` text, `state` varchar(100) NOT NULL default '', `priority` int(11) default '0', `time_estimate` int(11) default '0', `user_id` int(11) default '0', `iteration_id` int(11) default '0', PRIMARY KEY (`id`)) TYPE=MyISAM
10047 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `issue_project` (`id` int(11) NOT NULL default '0', `project_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`,`project_id`)) TYPE=MyISAM
10093 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `issue_time` (`id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `start_time` datetime NOT NULL, `minutes` int(11) NOT NULL default '0') TYPE=MyISAM
10140 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `iteration` (`id` varchar(100) NOT NULL default '', `title` varchar(255) NOT NULL default '', `start_date` date NOT NULL default '0000–00-00', `end_date` date NOT NULL default '0000–00-00', PRIMARY KEY (`id`)) TYPE=MyISAM
10187 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `project` (`id` varchar(100) NOT NULL default '', `title` varchar(255) NOT NULL default '', `details` text, `priority` int(11) default '0', PRIMARY KEY (`id`)) TYPE=MyISAM
10234 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `query` (`id` int(11) NOT NULL default '0', `user_id` int(11) default '0', `title` varchar(255) NOT NULL default '', `search_text` varchar(255) default '', `title_text` tinyint(1) NOT NULL default '0', `details_text` tinyint(1) NOT NULL default '0', `comments_text` tinyint(1) NOT NULL default '0', `projects` varchar(255) default '', `iterations` varchar(255) default '', `users` varchar(255) default '', `states` varchar(255) default '', `priorities` varchar(255) default '', `types` varchar(255) default '', PRIMARY KEY (`id`)) TYPE=MyISAM
10297 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `record` (`id` int(11) NOT NULL default '0', `deleted` tinyint(1) NOT NULL default '0', `modified_date` datetime NOT NULL, `type` varchar(100) NOT NULL default '', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`id`)) TYPE=MyISAM
10359 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `record_comment` (`id` int(11) NOT NULL default '0', `details` text NOT NULL, `comment_date` datetime NOT NULL, `user_id` int(11) default '0', KEY `RECORD_ID` (`id`)) TYPE=MyISAM
10406 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `record_history` (`id` int(11) NOT NULL default '0', `log_type` varchar(100) NOT NULL default '', `log_details` varchar(255) default '', `log_date` datetime NOT NULL, `user_id` int(11) default '0', KEY `RECORD_ID` (`id`)) TYPE=MyISAM
10453 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `record_state` (`type` varchar(100) NOT NULL default '', `order` int(11) NOT NULL default '0', `state` varchar(100) NOT NULL default '', `next_state` varchar(100) NOT NULL default '') TYPE=MyISAM
10515 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `sequence` (`id_sequence` int(11) NOT NULL default '0') TYPE=MyISAM
10562 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `subtask` (`id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `time_estimate` int(11) default '0', `parent_id` int(11) NOT NULL default '0') TYPE=MyISAM
10609 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `user` (`id` int(11) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `name` varchar(100) NOT NULL default '', `phone` varchar(100) default '', `cell` varchar(100) default '', `email` varchar(100) default '', PRIMARY KEY (`id`)) TYPE=MyISAM
10625 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 1…
10625 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: DELETE FROM `record_state`
10640 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: INSERT INTO `record_state` (`type`, `order`, `state`, `next_state`) VALUES
('Task', 1, 'Prepare', 'Open'),
('Task', 2, 'Open', 'Prepare'),
('Task', 2, 'Open', 'Later'),
('Task', 2, 'Open', 'Complete'),
('Task', 3, 'Later', 'Open'),
('Task', 3, 'Complete', 'Open'),
('Story', 1, 'Prepare', 'Open'),
('Story', 2, 'Open', 'Prepare'),
('Story', 2, 'Open', 'Later'),
('Story', 2, 'Open', 'Implemented'),
('Story', 3, 'Later', 'Open'),
('Story', 3, 'Implemented', 'Open'),
('Defect', 1, 'Prepare', 'Open'),
('Defect', 2, 'Open', 'Prepare'),
('Defect', 2, 'Open', 'Later'),
('Defect', 2, 'Open', 'Fixed'),
('Defect', 2, 'Open', 'Duplicate'),
('Defect', 2, 'Open', 'Not Reproducible'),
('Defect', 2, 'Open', 'Will Not fix'),
('Defect', 2, 'Open', 'Works As Designed'),
('Defect', 3, 'Later', 'Open'),
('Defect', 3, 'Fixed', 'Open'),
('Defect', 3, 'Duplicate', 'Open'),
('Defect', 3, 'Not Reproducible', 'Open'),
('Defect', 3, 'Will Not fix', 'Open'),
('Defect', 3, 'Works As Designed', 'Open')
10640 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 2…
10672 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_sequence` (`id_sequence` int(11) NOT NULL default '0', `issue_id_sequence` int(11) NOT NULL default '0') Type=MyISAM
10734 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_record` (`id` int(11) NOT NULL default '0', `type` varchar(100) NOT NULL default '', `deleted` tinyint(1) NOT NULL default '0', `modified_date` datetime NOT NULL, `name` varchar(255) default NULL, PRIMARY KEY (`id`)) Type=MyISAM
10781 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_comment` (`id` int(11) NOT NULL default '0', `content` text NOT NULL, `comment_date` datetime NOT NULL, `user_id` int(11) default NULL, `issue_id` int(11) default NULL, PRIMARY KEY (`id`)) Type=MyISAM
10828 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_history` (`id` int(11) NOT NULL default '0', `log_type` varchar(100) NOT NULL default '', `log_date` datetime NOT NULL, `user_id` int(11) default NULL, `record_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
10890 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_time` (`id` int(11) NOT NULL default '0', `start_time` datetime NOT NULL, `end_time` datetime NOT NULL, `issue_id` int(11) default NULL, `user_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
10937 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_user` (`id` int(11) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `phone` varchar(100) default '', `cell` varchar(100) default '', `email` varchar(100) default '', PRIMARY KEY (`id`)) Type=MyISAM
11047 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_project` (`id` varchar(100) NOT NULL default '', `description` text, PRIMARY KEY (`id`)) Type=MyISAM
11093 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_iteration` (`id` varchar(100) NOT NULL default '', `start_date` date NOT NULL default '0000–00-00', `end_date` date NOT NULL default '0000–00-00', PRIMARY KEY (`id`)) Type=MyISAM
11125 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_job` ( `id` int(11) NOT NULL default '0', `description` text, `time_estimate` int(11) default NULL, `tested_verified` tinyint(1) NOT NULL default '0', `closed` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
11187 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_issue` (`id` int(11) NOT NULL default '0', `issue_id` int(11) NOT NULL default '0', `state` varchar(100) NOT NULL default '', `importance` int(11) default NULL, `urgency` date default NULL, `user_id` int(11) default NULL, `iteration_id` int(11) default NULL, `project_id` int(11) default NULL, PRIMARY KEY (`id`)) Type=MyISAM
11234 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `t_subtask` (`id` int(11) NOT NULL default '0', `parent_issue_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
11250 [AWT-EventQueue-0] FATAL: persistence.TrackerMySQLDatabase – The automatic database update failed.
java.sql.SQLException: Syntax error or access violation, message from server: "BLOB/TEXT column 'search_text' can't have a default value"

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.Connection.execSQL(Connection.java:2051) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at agiletrack.server.persistence.DatabaseResourceProvider.executeUpdateReport(DatabaseResourceProvider.java:73) at agiletrack.server.persistence.TrackerMySQLDatabase.updateDatabaseSchema(TrackerMySQLDatabase.java:236) at agiletrack.server.persistence.TrackerMySQLDatabase.<init>(TrackerMySQLDatabase.java:122) at agiletrack.server.persistence.TrackerMySQLDatabase.instantiateTrackerMYSQLDatabase(TrackerMySQLDatabase.java:25) at agiletrack.server.persistence.TrackerMySQLDatabaseFactory.getTrackerPersistenceInstance(TrackerMySQLDatabaseFactory.java:36) at agiletrack.server.persistence.TrackerPersistenceParameters.instantiatePersistence(TrackerPersistenceParameters.java:34) at agiletrack.server.TrackerModel.<init>(TrackerModel.java:112) at agiletrack.server.controller.TrackerLocalAccess.<init>(TrackerLocalAccess.java:29) at agiletrack.data.access.TrackerDirectDataAccessFactory.getTrackerDataAccessInstance(TrackerDirectDataAccessFactory.java:35) at agiletrack.data.access.TrackerDataAccessParameters.instantiateAccess(TrackerDataAccessParameters.java:33) at agiletrack.client.controller.TrackerSession.createInstance(TrackerSession.java:102) at agiletrack.client.view.LoginPanel.login(LoginPanel.java:210) at agiletrack.client.view.LoginPanel$2.actionPerformed(LoginPanel.java:147) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:5488) at javax.swing.JComponent.processMouseEvent(JComponent.java:3126) at java.awt.Component.processEvent(Component.java:5253) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3955) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1778) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at agiletrack.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:64) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

—Posted by balwinder on Oct 27, 2006 at 5:40:53 PM

That stack trace had the right information in it. I'm not exactly sure which versions of MySQL 5.0 are affected, but some versions apparently can take a default value in a text field, but more recent ones cannot. I adjusted syntax and I believe it should work now. I don't have a installation of MySQL 5.0 with the problem, so I haven't been able to test it.

Just download the http://agiletrack.org/download/agiletrack.jar again and it should be working. You'll first need to drop the database that was being created when the error occurred, but after that, I believe it will work.

Thanks for the details of the error.

—Posted by Adam Lane on Oct 27, 2006 at 11:24:19 PM

I did try the latest agiletrack.jar but still have the same problem. I found there are two places having default '' for text fields of—search_text in t_query, line 236, and—next_states in t_issue_state.
I changed them, and database schema was created correctly.

—Posted by Weikuo Liaw on Oct 29, 2006 at 11:54:37 PM

I had only changed the search_text, but didn't notice the next_states. I fixed the other line and rebuilt the jar and uploaded it. It can be downloaded using the link above. Again, I don't have a way to verify it, but I'm pretty sure it'll work this time.

By the way, it include some small changes that are in progress for the next release, but it's stable.

—Posted by Adam Lane on Oct 31, 2006 at 2:16:04 PM

I am having the exact same problem. Here is my log file for output. I've tried downloading the jar you provided but it did not fix the issue. I'm running the following versions of software:

OS: Windows XP SP2
Java: 1.5.0_08
MySQL: 5.0.27
AgileTrack: most recent downloadable

C:\Program Files\AgileTrack>agiletrack.bat
MySQL JDBC driver found.
Registered persistence provider: agiletrack.server.persistence.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.server.persistence.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.server.persistence.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.server.persistence.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.data.access.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.data.access.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.data.access.TrackerJSONRPCStreamDataAccessFactory
java.lang.NullPointerException

at agiletrack.util.CommonString.getLanguageList(CommonString.java:650) at agiletrack.client.view.LoginPanel.<init>(LoginPanel.java:47) at agiletrack.client.view.LoginFrame.<init>(LoginFrame.java:24) at agiletrack.client.ClientApplication.main(ClientApplication.java:135)
0 [main] INFO : controller.LocalSettings – Check profile 'default'.
15 [main] INFO : controller.LocalSettings – Check profile 'demo'.
7078 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
agiletrack_config` (`schema_version` int(11) NOT NULL default '0') TYPE=MyISAM
7093 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 1 rows: INSERT INTO ag
iletrack_config (schema_version) VALUES (1)
7125 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
issue` (`id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `details` text, `state` varchar(100) NOT NULL default '', `priority` int(11) default '0', `time_estimate` int(11) d
efault '0', `user_id` int(11) default '0', `iteration_id` int(11) default '0', PRIMARY KEY (`id`))
TYPE=MyISAM
7156 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
issue_project` (`id` int(11) NOT NULL default '0', `project_id` int(11) NOT NULL default '0', PRIMAR
Y KEY (`id`,`project_id`)) TYPE=MyISAM
7203 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
issue_time` (`id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `start_time` datetime NOT NULL, `minutes` int(11) NOT NULL default '0') TYPE=MyISAM
7265 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
iteration` (`id` varchar(100) NOT NULL default '', `title` varchar(255) NOT NULL default '', `start_
date` date NOT NULL default '0000–00-00', `end_date` date NOT NULL default '0000–00-00', PRIMARY KEY (`id`)) TYPE=MyISAM
7312 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
project` (`id` varchar(100) NOT NULL default '', `title` varchar(255) NOT NULL default '', `details` text, `priority` int(11) default '0', PRIMARY KEY (`id`)) TYPE=MyISAM
7359 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
query` (`id` int(11) NOT NULL default '0', `user_id` int(11) default '0', `title` varchar(255) NOT N
ULL default '', `search_text` varchar(255) default '', `title_text` tinyint(1) NOT NULL default '0', `details_text` tinyint(1) NOT NULL default '0', `comments_text` tinyint(1) NOT NULL default '0', `p
rojects` varchar(255) default '', `iterations` varchar(255) default '', `users` varchar(255) default '', `states` varchar(255) default '', `priorities` varchar(255) default '', `types` varchar(255) de
fault '', PRIMARY KEY (`id`)) TYPE=MyISAM
7421 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
record` (`id` int(11) NOT NULL default '0', `deleted` tinyint(1) NOT NULL default '0', `modified_dat
e` datetime NOT NULL, `type` varchar(100) NOT NULL default '', `active` tinyint(1) NOT NULL default
'1', PRIMARY KEY (`id`)) TYPE=MyISAM
7468 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
record_comment` (`id` int(11) NOT NULL default '0', `details` text NOT NULL, `comment_date` datetime NOT NULL, `user_id` int(11) default '0', KEY `RECORD_ID` (`id`)) TYPE=MyISAM
7515 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
record_history` (`id` int(11) NOT NULL default '0', `log_type` varchar(100) NOT NULL default '', `lo
g_details` varchar(255) default '', `log_date` datetime NOT NULL, `user_id` int(11) default '0', KEY `RECORD_ID` (`id`)) TYPE=MyISAM
7546 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
record_state` (`type` varchar(100) NOT NULL default '', `order` int(11) NOT NULL default '0', `state
` varchar(100) NOT NULL default '', `next_state` varchar(100) NOT NULL default '') TYPE=MyISAM
7578 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
sequence` (`id_sequence` int(11) NOT NULL default '0') TYPE=MyISAM
7625 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
subtask` (`id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `time_estimat
e` int(11) default '0', `parent_id` int(11) NOT NULL default '0') TYPE=MyISAM
7671 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
user` (`id` int(11) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `name` varcha
r(100) NOT NULL default '', `phone` varchar(100) default '', `cell` varchar(100) default '', `email` varchar(100) default '', PRIMARY KEY (`id`)) TYPE=MyISAM
7687 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 1..
.

7687 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: DELETE FROM `r
ecord_state`
7687 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 26 rows: INSERT INTO `
record_state` (`type`, `order`, `state`, `next_state`) VALUES
('Task', 1, 'Prepare', 'Open'),
('Task', 2, 'Open', 'Prepare'),
('Task', 2, 'Open', 'Later'),
('Task', 2, 'Open', 'Complete'),
('Task', 3, 'Later', 'Open'),
('Task', 3, 'Complete', 'Open'),
('Story', 1, 'Prepare', 'Open'),
('Story', 2, 'Open', 'Prepare'),
('Story', 2, 'Open', 'Later'),
('Story', 2, 'Open', 'Implemented'),
('Story', 3, 'Later', 'Open'),
('Story', 3, 'Implemented', 'Open'),
('Defect', 1, 'Prepare', 'Open'),
('Defect', 2, 'Open', 'Prepare'),
('Defect', 2, 'Open', 'Later'),
('Defect', 2, 'Open', 'Fixed'),
('Defect', 2, 'Open', 'Duplicate'),
('Defect', 2, 'Open', 'Not Reproducible'),
('Defect', 2, 'Open', 'Will Not fix'),
('Defect', 2, 'Open', 'Works As Designed'),
('Defect', 3, 'Later', 'Open'),
('Defect', 3, 'Fixed', 'Open'),
('Defect', 3, 'Duplicate', 'Open'),
('Defect', 3, 'Not Reproducible', 'Open'),
('Defect', 3, 'Will Not fix', 'Open'),
('Defect', 3, 'Works As Designed', 'Open')
7687 [AWT-EventQueue-0] INFO : persistence.TrackerMySQLDatabase – Updating database from version 2..
.

7718 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_sequence` (`id_sequence` int(11) NOT NULL default '0', `issue_id_sequence` int(11) NOT NULL defaul
t '0') Type=MyISAM
7750 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_record` (`id` int(11) NOT NULL default '0', `type` varchar(100) NOT NULL default '', `deleted` tin
yint(1) NOT NULL default '0', `modified_date` datetime NOT NULL, `name` varchar(255) default NULL, P
RIMARY KEY (`id`)) Type=MyISAM
7796 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_comment` (`id` int(11) NOT NULL default '0', `content` text NOT NULL, `comment_date` datetime NOT
NULL, `user_id` int(11) default NULL, `issue_id` int(11) default NULL, PRIMARY KEY (`id`)) Type=MyI
SAM
7859 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_history` (`id` int(11) NOT NULL default '0', `log_type` varchar(100) NOT NULL default '', `log_dat
e` datetime NOT NULL, `user_id` int(11) default NULL, `record_id` int(11) NOT NULL default '0', PRIM
ARY KEY (`id`)) Type=MyISAM
7890 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_time` (`id` int(11) NOT NULL default '0', `start_time` datetime NOT NULL, `end_time` datetime NOT

NULL, `issue_id` int(11) default NULL, `user_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) Type=MyISAM
7937 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_user` (`id` int(11) NOT NULL default '0', `username` varchar(100) NOT NULL default '', `phone` var
char(100) default '', `cell` varchar(100) default '', `email` varchar(100) default '', PRIMARY KEY
(`id`)) Type=MyISAM
7968 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_project` (`id` varchar(100) NOT NULL default '', `description` text, PRIMARY KEY (`id`)) Type=MyI
SAM
8015 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_iteration` (`id` varchar(100) NOT NULL default '', `start_date` date NOT NULL default '0000–00-00'
, `end_date` date NOT NULL default '0000–00-00', PRIMARY KEY (`id`)) Type=MyISAM
8078 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_job` ( `id` int(11) NOT NULL default '0', `description` text, `time_estimate` int(11) default NULL
, `tested_verified` tinyint(1) NOT NULL default '0', `closed` tinyint(1) NOT NULL default '0', PRIMA
RY KEY (`id`)) Type=MyISAM
8109 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_issue` (`id` int(11) NOT NULL default '0', `issue_id` int(11) NOT NULL default '0', `state` varcha
r(100) NOT NULL default '', `importance` int(11) default NULL, `urgency` date default NULL, `user_id
` int(11) default NULL, `iteration_id` int(11) default NULL, `project_id` int(11) default NULL, PRIM
ARY KEY (`id`)) Type=MyISAM
8156 [AWT-EventQueue-0] INFO : persistence.DatabaseResourceProvider – Updated 0 rows: CREATE TABLE `
t_subtask` (`id` int(11) NOT NULL default '0', `parent_issue_id` int(11) NOT NULL default '0', PRIMA
RY KEY (`id`)) Type=MyISAM
java.lang.RuntimeException: The automatic database update failed. Must halt. at agiletrack.server.persistence.TrackerMySQLDatabase.updateDatabaseSchema(TrackerMySQLDatab
ase.java:586) at agiletrack.server.persistence.TrackerMySQLDatabase.<init>(TrackerMySQLDatabase.java:122) at agiletrack.server.persistence.TrackerMySQLDatabase.instantiateTrackerMYSQLDatabase(Tracke
rMySQLDatabase.java:25) at agiletrack.server.persistence.TrackerMySQLDatabaseFactory.getTrackerPersistenceInstance(T
rackerMySQLDatabaseFactory.java:36) at agiletrack.server.persistence.TrackerPersistenceParameters.instantiatePersistence(Tracker
PersistenceParameters.java:34) at agiletrack.server.TrackerModel.<init>(TrackerModel.java:112) at agiletrack.server.controller.TrackerLocalAccess.<init>(TrackerLocalAccess.java:29) at agiletrack.data.access.TrackerDirectDataAccessFactory.getTrackerDataAccessInstance(Tracke
rDirectDataAccessFactory.java:35) at agiletrack.data.access.TrackerDataAccessParameters.instantiateAccess(TrackerDataAccessPar
ameters.java:33) at agiletrack.client.controller.TrackerSession.createInstance(TrackerSession.java:102) at agiletrack.client.view.LoginPanel.login(LoginPanel.java:210) at agiletrack.client.view.LoginPanel$2.actionPerformed(LoginPanel.java:147) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:5488) at javax.swing.JComponent.processMouseEvent(JComponent.java:3126) at java.awt.Component.processEvent(Component.java:5253) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3955) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1778) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at agiletrack.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:64) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "BLOB/TEXT column 'search_text' can't have a default value" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192) at com.mysql.jdbc.Connection.execSQL(Connection.java:2051) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedState
ment.java:101) at agiletrack.server.persistence.DatabaseResourceProvider.executeUpdateReport(DatabaseResour
ceProvider.java:73) at agiletrack.server.persistence.TrackerMySQLDatabase.updateDatabaseSchema(TrackerMySQLDatab
ase.java:236) ... 36 more

—Posted by Charles Haines on Nov 9, 2006 at 10:38:31 AM

Ok, I thought I downloaded you new jar file, but I just tried again and I'm getting a 404 webpage not found error. Is the jar file still valid?

—Posted by Charles Haines on Nov 9, 2006 at 10:43:02 AM

The download links seemed to be working for me, but I wouldn't worry about it any more. AgileTrack version 0.8a is out now. Check the agiletrack.org main page for details.

—Posted by Adam Lane on Nov 12, 2006 at 10:08:12 PM