[USAMustangs.com]

Originally Posted by USAMustangs.com

It would really nice if someone could tell me where and how to change the RAND() value because my host is killing off the process half the time I refresh my forum index because it is using too much CPU time to process the queries to get random pictures out of 138 garages. Nobody has an idea? I like the mod, but I can't keep it on my site with this happen so frequently. I'm sure it's just a simple modification of the RAND() code to fix it. This value is not found in any of the vbgarage templates or my vbgarage.php file. Is there a way to go into phpmyadmin and correct this where it doesn't call for random pictures? Or run Execute an SQL Query in AdminCP to correct this issue? The ORDER BY RAND() is causing me a lot of problems. I need it to be changed to use less processing time. It takes 5 - 6 second to run this query and half the time my host is killing off the process.

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT * FROM vbgarage_images ORDER BY RAND() LIMIT 5;

MySQL Error  : Server shutdown in progress
Error Number : 1053
Date         : Tuesday, May 18th 2010 @ 12:03:03 PM
Script       : http://www.usamustangs.com/forum/index.php
Referrer     : http://www.usamustangs.com/forum/private.php?folderid=0
IP Address   : 71.xxx.xxx.xx
Username     : Me
Classname    : vB_Database

Problem solved! If anyone is experiencing the same problem, the fix can be found here. https://vborg.vbsupport.ru/showthread.php?t=242869