PhotoPlog

Go Back   PhotoPlog > PhotoPlog Lite > Troubleshooting & Problems
Screens Demo Purchase Download Register

Reply
Attention: Last reply in this thread was more than 7 Years ago
 
Thread Tools
  #1  
Old 01-09-2010, 04: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
  #2  
Old 01-10-2010, 06:40 PM
Morgan's Avatar
Morgan Morgan is offline
Head Plog
Admin
 
Join Date: Dec 2005
Posts: 5,324
Gallery: 10
Comments: 25
Default

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:
Code:
Content visible to registered users only.
Please report back the full results of the above query.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #3  
Old 01-11-2010, 04:40 AM
j3st3r's Avatar
j3st3r j3st3r is offline
Green Plog
 
Join Date: Oct 2008
Posts: 3
Gallery: 0
Comments: 0
Default

Code:
Content visible to registered users only.
Reply With Quote
  #4  
Old 01-11-2010, 10:26 PM
Morgan's Avatar
Morgan Morgan is offline
Head Plog
Admin
 
Join Date: Dec 2005
Posts: 5,324
Gallery: 10
Comments: 25
Default

Thanks, but that looks like the output from the query itself. The query you need to run is this one:
Code:
Content visible to registered users only.
It should produce a table with the following results:
Code:
Content visible to registered users only.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #5  
Old 01-12-2010, 03:54 AM
j3st3r's Avatar
j3st3r j3st3r is offline
Green Plog
 
Join Date: Oct 2008
Posts: 3
Gallery: 0
Comments: 0
Default

Code:
Content visible to registered users only.
Reply With Quote
  #6  
Old 01-15-2010, 03:58 AM
Morgan's Avatar
Morgan Morgan is offline
Head Plog
Admin
 
Join Date: Dec 2005
Posts: 5,324
Gallery: 10
Comments: 25
Default

In the rows column you have 3407 plus 757 for a total of 4164 rows.
Code:
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.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
what sql statement do I use... luker Miscellaneous Foobar 3 06-20-2007 08:01 AM


All times are GMT. The time now is 07:29 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.