[fixed] Mass User Prune SQL Error

[jdearing]

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: SELECT userid,username FROM user WHERE userid IN() LIMIT 0,50 mysql error: You have an error in your SQL syntax near ') LIMIT 0,50' at line 1

mysql error number: 1064

Date: Thursday 29th of August 2002 03:47:23 PM
Script: http://www.stlracing.com/forums/forums/admin/user.php?action=prune_updateposts&startat=0
Referer: http://www.stlracing.com/forums/admin/



I see the error message has the wrong path for the user.php file.

My "VBULLETIN OPTIONS", "GENERAL SETTINGS" has http://www.stlracing.com/forums for URL & http://www.stlracing.com for Homepage.

I don't get any errors doing anything else...

[jdearing]

anybody?

[Steve Machol]

I don't mass prune users so it's hard to test this. I suggest you try reuploading the user.php file from the 2.2.7 zip file. Make sure you overwrite the one on the server.

[isman]

I had the same problem. When pruning a bunch of 0 post users and got the exact same error.

Is this a bug that needs to be addressed?

[Steve Machol]

Did you reupload the original user.php?

[jdearing]

yes and that didn't help....

I can still delete single users and do other things with user accounts.

I just get this error trying to do mass deletes, even if it is just 2 accounts at the same time.

[Steve Machol]

Confirmed in my unhacked 2.2.7 test forum. Moving to Bugs.

[Scott MacVicar]

Wierd.

REPLACE INTO isn't working correctly for the storetext function, though title is a primary key so it should overwrite the row if the title is the same, which it is...

[John]

Scott did the index changes I suggested help this one?

[Scott MacVicar]

yes they did but you add to include the IGNORE

[Scott MacVicar]

Fix:

ALTER IGNORE TABLE adminutil DROP INDEX title, ADD PRIMARY KEY (title);

run this sql query to sort the problem.

[Paul]

Is the SQL the only fix necessary? Are there any changes to the php that need to be made?

Thanks,
Paul

[Scott MacVicar]

yep only the sql query is needed, the file was modified but no one checked to make sure the title was a primary key so the REPLACE INTO query never worked.

[jucs]

I get no MYSQL errors and yet mass prune of users DOES NOT work, period.

It just ACTS like it works, but the users are still there.

Also, the # of users does not decrease no matter what I do.

This software has been running fine UNTIL version 2.2.7 upgrade.

Can someone PLEASE fix this. I keep getting pointed to this thread and it is NOT the same error (I Get NO error).

I am getting pretty frustrated.

[Steve Machol]

Did you apply the fix in this thread? If so, then your problem is a different one and you should submit a support ticket on it.

[jucs]

Removed because it was unfair....:)

[jucs]

Originally posted by PPN
Fix:

ALTER IGNORE TABLE adminutil DROP INDEX title, ADD PRIMARY KEY (title);

run this sql query to sort the problem.


Could you explain what this means a bit more? Where and how do I run this "query"?

Thanks.

[Freddie Bingham]

Originally posted by jucs
Putting in a support ticket, in my experiences, is about useless. I've never gotten good support through that route! Please post the ticket ids of the unaswered questions so that we may look into your support history and see what the problem(s) were.

[jucs]

Can I have a better explanation first?

Do I need to install phpmyadmin and then simply run this as a query?

[jucs]

Originally posted by freddie
Please post the ticket ids of the unaswered questions so that we may look into your support history and see what the problem(s) were.

See above. ;)

[Steve Machol]

Originally posted by jucs
Do I need to install phpmyadmin and then simply run this as a query? Yes.