Projects: Issueshttp://projects.andriylesyuk.com/http://projects.andriylesyuk.com/plugin_assets/andriy_lesyuk/images/s-andy.ico2013-10-04T16:10:29ZProjects
Redmine Extended Fields - Bug #2242 (Incomplete): Message "invalid statement: STR_TO_DATE" when using MS SQLhttp://projects.andriylesyuk.com/issues/22422013-10-04T16:10:29ZOlivier Houdas
<p>I activate Extended Fields 0.2.2 on Redmine 2.3.3.<br />Our installation of Redmine is on CentOS, uses MS SQL server 2008 and Ruby on rails 2.0.0-p247</p>
<p>When I click on the Calendar tab of a project, I get an internal error, with the following indication in the log:</p>
<pre><code>ActiveRecord::StatementInvalid (TinyTds::Error: 'STR_TO_DATE' is not a recognized built-in function name.: EXEC sp_executesql N'SELECT [custom_values].[id] AS t0_r0, [custom_values].[customized_type] AS t0_r1, [custom_values].[customized_id] AS t0_r2, [custom_values].[custom_field_id] AS t0_r3, [custom_values].[value] AS t0_r4, [custom_fields].[id] AS t1_r0, [custom_fields].[type] AS t1_r1, [custom_fields].[name] AS t1_r2, [custom_fields].[field_format] AS t1_r3, [custom_fields].[possible_values] AS t1_r4, [custom_fields].[regexp] AS t1_r5, [custom_fields].[min_length] AS t1_r6, [custom_fields].[max_length] AS t1_r7, [custom_fields].[is_required] AS t1_r8, [custom_fields].[is_for_all] AS t1_r9, [custom_fields].[is_filter] AS t1_r10, [custom_fields].[position] AS t1_r11, [custom_fields].[searchable] AS t1_r12, [custom_fields].[default_value] AS t1_r13, [custom_fields].[editable] AS t1_r14, [custom_fields].[visible] AS t1_r15, [custom_fields].[multiple] AS t1_r16, [custom_fields].[is_for_new] AS t1_r17, [custom_fields].[hint] AS t1_r18 FROM [custom_values] LEFT OUTER JOIN [custom_fields] ON [custom_fields].[id] = [custom_values].[custom_field_id] WHERE (custom_fields.field_format = N''date'' AND custom_values.customized_type = N''Issue'' AND custom_values.customized_id IN (NULL) AND STR_TO_DATE(custom_values.value, ''%Y-%m-%d'') BETWEEN ''09-30-2013'' AND ''11-03-2013'')')</code></pre>
<p>Removing the calls to STR_TO_DATE() in /lib/extended_calendars_controller_patch.rb fixes the internal error issue (but it might of course cause other issues, this is not a fix, just a check that the issue lies there and only there).</p> Project Settings - Feature #2131 (In Progress): Redmine 2 / Rails 3 compatibilityhttp://projects.andriylesyuk.com/issues/21312012-12-09T17:26:01ZMarcus Ilgner
<p>Just tried to install the redmine-settings plugin into a Redmine 2 installation because I’m using it in one of my plugins.<br />Unfortunately, it isn’t compatible anymore since a few things changed with Rails 3.</p>
<p>I fiddled around with it for a bit and got so far to come up with this diff to at least avoid throwing exceptions. But still I had to add a manually-defined route for my settings page in my plugin and the view doesn’t show up anymore after the upgrade.</p>
<pre>
-require 'dispatcher'
-RAILS_DEFAULT_LOGGER.info 'Starting Project Settings Hook Plugin for Redmine'
+::Rails.logger.info 'Starting Project Settings Hook Plugin for Redmine'
-Dispatcher.to_prepare :project_settings_hook_plugin do
+Rails.configuration.to_prepare do
</pre>
<p>Do you have any plans to support Redmine 2 or should I roll my own settings hook?</p> SCM Creator (+Github) - Bug #2084 (Incomplete): ActionView::Template::Error (syntax error on line...http://projects.andriylesyuk.com/issues/20842012-07-02T06:04:00ZRob Landry
<p>I have decided to use my webhost for redmine vice my home pc. I have done a fresh install of redmine 2.0.3. Following installation instruction i installed redmine_scm 0.4.1.</p>
<p>Upon creating a new project I am getting a 500 error. Looking at my production log this is what i see:</p>
<pre>Started GET "/projects/new" for 74.76.105.241 at Sun Jul 01 23:58:29 -0600 2012
Processing by ProjectsController#new as HTML
Rendered plugins/redmine_scm/app/views/projects/_scm.html.erb (2.2ms)
Rendered projects/_form.html.erb (329.9ms)
Rendered projects/new.html.erb within layouts/base (332.2ms)
Completed 500 Internal Server Error in 349ms
ActionView::Template::Error (syntax error on line 33, col 12: `'):
1: <% if ScmConfig['force_repository'] %>
2: <script type="text/javascript">
3: //<![CDATA[
4: Event.observe(window, 'load', function() {
lib/redmine/hook.rb:111:in `send'
lib/redmine/hook.rb:111:in `view_projects_form'
lib/redmine/hook.rb:61:in `send'
lib/redmine/hook.rb:61:in `call_hook'
lib/redmine/hook.rb:61:in `each'
lib/redmine/hook.rb:61:in `call_hook'
lib/redmine/hook.rb:58:in `tap'
lib/redmine/hook.rb:58:in `call_hook'
lib/redmine/hook.rb:158:in `call_hook'
app/views/projects/_form.html.erb:23:in `_app_views_projects__form_html_erb__1330010327_69983346472560'
app/views/projects/new.html.erb:4:in `_app_views_projects_new_html_erb__1556954071_69983346550480'
app/helpers/application_helper.rb:950:in `labelled_form_for'
app/views/projects/new.html.erb:3:in `_app_views_projects_new_html_erb__1556954071_69983346550480'</pre>
<p>I know in fact that this version of scm works great on my home pc. The only differences i can think of between the 2 servers is that the problematic one has ruby 1.8.7.</p>
<p>Please Advise.</p> SCM Creator (+Github) - Feature #2075 (Open): Make an option to fully automate repository creatio...http://projects.andriylesyuk.com/issues/20752012-06-26T13:59:32ZHumberto Anjos
<p>Here’s my situation: I need a SourceForge-like solution for internal use in my company, and Redmine seems like the best option. I need to create repositories only through Redmine, so this plugin fell like a glove <span class="wiking smiley smiley-smiley" title=":)"></span> Thing is, the URL field is fully editable, so users can create repos anywhere on the server <span class="wiking smiley smiley-sad" title=":("></span></p>
So my current options now are:
<ul>
<li>stick to Redmine 1.3 and SCM Creator 0.3; or</li>
<li>migrate to Redmine 2, SCM Creator 0.4, use the <a href="http://projects.andriylesyuk.com/projects/scm-creator/wiki/Common-configuration-scenarios#Force-repository-creation-for-all-projects" class="external">Force repository creation for all projects</a> configuration and limit repos to one per project (<code>max_repos: 1</code>), so the user never gets the option of editing the URL.</li>
</ul>
<p>The best solution (for me) would be for the URL field to be non-editable, and for the URL to be fully determined by the project name, the path in <code>scm.yml</code> and the repository identifier. So, for a path <code>/var/lib/svn</code>, a project <code>test</code> and an repository <code>main</code>, the repo’s full URL would be <code>file:///var/lib/svn/test/main</code>.</p>
<p>Of course, Redmine-based authentication should still work (it seems like a simple matter, but I don’t know if there’s any hidden surprises...).</p> WikiNG - Feature #1977 (Open): Conditional macro for users & groupshttp://projects.andriylesyuk.com/issues/19772012-02-16T08:43:48ZДмитрий Салашник
<p>I think something like <br /><pre>
{{visible for some_user1, some_user2, group1, group2, role1, role2 }}
This text is invisible for other peoples :)
{{visible}}
</pre></p>
<p>This is really required feature, it allow’s include some technical comments for developers <span class="wiking smiley smiley-smiley" title=":)"></span> or something else</p> WikiNG - Bug #1931 (Deferred): it seems conflict with the redmine ckeditorhttp://projects.andriylesyuk.com/issues/19312012-01-05T04:54:41ZSteven Wong
<p>it seems conflict withe the redmine ckeditor.</p>
<p>i write a wiki and use the wiking code ,but not supply.</p> SCM Creator (+Github) - Feature #1793 (Incomplete): Allow the creation of non-local repositories http://projects.andriylesyuk.com/issues/17932011-06-17T17:22:15ZStefanos Kariotidis
<p>It would be nice if the plugin could create non-local repositories like reposman.rb.<br />I don’t know how difficult this may be but if is doable this plugin will shine in contrast to<br />reposman.rb. I say this because i find SCM Creator very delicate, robust and better polished addition to Redmine.</p>
<p>Regards, Stef</p> Red-Andy - Feature #1725 (Deferred): Stick footer to the bottom of a pagehttp://projects.andriylesyuk.com/issues/17252011-05-04T17:21:36ZAndriy Lesyuks-andy@andriylesyuk.com
Some links on the subject:
<ul>
<li><a class="external" href="http://www.cssstickyfooter.com/using-sticky-footer-code.html">http://www.cssstickyfooter.com/using-sticky-footer-code.html</a></li>
</ul> Orangutan - Feature #1619 (Open): Avatarhttp://projects.andriylesyuk.com/issues/16192011-02-03T13:20:32ZAndriy Lesyuks-andy@andriylesyuk.com
<p>Currently the only method to change Orangutan’s avatar is to use another Jabber client to upload it.</p>
<p>I guess it’s easy to support this! A new configuration option can be added:<br /><pre>
jabber.avatar = /path/to/avatar.png
</pre></p>
<p>Then on every start Orangutan can ensure the right avatar is set...</p> Orangutan - Feature #1603 (Open): MegaHALhttp://projects.andriylesyuk.com/issues/16032011-02-01T16:33:53ZAndriy Lesyuks-andy@andriylesyuk.com
<p>I guess it is possible to use MegaHAL for speaking to people. In some way MegaHAL could “filter out” human requests not related to time tracking or Redmine. This way it could help.</p>
Some links:
<ul>
<li><a class="external" href="http://en.wikipedia.org/wiki/MegaHAL">http://en.wikipedia.org/wiki/MegaHAL</a></li>
<li><a class="external" href="http://megahal.alioth.debian.org/How.html">http://megahal.alioth.debian.org/How.html</a></li>
</ul>
<p>Anyone wants to do this? <span class="wiking smiley smiley-smiley" title=":)"></span></p> Orangutan - Feature #1464 (Open): Ability to see Orangutan logs for a userhttp://projects.andriylesyuk.com/issues/14642010-12-28T17:05:29ZAndrii Lundiak
<p>1) Yes, we have <strong>show tasks</strong> and this give us like this:<br /><pre>
(04:51:14 PM) alundyak@jabber.sjua/: show tasks
(04:51:14 PM) Orangutan: This is what I found:
1) Tue, Dec 28 10:30 - 11:58 (1:28): working on SCRUM research on #1457 for Research (Normal)
2) Tue, Dec 28 12:52 - 13:16 (0:24): working on SCRUM research on #1457 for Research (Normal)
3) Tue, Dec 28 13:20 - 14:17 (0:57): work on #1457 for Research (Normal)
4) Tue, Dec 28 14:17 - 14:28 (0:11): cont work on #1457 for Research (Normal)
5) Tue, Dec 28 14:35 - 14:49 (0:14): svn update work on #1447 for SVS (Normal)
6) Tue, Dec 28 15:24 - 15:54 (0:30): cont work with Agile research on #1457 for Research (Normal)
7) Tue, Dec 28 15:55 - 16:30 (0:35): start working with Netbeans IDE + PHPunit on #1462 for SVS (Normal)
8) Tue, Dec 28 16:30 - 16:32 (0:02): Create FR on #1463 for Redmine (Normal)
</pre></p>
<p>2) It’s ok, but I would like to have ability to see entire list of logs. Example is in attached file <strong>201012.log</strong></p>
<pre>
10.12.02 11:54:08 Orangutan: Got it!.. I hope this task is not very complex and you'll get it done easily. The issue is Task #1304 "SVS_DEMO update sql script" (project is "SVS"). Assuming the activity is "Normal"...
10.12.02 12:03:15 Orangutan: User odemyanyuk@jabber.sjua modified the following in Bug #1255 "Project Can not be created if no technologies" (Redmine):
o set status to Resolved
o completed at 100%
And wrote the following:
Done
10.12.02 13:22:11 alundyak went away
10.12.02 13:50:02 alundyak went online
10.12.02 13:50:02 Orangutan: You went away at 13:22 that is 28 minutes ago. Should I record a break?
10.12.02 14:20:03 Orangutan: Ok... Breaking the task
10.12.02 15:08:45 alundyak went away
10.12.02 15:12:59 alundyak went online
10.12.02 15:18:01 alundyak went away
10.12.02 16:09:52 alundyak went online
10.12.02 16:09:52 Orangutan: You left at 15:18 that is 51 minutes ago. Should I stop the task on that time and reopen it?
10.12.02 16:25:51 alundyak went away
10.12.02 16:26:00 alundyak went online
</pre>
<p>3) Would be great to have ability to see logs for some period (hour, some hours, day)<br />3.1) More than 1day is to much for Jabber Client and it will be not useful</p> Orangutan - Feature #605 (Open): SVN monkeyhttp://projects.andriylesyuk.com/issues/6052010-06-27T00:05:19ZAndriy Lesyuks-andy@andriylesyuk.com
<p>Orangutan can be very helpful for employees which use SVN...</p>
<p>What is required for a user to track time? A user must specify work hours, project and maybe issue and a short description...</p>
<p>What does developer which uses SVN do? Runs “update” when comes to the office and runs “commit” when leaves... If we assume that a user always specifies a description when committing (-m) we have a start time, end time and a description! All that we need is project/issue - project can be guessed (or determined if SVN was registered in Redmine) and issue can be extracted from -m message...</p>
That is:
<ul>
<li>When user does “update” Orangutan starts “tracking”;</li>
<li>When user goes away and returns Orangutan tracks breaks and saves them somewhere;</li>
<li>When user commits...</li>
<li>Orangutan tries to determine the project (if failed the monkey can ask for project later);</li>
<li>Orangutan tries to determine the issue;</li>
<li>Orangutan suggests a user to save tasks...</li>
</ul>
<p>The last is done when there are no conflicts - that is a user did not save any entries for the time a user is believed to work.</p>
<p>That is a user will only be required to answer “yes” per commit (besides the cases when the project is not known)...</p> Orangutan - Feature #558 (Open): Jokes contexthttp://projects.andriylesyuk.com/issues/5582010-06-15T20:52:22ZOleh Demyanyukolkobg@gmail.com
<p>tell redmine 'joke’ and he print something like fortune command form linux...</p> Orangutan::Redmine - Feature #230 (Open): Starting task/time entry and new issue at the same timehttp://projects.andriylesyuk.com/issues/2302010-04-16T00:31:36ZAndriy Lesyuks-andy@andriylesyuk.com
<p>In the testing phase most of their time developers fix bugs. Mostly these are small bugs. So it can be a headache to add issues to Redmine and then to add time logs using Orangutan...</p>
<p>The idea is to create a context which would allow to create issue and time log with one “command”.</p>
<p>The syntax can be:</p>
<pre>
User: Fixing new issue: Dialog is shown incorrectly [high]
</pre> Orangutan::Redmine - Feature #124 (Open): Let users specify what they did during a break by answe...http://projects.andriylesyuk.com/issues/1242010-03-09T17:47:14ZAndriy Lesyuks-andy@andriylesyuk.com
<p>Saying I’m working on something and suddenly my manager asks me to attend a meeting. Saying the meeting lasts for an hour. When I get back Orangutan asks me if he should record a break. That’s fine! But it would be cool if I could answer something like: “Yes... I had a meeting with my manager.”. And he would add this as a task.</p>