Announcement

Collapse
No announcement yet.

Select * from words errors

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Select * from words errors

    I noticed pages of
    Code:
    SELECT * FROM words where 'word' in ('
    errors towards the end of running searchindex.php after upgrading to the latest version of VB5. Has anyone else seen these? I did try to do it through the Admin CP but it takes forever to complete.
    Possibly this is because I only have MariaDB 10.1.44 in Ubuntu Server 18.04?

  • #2
    Maria 10.1.44 is fine. 5.6.3 runs on Maria 10.0.0 or newer.

    5.6.3 requires PHP 7.2.0 or greater. What PHP version are you using?

    Do you have cURL and PHAR PHP modules enabled?

    Comment


    • #3
      Hi, I'm running PHP 7.4. I checked & the 2 modules you mentioned are showing as enabled through a php -m

      Comment


      • #4
        Have you attempted to rebuild the search index using the command line?

        Comment


        • #5
          What is the entire error? The snippet posted is meaningless for diagnostic purposes.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment


          • #6
            Originally posted by In Omnibus View Post
            Have you attempted to rebuild the search index using the command line?
            Yes, using php searchindex.php It drops out with those same errors at the same point.

            Comment


            • #7
              Originally posted by Wayne Luke View Post
              What is the entire error? The snippet posted is meaningless for diagnostic purposes.
              Code:
              Invalid SQL:
              SELECT * FROM words
              WHERE `word` IN ('ordered','snuscentral','night','warming','order','form','basically','states','ball','usu al','quick','shipping','registerd','quickly','loaded','slow','early','note','consignment', 'suffer','delays','recently','updated','regulations','tobacco','deliveries','massive','wor kload','handle','sufficiently','rest','assured','information','provided','processed','shor ten','eventual','delay','caused','hope','situation','contact','customer','support','info', 'juice','inclined','guess','long','good','luck','notice','answer','days','snus','central', 'snus24','future','orders','lots','quicker','agree','drops','portion','depending','concent ration','full','aprox','portions','mixing','tiny','water','find','small','sprayer','give', 'shot','evenly','distribute','flavoring','frige','suppose','caught','xmas','rush','skruf', 'stark','herr','frucht','odens','brand','occasion','higher','nicotine','snuses','extreme', 'white','dryer','harsher','gums','original','moist','start','habit','dude
              ','time','elian','check','private','messages','forum','mate','advice','starting','safest', 'forms','addiction','expensive','folks','move','safer','product','hard','break','cost','mo ney','chreers','snusdog','arrived','yesterday','slower','tracking','lotta','entries','late ','flight','clearing','agencies','past','kentucky','goteborgs','rape','breakfast','husband ','asked','wife','lottery','replied','half','leave','great','stay','touch','room','tempera tur','stored','colder','boiled','coffe','potatoe','peel','sounds','wait','drop','worried', 'hubby','fell','asleep','pouch','mouth','hours','doctors','sores','pallet','doesn','strep' ,'blood','work','hurts','burnt','chew','heard','thing','short','happened','years','site',' 1000s','members','problem','sleeping','people','purpose','peoples','irritated','regular',' shouldn','hurt','loose','chewing','irritation','close','doctor','wouldn','blame','allergic ','withh','reaction','started','exclusively','swedish','match','soft','irritate','planets
              ','aligned','cowinkydink','negative','posts','posters','agreed','kind','cold','understandi ng','post','correctly','developing','pocket','pretty','harmless','moderate','serious','iss ue','pockets','recommend','alternate','sides','advantage','lays','makes','difficult','sear ch','button','side','snuson','page','subject','content','forums','helpful','answers','glad ','pipe','cigar','smoker','cigarette','school','counselor','smoke','helped','dilemma','gen eral','corner','stores','bought','pack','chimo','toro','satisfies','cravings','websites',' recommended','brands','high','snuss','guys','epok','make','business','variety','northerner ','online','retailers','specials','secret','ordering','line','sales','bulk','sale','helps' ,'offset','average','price','married','mother','drink','cool','license','sell','miles','li ve','question','mind','telling','customs','bring','country','receiver','talking','large',' quanity','government','eyes','shipment','manufacture','deal','ship','final','location','c
              hecked','1000','cans','oden','forty','inspectors','bigger','fridge','store','chicago','ill inois','nope','didn','louis','year','vote','pick','honor','wanted','hoping','texas','plan' ,'event','giant','city','logistics','venue','estimate','transportation','costs','provide', 'details','harder','guays','attend','walk','stud','young','lucky','strike','found','freeze r','wintergreen','main','smdb','selling','europe','canada','lazy','reply','email','thousan ds','dollars','month','thinks','nefarious','passing','sniff','test','lundgrens','perforate d','yeah','snus-mules','chapo','mules','göteborgs','rapé','strong','centric','grov','ettan','ankare','love ','begamot','smell','taste','fine','flavored','gotlandssnus','2018','taking','place','loun ge','wicker','park','june','10th','free','tickets','eventbrite','smoking','ticket','offeri ng','limited','amount','https','42961296394','olde','ving','fudge','facebook','fact','forw ard','cross','fingers','back','eventually','west','vegas','2020','east'
              ,'coast','left','feel','sweat','forehead','breasts','trickling','ecstasy','huge','smile',' face','moved','forwards','backwards','backward','heart','pounding','flushed','moaned','sof tly','began','groan','louder','finally','totally','exhausted','piercing','scream','smug',' parallel','lmao','truth','ahhahahhahah','games','till','dints','fender','paperwork','porn' ,'ratrod76','dealers','haven','click','link','replace','code','idea','call','drive','http' ,'hosted','where2getit','mccannworldgroup','locator_search','searchradius','addressline',' 37917','burnie','islay','whisky','squeeze','bless','instructions','taught','oddly','recipe ','made','dark','cacao','coffee','vanilla','cheers','tasty','swedes','snusbolaget','nyhete r','rare','sweden','offroad','snubie','brandy','alexander','portionssnus','roll','worth',' recent','trebli','sending','couple','nice','special','aromas','pouches','spraybottle','hap pen','sells','ships','flavors','making','e-juice','working','works','member','squeezyjohn
              ','recall','expert','including','cultivation','drunk','trump','video','slowed','jimmy','ki mmel','funny','drinker','rolleyes','older','realize','talk','times','style','clothes','ang er','management','stop','pissing','skills','tolerance','idiots','biggest','write','remembe r','life','tent','circus','duct','tape','stupid','muffle','sound','wonderful','minutes','w rinkle-free','sizes','smaller','noticed','means','walking','remembering','child','thought','punis hment','feels','mini','vacation','growing','longer','aging','hasn','shut','learned','happy ','monday','wrinkle','flavor','thunder','slim','pleasantly','surprised','congrats','chad', 'curious','told','pairing','snusline','morning','index','php','html','showed','issues','ja nuary','salmiak','louisville','extra','delivery','friday','sniffing','saturday','matter',' encouragement','coming','pike','snuser','voted','re-posted','smokeless','section','crew','jren','boat','cigs','mint','sweet','similar','jmho', 'menos','zone','weather','cont
              inents','enjoying','charge','ridiculously','freight','buysnus','picked','pricey','volume', 'reduce','exotic','bunch','crushed','siberia','supposed','week','warehouses','denmark','pr ices','depends','warehouse','campaign','today','sites','lowest','push','quantity','change' ,'larger','rolls','0327','8348','7274','6371','8561','9814','7043','5705','4910','4292','3 940','0281','8314','7246','6366','5820','5400','seniors','generation','comprehend','exists ','gain','friends','applying','principles','street','passers-by','eaten','moment','pictures','family','dead','gardening','things','garage','fixing','wa tering','lawn','standing','front','landmarks','driving','town','lunch','listen','conversat ions','thumbs','police','officers','investigator','psychiatrist','passers','weight','tins' ,'stuff','minute','decided','throw','bumped','total','cart','play','shopping','carts','eng ineer','bucks','premium','landed','numbers','miss','pre-pact','buck','postage','mailman','deliver','pact','breakdown',
              'adding','tuesday','tomorrow','brokerage','lasting','lines','peppermint','suggestions','re views','terms','longevity','tend','hour','smooth','stronger','catch','xrange','strength',' material','nick','johnny','blend','lasts','milder','products','requires','shipped','carrie r','verifies','control','buying','effective','months','included','cheaper','locally','dela yed','mine','arkansas','varies','period','violin','backround','music','inspiring','virgini a','complaining','ended','showing','woulda','wasn','package','mechanical','failure','richm onds','truck','amelia','interesting','story','spin','wrong','route','richmond','piggys','c rossed','witch','hunt','flood','sexual','abuse','allegations','read','professional','medic al','training','fired','minor','indiscretion','slept','patients','profession','waste','eff ort','paying','loans','show','mistake','ruin','thoughts','prayers','article','brilliant',' veterinarian','banjo777','events','noted','point','update','arrive','destination','schedu
              led','confused','received','impressions','disappointed','expecting','kapton','closest','no ticable','buzz','nordic','gross','mild','equal','slightly','bitter','annihilates','craving ','settled','occassional','mentioned','abroad','waiting','cents','seek','uncomfortable','s hake','body','subside','relaxing','sedative','refer','vices','risk','cigarettes','alternat ive','type','option','decide','questions','home','follow','snusdogs','granit','cheap','gen erally','usps','directly','brokers','china','accurate','reference','progress','pass','pack agemapping','17track','download','phone','easier','anniversary','spit','hiccups','feeling' ,'sinusis','blocked','tired','symptoms','underlying','coincidentally','grinds','youtube',' espresso','guarana','b-vitamins','taurine','vitamins','niccups','starks','overload','burnsey','hell','thread','vi brators','jump','real','winner','parrotnoid','meds','office','inspector','audit','books',' local','hospital','agent','checking','turned','alot','bandages','s
              ave','send','bandage','company','auditor','unusual','practical','arrogant','obnoxious','se tting','cast','patient','realizing','trap','unanswerable','manufacturer','plaster','thinki ng','fluster','know-it-all','remains','circumcision','surgeries','answered','foreskins','complete','prick','vapin g','boards','kinds','problems','return','ignore','irish','ghost','dublin','alfred','hitchc ock','tale','true','john','bradford','university','student','road','hitch-hiking','midst','storm','rolling','feet','ahead','suddenly','slowly','stopped','desperate' ,'shelter','closed','door','wheel','engine','running','moving','looked','curve','approachi ng','scared','pray','begging','hand','appeared','window','paralyzed','terror','watched','t ouched','harmed','shortly','lights','gathering','jumped','breath','rushed','inside','horri ble','experience','silence','enveloped','realized','crying','opened','walked','stormy','so aked','sobbing','paddy','fooking','idiot','pushing','hitch','hiking','addy','whale
              n','address','samples','salt','100mg','24mg','aroma','giving','10ml','pulled','untouched', '2015','date','sticky','plasticizer','breaking','common','dusting','talcum','powder','case ','sand','remedy','plastic','newer','retired','marijuana','card','afraid','labels','stick' ,'pealed','painted','pattern','wash','leaving','underneath','misses','seal','o-ring','measured','calipers','sucks','o-rings','rusty','sanded','smells','paint','experiment','putting','chance','mess','loss','ri ng','rings','counts','mailed','rubberized','graphics','enjoy','paypal','shoot','restricts' ,'service','watch','activity','aware','talked','personally','operate','children','pleasure ','sucker','parrots','coot','lose','accounts','promised','warn','payments','hazards','conc ern','offer','splitting','wood','ibuprofen','shower','understand','kill','spend','busting' ,'woods','firewood','lost','foot','trees','borer','saved','treat','acres','peek','spring', 'payment','offered','kids','ride','generosity','appreciated',
              'favor','snowing','snowman','feminist','passed','snow','woman','nanny','neighbors','compla ined','voluptuous','chest','living','nearby','grumbled','snowmen','vegans','lane','carrot' ,'nose','veggies','food','decorate','figures','called','racist','muslim','gent','wear','he adscarf','calls','cops','broomstick','removed','deadly','weapon','worse','mutter','news',' difference','snow-women','snowballs','sexist','seized','handcuffed','station','marked','suspected','terroris t','bent','stirring','trouble','accomplices','mark','owes','kicked','names','loud','record ed','little-known','jihadist','group','claimed','plot','slip','identify','male','female','baby','mamma s','shoes','planet','illegally','cadillac','escalade','million','pair','ultra','nike','sei smograph','presented','universe','milky','entrance','moral','world','women','word','alerte d','watching','prefer','straight','profile','chili','cookoff','tears','laughter','cheeks', 'attention','judges','judge','lived','cook-off','rodeo','ta
              kes','major','parking','astrodome','notes','inexperienced','taster','named','frank','visit ing','honored','selected','sick','table','directions','budweiser','native','texans','spicy ','beer','tasting','accepted','scorecards','mike','maniac','mobster','monster','heavy','to mato','amusing','kick','holy','****','remove','dried','driveway','beers','flames','worst', 'crazy','arthur','afterburner','smoky','hint','pork','slight','jalapeno','tang','exciting' ,'peppers','reach','pain','wave','heimlich','maneuver','fred','famous','burn','barn','exce llent','firehouse','beans','bean','salty','located','uranium','spill','snorting','drano',' routine','ignite','barmaid','pounded','backbone','part','****-faced','bubba','black','magic','spice','disappointing','lime','dish','fish','foods','felt' ,'scraping','tongue','unable','buds','sally','fresh','refills','300-lb','*****','nuclear','eating','aphrodisiac','linda','legal','remover','meaty','cayenne',' freshly','ground','considerable','impressive','sh
              redded','beef','admit','statement','ears','ringing','pouring','focus','farted','needed','p aramedics','contestant','offended','brain','damage','bleeding','pitcher','burning','lips', 'pisses','screaming','screw','rednecks','vera','vegetarian','thin','bold','balance','spice s','aggressive','onions','garlic','superb','chair','stand','slut','kinkier','anymore','wip e','cone','susan','sensation','mediocre','reliance','canned','tastes','chef','literally',' threw','appears','distress','cursing','uncontrollably','grenade','pull','sight','rushing', 'shirt','covered','slid','unnoticed','pants','lava','poop','autopsy','killed','breathing', 'painful','oxygen','suck','4-inch','hole','stomach','tommy','toe-nail','curling','perfect','ending','declare','existence','entry','balanced','poor','reacte d','cook','faced','inch','nail','posting','list','no=will','ok=will','yes=will','=ordered' ,'jakobsson','14mg','stressful','melon','afternoon','evening','americana','xtra','lotte',' latte','raspberry','supe
              r','green','12mg','cinnamon','dominate','frosted','blue','sample','weak','blueberry','95mg ','blackberry','änglaholm','crafted','conny','andersson','11mg','bergamot','glögg','kanel' ,'10mg','licorice','cola','flat','kaliber','kapten','café','knox','mocca','phantom','class ic','friend','onyx','southener','south','africa','batch','seeds','picking','brains','sm-a510f','tapatalk','a510f','current','extremely','apologies','ressurection','england','sque ezy','threads','dawn','soap','elbow','grease','dessert','iced','savoring','migrating','pla sticizers','stubborn','washed','wd40','wonders','cutting','glue','scrub','shame','overcome ','skoal','coupon','camel','toque','ambrosia','wake','kasirob74','hear','experienced','web site','american','snuff','assist','services','wishes','julia','pardon','resurrection','lik es','selection','choose','stash','oldeving','sold','sadly','discontinued','ditch','claq',' machine','slam','fully','knowing','frostbite','gajane','mofos','caprice','hate','aboard'
              ,'cope','rustica','photo','elephant','ginger','habits','forgive','lord','impure','dipper', 'dream','offers','ireland','wishing','favorite','lineup','occasional','stuck','rooster','t eeth','podcast','missed','summer','honey','explosion','sydney','blonde','economy','class', 'moves','sits','attendant','watches','asks','informs','paid','replies','beautiful','stayin g','cockpit','tells','pilot','co-pilot','bimbo','sitting','seat','explain','land','arrest','reason','speak','whispers','ama zed','fuss','knew','hands','cotton','boll','twist','brown','ideas','trade','exchange','ver n','troyer','dropping','flies','haha','eight-nine','grey','1847','makla','drip','southeast','nasty','eliquid','lovely','juicey','vapres so','veco','tank','3ohm','coil','zelous','loving','costantly','blow','battery','drizzle',' overbaord','hobby','easy','fella','curiosity','apple','copenhagen','reasonable','fast','ge nuinely','comments','experiences','highly','intend','fairy','prince','princess','marry','i mmediately'
              ,'happily','rode','motorcycles','dated','long-legged','full-breasted','hunted','fished','raced','cars','titty','bars','ladies','drank','whiskey','capt ain','morgan','*****ing','alimony','cheerleaders','house','guns','spam','potato','chips',' blew','enormous','farts','cheated','dogs','cats','tons','bank','toilet','legged','breasted ','sister','bees','vape','proven','fatality','safety','tips','safe','2009','crap','equipme nt','2013','unprotected','mech','shorted','popped','atomizer','hold','recycled','risking', 'protected','devices','covers','charles','krauthammer','york','reading','enemy','2017','de mocracy','established','history','presidents','organizing','action','disrupt','president', 'administration','organization','operation','destroy','governing','constitution','laws','p rocesses','allowed','proceed','chaos','countries','respected','army','court','system','sta cked','decades','america','ex-president','involved','community','post-administration','promise','intends','strategic','
              tactical','implementation','resistance','politically','active','courts','providing','lever age','revolution','dedicated','communities','progressive','socialist','healthcare','aborti on','equality','climate','immigration','reform','propped','message','shadows','building',' block','accomplished','organizers','fighting','groups','commit','obtained','digital','asse ts','re-election','inspired','movement','shadow','aimed','resisting','tearing','constitutional','r epublic','paul','sperry','writing','fight','donald','turn','presidency','command','bunker' ,'writes','sabotage','network','non-profits','offices','nationwide','filings','volunteers','oversee','washington','executive', 'signals','protests','statements','pro-immigrant','aclu','lawyers','file','lawsuits','jurisdictions','activist','obstruct','prote st','airports','congressional','hall','meetings','leftist','media','springs','activities', 'twitter','sphere','social','violence','signal','heartened','barack','obama','plans','foun dation
              ','operated','scare','losing','compliant','target','editor','brightest','journalist','poli tical','analyst','opinion','words','warning','spread','citizens','happening','noses','elec tion','profits','immigrant','quit','wanna','farmer','google','client','ms-android-rogers-ca','isch','krdzwviviuaoggefpzfg','tsna','study','gs_l','mobile-gws-wiz-img','84981','89165','89743','1193','1j7j1','30i10j0i24','somr4osjqvy','imgrc','py3lfat98f n4m','image','android','rogers','mobile','expect','annoyin','dippin','sting','technology', 'patent','approved','applied','global','gtnf','september','golden','leaf','award','newcome r','industry','signed','non-exclusive','starters','hauni','machinenbau','gmbh','germany','solving','machinery','produc e','launch','sting-free','varieties','adds','protective','manufacturing','process','removes','stinging','user s','oral','mucosa','whilst','protecting','vital','organs','harm','ph-level','stingfreesnus','jones','announcement','youtu','pn67hmzw3u8','bengt','wiber
              g','invented','dentist','recede','hurtful','lesion','refused','solution','patented','artic les','videos','pics','snusing','exclusive','level','poll','open','semi','finals','released ','results','select','opinions','mixed','owns','release','convenience','background','dissi ng','preference','pussies','completely','teabags','suggestion','semi-finals','options','rose','ease','password','sorted','expresso','suspect','remaining','dail y','voting','jokes','giggle','synagogue','rabbi','candles','candle','drippings','makers',' matzo','purchases','crumbs','collect','manufacturers','balls','leftover','circumcisions',' perform','dick','lungs','oldie','goodie','laugh','energy','sleep','absolutely','urge','smo kers','vendor','plays','rules','worries','drinking','opposed','splash','soda','wondering', 'dipping','aren','kinda','wondered','20th','savings','ability','meeting','public','arsenal ','fall','simply','fantastic','ahahahhaaaha','laughing','trow','flint','knife','doubt','gr eater','expertise','
              arriving','crusty','georgia','suggest','vacumn','star','dealer','employees','consist','ret ailer','silly','number','mention','googled','spanish','technically','figured','paper-like','paper','vendors','possibly','showthread','9085','deciphering','expiration','dates', 'severe','initial','assessment','anticipated','colored','stateside','weeks','accustomed',' dripping-wet','well-humidified','refrigerator','aback','rehydration','dripping','humidified','stoker','cherry' ,'plumb','bruno','mail','apparently','favoured','tony','benn','share','brushes','authoriti es','session','nights','drinks','shots','limit','checkpoint','waved','safely','incident',' surprise','driven','finalized','needless','result','surprising','driver','spot','delivers' ,'mychoice','facility','mouse','clicks','prisoner','srch','mc_id','ds_gclid','dscid','7170 0000031307143','searchterm','gclid','gclsrc','sooner','untrained','monkeys','manager','gra in','margin','flavoured','unlike','natural','flavour','spearmint','ex-dipp
              er','40mg','gram','oliver','guessed','spun','pellets','arctic','enjoyed','newbie','ohio',' akron','area','verify','hook','shops','cleveland','dedication','getgo','missing','purchase ','gave','saves','hassle','listed','keen','appeals','compares','gather','cleaner','glitch' ,'deals','international','assortment','vacuum','sealed','stock','increasing','role','thank fully','places','familiar','based','israel','scandinavian','fascinating','nations','hebrew ','vary','half-ish','fixed','damn','strongest','empty','42mg','sweating','light','headed','cautious','dis creet','strawberry','maintenance','yorkshire','taxfreesnus','odenssnus','single','direct', 'kits','flavours','tala','noticing','league','wise','effect','user','term','individual','m almö','kardus','danish','shop','albeit','drier','bottom','deck','lipped','dizzy','43mg','h onestly','lenny','gents','prima','fint','prilla','fellers','goteborg','review','thismornin g','actual','united','requested','choice®','completed','arranged','picku
              p','view','jonkoping','export','scan','import','arrival','philadelphia','departure','koeln ','malmo','sturup','ready','positive','minus','religious','forgotten','rubber-stamp','fighter','sort','rubber','stamp','2014','sympathy','outrageous','florida','roda',' lacket','tiger','berawa','naken','batu','bolong','petitenget','uluwatu','warung','keroboka n','bali','indonesian','parcels','taxes','happier','buddy','canadian','snusers','joint','d arts','dings','harvest','greenhouse','farm','encourage','companies','stealing','homemade', 'cannabis','infused','fronto','grown','homegrown','bragging','pointers','william','bargain s','edition','norrland','organic','craft','fairly','simple','correct','fridges','anyones', 'interested','pooch','admin','okie','dokie','clove','held','bags','helping','messaging','a dministrator','messaged','inbox','busy','restored','swallow','stingfree','goin','protect', 'thicker','pouchmaterial','stings','carbonate','contractors','bidding','broken','fence','o rleans','of
              ficial','examine','contractor','measure','measuring','pencil','figure','materials','profit ','figuring','leans','incredulous','hire','stimulus','worked','boxes','ballot','jury','car tridge','drill','politics','larry','snus-news','iterated','choice','steady','lady','giggled','snickered','creatures','stays','weddi ng','care','chocolate','snack','pregnant','t-shirt','mechanics','urinal','restroom','icky','bolt','wrinkles','character','dress','renta l','stare','blister','mangle','mood','seconds','tanks','five-day','suitcase','jars','credit','slightest','thoughtfulness','forgets','invite','underwear ','three-pack','pairs','strap','color','hairstyle','shave','neck','toys','wallet','seasons','shorts ','legs','nails','freedom','mustache','christmas','relatives','december','nickname·','laur a','kate','sarah','dave','affectionately','wild','out·','bill','arrives','girls','outcome' ,'calculators','item','needs·','bathrooms·','items','bathroom','toothbrush','toothpaste',' shaving','cream','r
              azor','towel·','typical','arguments·','argument','beginning','future·','husband·','marriag e·','marries','dressing','plants','trash','book','weddings','funerals','natural·','good-looking','bed·','deteriorate','offspring·','appointments','romances','fears','hopes','drea ms','vaguely','forget','mistakes','sense','humor','personal','pre-75','behavior','hosed','duties','knives','froggy','hairlip','wearing','guarding','pond','r uns','conspiracy','purple','crocs','adult','diaper','clean','trades','sideways','gifted',' additional','steps','packaging','tagged','stocked','obtain','switching','croatia','church' ,'catholic','fatal','accident','catholics','pearly','gates','peter','heaven','begin','leav es','gate','returns','bedraggled','divorce','bloody','joking','red-faced','frustration','slamming','clipboard','frightened','shouted','priest','lawyer','cong ratulations','timers','texting','wheelchair','ttyl','byot','lmdo','dentures','fwiw','forgo t','imhao','hearing','ommr','massage','r
              ecliner','roflacgu','floor','peez','prison','deterrent','french','goals','weren','fellow', 'snusser','dangerously','fart','booboo','stokers','preacher','appalachian','circuit','bowl ','tubs','firm','refrigerate','decant','hydrate','repeat','tide','terminology','directives ','calling','beach','levi','garret','refrigerated','noticeable','deterioration','moisture' ,'1800s','rope','plug','shelf','holding','moths','cellar','genuine','southerner','board',' swede','shine','bourbon','disclaimer','father','southern','roots','fluent','cousins','brot her','numerous','occasions','context','karen','emoji','concerned','health','ramifications' ,'spitting','detrimental','incurred','swallowing','wind','dudes','girl','luckily','interce ded','peace','digress','ramification','football','cups','competition','african','violates' ,'busted','beat','kills','detriment','foliage','gotta','wander','vagina','cousin','announc e','preferred','discount','crowd','sayin','glenn','couch','meat','vaseline','island','lal
              a','stayed','died','breathe','backup','promote','winds','frogs','edge','embossed','digits' ,'signify','expires','february','digit','a129','12th','2019','extend','significantly','fre eze','ziplock','gallon','ssmtp','dragonx5','noreply','username','request','changed','nicot inerush','team','receive','vbcontact','infromation','e-mail','sender','1098','2008','packing','quotes','dangerous','mcdonalds','punched','jeremy' ,'limb','eighty-two','cent','statistics','reeves','anti-bullying','wristbands','stole','jack','whitehall','drowned','funeral','wreath','shape','li febelt','gary','delaney','therapy','gift','vouchers','clubbed','crossbow','sean','lock','e ighty','anti','bullying','painter','murphy','scholar','portrait','artist','fame','grew','m iltown','malbay','county','clare','likenesses','english','stretch','limo','nude','perturbe d','object','pounds','wanting','marital','strife','confer','mary','rightness','wrongness', 'decision','condition','returned','missus','socks','xtreme','faithfu
              l','picture','repackaged','grabbed','555-snus-xtool-bags','heat','fasttech','4855901','xtool','heads','filtsnuspaper','reasons','generals','pr illan','filling','tedious','chore','filt','discrete','twisting','ritual','greasy','handlin g','papers','russians','nortons','purchased','identity','theft','protection','threats','no rton','……………','normal','airport','screening','terrorists','discovered','transvestites','he rnias','hemorrhoid','cases','enlarged','prostates','breast','implants','blondes','politici ans','annual','aspx','placing','unsure','duty','rinse','webo','headsup','beating','head',' wall','brought','ranges','discounts','snus-on-sale','timing','finished','briefly','dear','kean','elementary​','radio','senior','luncheon ','sprenger','aged','kindness','roommate','napping','broke','pieces','awful','answering',' kiss','opportunity','sincerely','agnes​','_________________','smart','college','teacher',' reminds','exam','tolerate','excuses','attack','injury','illness','d
              eath','whatsoever','raised','suffering','utter','exhaustion','entire','reduced','snickerin g','smiled','knowingly','shook','sweetly','double','packed','kicking','scotch','liking','s wisher','cigars','buypipetobacco','satisfactory','guaranteed','stickyed','milds','enjoymen t','ciggarellos','panic','corn','pipes','briar','falcon','stem','accessorys','goodness','a rggh','spirit','guestimated','spent','puking','guts','dunhill','standard','missouri','meer schaum','legend','polish','bargain','actaully','preferring','deeper','cheapness','snused', 'messyness','adjust','dosage','messy','discarded','ends','sink','nececery','charges','deli vered','thursday','knowledge','report','couldn','lobbyist','reports','policy','funded','ya ch','independent','awareness','length','benifits','nicorrette','lozenges','monkey','ration alizing','factors','diet','exercise','nxiety','pharma','pills','swollow','calm','extract', 'passionflower','antianxiety','herb','peer','studied','benzodiazapines','fertilized','hun
              dred','pullets','roosters','fertilize','eggs','records','performing','soup','replaced','be lls','attached','bell','tone','distance','porch','fill','efficiency','listening','favourit e','butch','specimen','hadn','rung','investigate','chasing','bells-a-ringing','cover','amazement','beak','sneak','pullet','proud','entered','overnight','awarde d','prize','pulletsurprise','politician','coveted','awards','sneaking','unsuspecting','pop ulace','screwing','carefully','butterworths','syrup','marriage','lying','fondle','ways','t ickled','caressed','shoulders','stopping','lower','proceeded','gently','buttock','calf','t high','uppermost','continued','manner','rolled','aroused','caressing','voice','remote','ge rman','controllers','frankfurt','renowned','short-tempered','assistance','amusement','listened','british','airways','sign','speedbird','clea r','runway','taxi','alpha','one-seven','taxiway','impatience','coolly','1944','tempered','ricman555','apologize','inconven ience','producing','impatien
              tly','newsletter','patience','buffalo','july','response','comp','tied','cancel','refund',' riceman','newest','obsession','killing','epipe','manowar','incacao','redskins','offensive' ,'snyder','owner','announced','henceforth','reported','finds','imparts','leadership','mism anagement','corruption','cheating','graft','fitting','role-model','fans','model','joshhead','locator','pages','locators','14214','generalsnus','finde r','grabs','yard','hung','mistrustful','emergency','horseback','riding','mistak','horse',' faster','pace','stirrup','dragging','toys-r-us','unplugged','bastard','mans','journey','hoped','girlfriend','passion','passionate','ze st','emotional','drama','queen','cried','threatened','suicide','stability','stable','borin g','predictable','excited','dull','excitement','settling','impetuous','miserable','initial ly','energetic','directionless','ambition','ambitious','planted','firmly','divorced','owne d','wiser','tits','courtesy','true…','revo','passengers','resolving','trav
              el','cancellations','mccubc','yahoo','unregistered','craig','linked','banned','emailed','e arlier','unban','re-register','reset','stating','heck','reached','443-926-3150','register','3150','login','account','deactivated','inactivity','reversed','re-activated','registered','gmail','resolves','incase','difficulties','contactus','endevour', 'userame','activated','modern','sandra','neighbor','daughter','ohhh','naturally','bummed', 'daddy','hotter','angela','hugs','signing','wasa','g-mail','craigmccubbin','confirm','locked','access','temp','unlock','person','craig443-926-3150','craig443','confirmed','queries','maryland','state','stations','2005','overseas','li ck','hairy','licking','marylander','snuskompagniet','swedishsnusstudio','thank-you','sussed','markets','heads—up','submitted','notices','handsome','staring','offend','fa ntasy','responds','alley','fulfills','hooker','blush','starts','sinned','lied','confess',' jewish','kevin','halloween','party','duck','hunting','meadows','neva
              da','dropped','bird','field','climbed','elderly','drove','tractor','litigator','responded' ,'retrieve','property','indignant','trial','settle','disputes','disagreements','rule','dis pute','occurs','proposed','contest','easily','codger','abide','custom','attorney','steel-toed','boot','groin','knees','midriff','meal','gushing','fours','rear','face-first','summoning','managed','wiping','jacket','steel','toed','limp','veterinary','surgeon ','laid','stethoscope','cuddles','distressed','wailed','protested','testing','coma','labra dor','retriever','stood','hind','paws','examination','sniffed','patted','delicately','haun ches','meowed','strolled','certifiably','computer','terminal','keys','produced','handed',' shock','shrugged','complaints','element','honoring','veterans','honors','veteran','neverfo rget','checkout','carry','sponsoring','humble','tribute','valid','november','veteransday', 'salutetoservice','veteransday2018','informed','receiving','mörkbrunt','bigdaddysmoke','ri gs','india',
              'evidence','lives','harmful','legendary','dynasty','turkey','favorites','begun','queenofsn us','grizzly','grade','marine','barbwire','flags','eussr','tranza','quihubo','hermanos','m exicanos','aquí','explicación','ilegal','comprar','tabaco','sino','limitantes','paquete',' evidentemente','aduana','pocos','saben','siguiente','problema','siempre','entra','méxico', 'entrega','través','correos','llegará','tarde','existe','riesgo','pierda','será','extremad amente','difícil','poder','contar','recomendación','paquetes','menores','gramos','costo',' envío','depende','cantidad','tener','apartado','postal','sólo','tendrás','tiempo','seguro' ,'mexico','bringing','plane','random','thruthfully','enter','breaks','middle','smoked','20 07','havn','prior','previous','americans','sweepstakes','giveaway','winners','visit','chru shed','23rd','24th','freesnus','popular','syrupy','molasses','redman','occasionally','ipho ne','transitory','citrus','cured','fragrance','qualifies','lightest','awesome'
              ,'schmalzler','styles','offerings','menthol','camphor','ratio','chill','merit','sinuses',' snufers','build','nature','runny','reseal','electrical','security','drugstore','buys','pre gnancy','shows','shouting','picks','mercedes','limosine','stops','mature','distinguished', 'gray','hair','rolex','armani','suite','diamond','wealth','enters','additionally','born',' bequeath','retail','furniture','deli','condo','miami','legacy','chain','jewelry','miscarri age','choked','remained','silent','shoulder','25th','26th','27th','28th','announcements',' samuel','gawith','classified','photos','medicated','indian','mentholated','differences','t exture','supply','challenge','manageable','affordable','compared','meantime','serving','up holds','interestingly','expected','channelnewsasia','stands','10959528','meant','invasion' ,'press','elmo90_','hotmail','deleted','elmo','5019','deleting','advance','leukoplakia','t oshow','dramatic','increase','biopsy','reveals','malignant','feature','diagnostic','requi
              red','ensure','cancerous','precancerous','fluid-filled','blisters','critical','fluid','filled','links','studies','parked','reluctantly','f are','drive-by','quackery','annoy','increasingly','dissatisfied','nicorette','12-year-old','detroit','raining','prostitutes','awnings','husbands','turns','geez','hookers','wide ','glaring','babies','drivers','sterks','14-15','range','post-brexit','brexit','weekly','source','footbag','pure','pasture','cletus','billy','sees','sen sual','striptease','deere','buttocks','clenched','performs','pirouette','slides','overalls ','hunches','hips','revealing','torn','frayed','plaid','grabbing','rips','reveal','stained ','flourish','hurls','baseball','pile','rushes','grief','bejeebers','embarrassed','havin', 'bedroom','partment','therapist','suggested','sexy','unflavored','ettans','favors','additi ves','added','snus-ban','demand','entering','enacted','eu-law','nonetheless','monolithic','superstate','potential','tyranny','majority','undemocrati c','itchin','bu
              st','server','greek','2011','pre-christmas','eshop','hundreds','join','august','finger','socket','very_drunk','snuck','2006 ','exact','creamy','muted','mrefsal','eggmcmartin','re-join','delete','sweetness','hearty','earthy','apples','borbon','peppery','baking','pepperi ness','mints','contemplating','sweetening','bulb','safari','smashing','ipad','satisfy','ch eapest','maklas','bernie','bite','singleton','heya','lack','lössnus','disappointment','gam bled','rallarsnus','whim','adoption','linux','enthusiasm','gears','marching','onward','skå l','tom502','oldtimers','sexiest','song','lxskllr','boutique','maker','unique','designing' ,'releases','border','seemingly','producers','estores','quality','innovative','skoalbandit s','slating','footballers','cancers','bollox','kailash','gonna','hangover','un-ticked','promotional','ticked','thibaut','chantegret','wanadoo','un-subscribed','mailers','subscribed','armstrc','everyday','appreciation','promotion','locati ons','upper','displayed','hesita
              te','regard','malin','chewbags','replacement','expense','submitting','substitite','bares', 'resemblance','degree','restricted','certified','knose','ronan','septoplasty','twenty','fl ow','nostril','tolerable','rumney','targeted','forbidden','e-stores','distribution','focused','pulling','affect','navy','1985','vending','machines','pa cks','forge','letter','clerk','recollection','carton','in12','cartons','guessing','budget' ,'played','fruity','viking','visible','gold','theme','faded','yellow','gung-fu','brewing','gung','fire','eliminates','step','assumed','handful','devoted','ahahhahhahh a','approach','skins','maintained','separate','default','manage','mistaken','sampler','cha rlie','skin','basic','functional','euros','walter','scott','lundy','exquisite','tiresome', 'darwin','gang','rick','types','webstore','2012','shocking','diabetes','sharing','shared', 'informative','anarkali','toast','latest','leading','overview','moderating','top-right','vb','ad_location','vietv2b_topx','wizard','
              emoji41','error','browser','submission','token','expired','shaking','glancing','surmise',' culprit','playing','factor','hypertension','ingredients','interest','comparing','cancer',' processing','method','distinguishes','shown','shed','stream','centered','lined','hare','fe edback','advertising','centre','banner','internet','explorer','ctrl','refresh','center','b rouser','chrome','cookie','okdokey','switch','rotating','java','script','adjustments','rin gie','dingie…………','downloading','stetting','tool','cookies','unrelated','solved','perfectl y','qualified','shooting','department','powering','power','gummys','chat','barrels','molen s','windmills','mettaijer','behaves','serves','base','snuffs','gingerbread','dholakia','ma dras','eastern','undertone','behaved','firefox','motzilla','inexpensive','math','tech','ab andoned','windows','compatibility','concentrated','re-invent','take-up','addition','rumour','abandon','back-end','unix','invent','impressed','split-personality','split','p
              ersonality','ebay','alway','preferably','mackmyra','röda','mustang','exorbitant','shovelin g','carlisle','scranton','northeast','roadtrips','restrictions','loosen','plowing','warmer ','changing','fiberboard','fits','lids','flimsy','fave','nasal','partake','recession','pin ch','chaw','grass','shredder','re-visiting','addict','brings','memories','relapse','seats','temple','lexington','jessica','g lazed','retirement','dimension','fiberboad','earl','cambell','sparrow','intriguing','trys' ,'alabama','grand','mystery','version','grab','retry','garrett','chewed','mails','dunno',' behalf','marie','miguel','mental','project','mailto','mariemiguel746','emailing','goal','e ducate','families','wellness','related','topics','featured','adaa','themighty','amhca','go odmenproject','discussions','important','resource','psychologytoday','covering','benefit', 'readers','discuss','detail','necessarily','consideration','referring','hasan','hassanonli ne72','reader','contribute','guest','i_ve','brainstorm
              ing','i_ll','piece','can_t','backlink','proposal','topic','hassan','17739','can’t','studen ts','hasson','spammer','copy','emails','research','mailbox','resets','requests','drips','d rawback','minis','considerably','loses','coincidence','beechnut','diagnosed','copd','prope rties','ownership','weigh','deciding','sagedil','disappeared','butt','crack','forumdisplay ','46-snus-newbies','newbies','nominate','stats','track','ajax','submisson','install','volunteered',' planned','exploded','doggy','offence','stickying','presently','function','faqs','upto','de velopments','viewing','non-expired','staff','welcoming','relevant','desktop','roughly','edit','mellow','1000x','jangl es','snuslos','finding','surprises','preferences','sigh','bugging','advanced','ckeditor',' mill','opening','text','adopting','comcast','jitters','rely','retest','template','tweak',' clicked','typed','translate','forskning','1289732','fbclid','royking','samfunn','sykdommer ','oker','ikke','risikoen','slag','eller','hjertes
              ykdom','hsiak_rchozpqajrsg','weird','footer','midnight','sentence','touchy','jitter','bros wers','handy','berry','worry','boyfriend','addicted','newbe','scrambling','go-round','round','goto','acquire','plenty','carries','basis','span','motivation','anxiety',' prescription','attributing','acquiring','vbulletin','specifically','bolded','bother','lapt op','nuts','hormone','chewbacca','lyft','strengths','blackline','identical','scooped','mar ch','versus','glorious','delicious','ecological','garden','fruit','evaded','click-through','snusdirect','ingredient','leads','lacked','prominent','lacking','pickle','pickle s','corrected','tooth','cracked','chipped','switched','dryft','chipping','skuf','utm_campa ign','unspecified','utm_content','utm_medium','utm_source','apsis-anp-3','delists','apsis','injured','ejecting','skyhawk','catapult','heroics','rescue','helicop ter','permanent','physically','impaired','status','admiral','career','sensitive','appearan ce','interviewing','master','chiefs','s
              ergeant','chief','surface','interview','starboard','impacts','angry','tact','candidate','a viation','articulate','sharp','lenses','incredibly','tactful','glasses','discontinuing','f loral','subtle','anytime','consumption','bump','priority','mysnus','amazing','muster','cou rage','encouraging','blizzard','eucalyptys','non-tobacco','patch','winning','chadizzy1','blogspot','orange','re-locked','frost','nicotinell','swallowed','describe','rough','smokey','poison','chuck','cha d-links','bits','nash','beard','ewww','thankee','kindly','dawg','ocean','sequel','amazon','i nstallment','b07ncyz6xf','sr_1_1','digital-text','utf8','1549305852','keywords','grace','learn','saliva','generate','sticks','sandpap er','jayafink','lightly','moistening','80°c','reacting','unfamiliar','causing','theory','n uances','flavouring','pleasant','fanta','orangish','fizz','underwhelming','athlete','pisto l','fair','hidden','dosing','mins','rarity','hybrid','homer','simpon','experimenting','ass ume','remain','hygien
              e','packet','cocktail','toothpicks','grubby','touching','whack','unscented','aromatic','im pression','sweeter','stout','latakia','ruins','comparison','film','swung','reduction','mar ket','botted','sluggish','pinoy','fuma','pinoy-snus-original','pinoysnus','webshop','swedesnus','verified=c052df3ca5','suspicion','closer','pe pper','lemony','forefront','cherish','uncertain','dislike','dominant','presence','mentions ','partial','hopeless','romantic','mellows','blends','ultimately','usable','taste-wise','absolute','tobacco-ish','peaty','complex','offsetting','bitterness','unsweetened','hjortron','lemon','cranber ry','favourites','icetool','desired','wrapped','tightly','assure','justice','accessory','u pper-lipping','traditional','inflating','compounds','whichever','chimney','identified','puff',' lipping','discretely','settings','hydrated','scent','lighter','moth','comparable','dose',' longer-lasting','onset','chaga','mushroom','clickbait','20172','tasted','assumes','assumption','r esides'
              ,'occurring','resulting','absorbed','governed','freebased','phenomenon','encountered','tob acco-free','punch','equivalent','tincture','maturing','determined','loosesnusmoose','truffle',' factory','description','pirated','software','monitor','induced','freed','palpitations','re moving','ingest','full-bodied','bodied','misplaced','ansel','accordion','stage','tour','imagined','benefits','ste ep','compare','weekend','tigersnus','ansbacca','hilarious','worn','feud','feminists','aria na','grande','starbucks','remembered','squirrel','fried','chicken','plateaued','alive','im agine','descriptions','jacobson','aswell🙄','afford','skruff','upgrade','rotation','bueno', 'unremarkable','recipes','sachets','mire','pming','20134','quot','impossible','moar','meth ','precious','stuff🤘🏻','hahaha','hefty','easiest','dislodged','nursing','mini-portions','alve','precious007','gender','realignment','surgery','viewprofile','profile_id' ,'76938359','old-school','reacts','learning','fund','reunion','f
              lader','rated','snus🤘🏻','odrer','northener','stunned','can´t','don´t','arse','speaking','m inty','bedtime','christy','shotgun','transition','ruined','lite','silver','creek','tattooe r','booze','drugs','interrupt','*****','diminished','libido','erectile','dysfunction','imp otency','root','longcut','bandits','orders🤔','fleshlight','reused','hipaa','privacy','unpl easant','finish','size','format','juicy','one-day','dishwasher','fleshlights','decade','space','silicone','amazingly','shrink','candy',' sour','fravor','fades','gasket','sealant','gated','basics','rotate','attempt','gravitate', 'mackymara','macymara','madness','includes','unloadingzone','thick','combined','gtossed',' pushed','sweetened','lining','clouds','neat','dozen','refined','comfortable','comfort','re minded','pate','uninteresting','pasty','residue','disgusting','bakes','grow','baked','10-15','intense');
              
              MySQL Error   : Illegal mix of collations for operation ' IN '
              Error Number  : 1271
              Request Date  : Thursday, September 3rd 2020 @ 02:57:44 PM
              Error Date    : Thursday, September 3rd 2020 @ 03:10:08 PM
              Script        : http:///searchindex.php
              Referrer      :
              IP Address    :
              Username      : Guest
              Classname     : vB_Database_MySQLi
              MySQL Version :
              
              
              Stack Trace:
              #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1207
              #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
              #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 576
              #3 vB_Database->query_read() called in phar://[path]/vb/vb.phar/db/result.php on line 144
              #4 vB_dB_Result->rewind() called in phar://[path]/vb/vb.phar/db/result.php on line 68
              #5 vB_dB_Result->__construct() called in phar://[path]/vb/vb.phar/db/query/select.php on line 121
              #6 vB_dB_Query_Select->doSelect() called in phar://[path]/vb/vb.phar/db/query/select.php on line 98
              #7 vB_dB_Query_Select->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293
              #8 vB_dB_Assertor->assertQuery() called in [path]/packages/vbdbsearch/core.php on line 735
              #9 vBDBSearch_Core->addWords() called in [path]/packages/vbdbsearch/core.php on line 245
              #10 vBDBSearch_Core->indexTextBatch() called in phar://[path]/vb/vb.phar/search/core.php on line 257
              #11 vB_Search_Core->indexBatch() called in phar://[path]/vb/vb.phar/library/search.php on line 101
              #12 vB_Library_Search->doIndexNodeList() called in phar://[path]/vb/vb.phar/library/search.php on line 95
              #13 vB_Library_Search->indexRangeFromNode() called in [path]/admincp/searchindex.php on line 256

              Comment


              • #8
                Make sure that that word field in the words table has the same collation as the table itself. Should be able to see this in phpMyAdmin or HeidiSQL. Might be useful to use the dbtools provided to make sure all your tables have the recommended character set and collation of utfmb4 and utf8mb4_general_ci (respectively). See: https://forum.vbulletin.com/articles...database-tools

                Switching how the site is indexed won't resolve this issue. Nor is it related to the version of PHP or using PHAR. It is a database configuration issue.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API

                Comment


                • #9
                  All resolved. Many thanks Wayne Luke :-)

                  searchindex.php ran through with no errors and completed after running utf8tablefix.phar (was using INNODB tables)

                  Comment

                  Related Topics

                  Collapse

                  Working...
                  X