Home
LimeSurvey Forums
Welcome, Guest
Please Login or Register.    Lost Password?
LimeSurvey Forums LimeSurvey Support Installation Issues
Re:[done] Microsoft sql user table issue (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Re:[done] Microsoft sql user table issue
#16919
dasmith (User)
Fresh Lemon
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
[done] Microsoft sql user table issue 3 Months, 3 Weeks ago Karma: 0  
LimeSurvey Version: 1.71
Os: windows 2003 server
PHP 5.2.6
Database Microsoft SQL 2005

I get this error when I click on the key (edituser button) with any user besides the super admin.

Code:
[Microsoft][ODBC SQL Server Driver][SQL Server]Column 'u.users_name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.:SELECT u.* FROM [lime_users] AS u, [lime_user_in_groups] AS ga ,[lime_user_in_groups] AS gb WHERE u.uid=11 OR (ga.ugid=gb.ugid AND ( (gb.uid=11 AND u.uid=ga.uid) OR (u.parent_id=11) ) ) GROUP BY u.uid


Also get this when I click on "Set Template Rights" with any user including super admin.

Code:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '`'.:SELECT `folder`, `use` FROM lime_templates_rights WHERE uid=9


Everything else seems to work fine...

Any suggestions would be much appreciated. I have tried using ms sql 2000 and get the same result. Also am running on mysql in my development environment with no issues seems to be only with ms sql.

Thanks
Daniel Smith
 
Logged Logged  
 
Last Edit: 2008/08/04 14:44 By Mazi.
  The administrator has disabled public write access.
#16925
ElMatador69 (Moderator)
LimeSurvey Team
Posts: 1576
graphgraph
User Online Now Click here to see the profile of this user
Re:Microsoft sql user table issue 3 Months, 3 Weeks ago Karma: 31  
Hi, which build of LimeSurvey 1.71+ do you use? If not the latest, plz upgrade!
 
Logged Logged  
 
Get in touch with the LimeSurvey Development Team via IRC
If our informations and answers were useful to you, please consider a donation to the LimeSurvey Project!
  The administrator has disabled public write access.
#16926
c_schmitz (Admin)
Moderator Lime
Posts: 1354
graphgraph
User Online Now Click here to see the profile of this user
Re:Microsoft sql user table issue 3 Months, 3 Weeks ago Karma: 39  
If the error still persists after upgrading to the latest version please file a bug report.

Thank you!
 
Logged Logged  
 
Best regards

Carsten Schmitz
LimeSurvey Project Leader
  The administrator has disabled public write access.
#16931
dasmith (User)
Fresh Lemon
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:Microsoft sql user table issue 3 Months, 3 Weeks ago Karma: 0  
Thanks for the reply.
I am now on build5370_20080730 and still have the same issue I will fill out a bug report. If anyone has any ideas please let me know

Thanks
Daniel
 
Logged Logged  
  The administrator has disabled public write access.
#16936
dasmith (User)
Fresh Lemon
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:Microsoft sql user table issue 3 Months, 3 Weeks ago Karma: 0  
Out of curiosity I started working backwards with through the versions and the issue does not appear in Version 1.53+ (4108) so it must be something that was added in the versions newer than that....


Daniel
 
Logged Logged  
  The administrator has disabled public write access.
#17075
Mazi (Moderator)
Moderator Lime
Posts: 3247
graph
User Offline Click here to see the profile of this user
Re:Microsoft sql user table issue 3 Months, 2 Weeks ago Karma: 25  
Thanks for this hint.

Can you please post the ticket ID so we can follow the progress?
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#17077
dasmith (User)
Fresh Lemon
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:Microsoft sql user table issue 3 Months, 2 Weeks ago Karma: 0  
The ticket id is 02354 there has been no progress so far that I am aware of....

Thanks
Daniel
 
Logged Logged  
  The administrator has disabled public write access.
#17145
Mazi (Moderator)
Moderator Lime
Posts: 3247
graph
User Offline Click here to see the profile of this user
Re:Microsoft sql user table issue 3 Months, 2 Weeks ago Karma: 25  
It's marked as "solved". Please watch out for the next stable plus release which is released each week.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#17474
dasmith (User)
Fresh Lemon
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:[done] Microsoft sql user table issue 3 Months, 1 Week ago Karma: 0  
Hey,
I have installed the latest build, and no longer get the errors but I still have issues. I am able to create users with users that are not super admin so this has been fixed. Still after you click add user and then click set user rights that page loads but with no rights to set. Also when I click on the Key (create/edit users) no other users show up not even the one I have just created. When I log in as the super admin the users that I created as a non super admin does show up....

Any suggestions. I will add this to my bug report..

Thanks
Daniel
 
Logged Logged  
  The administrator has disabled public write access.
#17480
Mazi (Moderator)
Moderator Lime
Posts: 3247
graph
User Offline Click here to see the profile of this user
Re:[done] Microsoft sql user table issue 3 Months, 1 Week ago Karma: 25  
It's best to discuss this with the developers within the bugtracker...
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
Go to top
Powered by FireBoardget the latest posts directly to your desktop