solar-group/tawos

The Tawosi Agile Web-hosted Open-Source Issues dataset

tawos's Issues

Where is the data?

I really interested in your work, however after building a database scheme in mysql, I cannot find any clue or additional information to retrieve the dataset. It is only the empty database so far.

Can't import database

somehow i can't import the database
it starts by showing everything is OK for a long time, but then errors start:
[...]
Query OK, 1384 rows affected (0.12 sec)
Records: 1384 Duplicates: 0 Warnings: 0

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 75
Current database: tawos
[...]
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (tawos.issue, CONSTRAINT issue_ibfk_1 FOREIGN KEY (Project_ID) REFERENCES project (ID))
[...]
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (tawos.issue_component, CONSTRAINT issue_component_ibfk_1 FOREIGN KEY (Component_ID) REFERENCES component (ID))
[...]
ERROR 1136 (21S01): Column count doesn't match value count at row 1
Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 3730 (HY000): Cannot drop table 'repository' referenced by a foreign key constraint 'project_ibfk_1' on table 'project'.
Query OK, 0 rows affected (0.00 sec)
[...]
ERROR 1231 (42000): Variable 'time_zone' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'
Query OK, 0 rows affected (0.00 sec)

ERROR 1231 (42000): Variable 'collation_connection' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'

i tried importing a sql database from a tutorial and everything worked fine, is it a limitation of my system or is the file corrupt ?
i have also made sure not to open the file with a text editor before importing.

ERROR 2013 (HY000) at line 1521: Lost connection to MySQL server during query

After creating an empty database "tawos", I run the following: mysql -u root -p tawos < TAWOS.sql. It runs for about 5 minutes before returning the following error: ERROR 2013 (HY000) at line 1521: Lost connection to MySQL server during query. I have reviewed this error extensively and have adjusted various timeout settings to no avail. Is there any reason this might be happening? Any help is greatly appreciated.

Single team or Multiple teams?

Is there any way to know if the issues of each project are performed by a single team or multiple teams?

Can't import the file

I can't import the sql file to mysql database successfully. It seems like the data contains single quotes and they mix with mysql scripts.