beckiehawk Posted November 11, 2010 Share Posted November 11, 2010 I downloaded the Georgia Sales Tax by county. It is based on the Ohio tax by county. When I try to import the 4 sql files, the first one, Georgia Zones, executes with no problem, but when I import the second one, Georgia Tax Rates, I get the following error Error SQL query: INSERT INTO tax_rates VALUES ( '', '2', '1', '1', '7.00', 'Atkinson County Tax (7.00%)', NULL , NOW( ) , 'ATKINSON' ); MySQL said: #1062 - Duplicate entry '0' for key 'PRIMARY' When I try to import the third one, Zones I get this error: SQL query: INSERT INTO zones VALUES ( '', 223, 'GA', 'Georgia (Atkinson County)' ); MySQL said: #1062 - Duplicate entry '0' for key 'PRIMARY' Then the last one, Zones to Georgia Zones, executes successfully. I am not a an expert in SQL, so I don't know what to do about this. Can anyone tell me what I need to do here? Quote Link to comment Share on other sites More sharing options...
multimixer Posted November 11, 2010 Share Posted November 11, 2010 Go to your phpMyAdmin and check if you have the "do not use auto-increment for zero values" checked Quote My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
beckiehawk Posted November 11, 2010 Author Share Posted November 11, 2010 Thank you so much... who woulda' thunk it. That worked perfectly. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.