Digerdoo Posted December 28, 2004 Share Posted December 28, 2004 what is this ? when i click adminstration who's online : 1054 - Unknown column 'http_referer' in 'field list' select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, http_referer, session_id from whos_online order by time_last_click DESC [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted December 28, 2004 Share Posted December 28, 2004 did you just add user tracking, or some other contribution? the error means it can not find the 'http_referer' field in the table being selected and you need to either create the field or find the sql statement in the contribution instructions to add the field Link to comment Share on other sites More sharing options...
Digerdoo Posted December 28, 2004 Author Share Posted December 28, 2004 did you just add user tracking, or some other contribution?the error means it can not find the 'http_referer' field in the table being selected and you need to either create the field or find the sql statement in the contribution instructions to add the field <{POST_SNAPBACK}> so what i do ? Link to comment Share on other sites More sharing options...
Guest Posted December 28, 2004 Share Posted December 28, 2004 you need to either create the field or find the sql statement in the contribution installation instructions to add the field to the database table Link to comment Share on other sites More sharing options...
Digerdoo Posted December 28, 2004 Author Share Posted December 28, 2004 you need to either create the field or find the sql statement in the contribution installation instructions to add the field to the database table <{POST_SNAPBACK}> ------------------------------> Thanx ! Link to comment Share on other sites More sharing options...
zboyblue Posted October 6, 2005 Share Posted October 6, 2005 Mibble, do you have any suggestions for my issues? Craig Link to comment Share on other sites More sharing options...
zboyblue Posted October 7, 2005 Share Posted October 7, 2005 WOOO HAAAAA!! Problem solved! (At least I think so) I was killing myself trying to figure out why in the world the referer was showing up as my own site and about the time I thought I had it figured out someone would place an order (and I can see them placing the order through my live chat software) and would see where they came from (Overture ad for instance) .. then the order would come through and it would show my site as the referer!!! AHHH!!! I thought I had this stupid thing fixed!! .. Well just now I went to overture for something (I have someone that manages my CPC advertising so I never go there) and looked at one of the ads, there was a Csid in the link!!! GRRR!! The guy that did the ads for me copied what was in his browser (which at the time has session id's, now I have them turned off - stored in cookies) and that was the problem the WHOLE time. To complicate matters even more while trying to test what was happening I had a theory that the referer variable was being reset before that user checked out (when someone new came to the site while they were still there). So while trying to duplicate the bug I got random results which drove me nuts. It turned out that because the session was then stored in COOKIES that no matter WHERE you clicked to the site from it would show the ORIGINAL referer that was in the cookie. AHH Man I thought I was going to go nuts! ANYWHO ... I think that is the whole problem (bad links) and so when those are fixed it should be to normal. (Fingers crossed : ) Hope this helps someone else, I REALLY DO! Craig Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.