Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #16  
Old 06 Mar 2018, 16:45
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Looks like OP needs to run a repair & optimize query against his database.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #17  
Old 06 Mar 2018, 16:58
scottkoz20 scottkoz20 is offline
 
Join Date: Jan 2016
Real name: Scott
Originally Posted by MarkFL View Post
Hmm...I have never encountered that error before, and doing a search led me to believe it was due to a disk space issue on your server as a result of a query on all your posts. So, I figured limiting the query would cure it.
is it possible to limit the query to the last day (24 hours)

In the meantime, I am working on table optimization and checking space issue on /tmp on my server
Reply With Quote
  #18  
Old 06 Mar 2018, 17:39
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Originally Posted by scottkoz20 View Post
is it possible to limit the query to the last day (24 hours)

In the meantime, I am working on table optimization and checking space issue on /tmp on my server
I've added an optional "Hours Limit" setting that will allow you to select posts made only during the last x hours.
Attached Files
File Type: xml product-markflrecentpostsblock.xml (15.6 KB, 2 views)
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #19  
Old 06 Mar 2018, 18:30
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Where exactly is this supposed to display and what does it look like ? lol ...
Reply With Quote
  #20  
Old 06 Mar 2018, 18:42
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Originally Posted by CAG CheechDogg View Post
Where exactly is this supposed to display and what does it look like ? lol ...
It displays on the index script (home) as well as other selected scripts, a block containing links to the most recent posts. Here's a screenshot from my local dev site:

Attached Images
File Type: jpg markfl_rpb.jpg (46.4 KB, 29 views)
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #21  
Old 06 Mar 2018, 18:57
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Weird ... for me it only shows the tittle
Attached Images
File Type: jpg recent-posts.jpg (66.2 KB, 10 views)
Reply With Quote
  #22  
Old 06 Mar 2018, 19:04
scottkoz20 scottkoz20 is offline
 
Join Date: Jan 2016
Real name: Scott
Mark -

Well, I got past the SQL errors (the time seemed to help as optimization is still going )


However, I get no posts when I enable the modification
Attached Images
File Type: jpg 1.jpg (12.8 KB, 9 views)
File Type: png 2.PNG (61.3 KB, 4 views)
Reply With Quote
  #23  
Old 06 Mar 2018, 19:08
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Scott, it looks like you have the block collapsed?
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #24  
Old 06 Mar 2018, 19:09
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Originally Posted by scottkoz20 View Post
Mark -

Well, I got past the SQL errors (the time seemed to help as optimization is still going )


However, I get no posts when I enable the modification
Exactly what I got too ...

--------------- Added 06 Mar 2018 at 19:10 ---------------

Originally Posted by MarkFL View Post
Scott, it looks like you have the block collapsed?
I don't have it collapsed myself and it still doesn't show
Reply With Quote
  #25  
Old 06 Mar 2018, 19:12
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Originally Posted by CAG CheechDogg View Post
Exactly what I got too ...

--------------- Added 06 Mar 2018 at 19:10 ---------------



I don't have it collapsed myself and it still doesn't show
Can I get a link to your site, so I can inspect the DOM?
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #26  
Old 06 Mar 2018, 19:13
scottkoz20 scottkoz20 is offline
 
Join Date: Jan 2016
Real name: Scott
does the samething as what CAG is seeing -

I'll PM you with my site info
Reply With Quote
  #27  
Old 06 Mar 2018, 19:16
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Here it is ..

https://www.cagclan.com/community/forum.php
Reply With Quote
  #28  
Old 06 Mar 2018, 19:30
scottkoz20 scottkoz20 is offline
 
Join Date: Jan 2016
Real name: Scott
Ok Mark - what did you do?
Attached Images
File Type: jpg 3.jpg (46.6 KB, 12 views)
Reply With Quote
  #29  
Old 06 Mar 2018, 19:34
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
I had a variable used from another addon, which wasn't aan issue for me, but was for everyone else.

Scott, I have updated your site with the latest update, and for everyone else, I attach it here.
Attached Files
File Type: xml product-markflrecentpostsblock.xml (15.6 KB, 3 views)
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #30  
Old 06 Mar 2018, 19:40
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Good stuff Mark .. as always good stuff !!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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


New To Site? Need Help?

All times are GMT. The time now is 01:57.

Layout Options | Width: Wide Color: