I have a custom action (ImportLatestRevisionSchemaChanges) under "install" with "execution condition": "(Not Installed)".
In this custom action I am using a temporary file (observer_ems.sql):
Code: Select all
"[MYSQL_PATH]" -uroot -ppassword -f -e "source [&observer_ems.sql]"
When I perform upgrade: it fails:
Code: Select all
MSI (s) (E8:88) [02:22:42:053]: Executing op: ActionStart(Name=ImportLatestRevisionSchemaChanges,,)
Action 2:22:42: ImportLatestRevisionSchemaChanges.
MSI (s) (E8:88) [02:22:42:053]: Executing op: CustomActionSchedule(Action=ImportLatestRevisionSchemaChanges,ActionType=3074,Source=BinaryData,Target="C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe" -uroot -ppassword -f -e "source C:\Users\Observer\AppData\Local\Temp\observer_ems.sql",)
CustomAction ImportLatestRevisionSchemaChanges returned actual error code 1 (note this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (E8:88) [02:22:42:553]: Note: 1: 1722 2: ImportLatestRevisionSchemaChanges 3: C:\Windows\Installer\MSI2329.tmp 4: "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe" -uroot -ppassword -f -e "source C:\Users\Observer\AppData\Local\Temp\observer_ems.sql"
I checked at this point that the installer is "stuck" for me to acknowledge the error, and manually search for "C:\Users\Observer\AppData\Local\Temp\observer_ems.sql", and I see that it really doesn't exist!
What's going on here? how to solve this?
My project is set to "Uninstall first, and then install" (remember: first time installation this works, it only fails at upgrade).
Dashut.
FOLLOW US
Get the latest news in Application Packaging