osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Duplicate entry '0' for key 1, after installing oscmax

This is a discussion on Duplicate entry '0' for key 1, after installing oscmax within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; Hi there, i'm wondering if somebody can help me on this, i tried to install oscmax maybe 5 times, everytime ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Installation issues

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 12-30-2006, 04:31 AM
Lurker
 
Join Date: Dec 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
ournature is on a distinguished road
Default Duplicate entry '0' for key 1, after installing oscmax

Hi there,
i'm wondering if somebody can help me on this,
i tried to install oscmax maybe 5 times, everytime installation seems to be ok, but, when i open the front store the first time it works and as soon as i refresh or i change page i always get this error:

1062 - Duplicate entry '0' for key 1

insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '8c7dffa471e2c8d55101b03fb57c9afe', '::1', '1167480838', '1167480838', '/shop/')

and the front store won't work anymore.
the admin side looks to work fine.

i reinstalled the whole thing few times but when i get to the catalog front page i always get this error.

any help??
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 12-30-2006, 08:24 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 11,062
Thanks: 81
Thanked 348 Times in 327 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Duplicate entry '0' for key 1, after installing oscmax

Remove the primary key or index on the whos online table. It should not have one.

Or remove the table and run this sql it insert the correct table format:

Code:
CREATE TABLE `whos_online` (                                         
               `customer_id` int(11) NOT NULL default '0',                        
               `full_name` varchar(64) collate latin1_general_ci NOT NULL,        
               `session_id` varchar(128) collate latin1_general_ci NOT NULL,      
               `ip_address` varchar(15) collate latin1_general_ci NOT NULL,       
               `time_entry` varchar(14) collate latin1_general_ci NOT NULL,       
               `time_last_click` varchar(14) collate latin1_general_ci NOT NULL,  
               `last_page_url` varchar(64) collate latin1_general_ci NOT NULL     
             ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. Default multi server configuration for exceptional performance!

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 12-30-2006, 09:43 AM
Lurker
 
Join Date: Dec 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
ournature is on a distinguished road
Default Re: Duplicate entry '0' for key 1, after installing oscmax

Thank you so much Michael,
i deleted the table and run the query for creating the new one, it fixed the problem.
best,
Matteo
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Installing oscmax uniquedesign osCMax v2 Installation issues 6 03-05-2006 01:08 AM
Installing oscmax uniquedesign osCMax v2 Installation issues 2 02-25-2006 10:50 PM
Installing "Call for Price!" on osCMax v2.0 rgsat osCMax v2 Customization/Mods 1 09-26-2005 10:07 PM
Installing AttbuteSets to OscMax v2.0 itmltd osCMax v2 Customization/Mods 0 09-13-2005 05:26 AM
1062 - Duplicate entry '1-9445' for key 1 insert into... helixgroup osCommerce 2.2 Installation Help 0 01-11-2005 10:44 PM


All times are GMT -8. The time now is 12:45 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax