- Posts: 2
- Home
- Forum
- Community Forum
- Report bugs
- 1062 Duplicate entry
1062 Duplicate entry
- Savchenko
- Topic Author
- Offline
Less
More
10 years 5 months ago #2039
by Savchenko
1062 Duplicate entry was created by Savchenko
/administrator/index.php?option=com_solidres&task=system.installsampledata
1062 Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `y9u3v_sr_customer_groups` (`id`, `name`, `state`) VALUES (1, 'Regular Customer', 1), (2, 'Silver Customer', 1), (3, 'Gold Customer', 1), (4, 'Premium Customer', 1), (5, 'Diamond Customer', 1)
/administrator/index.php?option=com_solidres&task=system.installsampledata
1062 Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `y9u3v_sr_categories` (`id`, `parent_id`, `asset_id`, `lft`, `rgt`, `title`, `alias`, `description`, `state`, `ordering`, `access`, `checked_out`, `checked_out_time`, `created_by`, `created_date`, `modified_by`, `modified_date`, `params`) VALUES (1, 1, 212, 0, 19, 'Root', 'Root', '', 1, 0, 1, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 42, '2010-09-22 03:07:03', ''), (12, 1, 216, 17, 18, 'Apartment', 'apartment', '', 1, 1, 1, 0, '0000-00-00 00:00:00', 42, '2010-09-16 02:49:21', 42, '2010-09-17 07:00:02', ''), (13, 1, 215, 11, 16, 'Hotel', 'hotel', '', 1, 2, 1, 0, '0000-00-00 00:00:00', 42, '2010-09-16 02:49:40', 42, '2010-09-17 06:59:57', ''), (14, 1, 214, 9, 10, 'Motel', 'motel', '', 1, 3, 1, 0, '0000-00-00 00:00:00', 42, '2010-09-16 02:49:52', 42, '2010-09-17 06:59:25', ''), (15, 1, 213, 7, 8, 'Hostel', 'hostel', '', 1, 4, 1, 0, '0000-00-00 00:00:00', 42, '2010-09-16 02:50:05', 42, '2011-05-30 15:37:00', ''), (16, 1, 250, 5, 6, 'Guest Accommodation', 'guest-accommodation', '', 1, 5, 1, 0, '0000-00-00 00:00:00', 42, '2011-05-30 15:37:51', 0, '0000-00-00 00:00:00', ''), (17, 1, 249, 3, 4, 'Residence', 'residence', '', 1, 6, 1, 0, '0000-00-00 00:00:00', 42, '2011-05-30 15:38:26', 0, '0000-00-00 00:00:00', ''), (18, 1, 248, 1, 2, 'Resort', 'resort', '', 1, 7, 1, 0, '0000-00-00 00:00:00', 42, '2011-05-30 15:38:51', 0, '0000-00-00 00:00:00', ''), (19, 13, 255, 14, 15, 'Mini Hotel', 'mini-hotel', '', 1, 8, 1, 0, '0000-00-00 00:00:00', 118, '2012-07-23 03:35:48', 0, '0000-00-00 00:00:00', ''), (20, 13, 256, 12, 13, 'Garden hotel', 'garden-hotel', '', 1, 9, 1, 0, '0000-00-00 00:00:00', 116, '2012-07-25 03:41:58', 0, '0000-00-00 00:00:00', '')
1062 Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `y9u3v_sr_customer_groups` (`id`, `name`, `state`) VALUES (1, 'Regular Customer', 1), (2, 'Silver Customer', 1), (3, 'Gold Customer', 1), (4, 'Premium Customer', 1), (5, 'Diamond Customer', 1)
/administrator/index.php?option=com_solidres&task=system.installsampledata
1062 Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `y9u3v_sr_categories` (`id`, `parent_id`, `asset_id`, `lft`, `rgt`, `title`, `alias`, `description`, `state`, `ordering`, `access`, `checked_out`, `checked_out_time`, `created_by`, `created_date`, `modified_by`, `modified_date`, `params`) VALUES (1, 1, 212, 0, 19, 'Root', 'Root', '', 1, 0, 1, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 42, '2010-09-22 03:07:03', ''), (12, 1, 216, 17, 18, 'Apartment', 'apartment', '', 1, 1, 1, 0, '0000-00-00 00:00:00', 42, '2010-09-16 02:49:21', 42, '2010-09-17 07:00:02', ''), (13, 1, 215, 11, 16, 'Hotel', 'hotel', '', 1, 2, 1, 0, '0000-00-00 00:00:00', 42, '2010-09-16 02:49:40', 42, '2010-09-17 06:59:57', ''), (14, 1, 214, 9, 10, 'Motel', 'motel', '', 1, 3, 1, 0, '0000-00-00 00:00:00', 42, '2010-09-16 02:49:52', 42, '2010-09-17 06:59:25', ''), (15, 1, 213, 7, 8, 'Hostel', 'hostel', '', 1, 4, 1, 0, '0000-00-00 00:00:00', 42, '2010-09-16 02:50:05', 42, '2011-05-30 15:37:00', ''), (16, 1, 250, 5, 6, 'Guest Accommodation', 'guest-accommodation', '', 1, 5, 1, 0, '0000-00-00 00:00:00', 42, '2011-05-30 15:37:51', 0, '0000-00-00 00:00:00', ''), (17, 1, 249, 3, 4, 'Residence', 'residence', '', 1, 6, 1, 0, '0000-00-00 00:00:00', 42, '2011-05-30 15:38:26', 0, '0000-00-00 00:00:00', ''), (18, 1, 248, 1, 2, 'Resort', 'resort', '', 1, 7, 1, 0, '0000-00-00 00:00:00', 42, '2011-05-30 15:38:51', 0, '0000-00-00 00:00:00', ''), (19, 13, 255, 14, 15, 'Mini Hotel', 'mini-hotel', '', 1, 8, 1, 0, '0000-00-00 00:00:00', 118, '2012-07-23 03:35:48', 0, '0000-00-00 00:00:00', ''), (20, 13, 256, 12, 13, 'Garden hotel', 'garden-hotel', '', 1, 9, 1, 0, '0000-00-00 00:00:00', 116, '2012-07-25 03:41:58', 0, '0000-00-00 00:00:00', '')
Please Log in or Create an account to join the conversation.
- vietvh
-
- Offline
Less
More
- Posts: 1553
10 years 5 months ago #2044
by vietvh
Replied by vietvh on topic 1062 Duplicate entry
Hi Savchenko,
Look like the sample data is already installed, you can check by going to your database and check the tables in the error messages to see if they contain any existing records.
vietvh
Look like the sample data is already installed, you can check by going to your database and check the tables in the error messages to see if they contain any existing records.
vietvh
The following user(s) said Thank You: Savchenko
Please Log in or Create an account to join the conversation.
- illumcsilla
- Offline
Less
More
- Posts: 7
8 years 7 months ago #6210
by illumcsilla
Replied by illumcsilla on topic 1062 Duplicate entry
Hy,
Same problem for install sample data... For my resolve problem in Solidres Setting temporary disable Multilanguage...
Same problem for install sample data... For my resolve problem in Solidres Setting temporary disable Multilanguage...
Please Log in or Create an account to join the conversation.
- vietvh
-
- Offline
Less
More
- Posts: 1553
8 years 7 months ago #6215
by vietvh
Replied by vietvh on topic 1062 Duplicate entry
Hi,
Nice week to you.
It is a little bit weird, did you have exactly the same error message with Savchenko?
Regards,
Nice week to you.
It is a little bit weird, did you have exactly the same error message with Savchenko?
Regards,
Please Log in or Create an account to join the conversation.
Moderators: solidres