The Arcive of Official vBulletin Modifications Site.

TECK · #**621** 10-14-2008, 04:01 AM

It is very easy to see if Sphinx indexed your posts, from console:

Code:

$ search "post title or content here" --config /etc/sphinx.conf

If it returns results, you know Sphinx is not the culprit.

Spinball · #**622** 10-14-2008, 08:35 AM

From admin CP, find a user, from the drop-down menu near the top for that user, do 'find posts by user' and you get

Quote:

Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829

Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829

--------------- Added [DATE]1223994206[/DATE] at [TIME]1223994206[/TIME] ---------------

I am also getting a couple of database errors per minute which look like this:

Quote:

Database error in vBulletin 3.7.2:

Invalid SQL:

INSERT INTO search
(userid, titleonly, ipaddress, personal, query, searchuser, forumchoice, /*prefixchoice,*/ sortby, sortorder, searchtime, showposts, orderedids, dateline, searchterms, displayterms, searchhash, completed)
VALUES
(199144,
0,
'82.45.64.35',
1,
'',
'',
'',
'post.dateline',
'DESC',
0.41381, 1,
'7910162,7909683,7901421,7897556,7897435,7893091,7 891793,7891237,7890849,7890831,7890681,7883569,788 3453,7883405,7879058,7879034,7878857,7878747,78787 01,7873052,7873025,7872710,7872139,7870002,7869307 ,7865412,7865397,7858431,7855677,7854580,7854561,7 854552,7850714,7850693,7849703,7849688,7849004,784 8755,7848736,7848689,7841987,7841959,7841885,78413 84,7841345,7834603,7833936,7833119,7832472,7832123 ,7832111,7827946,7827737,7825843,7825294,7825061,7 824531,7824480,7824437,7822528,7820735,7818312,781 3687,7813676,7810657,7805266,7805174,7805125,78024 52,7793552,7789673,7786793,7786728,7786477,7782994 ,7782960,7781194,7778313,7773823,7773802,7772909,7 772858,7772774,7771517,7769068,7768999,7768966,776 5669,7764148,7764145,7764140,7764128,7764121,77641 14,7764111,7758989,7758968,7749807,7743705,7737046 ,7736969,7732475,7731262,7731233,7731188,7726538,7 726485,7720900,7720785,7720776,7720637,7720591,772 0531,7720440,7720289,7711014,7710978,7708282,77080 17,7707792,7701848,7701797,7698239!
,7698089,7694948,7694687,7694620,7694595,7694518,7 694495,7688325,7688277,7687918,7687759,7687660,768 7625,7684177,7676849,7671353,7660707,7657314,76560 13,7655765,7652852,7647751,7647741,7647460,7647453 ,7647396,7645990,7644340,7642598,7642102,7642011,7 641985,7639370,7639367,7638532,7635655,7635552,763 0940,7629198,7628772,7627899,7627725,7626677,76258 96,7625789,7625778,7623074,7623051,7618844,7618819 ,7618798,7618753,7618718,7615635,7614744,7613102,7 611940,7611906,7609673,7609187,7608659,7607236,760 6473,7605869,7605585,7605558,7605534,7605440,75980 45,7598029,7597878,7597560,7597466,7597393,7595869 ,7595668,7593681,7591317,7589223,7589076,7589063,7 589047,7589030,7588341,7587985,7587606,7586505,758 1381,7581368,7581226,7580732,7580720,7580687,75806 78,7580628,7580580,7574523,7573417,7573332,7573302 ,7570499,7570479,7570475,7570404,7566942,7566921,7 562532,7562417,7562406,7562310,7562212,7561992,756 1600,7561591,7561275,7561232,7561209,7561098,75607 16,7560686,7560315,7559990,7559864,755!
9818,7559679,7559664,7559637,7559531,7552998,75513 79,7550063,7549983,7
549968,7549938,7542743,7542408,7541111,7541097,754 1084,7540205,7540199,7540152,7539856,7539838,75398 02,7539754,7529899,7529880,7529867,7529514,7529478 ,7529415,7529341,7529310,7529249,7529241,7529231,7 528448,7526898,7520976,7520378,7520366,7519948,751 9917,7517303,7517259,7516412,7514267,7513816,75121 22,7511965,7506440,7506431,7506429,7506361,7506348 ,7498172,7498144,7497922,7497541,7497510,7497479,7 495560,7495546,7492065,7491901,7491881,7491869,748 6804,7486783,7486768,7486720,7484166,7484157,74835 47,7483525,7483439,7483430,7482868,7482845,7482831 ,7480220,7480186,7480169,7478760,7476151,7475535,7 475530,7473277,7473249,7473017,7472970,7472940,747 2927,7472913,7472906,7472901,7472893,7461283,74599 90,7459938,7459905,7450408,7448863,7445663,7445648 ,7445616,7445587,7445523,7445087,7445047,7445035,7 444995,7444974,7444963,7444946,7443716,7443704,744 3157,7443134,7442854,7441626,7441502,7439405,74390 61,7439056,7438995,7433513,7433466,7433449,7433438 ,7433420,7430835,7430827,7430812,743076!
2,7430750,7430646,7428899,7426674,7426379,7425996, 7424770,7424739,7424727,7423765,7423747,7423731,74 23676,7423671,7423664,7418334,7418322,7418311,7418 208,7418196,7414469,7414431,7414416,7404690,740464 6,7404622,7404599,7404485,7404448,7402360,7402340, 7402219,7401855,7401838,7401829,7401820,7401818,74 01804,7401790,7401772,7401761,7401752,7401085,7398 252,7398246,7398027,7397717,7395856,7395842,739569 4,7395676,7395675,7395635,7395580,7395564,7391565, 7385480,7385460,7384731,7384632,7384584,7384529,73 84500,7384486,7384475,7382921,7378980,7378900,7378 058,7377876,7370600,7370470,7370438,7368364,736833 9,7368298,7366974,7366863,7366852,7363126,7363116, 7363104,7363096,7363056,7363048,7363047,7363040,73 63033,7361440,7361420,7359385,7357792,7357784,7356 178,7356104,7355478,7355242,7355214,7353450,735122 1,7351183,7351169,7351154,7351093,7351059,7350646, 7350602,7350565,7347493,7345110,7344986,7344941,73 44921,7344901,7343615,7343606,7337949,7337926,7337 907,7337823,7337783',
1223993854,
'a:25:{s:5:\"query\";N;s:10:\"searchuser\";N;s:9:\ "exactname\";N;s:11:\"starteronly\";i:0;s:3:\"tag\ ";N;s:11:\"forumchoice\";a:0:{}s:12:\"prefixchoice \";N;s:11:\"childforums\";i:0;s:9:\"titleonly\";b: 0;s:9:\"showposts\";b:1;s:10:\"searchdate\";N;s:11 :\"beforeafter\";N;s:6:\"sortby\";N;s:9:\"sortorde r\";N;s:9:\"replyless\";N;s:10:\"replylimit\";N;s: 14:\"searchthreadid\";i:0;s:9:\"saveprefs\";N;s:11 :\"quicksearch\";N;s:10:\"searchtype\";i:1;s:7:\"e xclude\";N;s:7:\"nocache\";N;s:4:\"ajax\";i:0;s:11 :\"humanverify\";N;s:6:\"userid\";i:199144;}',
'a:8:{s:5:\"words\";a:1:{i:0;N;}s:9:\"highlight\"; a:1:{i:0;s:0:\"\";}s:6:\"common\";a:0:{}s:5:\"user s\";a:1:{i:199144;s:6:\"Yemeth\";}s:6:\"forums\";a :0:{}s:8:\"prefixes\";a:0:{}s:3:\"tag\";s:0:\"\";s :7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11: \"childforums\";i:0;s:6:\"action\";s:7:\"process\" ;}}',
'2ebb9cb46ee5005c200207e9e3343161',
1)
### SAVE ORDERED IDS TO SEARCH CACHE ###;

MySQL Error : Duplicate entry '2ebb9cb46ee5005c200207e9e3343161-post.dateline-DESC' for key 2
Error Number : 1062
Request Date : Tuesday, October 14th 2008 @ 03:17:33 PM
Error Date : Tuesday, October 14th 2008 @ 03:17:34 PM
Script : http://www.avforums.com/forums/searc...duser&u=199144
Referrer : http://www.avforums.com/forums/xbox-...-oct-08-a.html
IP Address : 82.45.64.35
Username : Yemeth
Classname : vB_Database_Slave
MySQL Version :

--------------- Added [DATE]1224000005[/DATE] at [TIME]1224000005[/TIME] ---------------

Looks like the code is doing an insert onto the slave server causing the duplicate record error. Is this a bug in the code?
This is very urgent as we are having several database errors per minute.

--------------- Added [DATE]1224007861[/DATE] at [TIME]1224007861[/TIME] ---------------

There is also an error when running this:
http://www.avforums.com/forums/searc...duser&userid=1
(the my posts link in the menu)
which gives

Quote:

Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829

Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829

Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829

Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829

Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829

Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829

snakes1100 · #**623** 10-14-2008, 08:13 PM

@spinball
are you using the plugin version of the hack or the older manually edited version?

ive not seen this issue and i run sphynx on a few servers/sites, ive not seen this issue yet.

Spinball · #**624** 10-16-2008, 06:38 AM

Quote:

Originally Posted by snakes1100

@spinball
are you using the plugin version of the hack or the older manually edited version?

ive not seen this issue and i run sphynx on a few servers/sites, ive not seen this issue yet.

The plugin as per the updated instructions in the first post in this thread.

I changed the INSERT back to a REPLACE in the search_sphinx.php script which stopped the database errors, and I put error_reporting(0); as the first line in includes/search_functions.php to kill the error messages, but there are still other anomalies, and I think I'm going to have to offer someone $ to fix this properly for us.

Lizard King · #**625** 10-16-2008, 01:16 PM

Quote:

Originally Posted by Spinball

The plugin as per the updated instructions in the first post in this thread.

I changed the INSERT back to a REPLACE in the search_sphinx.php script which stopped the database errors, and I put error_reporting(0); as the first line in includes/search_functions.php to kill the error messages, but there are still other anomalies, and I think I'm going to have to offer someone $ to fix this properly for us.

I may suggest you to contact Teck privately. His sphinx script is working flawlesly on lots of sites.

Spinball · #**626** 10-16-2008, 07:52 PM

Quote:

Originally Posted by Lizard King

I may suggest you to contact Teck privately. His sphinx script is working flawlesly on lots of sites.

Will do, thanks

kerplunknet · #**627** 10-23-2008, 02:14 AM

Has anyone figured out the "Find More Posts by UsernameHere" issue? It results in these error messages, but the results seem to work properly:

PHP Code:


			
Warning: strpos() [function.strpos]: Empty delimiter. in /includes/functions_search.html on line 868

Warning: strpos() [function.strpos]: Empty delimiter. in /includes/functions_search.html on line 868

Warning: strpos() [function.strpos]: Empty delimiter. in /includes/functions_search.html on line 868

Warning: strpos() [function.strpos]: Empty delimiter. in /includes/functions_search.html on line 868

Warning: strpos() [function.strpos]: Empty delimiter. in /includes/functions_search.html on line 868

Warning: strpos() [function.strpos]: Empty delimiter. in /includes/functions_search.html on line 868

Warning: strpos() [function.strpos]: Empty delimiter. in /includes/functions_search.html on line 868

I really don't want to put Sphinx live until this is fixed... any advice would be welcome.

I am wondering if it has something to do with using an older 3.6 version of vBulletin.

RedWingFan · #**628** 10-23-2008, 03:15 AM

Quote:

Originally Posted by kerplunknet

Has anyone figured out the "Find More Posts by UsernameHere" issue?

I think I posted earlier in this thread (a couple pages back) that I put "error_reporting(0);" on one of the pages, which got rid of the error message. But it didn't fix the problem... :erm: I didn't have time to track through all of the code to find out what was missing in the query.

kerplunknet · #**629** 10-23-2008, 04:39 AM

Hi RedWingFan,

Thanks for the tip. That is a good workaround so the warning does not get shown, but a *real* fix for this would be ideal. I am going to have our main site developer look at this code quickly. Maybe it's an easy fix. Thank you for the workaround, though.

Spinball · #**630** 10-27-2008, 08:38 AM

You can turn off the errors that way, but doing a search for posts by a user is still broken. This is crippling the search capabilities and the abilities of the moderators to do their jobs.
This latest sphinx modification is broken.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.12730 seconds Memory Usage 2,304KB 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 (1)bbcode_code (1)bbcode_php (7)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 (4)pagenav_pagelink (3)pagenav_pagelinkrel (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (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 post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!