Results 1 to 3 of 3

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 ...

      
  1. #1
    Lurker
    Join Date
    Dec 2006
    Posts
    2
    Rep Power
    0


    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??

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    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 installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Lurker
    Join Date
    Dec 2006
    Posts
    2
    Rep Power
    0


    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

Similar Threads

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •