Best practice forum (Archived)

error message from positions tab

 
John Roughley
error message from positions tab
par John Roughley, Friday 13 May 2011, 05:52
 

I was trying to set the organisation details for a user account. When I click on the Positions tab I get the following error message...

Error: more than one record returned (table 'pos_assignment')

Any ideas?

Craig Eves
Re: error message from positions tab
par Craig Eves (Totara Support), Sunday 15 May 2011, 15:21
Groupe Totara

Hi John

It sounds as though a position has been assigned more than once and it hasn't let go of the former position.

Did you assign the position more than once - did you asssign a position and then delete it and maybe reassign.

I will try and reproduce this error - it  sounds like it might be a bug. What version of Totara are you using?

regards

Craig

Simon Coggins
Re: error message from positions tab
par Simon Coggins, Monday 16 May 2011, 16:58
Groupe Totara

Hi John,

We're aware of a bug that means under certain circumstances, this can happen. We're working on a fix that will let you correct the database as part of an upgrade, and we hope to have it ready in a week or so.

In the mean time, if you're happy working directly with your database you could remove the duplicate record yourself. I can post further instructions if that would be helpful, but you will need direct access to the database to make the change.

Simon