Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Clear a User's Cookie for My Site

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #1  
Old 01-19-2015, 03:15 AM
 
dpcompany dpcompany is online now
 

eXpert
  
Join Date: Oct 2008
Posts: 313
 

Default Clear a User's Cookie for My Site

Upon our most recent upgrade from 4.3.2 to 4.6.3, a few users are experiencing strange things at checkout. Upon having those users clear their browser cookies (cookies only, not cache), this 100% of the time alleviates the issues. Is there a way to have our website force a users cookie for our site to refresh upon their next visit?

Thank you X-Cart Community!
__________________
Michael

Development
X-Cart Gold Plus v4.7.12
- php 7.3
- reBOOT reDUX
- other goodies

X-Cart Gold v4.7.7
- reBOOT Template
- XPayments 3.0.2
- Abandoned Cart Reminder
- BCSE Reward Points
- BCSE Stock Notify
- XPDF Invoices
Reply With Quote
  #2  
Old 01-20-2015, 08:27 PM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Clear a User's Cookie for My Site

Hello Michael,

You may clear all sessions (this will sign all users out, drop all stored carts and remove other session data) as follows:

Code:
DELETE FROM xcart_sessions_data; DELETE FROM xcart_session_history WHERE dest_xid NOT IN (SELECT sessid FROM xcart_sessions_data) AND xid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_packages_cache WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_shipping_cache WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_users_online WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_ge_products WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_form_ids WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_iterations WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_secure3d_data WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_taxcloud_cache WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data); DELETE FROM xcart_amazon_data WHERE sessid NOT IN (SELECT sessid FROM xcart_sessions_data);
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote

The following 2 users thank qualiteam for this useful post:
dpcompany (01-21-2015), ntclick (01-22-2015)
  #3  
Old 01-21-2015, 05:57 AM
 
dpcompany dpcompany is online now
 

eXpert
  
Join Date: Oct 2008
Posts: 313
 

Default Re: Clear a User's Cookie for My Site

Thanks Alex! I'll give this a shot and see if it fixes our issue!
__________________
Michael

Development
X-Cart Gold Plus v4.7.12
- php 7.3
- reBOOT reDUX
- other goodies

X-Cart Gold v4.7.7
- reBOOT Template
- XPayments 3.0.2
- Abandoned Cart Reminder
- BCSE Reward Points
- BCSE Stock Notify
- XPDF Invoices
Reply With Quote

The following 2 users thank dpcompany for this useful post:
ntclick (01-22-2015), ntclick (01-22-2015)
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 01:09 PM.

   

 
X-Cart forums © 2001-2020