Unknown column 'stripe_card_token' in 'field list'

I am currently running 1.5.5a and have no problems. I wanted to upgrade to the "B" version.

I installed a 1.5.5a in a test folder and attempted to import the database. One of the errors I am getting is:

Error
SQL query:

--
-- Dumping data for table customers

INSERT INTO customers ( customers_id , customers_gender , customers_firstname , customers_lastname , customers_dob , customers_email_address , customers_nick , customers_default_address_id , customers_telephone , customers_fax , customers_password , customers_newsletter , customers_group_pricing , customers_email_format , customers_authorization , customers_referral , customers_paypal_payerid , customers_paypal_ec , stripe_card_token , stripe_customer_token , stripe_card_number )
VALUES ( 4, '', 'Ron', 'Miller', '0001-01-01 00:00:00', 'john3######################', '', 6, '4403341840', '4403341840', '$2y$10$t2Xs41hKNHTY7LtvdYgq5.P1JIvf457CpuZ1U1ddhEpz0BR.V32Fu', '1', 0, 'HTML', 0, '', '', 0, NULL , NULL , NULL ) , ( 5, '', 'Joe', 'fuksa', '0001-01-01 00:00:00', 'rkeane85257######################', '', 7, '4844444444', '', '$2y$10$ouibRKrBo2SZS2e6kuSDKOxGWUWPop822YkbKxS5rg08fGf6YPgUK', '0', 0, 'TEXT', 0, '', '', 0, NULL , NULL , NULL ) ;

MySQL said: Documentation

#1054 - Unknown column 'stripe_card_token' in 'field list'

When I do a quick export of the DB, I get this error when importing:

SQL query:

--
-- Dumping data for table address_format

INSERT INTO address_format ( address_format_id , address_format , address_summary )
VALUES ( 1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country' ) , ( 2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country' ) , ( 3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country' ) ;

MySQL said: Documentation

#1062 - Duplicate entry '1' for key 'PRIMARY'

In the phpmyadmin I did go into the address_format and removed the duplicate values. Then when I run the import again the same error happens. How do I get past this? I have read many forums etc but can't find a solution. I did run CK Database and it was ok. Thank you for your help.

2 things:

1. "Unknown column 'stripe_card_token' in 'field list'"
   This is because your customers table has had fields added to it that aren't in the default database, but you're trying to import data into those non-existent fields.
   It would appear that the fields in your case are for the Stripe payment module ... which isn't installed on your new site.

2. Duplicate entries.
   This is because you're importing data into a table that already has data in it.
   This is a classic symptom of exporting data without telling the export to include a "DROP TABLES IF EXIST" statement for each table.

Both of these problems will disappear if your database-export is built properly:

• include both "structure AND data"
• include "drop tables"
• and others ... all of which is explained here: How can I do a Site Backup? Or use phpMyAdmin to backup my database?