'Bulk Update' not working?

Hi,
I’m playing around with 3.5.7, and I can’t seem to get the 'Bulk Update’
feature to work. I selected a bunch of tickets (status=‘new’ and
Owner=‘Nobody’), clicked on ‘Bulk Update’, and then tried to change the
status to Deleted. It acks like everything is going well, then it reloads
the same ‘Bulk Update’ page (and there were no changes to the their status).
Help?
…dave

Dave Alden
The Ohio State University
Department of Mathematics

Dave Alden said the following on 1/21/2006 10:23 PM:

Hi,
I’m playing around with 3.5.7, and I can’t seem to get the ‘Bulk Update’
feature to work. I selected a bunch of tickets (status=‘new’ and
Owner=‘Nobody’), clicked on ‘Bulk Update’, and then tried to change the
status to Deleted. It acks like everything is going well, then it reloads
the same ‘Bulk Update’ page (and there were no changes to the their status).
Help?
…dave

For grins…

Are you running MySQL?

If so, have you upgraded it lately? I had this same trouble after doing
a point-upgrade, and had to run a utility called
mysql_fix_privilege_tables (I had logged into phpMySQL and it gave me an
error that said “Hey–you need to run this utility!”–you might want to
check into that.)

Best,
–Glenn

“They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety.”
~Benjamin Franklin, Historical Review of Pennsylvania, 1759

Hi,

For grins…

Are you running MySQL?

Yes.

If so, have you upgraded it lately? I had this same trouble after doing
a point-upgrade, and had to run a utility called
mysql_fix_privilege_tables (I had logged into phpMySQL and it gave me an
error that said “Hey–you need to run this utility!”–you might want to
check into that.)

I haven’t upgraded lately, but I tried it anyway. It didn’t make any
difference.

…dave

Dave Alden
The Ohio State University
Department of Mathematics

I tried that, too after seeing your first email … And that didn’t work.
I’ve only had this problem with 3.5.x – never with 3.4. But if I initiate
a new query and form an advanced query by hand (or cut-n-paste a previous
query, but it MUST be a new/blank advanced query to start) such that the
FORMAT window is empty, it works just fine. Dave – can you see if that
works for you?

-=| BenFrom: rt-devel-bounces@lists.bestpractical.com

[mailto:rt-devel-bounces@lists.bestpractical.com] On Behalf Of Glenn Sieb
Sent: Sunday, January 22, 2006 1:21 AM
To: Dave Alden
Cc: rt-devel@lists.bestpractical.com
Subject: Re: [Rt-devel] ‘Bulk Update’ not working?

Dave Alden said the following on 1/21/2006 10:23 PM:

Hi,
I’m playing around with 3.5.7, and I can’t seem to get the ‘Bulk Update’
feature to work. I selected a bunch of tickets (status=‘new’ and
Owner=‘Nobody’), clicked on ‘Bulk Update’, and then tried to change
the status to Deleted. It acks like everything is going well, then it
reloads the same ‘Bulk Update’ page (and there were no changes to the
their status).
Help?
…dave

For grins…

Are you running MySQL?

If so, have you upgraded it lately? I had this same trouble after doing a
point-upgrade, and had to run a utility called mysql_fix_privilege_tables (I
had logged into phpMySQL and it gave me an error that said “Hey–you need to
run this utility!”–you might want to check into that.)

Best,
–Glenn

“They that can give up essential liberty to obtain a little temporary safety
deserve neither liberty nor safety.”
~Benjamin Franklin, Historical Review of Pennsylvania, 1759
Rt-devel mailing list
Rt-devel@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Hi,On Tue, Jan 24, 2006 at 07:09:39AM -0500, Ben Goodwin wrote:

I tried that, too after seeing your first email … And that didn’t work.
I’ve only had this problem with 3.5.x – never with 3.4. But if I initiate
a new query and form an advanced query by hand (or cut-n-paste a previous
query, but it MUST be a new/blank advanced query to start) such that the
FORMAT window is empty, it works just fine. Dave – can you see if that
works for you?

Let me make sure I understand. First I select “Tickets”, then “New Search”,
then “Advanced”, then I type something like “Owner = ‘alden’” in the top
window and select “Apply”, then “Bulk Update” and try to do my bulk update?
If so, this didn’t make any difference. :frowning:

…dave

Dave Alden
The Ohio State University
Department of Mathematics

Yes, that’s what I meant. When you click “Advanced”, are both boxes
completely empty?

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.

I’ve had to delete any results (DELETE FROM Attributes WHERE id = ‘xxx’:wink: to
regain some functionality … I’m curious what prefs if you have, if any.

(I’m removing Glenn from the Cc list in case he doesn’t want all this spam
:slight_smile:

-=| BenFrom: Dave Alden [mailto:alden@math.ohio-state.edu] 

Sent: Tuesday, January 24, 2006 7:53 AM
To: Ben Goodwin
Cc: ‘Glenn Sieb’; rt-devel@lists.bestpractical.com
Subject: Re: [Rt-devel] ‘Bulk Update’ not working?

Hi,

Hi,

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). :slight_smile:

…dave

Dave Alden
The Ohio State University
Department of Mathematics

Really? What on earth? I have a Pref-SummaryRows and it works for me.
Ther’es definitely something strange going on here WRT the Attributes
stuff…

-=| Ben

Ben Goodwin said the following on 1/24/2006 11:35 AM:

(I’m removing Glenn from the Cc list in case he doesn’t want all this spam
:slight_smile:

Nah–I’m subbed to the list, so I see it all anyway (grin). Just call me
old-fashioned that way… all these newfangled (makes quote-sign with
fingers) “archives” (makes quote-sign with fingers). I swear. You kids
don’t know how good you have it. I remember the days when we had to
download our BBS topics from BBS’, over 2400bps modems, and had to use
external readers to handle it all. Filters of subject lines you were
interested in seeing, etc. shakes head I tell ya… this Internet thing
is just a fad. A fad I tell you!

(grin)

Best,
–Glenn
“They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety.”
~Benjamin Franklin, Historical Review of Pennsylvania, 1759