Viewing 11 posts - 46 through 56 (of 56 total)
  • Author
    Posts
  • jooservices Friend
    #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
    #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.

    tejinfo Developer
    #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
    #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
    #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
    #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
    #736888

    Hi @sislei,

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

    sislei Friend
    #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
    #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
    #572090

    Solved reviewing the database utf8_general_ci collation, my fault. thanks

    sislei Friend
    #737130

    Solved reviewing the database utf8_general_ci collation, my fault. thanks

Viewing 11 posts - 46 through 56 (of 56 total)

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