Hi, ocurrering a error in sandbox...

Unknown column 'foto_principal' in 'field list' SQL=INSERT INTO `[PREFIX]demo2368_imoveis` (`id`, `params`, `cdigo`, `tipo`, `cidade`, `bairro`, `modalidade`, `descrio`, `contato`, `foto_principal`, `foto_`, `detalhes`) VALUES (1,'',15421,'Casa','Joinville','Paranaguamirim','Venda','Casa Madeira com 3 quartos, 2 banheiros','Ricardo','cau-hansen-1.png','911_gt3_rs_4.0.png','');
Unknown column 'foto_principal' in 'field list' SQL=INSERT INTO `[PREFIX]demo2368_imoveis` (`id`, `params`, `cdigo`, `tipo`, `cidade`, `bairro`, `modalidade`, `descrio`, `contato`, `foto_principal`, `foto_`, `detalhes`) VALUES (1,'',15421,'Casa','Joinville','Paranaguamirim','Venda','Casa Madeira com 3 quartos, 2 banheiros','Ricardo','cau-hansen-1.png','911_gt3_rs_4.0.png','');

Not good.

This is a known bug.
It appears when you rename fields.

Renaming fields works, but SOMETIMES it lacks. You sould rename not too much fields in the same time.

You might lost your current dataset in use.

TODO :
Regenerate.
It stops on the last step, but your component is installed in sandbox.
Go to the sandbox manually (bookmark the Sandboxes URLS)
Find your empty project and add at least ONE entry.

Regenerate your component.
It passes. but you lost your current dataset.


Why adding ONE entry ?
Because when the system process the backup, if your dataset is empty, it doesn't backup anything and keep the last in date one.

Hope it helps.

Hi,

People need to test with the data. It is time demanding to put the data into DB again and again. This is quite annoying. So I have to download the component and install on my website to test it with the data I allready put into DB.
This cost me credits even I removed something from my application. And this is really unfair.

I add a precision.

Renaming the fields is working. Everithing is working... BUT... It you do too much modification at the same time, it lacks.

The problem comes when you rename table aliases and fields aliases in mass.

You can try to change only one field name, and régenerate, it works.

I believe it works. But everytime I try to run sandbox it generates error with restoring data or something like that. I probably changed more data, but I did what I did. Lesson learned.
So is it possible to remove the data from DB regarding my component. I mean clean it somehow so I can install my component from the scretch?

I can do this manually, but did you tried this ?

TODO :