redmine_all_time_team icon indicating copy to clipboard operation
redmine_all_time_team copied to clipboard

Published 20 hours ago • verified publisher icon daipresents

When I click the "All Time team tab" i am getting error

Open kishorej opened this issue 13 years ago • 6 comments

Hi, I have installed this package and when i click the tab i a getting this below error.

PGError: ERROR: column "users.lastname" must appear in the GROUP BY clause or be used in an aggregate function : select members.user_id, users.lastname, users

Thanks, Kishore.J

kishorej avatar Apr 19 '11 12:04 kishorej

Hi

Sorry I'm late. I will check my plugin, so please give me your environment information. Ex. gem, rails, ruby version.

Thanks Dai

daipresents avatar Apr 19 '11 13:04 daipresents

Hi Dai, Please find the environmental information: gem 1.42 Rails 3.0.3 ruby 1.8.7 (2009-06-12 patchlevel 174) [x86_64-linux] Redmine -1.1

Thanks, Kishore.J

kishorej avatar Apr 19 '11 14:04 kishorej

Hi Dai, Any updates can you please help me in this?

kishorej avatar Apr 25 '11 12:04 kishorej

OK, I will check weekend. Sorry I'm late.

daipresents avatar Apr 25 '11 13:04 daipresents

Hi,

I checked your problem. That error message looks like on PostgressSQL only. Sorry, I tested on MySQL only so I can't see best solution. If you have some knowledge about Postgress, please tell me. I think this message is SQL difference problem.

daipresents avatar Apr 29 '11 10:04 daipresents

This solves the SQL problem https://github.com/daipresents/redmine_all_time_team/pull/7

camilonova avatar Sep 10 '11 20:09 camilonova