The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
MySQL Error 1053 / How to change a RAND() function db query
EDIT: See post#7 for solution.
Need help on a database query that is causing my host to kill off the process for taking too much CPU time. In debugging mode, I have a vbgarage template "vbgarage_latestbits" that is causing me all kinds of problems. It takes 4 - 6 second on average to process because it runs a db query that is calling for SELECT * FROM vbgarage_images ORDER BY RAND() LIMIT 5. There are 533 rows, so this is slowing my site down severely and causing an occasional database error when server loads are high. As it's trying to pull of a random set of pictures from 138 different garages. Well, since I can't find "ORDER BY RAND() LIMIT 5" in any of my garage templates or vbgarage.php file. It doesn't come up in my CMPS index.php and the page generates in about 1 second. How is the best way to rectify this problem. And is there a workaround where I can run execute a SQL query to change that RAND() or something I can do to the table itself in phpmyadmin? This is the error I get whenever server loads are high. Code:
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 This is becoming an annoying problem for me. Any help would greatly appreciated. I already attempted to contact the coder to no avail. However, this thread made me wonder if there is a work around. Because I have dedicated link to it on my navbar. I have no idea why this is running the RAND() query when I don't have the images displaying on my FORUMHOME or navbar templates. Thanks. __________________ |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|