Thread: SQL Query issue
View Single Post
  #1  
Old 01-09-2010, 03:54 PM
j3st3r's Avatar
j3st3r j3st3r is offline
Green Plog
 
Join Date: Oct 2008
Posts: 3
Gallery: 0
Comments: 0
Default SQL Query issue

Well since I cant seem to post in the pro section I will try here...

I have PhotoPlog Pro v.2.1.4.8 and received and email from my hosting company stating:

We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:

SELECT f1.userid, f1.fileid, f1.filename, f1.title
FROM photoplog_fileuploads AS f1
LEFT JOIN photoplog_fileuploads AS f2
ON (f2.userid = f1.userid AND f2.fileid > f1.fileid)
WHERE 1=1

AND f2.fileid IS NULL
AND f1.userid IN
(1,2,3,4,6,221,8,9,21,14,10,11,224,13,15,16,17,18, 20,22,23,25,235,238,31,86,89,99,
125,113,249,120,123,259,117,118,122,128,129,130,13 8,141,253,150,149,263,154,157,258,159,243,173,
171,242,167,166,239,209,206,241,210,203,244,214,20 8,211,213,218,216,217,230,228)
AND f1.catid NOT IN (0)
AND f1.moderate = 0

This query examines 2579099 rows, which is unacceptable in shared hosting.

How do I go about correcting this issue....or where do I go to find this query
Reply With Quote