Email:
Password:   
| lost password | Register
Home » TypingMaster Intra » SQL database error 169 Messages in this topic - RSS
6/23/2011 8:43:50 AM
darkstar01
Posts 3
"Database Error
An error occurred when accessing the database: 169:
A column has been specified more than once in the order by list.
Columns in the order by list must be unique."



I am really not sure how to resolve this particular error, I have tried looking on Google but to no avail.
This error occurs when trying to sort the list of students using the "Last login" option under "Users & results"
I have also had the error when creating new accounts individually. Last time I had it happen while creating
a teacher account.
edited by darkstar01 on 6/23/2011
6/23/2011 10:14:32 AM
darkstar01
Posts 3
Also I forgot to say that this error is with Microsoft SQL server 2005. With Windows 2003 Server R2.
6/28/2011 2:13:24 AM
TypingMaster
TypingMaster
Posts 136
Hi,

We regret the delay in our reply.

It seems that an extra sort clause is added erroneously to the query when viewing the next page of results. Please zip up the "C:\Program Files\tmintra4\logs" and send it to us as an attachment. The log files contain a more detailed description of the error and allow us to locate and fix the problem.

--
Best Regards,

TypingMaster, Inc.
www.TypingMaster.com
6/28/2011 8:34:10 AM
darkstar01
Posts 3
I attached the log files to the email you sent me, please let me know if you need any other information.
pages: 1
|

Home » TypingMaster Intra » SQL database error 169