Welcome to the FogBugz Knowledge Exchange

Question

1

I am having a problem where the drop downs such as Project, Area, Milestone, Category, and Status are not populating. This happens at intermittent times, on different Os's and different browsers. A list of the Os's and browsers are as follows.

Win Server 2003, Mozilla 3.6, 4 Ie 7, 8 Mac OSX Mozilla 3.6, 4 Safari Version 5.0.3 Win 7 IE 8, Mozilla 3.6

FogBugz Link: default.asp?command=new&pg=pgEditBug

edited Apr 21 2011 at 17:13

asked Apr 20 2011 at 20:06

John B
31●3

	Here is the link for the Mozilla Error console output... Link: ddsi.me/ss/fbz/20110420_ff4_ec_output.jpg – John B Apr 20 2011 at 20:23
	We are having the same issue but we are using Microsoft SQL Server 2005. Is the command still valid except for the data type? If it is just changing the data type what would we change it to? – Megan Oertel May 10 2011 at 17:55

John B · Answer 1 · 2011-04-21 17:11:47Z UTC

FogBugz generates the jsDB.asp string, it caches it in the FragmentCache table, but in MySQL, one column's defined to be too short so it gets truncated. The fix is two quick SQL queries. Just run these in MySQL against the FogBugz database, then reload the New Case page and it should be fixed. We have a case open to correct this problem with the schema for future versions.

ALTER TABLE FragmentCache MODIFY COLUMN sValue mediumtext;

DELETE FROM FragmentCache;

Claps to Adam at Fogbugz for help with this solution.

jason · Answer 2 · 2011-04-26 18:06:51Z UTC

0

Awesome! thk you! Worked like a charm.

answered Apr 26 2011 at 18:06

jason
1

You're welcome! : ) – John B Apr 27 2011 at 21:47

FogBugz 8 New Case Drop Down Not Populating

2 Answers