vb.org Archive - View Single Post - Show Thread Enhancements

ForceHSS · #**2825** 08-09-2012, 01:21 PM

Quote:

Originally Posted by tricksodave

@ForceHSS

A few members have now reported when they click on Find all thanked posts by: We end up with a database error, see below.

Dave

PHP Code:


			
Database error in vBulletin 4.2.0:



Invalid SQL:



            REPLACE INTO vbsearch (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)

            VALUES (2, '192.109.140.134', 1, 'Disco_Dave', '', 'post.dateline', 'DESC', 0.01743, 1, '54231,54219,54172,54098,54084,54083,53994,53915,53767,53718,53597,53548,53339,53319,53193,53169,52896,52503,52497,52485,52459,52453,52385,52144,51968,51939,51630,51620,51612,51610,51569,51542,51304,51160,51159,37103,37053,37000,36962,36912,36902,36861,35942,35817,35526,35515,35368,34461,34162,33611,33608,33501,33313,33133,33105,32888,32425,31765,31721,31348,31096,31092,30836,30830,30816,30743,30724,30162,30160,30126,30125,30095,30085,29910,29668,29626,29465,29403,29364,29319,29221,29218,29217,29025,29003,28998,28959,28821,28730,28591,27530,26800,25993,25858,25769,23399,23330,22925,22737,22380,21937,21729,21413,21388,21320,21300,20813,20542,20512,20220,20169,20055,20019,19994,19763,19367,19232,19176,19151,19112,19104,18168,17921,17650,17551,17425,17424,16637,16409,16370,16136,15310,15140,14339,14330,13424,13408,13107,13081,11795,11749,11743,11421,10670,10200,10094,9768,9128,9119,9118,9111,9057,8994,8598,8565,8483,8173,7792,7138,6985,6925,6445,6440,5876,5808,5315,5312,5290,5158,4699,4529,4134,4075,3923,3891,3853,3431,3120,2829,2749,2273,2241,1548,1426,356,353,351,350', 1344499191, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:2;s:10:\"Disco_Dave\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', '28ee937b1b4bc2f17f88e466108be8ec');



MySQL Error   : Table 'nirc_xxxxxx.vbsearch' doesn't exist

Error Number  : 1146

Request Date  : Thursday, August 9th 2012 @ 02:59:51 AM

Error Date    : Thursday, August 9th 2012 @ 02:59:51 AM

Script        : http://www.nirc.co.uk/forums/post_thanks.php?do=findthanks_user_gave&u=2

Referrer      : http://www.nirc.co.uk/forums/member.php?2-Disco_Dave

IP Address    : xxxxxxxxxxxxx

Username      : Disco_Dave

Use the one in my sig with search fix

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01190 seconds Memory Usage 1,793KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php (1)bbcode_quote (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_box_bit (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post 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 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 postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages:

Благодарность от:
Disco_Dave