FAQ: Problems with MySQL

Discuss problems installing or using TrackStudio.

FAQ: Problems with MySQL

Postby admin » Mon Apr 07, 2003 6:30 pm

We receive messages about problems with TrackStudio and MySQL. The common thing of all problems: some strange errors after you delete something in database (user status, workflow, task, user, etc).

If you has such problems, you, possible, need to ensure that you setup InnoDB (we need FK support and MyISAM does not support FK). To check this please try login as root/root and try delete user status 'administrator' or 'manager'.

If all OK, you should receive exception, something like this:
gran.exception.GranException: User Test could not be deleted
at gran.app.UserManager.deleteUsers(UserManager.java:204)
at gran.jsp.ListAction_jsp._jspService(ListAction_jsp.java:136)

If item deleted without exception - you setup InnoDB incorrectly and you need check MySQL configuration guide again.
Maxim Kramarenko (mailto: maximkr@trackstudio.com)
TrackStudio - Hierarchical Bug & Issue Tracking Software
Site Admin
Posts: 8148
Joined: Thu Jan 01, 1970 3:00 am
Location: Smolensk, Russia

Return to TrackStudio Support

Who is online

Users browsing this forum: Google [Bot] and 12 guests