After some refactoring, my project is nearly finished, but I can't test it in the sandox anymore.
I have an error in the "Restore data set" step :

Error

---

Unknown column 'code_postal' in 'field list' SQL=INSERT INTO `[PREFIX]demo2088_prestations` (`id`, `params`, `nom`, `alias`, `code_postal`, `ville`, `duree`, `categorie`, `publish`, `creation_date`, `modification_date`) VALUES (1,'','Prestation','prestation',45000,'Orléans','1 heure',3,0,'2012-01-25','2012-01-25');
Unknown column 'creation_date' in 'field list' SQL=INSERT INTO `[PREFIX]demo2088_categories` (`id`, `params`, `nom`, `alias`, `parent`, `creation_date`, `modification_date`) VALUES (1,'','Catégorie 1','categorie1',0,'',''),(2,'','Catégorie 2','categorie-2',0,'2012-01-25','2012-01-25'),(3,'','Sous-catégorie 1','sous-categorie-1',1,'2012-01-25','2012-01-25');
Unknown column 'code_postal' in 'field list' SQL=INSERT INTO `[PREFIX]demo2088_prestations` (`id`, `params`, `nom`, `alias`, `code_postal`, `ville`, `duree`, `categorie`, `publish`, `creation_date`, `modification_date`) VALUES (1,'','Prestation','prestation',45000,'Orléans','1 heure',3,0,'2012-01-25','2012-01-25');
Unknown column 'creation_date' in 'field list' SQL=INSERT INTO `[PREFIX]demo2088_categories` (`id`, `params`, `nom`, `alias`, `parent`, `creation_date`, `modification_date`) VALUES (1,'','Catégorie 1','categorie1',0,'',''),(2,'','Catégorie 2','categorie-2',0,'2012-01-25','2012-01-25'),(3,'','Sous-catégorie 1','sous-categorie-1',1,'2012-01-25','2012-01-25');

Maybe because of some renamed fields in tables ?
Need help, it's a little bit urgent...

Well, in facts it can happens sometimes when you rename too much fields in the same time.

Renaming is possible, but sometimes it lacks. I have a still opened issue here.

If you nevermind loosing your dataset and wanting to continue working, you can still open the sandboxes :
1.5 : sandbox.cms15.j-cook.pro/
1.7 : sandbox.cms.j-cook.pro/

You MUST add at least ONE entry, and then at the next backup/restore, it will flush the previous wrong one.
(If your tables are all empty, it don't backup anything for security and keep the last one in date)


Second option if you want to keep your dataset.
- Try to undo your changes and come back to the old names.
- Try to delete the 'code_postal' field. Regenerate your project, and then add it for new and regenerate again.


For the moment I am very busy, so I don't want to intervent manually on your tables to check the problem.
But if you have a LOT of entries that you want to keep, please tell me, and I see what can I do.


FOR THE MOMENT :
This issue happens some times. Once a month a user ask me for that. And I can see it in my debug screens that it happens in error boxes.

Try to first design well you database fields and when you want to rename fields, do only operation of renaming WITHOUT ADDING ANY OTHERS FIELDS (of same name), and generate. It passes.


Hope it helps.

In case, keep the sandboxes links in your bookmarks.

PS : nice avatar.... Little bit of colors here

Logging to the sandbox and creating one entry does work.
Thanks for all

PS: an ooold avatar, but it's mine, on every website