Does anyone know anything about Value dropdown lists not populating in List Manager? We're having this issue lately and have no idea why it's happening.
If you take the selection values from t_keyword for the keywords in question and run the same select statement in management studio that should be populating the dropdown do you get results? If not, there might be an issue with the table/view the keyword is pulling from.
But like for Subscription-Section under the Ticketing folder on the left, how do I know the query to pull those values up?
Look in t_keyword for the Subscription Section keyword (for me that's 204, but I'm not sure if that'd be same for you?) and then scroll over to the ref_tbl, ref_idcol, ref_desccol and ref_where. That's how it builds the query for the dropdown. So then you just run the same thing and see what you get. In mine for that one it's the print_desc from tr_section where print_desc<>null. If yours is the same, if you have blank print descriptions for your sections that could cause the problem you described. But it also might not be pulling from the same table in yours.