JInstaller: :Install: Error SQL DB function failed with error number 1136

Column count doesn't match value count at row 1 SQL=INSERT INTO `kitsr_demo2580_customers`

Before we had the error with the memory, now this !

Please i don't wan't to flush my data in sandbox because i need this data with my component.
It takes too much time for me to add all this records.

This is it, when this occurs, you can flush dataset to pass.
If you want to keep your datas, it is a problem.

I know I have a problem here since long time.
Let see if I can do something...

The data from table Customers is not importand to me if this help's you.

But from all the other tables is too much records we need.

So you can go to the sandbox and empty the Customers table.

I would like to fix this issue, give me some time.

This is not Fixed....

I get the same Fatal Error !

JInstaller: :Install: Error SQL DB function failed with error number 1136
Column count doesn't match value count at row 1 SQL=INSERT INTO `kitsr_demo2580_customers` (`id`,`representative`,`store_name`,`customer_code`,`company_name`,`job`,`vat_number`,`vat_doy`,`address`,`city`,`postal`,`province`,`country`,`telephone`,`customer_email`,`website`,`subscription_audio`,`subscription_video`,`subscription_support`,`joomla_user`,`storelogo`,`subscription_start_date`,`subscription_end_date`,`subscription_signed`,`setup_date`,`published`,`ordering`,`access`) VALUES (1,3,'DJPro - Master','0','DJPro Ltd.',6,'998302940','Β\' Κατερίνης','Παλαιών Πατρών Γερμανού 28',1,'60100','Πιερία',1,'2351032300','http://www.djpro.gr',19,1,1,20,'djpro_logo.png','2013-01-01','2014-12-31',0,'2013-01-01',1,1,1);

What i want is not to flush the data becuase 3-4 tables has many records that we wan't to install with our component. (That's why we have "Include Dataset": Yes) !

Can you please send me an e-mail with the dump of the following tables ??

Cities,
Jobs,
Countries,
Music Categories,
Representatives,
Audio Subscriptions,
Video Subscriptions,
Support Subscriptions.

Then we can Flush the dataset....

Thank you in advance,

Dear Admin,

After some research i found that the e-mail field is our problem in Customers table... missing data for that field causing this error !

If i remove that e-mail field and create a new string or text field, is there any fear to loose data from SandBox ?