Go Back   vb.org Archive > Community Discussions > Forum and Server Management
Reload this Page Sphinx Search
FAQ Community Calendar Today's Posts Search

Reply
Page 63 of 84 « First 13536162 63 646573 Last »
 
Thread Tools Display Modes
  #621  
Old 10-14-2008, 04:01 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #622  
Old 10-14-2008, 08:35 AM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
  #623  
Old 10-14-2008, 08:13 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
@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.
Reply With Quote
  #624  
Old 10-16-2008, 06:38 AM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by snakes1100 View Post
@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.
Reply With Quote
  #625  
Old 10-16-2008, 01:16 PM
Lizard King Lizard King is offline
 
Join Date: Jan 2005
Location: Mersin
Posts: 907
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Spinball View Post
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.
Reply With Quote
  #626  
Old 10-16-2008, 07:52 PM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Lizard King View Post
I may suggest you to contact Teck privately. His sphinx script is working flawlesly on lots of sites.
Will do, thanks
Reply With Quote
  #627  
Old 10-23-2008, 02:14 AM
kerplunknet kerplunknet is offline
 
Join Date: Jul 2002
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #628  
Old 10-23-2008, 03:15 AM
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
Location: Canton, MI USA
Posts: 103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by kerplunknet View Post
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.
Reply With Quote
  #629  
Old 10-23-2008, 04:39 AM
kerplunknet kerplunknet is offline
 
Join Date: Jul 2002
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #630  
Old 10-27-2008, 08:38 AM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
Reply
Page 63 of 84 « First 13536162 63 646573 Last »

« Previous Thread | Next Thread »

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 11:28 PM.

Contact Us - Archive - Top

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.14940 seconds
  • Memory Usage 2,307KB
  • 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