Installation error number 1062

  • Wavefront
  • Wavefront's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0

Wavefront created the topic: Installation error number 1062

Hi, I had a problem installing breezingCommerce.
In the site is already up and running BreezingForms. When I try to install BreezingCommerce I obtain this:
Warning
JInstaller: :Install: Error SQL Duplicate entry '1' for key 'PRIMARY'
Extension Install: SQL error processing query: DB function failed with error number 1062 
Duplicate entry '1' for key 'PRIMARY'

SQL =

INSERT INTO `#__breezingcommerce_categories` (`id`, `title`, `alias`, `description`, `description_fulltext`, `image_name`, `image_alt_name`, `image_description`, `image_background_color`, `image_physical_name`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `modified_by_alias`, `metadesc`, `metakey`, `metadata`, `parent_id`, `level`, `lft`, `rgt`, `path`, `published`, `ordering`) VALUES(1, 'ROOT', 'root', '', '', '', '', '', '', '', '0000-00-00 00:00:00', 0, '', '0000-00-00 00:00:00', 0, '', '', '', '', 0, 0, 0, 1, '', 0, -1);

I know, that this means that in the table already exist an antry in the primary key. But why this happens?
Any idea?
#234514
  • Wavefront
  • Wavefront's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0

Wavefront replied the topic: Installation error number 1062

I found a work around.
I deleted all the breezingcommerce tables from the database. I restarted the installation and, this time, everything worked fine.
#234537
  • Posts: 2282
  • Karma: 84
  • Thank you received: 306

mihaela replied the topic: Installation error number 1062

Hello,

I'm glad that you have managed to found a work around for this issue and install the component.

Regards,

Mihaela
#234545
Time to create page: 0.059 seconds

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99€

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here