Invalid column name 'summary'
I am receiving an invalid column name error when I try to view an issue details or view a list of issues in the components of some projects. I was running v3.5.4 and on the forum found some other people with similar issues (although not the same column name) where the advise was to upgrade to the latest version.
I have upgraded to v3.6.2 as per the instructions but still get the same error, everything else appears to work (in MSIE, in Firefox, the top menu (Home, Projects, Create Issue, Administration doesn't work - shows as bullet points).
martin
· 1 |
|
Thursday, January 28, 2010, 4:09:06 PM |
0
|
Can you please post the stack trace? Also, did you run create_view.sql.
As for the menu, did you re-install the web app? Aer you using the old conifg file? |
||||
|
0
|
Oops - meant to post the trace: |
||||
|
0
|
I did the full upgrade, including the web-app. I am using the new config file. I removed all the old v3.5.4 files from the directory before copying in the new ones to make sure that there were no old remanents left behind. |
||||
|
0
|
Ok, the problem is with your custom field definition. You seem to have a custom field that is bound to a lookup table and summary used to be a field in that lookup. Please check your definition under the Administration -> Custom Fields. |
||||
|
0
|
Ah - makes sense now. I have removed that custom field and all now works. What I was trying to do was get a simple list of values in a lookup field from a table within the Gemini database. I know the principle behind the lookup field but can't get the actual lookup to work. |
||||
|
0
|
Which table are you trying to use? |
||||
|
0
|
A custom table called domain_users which has the following fields: NTUsername, Firstname, Lastname and Email. I really just want to populate a listbox with all the NTUsername's from the table. |
||||
|
0
|
I would create a new field (Fullname) that will be the Firstname + ' ' + Lastname and
|
||||
|
0
|
Hmm... no luck really - just get "invalid column name" errors. I am going to leave this for now - all I really want to do is return all values from a particular column in the table. |
||||
|
0
|
Feel free to add your comments: http://gemini.countersoft.com/Default.aspx?p=2&i=379 |
||||
|