A forum for technical support discussion related to Fogbugz.
luckily, i created a copy of our FB 3.1.9 database and site to test the upgrade on.
the upgrade fails with the following message:
Full-text catalog 'FogBUGZCatalog' has been lost. Use sp_fulltext_catalog to rebuild and to repopulate this full-text catalog.
SQL: exec sp_fulltext_table ?, 'create', 'FogBUGZCatalog', ?
and then the "restore from failed upgrade" doesn't restore the registry entries properly, leaving the site in an unusable state. a delte/reapply of the old registry keys fixes this part.
i placed a call into fogcreek for support on 3/2, but nobody returned my call.
I received your phone message that day. I couldn't quite make out the number that you left in your message. I called 2 permutations of what I believe the number was, one of them was valid but there was no answer and no voice mail.
So I called the only number we have on file for you, for Kelly at the Jacksonville office, who ordered FogBugz. I left a message with her describing the situation and asking that she pass on my message to you. I also called the only phone number on your company website, but they say you do not work at that office and did not give me a way to reach you, but passed me to Kelly's voice mail again.
Please take a look at this guide and see if it helps:
If you have questions please send an email to us at email@example.com or call us at 866-364-2733.
When you attached the copy of the database, the fulltext catalog was not recreated; this happens with MSSQL and was not something we considered as a possible upgrade problem. It is now noted. You can use Enterprise Manager to manually create the catalog, or run "exec sp_fulltext_catalog 'FogBUGZCatalog', 'create'" against the attached db copy.
Thank you for your attempts to call me back. ;o) I'm apologize that I wasn't clear on the message.
The KB entry you pointed me to is for a 4.0.11 installation. However, the installation application attempts to roll back the installation to the 3.1.9 version. This rollback is successful except for the registry entries. I have to delete/reapply the 3.1.9 registry keys to make the non-upgraded version workable again.
I tried the steps in the KB article anyways and the results were the same as before; same error, same failed rollback.
I am doing a full restore from backup to a new test database. The fulltext catalog is restored properly along with the rest of the database. Searches executed from withing FogBugz return proper results. Executing your "exec sp_fulltext_catalog 'FogBUGZCatalog', 'create'" statement results in: "A full-text catalog named 'FogBUGZCatalog' already exists in this database."
As far as I can tell, this is as close to a default installation of FogBugz that can be implemented. The fulltext search options in SQL Server were installed and working before FogBugz was installed and after installation of 3.1.9, the search features worked flawlessly. There were no other changes to the installation after that.
Is there a way to force the installer to not rollback after an error? We might be able to get some more information from the failed installation, or perhaps even repair it.
I appreciate your help in hunting this down.
I did these steps:
- ran a standalone installation of 4.0.11
- changed the registry key to point to my old database
- hit the new homepage, ran the manual upgrade and received the error
- ran the sp "sp_fulltext_catalog 'FogBUGZCatalog', 'Rebuild'"
- hit the homepage again, the manual upgrade worked this time
Thanks for your help!
This topic is archived. No further replies will be accepted.Other recent topics