[DRE-maint] Bug#891959: redmine: sql_for_field returns bad result for a user lives in different timezone against a server.

[Miyamoto Luisch]

Package: redmine
Version: 3.3.1-4
Severity: minor
Tags: l10n

Dear Maintainer,

My redmine server is in Japan, and an user is in Taiwan.
When an user in Taiwan (his timezone is CTT, Feb 10 23h30, and my server is Feb 
11 0h30 JST) tried to use a custom query to find his issues,
a query calls sql_for_field method with parameters below,

> oparator = { "due_date" => " v = {"due_date" => ["0"]}
> sql_for_field("due_date", oparator, v, db_table,"due_date",false)

and that returns a SQL like this,
> (issues.due_date <= '2018-02-11 00:59:59.99')

But, I think sql_for_field method has to return a SQL like this.
> (issues.due_date <= '2018-02-10 23:59:59.99')

and also, sql_for_custom_field might have same problems.


thank you.


-- System Information:
Debian Release: 9.3
  APT prefers stable
  APT policy: (990, 'stable'), (500, 'stable-updates'), (99, 'testing'), (9, 
'unstable'), (1, 'oldstable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-6-amd64 (SMP w/1 CPU core)
Locale: LANG=ja_JP.UTF-8, LC_CTYPE=ja_JP.UTF-8 (charmap=UTF-8), 
LANGUAGE=ja_JP.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages redmine depends on:
ii  dbconfig-common 2.0.8
ii  debconf [debconf-2.0]   1.5.61
ii  redmine-mysql   3.3.1-4
ii  ruby1:2.3.3
ii  ruby-actionpack-action-caching  1.1.1-4
ii  ruby-actionpack-xml-parser  1.0.2-2
ii  ruby-bundler1.13.6-2
ii  ruby-coderay1.1.1-1
ii  ruby-i18n   0.7.0-2
ii  ruby-jquery-rails   4.2.1-2
ii  ruby-mime-types 2.6.1-1
ii  ruby-mimemagic  0.3.0+dfsg-1
ii  ruby-net-ldap   0.12.1-2
ii  ruby-openid 2.7.0debian-1
ii  ruby-protected-attributes   1.1.3-2
ii  ruby-rack   1.6.4-4
ii  ruby-rack-openid1.4.2-1
ii  ruby-rails  2:4.2.7.1-1
ii  ruby-rails-observers0.1.2-1
ii  ruby-rbpdf  1.19.0-1
ii  ruby-redcarpet  3.3.4-2
ii  ruby-request-store  1.3.0-1
ii  ruby-rmagick2.16.0-2+b1
ii  ruby-roadie-rails   1.1.0-1
ii  ruby2.1 [ruby-interpreter]  2.1.5-2+deb8u3

Versions of packages redmine recommends:
ii  passenger  5.0.30-1+b1

Versions of packages redmine suggests:
pn  bzr 
pn  cvs 
pn  darcs   
ii  git 1:2.11.0-3+deb9u2
pn  mercurial   
ii  ruby-fcgi   0.9.2.1-2+b1
ii  subversion  1.9.5-1+deb9u1

-- debconf information excluded

___
Pkg-ruby-extras-maintainers mailing list
Pkg-ruby-extras-maintainers@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-ruby-extras-maintainers

[DRE-maint] Bug#792106: tdiary: wiki_style.rb has $SAFE=4 but it had been obsoleted

[Miyamoto Luisch]

Package: tdiary
Version: 3.2.2-3
Severity: important

Dear Maintainer,

On Debian jessie, if I make a diary that includes some plugin syntax
with WikiStyle (http://docs.tdiary.org/ja/?Wiki%A5%B9%A5%BF%A5%A4%A5%EB),
tdiary returns an error '$SAFE=4 is obsolete (ArgumentError)'

Please remove $SAFE from /usr/share/tdiary/tdiary/style/wiki_style.rb.


-- System Information:
Debian Release: 8.1
  APT prefers stable
  APT policy: (990, 'stable'), (500, 'stable-updates'), (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.16.0-4-amd64 (SMP w/2 CPU cores)
Locale: LANG=ja_JP.UTF-8, LC_CTYPE=ja_JP.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages tdiary depends on:
ii  rdtool  0.6.38-3
ii  ruby1:2.1.5+deb8u1
ii  ruby-debian 0.3.9
ii  ruby-json   1.8.1-1+b2
ii  ruby-redcarpet  3.1.2-1
ii  ruby-twitter-text   1.10.0+gem-1
ii  ruby-uconv  0.6.1-1+b3
ii  ruby2.1 [ruby-interpreter]  2.1.5-2+deb8u1

Versions of packages tdiary recommends:
ii  apache2 [httpd]  2.4.10-10
ii  tdiary-plugin3.2.2-3
ii  tdiary-theme 3.2.2-3

Versions of packages tdiary suggests:
ii  apache2 [httpd-cgi]  2.4.10-10
ii  tdiary-contrib   3.2.2-1
pn  tdiary-mode  none

-- no debconf information

___
Pkg-ruby-extras-maintainers mailing list
Pkg-ruby-extras-maintainers@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-ruby-extras-maintainers