thomasklein / redmine2mite

Redmine2mite connects your Redmine account with your mite.account. Track your time easily on issues within Redmine and get them automatically send to mite.
http://mite.yo.lk/
MIT License
13 stars 6 forks source link

Plugin doesn't save time tracker settings #16

Closed floeschie closed 12 years ago

floeschie commented 12 years ago

I just updated from version 1.3.1 to 1.5.1 and I'm very happy about the new improvements of your plugin! However, I cannot see the new stopwatch (time tracker) feature.

I went to /mite and checked the options "don't send time entry to mite" and "activate time tracking feature" (I'm using the German version, dunno about the correct english labels). After saving my preferences, the "don't send to mite" checkbox is checked, but the "activate time tracker" checkbox is not. I can repeat these steps, but the "activate time tracker" checkbox won't save its new state.

Any suggestions?

thomasklein commented 12 years ago

Hi Floeschi! Did you do a rake db:migrate_plugins after updating the plugin?

thomasklein commented 12 years ago

Ah, just noted in your last comment that you did it. The thing is, I can't reproduce the error. Do you have the possibility to check out the console for any errors when updating the plugin's preferences?

floeschie commented 12 years ago
Processing MiteController#save_preferences (for 78.42.xxx.xxx at 2012-03-20 20:10:36) [POST]
  Parameters: {"action"=>"save_preferences", "user_preferences"=>{"mite_note_pattern"=>"", "mite_tracker_option"=>"1", "mite_omit_transmission_option"=>"1"}, "bindings"=>{...lots of numbers...}, "controller"=>"mite", "authenticity_token"=>"1234567890IAMVERYSECRET"}
Redirected to https://my.redmine.host/mite
Completed in 511ms (DB: 24) | 302 Found [https://my.redmine.host/mite/save_preferences]

Processing MiteController#index (for 78.42.xxx.xxx at 2012-03-20 20:10:36) [GET]
  Parameters: {"action"=>"index", "controller"=>"mite"}
Rendering template within layouts/base
Rendering mite/index
Completed in 315ms (View: 261, DB: 6) | 200 OK [https://my.redmine.host/mite]

As you can see, the mite_tracker_option is set to "1". I haven't checked the database value yet, will do this tomorrow.

Cheers, Florian

thomasklein commented 12 years ago

yeah, this would be great! for the moment everything seems fine.

floeschie commented 12 years ago

List of all tables:

mysql> show tables;
+-------------------------------------+
| Tables_in_my_redmine                |
+-------------------------------------+
| attachments                         |
| auth_sources                        |
| boards                              |
| changes                             |
| changesets                          |
| changesets_issues                   |
| comments                            |
| custom_fields                       |
| custom_fields_projects              |
| custom_fields_trackers              |
| custom_values                       |
| dashboard_statuses                  |
| dashboard_trackers                  |
| dashboards                          |
| documents                           |
| enabled_modules                     |
| enumerations                        |
| groups_users                        |
| issue_categories                    |
| issue_relations                     |
| issue_statuses                      |
| issues                              |
| journal_details                     |
| journals                            |
| member_roles                        |
| members                             |
| messages                            |
| mite_bindings                       |
| mite_rsrcs                          |
| news                                |
| open_id_authentication_associations |
| open_id_authentication_nonces       |
| projects                            |
| projects_trackers                   |
| queries                             |
| repositories                        |
| roles                               |
| schema_migrations                   |
| settings                            |
| time_entries                        |
| tokens                              |
| trackers                            |
| user_preferences                    |
| users                               |
| versions                            |
| watchers                            |
| wiki_content_versions               |
| wiki_contents                       |
| wiki_pages                          |
| wiki_redirects                      |
| wikis                               |
| workflows                           |
+-------------------------------------+
52 rows in set (0.00 sec)

Structure of table _mitebindings:

mysql> describe mite_bindings;
+--------------+---------+------+-----+---------+----------------+
| Field        | Type    | Null | Key | Default | Extra          |
+--------------+---------+------+-----+---------+----------------+
| id           | int(11) | NO   | PRI | NULL    | auto_increment |
| user_id      | int(11) | YES  |     | NULL    |                |
| mite_rsrc_id | int(11) | YES  |     | NULL    |                |
| project_id   | int(11) | YES  |     | NULL    |                |
+--------------+---------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

Structure of table _mitersrcs:

mysql> describe mite_rsrcs;
+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| id                   | int(11)      | NO   | PRI | NULL    | auto_increment |
| user_id              | int(11)      | YES  |     | NULL    |                |
| mite_rsrc_id         | int(11)      | YES  |     | NULL    |                |
| type                 | varchar(255) | YES  |     | NULL    |                |
| mite_rsrc_name       | varchar(255) | YES  |     | NULL    |                |
| mite_rsrc_updated_at | datetime     | YES  |     | NULL    |                |
+----------------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

Structure of table _userpreferences:

mysql> describe user_preferences;
+-------------------------------+--------------+------+-----+---------+----------------+
| Field                         | Type         | Null | Key | Default | Extra          |
+-------------------------------+--------------+------+-----+---------+----------------+
| id                            | int(11)      | NO   | PRI | NULL    | auto_increment |
| user_id                       | int(11)      | NO   | MUL | 0       |                |
| others                        | text         | YES  |     | NULL    |                |
| hide_mail                     | tinyint(1)   | YES  |     | 0       |                |
| time_zone                     | varchar(255) | YES  |     | NULL    |                |
| mite_account_name             | varchar(255) | YES  |     | NULL    |                |
| mite_api_key                  | varchar(255) | YES  |     | NULL    |                |
| mite_note_pattern             | varchar(255) | YES  |     | NULL    |                |
| mite_connection_updated_on    | datetime     | YES  |     | NULL    |                |
| mite_omit_transmission_option | tinyint(1)   | YES  |     | 0       |                |
| mite_tracker_option           | tinyint(1)   | YES  |     | 0       |                |
| mite_tracker_data             | text         | YES  |     | NULL    |                |
+-------------------------------+--------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)

My saved mite settings in table _userpreferences:

mysql> select mite_omit_transmission_option, mite_tracker_option from user_preferences where user_id=6;
+-------------------------------+---------------------+
| mite_omit_transmission_option | mite_tracker_option |
+-------------------------------+---------------------+
|                             1 |                   0 |
+-------------------------------+---------------------+
1 row in set (0.01 sec)
thomasklein commented 12 years ago

This is weird, everything looks just fine. What version of Redmine and Rails are you using?

floeschie commented 12 years ago

ruby -v ruby 1.8.7 (2010-01-10 patchlevel 249) [x86_64-linux]

gem list --local * LOCAL GEMS * actionmailer (2.3.11) actionpack (2.3.11) activerecord (2.3.11) activeresource (2.3.11) activesupport (2.3.11) i18n (0.4.2) icalendar (1.1.6) json (1.6.5) mysql (2.8.1) rack (1.1.2) rails (2.3.11) rake (0.8.7)

floeschie commented 12 years ago

Maybe some kind of caching problem... Just updated my settings once again and now everything works fine... Weird! Anyways, thanks for your support!