Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

whos online problem


garyidweb

Recommended Posts

Can anyone shed some light on this please.

 

I get the following mysql error if i view my site in two browsers at the same time on the same machine.

 

The first browser will work fine but the second browser shows this:

1062 - Duplicate entry '0' for key 1

 

update whos_online set customer_id = '', full_name = 'Guest', ip_address = '81.99.31.182', time_last_click = '1058301540', last_page_url = '/catalog/product_info.php?cPath=&products_id=1179' where session_id = 'cd35b63faa1c47babc9957d2ac92f4b0'

 

Thanks

Link to comment
Share on other sites

I have seemed to tracked down the problem

 

After installing the "Create Indexes Automatically" contibution and creating the indexes the problem seems to have started

 

I droped the whose online table and created it again in PhpMyadmin and this fixed the problem.

 

Can any one tell me why this caused he problem

 

Thanks

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...