Register Members List Search Today's Posts Mark Forums Read

 
 
Mod Options
  #1  
Old 27 Oct 2008, 10:16
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Arcade query causing database lockups

SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM user AS user LEFT
JOIN avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=238420 OR user.userid=238420;
is grinding our database to a halt.
Is there any way to stop all avatar activity, or have I got to uninstall the arcade?
__________________
AVForums.com the UK's largest audio visual home consumer electronics forums. Running several hacks with thanks to vBulletin.org and its members.
Comments
  #2  
Old 27 Oct 2008, 21:15
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Real name: Marcel
if you have at least mySQL 4.1:

open /arcade/functions/dbclass.php

search for
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

and replace it with


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This should help (and is included in next v2.6.8+)
__________________
Get the most installed modification for your vBulletin (more than 8400 installations and 144.000 downloads!):
ibProArcade 2.7.2+ download here | Click here to enter the ibProArcade-Support-Section
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 18:54.

Layout Options | Width: Wide Color: