SiT! Bugs - SiT!
View Issue Details
0000977SiT!knowledge basepublic2009-10-09 09:302009-10-15 21:55
paulh 
nicdev 
normalminoralways
closedfixed 
 
3.503.50 
0000977: KB browse shows wrong owner
When browsing the list of KB articles it shows "sit" as the author though when you click on the article it shows the engineers name
No tags attached.
Issue History
2009-10-09 09:30paulhNew Issue
2009-10-09 09:40nicdevNote Added: 0002081
2009-10-09 09:41nicdevAssigned To => nicdev
2009-10-09 09:41nicdevStatusnew => confirmed
2009-10-09 10:03nicdevNote Added: 0002082
2009-10-09 10:03nicdevNote Edited: 0002082bug_revision_view_page.php?bugnote_id=2082#r39
2009-10-09 10:16nicdevNote Added: 0002083
2009-10-09 10:16nicdevStatusconfirmed => resolved
2009-10-09 10:16nicdevFixed in Version => 3.50
2009-10-09 10:16nicdevResolutionopen => fixed
2009-10-09 12:59nicdevNote Added: 0002084
2009-10-09 12:59nicdevStatusresolved => feedback
2009-10-09 12:59nicdevResolutionfixed => reopened
2009-10-09 13:02nicdevNote Added: 0002085
2009-10-09 13:02nicdevStatusfeedback => assigned
2009-10-09 13:18ivanStatusassigned => resolved
2009-10-09 13:18ivanResolutionreopened => fixed
2009-10-09 13:18ivanFixed in Version3.50 => Current SVN
2009-10-09 13:18ivanTarget Version => 3.50
2009-10-11 16:45paulhNote Added: 0002088
2009-10-15 20:38ivanFixed in VersionCurrent SVN => 3.50
2009-10-15 21:55ivanStatusresolved => closed

Notes
(0002081)
nicdev   
2009-10-09 09:40   
Hi,

I can confirm this one, it it is the same since 3.45 and still is there in 3.5RC3.
(0002082)
nicdev   
2009-10-09 10:03   
Paul i have found the issue but it is a bit deeper than this.

It seems that after changing to 3.45, we changed the way we wrote the author to the database, and the author name is stored directly in the DB instead of his 'id' thus the script cannot find him (it looks for an id).

I will investigate more as to why but for now a quick solution would be to directly access the DB and manually change the name to the users id.

(0002083)
nicdev   
2009-10-09 10:16   
Fixed in SVN Revision 5931.

Fix is to kb_article.php as it was pushing the user's real name to the DB which is why the list displayed it incorrectly.

**Note: Any KB articles created since v3.45 need to verified in the DB, and if the realname is found, it should be changed to the userid
(0002084)
nicdev   
2009-10-09 12:59   
We decided it would be best to make the list display correctly without asking anyone to modify the DB.
(0002085)
nicdev   
2009-10-09 13:02   
Fixed this in Branches 3.x (Revision 5932) in SVN.

I have tested on my side. Can anyone confirm it is now fixed?
(0002088)
paulh   
2009-10-11 16:45   
Cheers Nicdev, I can confirm that this does fix the issue.

Thanks again, Paul