Duplicate entry '1' for key 'PRIMARY'

marvays
marvays
Offline
0
Hi.
I am new here. Today i was buy this component with all extentions and plugins. I try instal to website, and have this problem.
Upozornění
JInstaller: :Instalace: Chyba SQL Duplicate entry '1' for key 'PRIMARY'
Rozšíření Instalovat: SQL chyba zpracování dotazu: DB funkce selhala, číslo chyby 1062
Duplicate entry '1' for key 'PRIMARY'
SQL =
INSERT INTO `#__invoices_currencies` (`id`, `currency_symbol`, `currency_code`, `currency_format`, `currency_name`, `currency_published`, `currency_rate`, `currency_locale`, `currency_displayed`, `currency_percent_fee`, `currency_modified`, `symbol_before`, `symbol_after`, `decimals`, `decpoint`, `thousands`, `negative_position`) VALUES
(1, '€', 'EUR', '%n', 'Euro', 1, '1.00000', 'a:13:{s:17:\"mon_decimal_point\";s:1:\",\";s:17:\"mon_thousands_sep\";s:1:\".\";s:12:\"mon_grouping\";s:1:\"3\";s:13:\"positive_sign\";s:0:\"\";s:13:\"negative_sign\";s:1:\"-;


On this eshop I have another invoice component too. I must use another and your :)

Any idea, where is the problem?
Responses (2)
  • Accepted Answer

    Tuesday, February 27 2018, 05:10 PM - #Permalink
    0
    looks like there some currencies already installed?

    can you check if a DB table named invoices_currencies existed previously?
    The reply is currently minimized Show
  • Accepted Answer

    marvays
    marvays
    Offline
    Tuesday, February 27 2018, 06:29 PM - #Permalink
    0
    hi. i check it. this table do not existed previously. this table must be created with first instal. I chcek it on live website. If I delete this table and instal again, are is good and component working :)
    The reply is currently minimized Show
Your Reply