Question

I have some non site admins. They have admin permissions for certain projects. The Remind button is available when a case for those projects is selected. When they click the Remind button, it crashes with the error: Table 'fogbugz_db.BUG' doesn't exist. I have more error information from the FogBugz Internal Error page if needed.

Case FC2305321

Answer 1

That definitely sounds like a bug. Thanks for reporting it!

What version of FogBugz are you running? Also, what database server and database version (e.g., SQL Server 2005, MySQL 5.5, etc.) are you running? Are you running FogBugz on a Windows server or on a Unix/Linux server? What operating system is your database server (if different from your FogBugz server) running?

If you're running FogBugz against a MySQL database, it sounds like your MySQL installation is running in "case-sensitive" mode. If this is the case, we've already fixed the underlying bug that's causing this problem and it will be released in the next version of FogBugz.

In the meantime though, you could work around this by telling your MySQL database to not be case-sensitive by setting the lower_case_table_names setting to 2 as outlined here. If you decide to make this change, be sure to restart MySQL before testing the change.