Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions

Reply
 
Thread Tools Display Modes
  #11  
Old 03-06-2018, 04:08 AM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have attached a "first draft" of the product. Please give this a try and let me know of any changes you would like.
Attached Files
File Type: xml product-markflrecentpostsblock.xml (14.5 KB, 7 views)
Reply With Quote
  #12  
Old 03-06-2018, 01:50 PM
scottkoz20 scottkoz20 is offline
 
Join Date: Dec 2015
Location: Lewiston, NY
Posts: 344
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarkFL View Post
I have attached a "first draft" of the product. Please give this a try and let me know of any changes you would like.
hey Mark -

When I enable this, my Forumhome triggers this SQL error - the rest of the forum is fine.

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:

		SELECT post.*, thread.title, thread.forumid, thread.prefixid, thread.iconid, thread.postuserid, thread.dateline AS t_dateline, thread.pollid, thread.sticky, user.*, icon.iconpath, icon.title AS icon_title
		FROM post AS post
		INNER JOIN thread AS thread
		ON thread.threadid = post.threadid
		INNER JOIN user AS user
		ON user.userid = post.userid
		LEFT JOIN icon AS icon
		ON icon.iconid = thread.iconid
		LEFT JOIN phrase AS phrase
		ON phrase.varname = CONCAT('prefix_', thread.prefixid, '_title_rich')
		WHERE post.visible = 1
		ORDER BY post.dateline DESC;

MySQL Error   : Incorrect key file for table '/tmp/#sql_24f2_2.MYI'; try to repair it
Error Number  : 126
Request Date  : Tuesday, March 6th 2018 @ 09:42:49 AM
Error Date    : Tuesday, March 6th 2018 @ 09:43:55 AM
Script        : http://www.sportscardforum.com/forum.php
Referrer      : https://www.sportscardforum.com/admincp/index.php?do=head
IP Address    : 74.77.177.253
Username      : scottkoz20
Classname     : vB_Database_MySQLi
MySQL Version : 5.6.38
I have it off at the moment - I need to rebuild my dev site this week as I blew it up (had to try this live :erm: )
Reply With Quote
  #13  
Old 03-06-2018, 02:18 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ah, I didn't take into account running this query on a large database. I have put a limit on the query...try this updated version please.
Attached Files
File Type: xml product-markflrecentpostsblock.xml (15.0 KB, 2 views)
Reply With Quote
  #14  
Old 03-06-2018, 02:32 PM
scottkoz20 scottkoz20 is offline
 
Join Date: Dec 2015
Location: Lewiston, NY
Posts: 344
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

same error

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:

		SELECT post.*, thread.title, thread.forumid, thread.prefixid, thread.iconid, thread.postuserid, thread.dateline AS t_dateline, thread.pollid, thread.sticky, user.*, icon.iconpath, icon.title AS icon_title
		FROM post AS post
		INNER JOIN thread AS thread
		ON thread.threadid = post.threadid
		INNER JOIN user AS user
		ON user.userid = post.userid
		LEFT JOIN icon AS icon
		ON icon.iconid = thread.iconid
		LEFT JOIN phrase AS phrase
		ON phrase.varname = CONCAT('prefix_', thread.prefixid, '_title_rich')
		WHERE post.visible = 1
		ORDER BY post.dateline DESC
		LIMIT 10;

MySQL Error   : Incorrect key file for table '/tmp/#sql_24f2_2.MYI'; try to repair it
Error Number  : 126
Request Date  : Tuesday, March 6th 2018 @ 10:23:52 AM
Error Date    : Tuesday, March 6th 2018 @ 10:25:35 AM
Script        : http://www.sportscardforum.com/forum.php
Referrer      : https://www.sportscardforum.com/admincp/index.php?do=head
IP Address    : 74.77.177.253
Username      : scottkoz20
Classname     : vB_Database_MySQLi
MySQL Version : 5.6.38
--------------- Added [DATE]1520354018[/DATE] at [TIME]1520354018[/TIME] ---------------

i wonder if the issue is on my /tmp directory
Reply With Quote
  #15  
Old 03-06-2018, 02:37 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #16  
Old 03-06-2018, 02:45 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks like OP needs to run a repair & optimize query against his database.
Reply With Quote
Благодарность от:
MarkFL
  #17  
Old 03-06-2018, 02:58 PM
scottkoz20 scottkoz20 is offline
 
Join Date: Dec 2015
Location: Lewiston, NY
Posts: 344
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 03-06-2018, 03:39 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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)
Reply With Quote
  #19  
Old 03-06-2018, 04:30 PM
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Location: Riverside, California USA
Posts: 1,080
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Where exactly is this supposed to display and what does it look like ? lol ...
Reply With Quote
  #20  
Old 03-06-2018, 04:42 PM
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Location: St. Augustine, FL
Posts: 3,853
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes

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


All times are GMT. The time now is 05:06 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05525 seconds
  • Memory Usage 2,289KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (10)post_thanks_box
  • (1)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (4)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete