SQL Query issue

[j3st3r]

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

[Morgan]

The query is in the PhotoPlog memberlist.php file. It is hard to think that the query is examining over 2.57+ million rows. Run this query and it'll tell you how many rows are being examined:

Content visible to registered users only.

Please report back the full results of the above query.

[j3st3r]

Content visible to registered users only.

[Morgan]

Thanks, but that looks like the output from the query itself. The query you need to run is this one:

Content visible to registered users only.

It should produce a table with the following results:

Content visible to registered users only.

[j3st3r]

Content visible to registered users only.

[Morgan]

In the rows column you have 3407 plus 757 for a total of 4164 rows.

Content visible to registered users only.

So it would seem that the query is not examining 2579099 rows, but you can undo the PhotoPlog memberlist stuff if you want to be rid of the query anyway.