I have been working on a component but noticed when I update it I get an error (something like "Component Update: DB error file function returned no error", not exact but close).
I notice this is due to the rows in the extension table (only the extension table). Deleting them fixes it. But that is basically "uninstalling" the component without removing its files/data (other then config), so its really not an option to do a preflight script and do that on update.
Due to the nature of the component I have a library that installs beside it, so I used F0F's installerscript tool (and extended it since it has no option to install libraries). F0F has a function called
bugfixDBFunctionReturnedNoError() Which fixes the error using the technique described above. However its made to do it in install in case it was uninstalled and left anything remaining. But i need it done on update.
I did some changes to the installer script to make it run on update as well and it is working with that. However it is not the way around this problem, any thoughts on this?