[Rt-devel] 'Bulk Update' not working?

[Dave Alden]

Hi,

On Tue, Jan 24, 2006 at 11:35:40AM -0500, Ben Goodwin wrote:
> Yes, that's what I meant.  When you click "Advanced", are both boxes
> completely empty?

Yes (but read on :-).

> Have you ever changed your Prefs -> Search Options?
> I've found that I've had to completely wipe out my personal prefs (manual
> database alteration) to get this to work right...
> Try this manual database query outside RT:
> 
> SELECT Attributes.id,Attributes.Name,Attributes.Description FROM Attributes
> LEFT JOIN Users ON Attributes.Creator = Users.id WHERE Users.Name =
> 'YOURLOGINNAME' AND Attributes.Name != "SquelchMailTo" AND Attributes.Name
> != "SavedSearch";
> 
> Replace YOURLOGINNAME as appropriate and fix any line wrapping.

That returned:

+----+------------------+-------------+
| id | Name             | Description |
+----+------------------+-------------+
|  4 | Pref-SummaryRows | NULL        |
+----+------------------+-------------+

I deleted id 4 and all is well now.  Wow.  Thanks a million (I never would have
figured that one out).  :-)

...dave

-- 
Dave Alden
The Ohio State University
Department of Mathematics