Joomla Templates Club 406,261 posts

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#570925

Hi 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 Vu

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#570968

Hi 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

1. dsantosg
2. visability

[tejinfo Developer tejinfoJoin date: February 2015Posts: 14Downloads:340Uploads:1 Thanks: 5]

#571379

Yes 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 but

with Quickstart sample data settings. In fact, it installs fine without sample data.

I was only able to install it using utf8_general_ci</blockquote>

[sislei Friend sisleiJoin date: July 2014Posts: 5Downloads:75Uploads:0 Thanked: 2 times in 3 posts]

#571651

Hi, 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,

[sislei Friend sisleiJoin date: July 2014Posts: 5Downloads:75Uploads:0 Thanked: 2 times in 3 posts]

#736697

Hi, 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 Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#571842

Hi @sislei,

Please check my previous reply (#30) or convert your database to utf8_general_ci collation and it should work.

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#736888

Hi @sislei,

Please check my previous reply (#30) or convert your database to utf8_general_ci collation and it should work.

[sislei Friend sisleiJoin date: July 2014Posts: 5Downloads:75Uploads:0 Thanked: 2 times in 3 posts]

#571989

Hi Adam, Thanks for answering. That test did not function. The Quickstar returns the error that I told you. There is another soculcion?

[unvacancier Friend unvacancierJoin date: May 2013Posts: 148Downloads:9Uploads:69 Thanks: 18 Thanked: 3 times in 1 posts]

#571990

Same 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`

[sislei Friend sisleiJoin date: July 2014Posts: 5Downloads:75Uploads:0 Thanked: 2 times in 3 posts]

#572090

Solved reviewing the database utf8_general_ci collation, my fault. thanks

1 user says Thank You to sislei for this useful post

1. TomC

[sislei Friend sisleiJoin date: July 2014Posts: 5Downloads:75Uploads:0 Thanked: 2 times in 3 posts]

#737130

Solved reviewing the database utf8_general_ci collation, my fault. thanks

1 user says Thank You to sislei for this useful post

1. TomC

[Author]

Posts