Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Sign in to follow this  

Error while trying to install sql file

Recommended Posts

Today I tried to install this contri (PDF_Customer_Invoice_v1.2) but right from the start when I use phpadmin to run the db file I got an error.

I guess th esolution must be very simpel but I'm not into the sql thing and don't know where to look for the solution.

If someone could help me out I would be grateful.


This is the error I get.


#1062 - Duplicate entry '0' for key 1






INSERT INTO `configuration` VALUES ('', 'Choose logo', 'PDF_INVOICE_IMAGE', 'images/sample_logo.png', 'Path and name of store logo to insert into PDF<br />Max dimensions 600 x 180px<br />Valid formats: jpg, gif, png<br />Default logo supplied is entered here', last_insert_id(), 1, '2007-07-26 20:41:38', '2007-07-25 20:00:00', NULL, ''), ('', 'Choose an invoice font', 'PDF_INV_CORE_FONT', 'arial', 'Choose a font for the PDF invoice.<br />Arial<br />Times<br />Courier<br />Helvetica', last_insert_id(), 2, '2007-07-25 20:00:00', '2007-07-25 20:00:00', NULL, 'tep_cfg_select_option(array(''arial'', ''times'',''courier'',''helvetica''),'), ('', 'Do you want to display a VAT / Tax reference?', 'DISPLAY_PDF_TAX_NUMBER', 'false', 'Would you like to display your VAT / Tax reference on the invoice [ default = false ]', last_insert_id(), 3, '2007-07-26 20:01:07', '2007-07-25 20:00:00', '', 'tep_cfg_select_option(array(''false'', ''true''),'), ('', 'Set VAT / Tax number description', 'PDF_TAX_NAM[...]


MySQL returned:

#1062 - Duplicate entry '0' for key 1


Thanks in advance,



Share this post

Link to post
Share on other sites

Check if you have "do not use auto increment for zero values" checked when importing the sql. Should be unchecked



Thanks man, that did the job.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this