WebGUI
      Click here to register.
      
irc://irc.freenode.net#webgui

iPhoneGuy: WebGUI is a pile of crap.
rizen: If WebGUI is such a pile of crap, why do you use it?
iPhoneGuy: Because it's the best pile of crap out there.

If this is what people who hate us are saying, imagine what people who love us will say. Come join us on IRC.


     Report a Bug > WebGUI Bug Tracker

AOIHits and AOIRank not working problem and solution
User arjan
Date 5/15/2007 10:03 am
Severity Fatal (can't continue until this is resolved)
Version WebGUI 7.3.8 -> 7.3.17
Views 61
Rating 1    Rate [
|
]
Karma Rank 0.000000
Previous · Next
User Message
arjan
Date: 5/15/2007 10:03 am   ·   Subject: AOIHits and AOIRank not working problem and solution   ·   Rating: 1

Both AOIHits and AOIRank were not working. This was caused by a simple typo:

AOIHits.pm

43                         and userId=".$session->db->$session->db->quote($session->user->userId)        ."
44                         and fieldName=".$session->db->$session->db->quote($key)."
45                         and value=".$session->db->$session->db->quote($value);

should be:

43                         and userId=".$session->db->quote($session->user->userId)."
44                         and fieldName=".$session->db->quote($key)."
45                         and value=".$session->db->quote($value); 

 

AOIRank.pm

44                         and userId=".$session->db->$session->db->quote($session->user->userId)."
45                         and fieldName=".$session->db->$session->db->quote($key)." order by a.count desc";

shoud be:

44                         and userId=".$session->db->quote($session->user->userId)."
45                         and fieldName=".$session->db->quote($key)." order by a.count desc";

Kind regards,

Arjan. 
Back to Top
Rate [
|
]
 
 
yhkhoe
Date: 5/15/2007 10:24 am   ·   Subject: Re: AOIHits and AOIRank not working problem and solution   ·   Rating: 0

fixed in 7.3.18
Back to Top
Rate [
|
]
 
 
     Report a Bug > WebGUI Bug Tracker