Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

http_referer


Digerdoo

Recommended Posts

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

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

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

 

 

 

so what i do ?

Link to comment
Share on other sites

  • 9 months later...

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...