Can't delete an account

[mzenns]

I installed Sugar CE 5.0.0g on a test box, populated it with the sample data and modified it for our needs, by adding several fields and a subpanel under Accounts. I now need to migrate this to the production server, but want to clear out the sample data. When I try to delete an Account, I get the following error message:

Query Failed:UPDATE services SET account_id=NULL, date_modified='2008-09-05 13:15:59' WHERE account_id= 'aacb083f-76b7-bfed-312a-48a9ad132064' ::MySQL error 1146:

Ubuntu Server 8.04
Apache 2.2
PHP 5.2.4-2
MySQL 5.0

[andopes]

Hi mzenns

Instead of removing the sample data you could create an installer containing all changes.
Then you can install this installer into an empty installation and reset it when you want.

Cheers

[mzenns]

Great! Could you please point me to instructions for creating an installer? Thanks.

[andopes]

Hi mzenns

There are good articles in the Sugar Wiki, wrote by kbril (The Sugar Legend) which explain wonderfully how to create an installer.

Best regards