Duke1974 Posted July 4, 2006 Posted July 4, 2006 I came across this error on my site this morning, would anyone have a clue how to fix this? Many thanks! 1054 - Unknown column 'http_referer' in 'field list' insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'cf8c5d026105a567a1893b68b81cd955', '69.158.122.110', '1152020672', '1152020672', '/', '', '') [TEP STOP]
mwstinson Posted July 4, 2006 Posted July 4, 2006 I came across this error on my site this morning, would anyone have a clue how to fix this?Many thanks! 1054 - Unknown column 'http_referer' in 'field list' insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'cf8c5d026105a567a1893b68b81cd955', '69.158.122.110', '1152020672', '1152020672', '/', '', '') [TEP STOP] have you made any changes to application_top.php or whos_online.php? I thought this stuff was gonna be easy!! BACK IT UP BEFORE YOU JACK IT UP!!!!
Duke1974 Posted July 4, 2006 Author Posted July 4, 2006 have you made any changes to application_top.php or whos_online.php? Not that I know of. Someone told me that the host may have made changes and not updated the database or something?
Guest Posted July 4, 2006 Posted July 4, 2006 Not that I know of. Someone told me that the host may have made changes and not updated the database or something? get the contribution you installed for the HTTP_REFERER and re-install the database part.
Duke1974 Posted July 4, 2006 Author Posted July 4, 2006 It seems to be missing the fields http_referer and possibly user_agent. I'm not sure what the contribution was as the person who instaled and customized os left.
Duke1974 Posted July 4, 2006 Author Posted July 4, 2006 It seems to be missing the fields http_referer and possibly user_agent. I'm not sure what the contribution was as the person who instaled and customized os left. Could I go to my database backup manager and select one and hit restore? Would that be able to solve the problem?
Duke1974 Posted July 4, 2006 Author Posted July 4, 2006 Could I go to my database backup manager and select one and hit restore? Would that be able to solve the problem? Alright that fixed it all, just it lost all the orders that were in the system. Good thing I printed them first.
Duke1974 Posted July 4, 2006 Author Posted July 4, 2006 Now this error keeps coming up. 1016 - Can't open file: 'whos_online.MYI'. (errno: 145) delete from whos_online where time_last_click < '1152031879' [TEP STOP] I keep restoring the database from an older one and it fixes it but it returns after some time. Anyone have any idea what that could be about?
ddp Posted July 22, 2006 Posted July 22, 2006 Did you figure this out? I am getting the same error today. I'd love to know what is going on. Backup before making changes. Backup before making changes! Backup before making changes!! You did do a backup? eh?
ddp Posted July 22, 2006 Posted July 22, 2006 Searched the fourms found the answer in the knowledge base. Good I read my own signature. :P All that needed to be done was go to myphpadmin and run the followng sql command repair table whos_online and all was fixed. Backup before making changes. Backup before making changes! Backup before making changes!! You did do a backup? eh?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.