-
AuthorPosts
-
jooservices Friend
jooservices
- Join date:
- October 2014
- Posts:
- 8556
- Downloads:
- 0
- Uploads:
- 130
- Thanked:
- 1245 times in 1121 posts
May 18, 2015 at 11:22 am #570925Hi there
I have tested on Windows 7 with WAMP inside my VMWare and everything fine.Actually if it’s quickstart trouble by itself. It must be troubles for ALL CASES. But in fact just some.
And about
<blockquote>I solved it by creating the database with utf8_general_ci and the quickstart has been successful.</blockquote>I believe utf8_general_ci must be default for all database
Thank you,
Viet VuAdam M ModeratorAdam M
- Join date:
- May 2014
- Posts:
- 5159
- Downloads:
- 33
- Uploads:
- 66
- Thanks:
- 95
- Thanked:
- 1271 times in 1235 posts
May 18, 2015 at 4:43 pm #570968Hi guys,
1. This is a well-known problem with Virtuemart when exporting database, you can see the thread here.
2. To fix this problem, please extract the quickstart package you got from our site, then open file installationsqlmysqljoomla.sql then look for this part :
UNIQUE KEY `state_3_code` (`virtuemart_vendor_id`,`virtuemart_country_id`,`state_3_code`),
UNIQUE KEY `state_2_code` (`virtuemart_vendor_id`,`virtuemart_country_id`,`state_2_code`),
KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
KEY `virtuemart_country_id` (`virtuemart_country_id`),and update as below :
KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
save your file and you can install as normal, whatever your database collation is.
2 users say Thank You to Adam M for this useful post
May 21, 2015 at 5:10 pm #571379Yes It is work for me also
<em>@efficiency 473758 wrote:</em><blockquote>I have had the same problem and went through all the advice here. The issue is not with hosting butwith Quickstart sample data settings. In fact, it installs fine without sample data.
I was only able to install it using utf8_general_ci</blockquote>
May 25, 2015 at 4:11 pm #571651Hi, I still have the same problem in the quick start. I’ve done all sorts of tests unresolved. I need help. Thanks.
This is the error. Duplicate entry ‘1-84-???’ for key ‘state_3_code’ SQL=INSERT INTO `wk4ft_virtuemart_states` (`virtuemart_state_id`, `virtuemart_vendor_id`, `virtuemart_country_id`, `virtuemart_worldzone_id`, `state_name`, `state_3_code`, `state_2_code`, `ordering`, `shared`, `published`, `created_on`, `created_by`, `modified_on`, `modified_by`, `locked_on`, `locked_by`) VALUES (390, 1, 10, 0, ‘San Juan’, ‘SJN’, ‘SJ’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (391, 1, 10, 0, ‘San Luis’, ‘SLU’, ‘SL’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (392, 1, 10, 0, ‘Santa Cruz’, ‘SCZ’, ‘SC’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (393, 1, 10, 0, ‘Santa Fe’, ‘SFE’, ‘SF’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (394, 1, 10, 0, ‘Santiago Del Estero’, ‘SEN’, ‘SE’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (395, 1, 10, 0, ‘Tierra Del Fuego’, ‘TFE’, ‘TF’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (396, 1, 10, 0, ‘Tucuman’, ‘TUC’, ‘TU’, 0, 0, 1,
May 25, 2015 at 4:11 pm #736697Hi, I still have the same problem in the quick start. I’ve done all sorts of tests unresolved. I need help. Thanks.
This is the error. Duplicate entry ‘1-84-???’ for key ‘state_3_code’ SQL=INSERT INTO `wk4ft_virtuemart_states` (`virtuemart_state_id`, `virtuemart_vendor_id`, `virtuemart_country_id`, `virtuemart_worldzone_id`, `state_name`, `state_3_code`, `state_2_code`, `ordering`, `shared`, `published`, `created_on`, `created_by`, `modified_on`, `modified_by`, `locked_on`, `locked_by`) VALUES (390, 1, 10, 0, ‘San Juan’, ‘SJN’, ‘SJ’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (391, 1, 10, 0, ‘San Luis’, ‘SLU’, ‘SL’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (392, 1, 10, 0, ‘Santa Cruz’, ‘SCZ’, ‘SC’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (393, 1, 10, 0, ‘Santa Fe’, ‘SFE’, ‘SF’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (394, 1, 10, 0, ‘Santiago Del Estero’, ‘SEN’, ‘SE’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (395, 1, 10, 0, ‘Tierra Del Fuego’, ‘TFE’, ‘TF’, 0, 0, 1, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0, ‘0000-00-00 00:00:00’, 0), (396, 1, 10, 0, ‘Tucuman’, ‘TUC’, ‘TU’, 0, 0, 1,
Adam M ModeratorAdam M
- Join date:
- May 2014
- Posts:
- 5159
- Downloads:
- 33
- Uploads:
- 66
- Thanks:
- 95
- Thanked:
- 1271 times in 1235 posts
Adam M ModeratorAdam M
- Join date:
- May 2014
- Posts:
- 5159
- Downloads:
- 33
- Uploads:
- 66
- Thanks:
- 95
- Thanked:
- 1271 times in 1235 posts
May 27, 2015 at 3:44 pm #571989Hi Adam, Thanks for answering. That test did not function. The Quickstar returns the error that I told you. There is another soculcion?
unvacancier Friendunvacancier
- Join date:
- May 2013
- Posts:
- 148
- Downloads:
- 9
- Uploads:
- 69
- Thanks:
- 18
- Thanked:
- 3 times in 1 posts
May 27, 2015 at 3:53 pm #571990Same problem here.
i check your post and i have an new error.
it’s the forst time i have problem with Joomlart Qucikstart package.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' DROP TABLE IF EXISTS `dhx7z_acymailing_config`' at line 1 SQL= DROP TABLE IF EXISTS `dhx7z_acymailing_config`
-
AuthorPosts
This topic contains 56 replies, has 16 voices, and was last updated by sislei 9 years, 5 months ago.
We moved to new unified forum. Please post all new support queries in our New Forum