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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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?? |
| Sponsored Links | ||
| ||
|
#2
| ||||
| ||||
| 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
|
|
#3
| |||
| |||
| Thank you so much Michael, i deleted the table and run the query for creating the new one, it fixed the problem. best, Matteo |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| 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 |