Just upgraded from v5.5.0 to v5.5.2. My Search Type is DB search. After finishing the upgrade I went to rebuild the search index.
First method I tried was via Admin CP
at approx 18000 items the search throws the following error:
********* Begin error capture **************
Error Invalid SQL: SELECT * FROM words WHERE `word` IN ('yeah','data','platform','migrations','aren','smooth','one','hope','techone','air','titan ','big','bright','plane','great','handling','wider','range','flight','conditions','smaller ','fms','firefly','compact','environments','glad','give','us','pilots','options','sizes',' pricepoints','man','alpha','electric','festival','meeting','attend','day','asst','guys','m rc','sending','last','weekend','february','http','azelectricfestival','org','brandon','upp er','window','select','profile','left','side','avatar','hover','mouse','edit','button','cl ick','upload','new','image','make','promises','working','two','superstition','year','featu re','me','p-40b','40b','1400mm','fw','90mm','f-15','burners','15','photos','want','work','surprised','delay','good','test','post','huge', 'software','update','didn','link','retired','december','better','spend','city','short','dr ive','viva','las','vegas','finally','flew','10','packs','2200','2500','needed','nose','wei ght','3000','3600','fine','cowling','overs','learning','power','landing','till','made','ta il','stuck','half','fun','flyer','load','figure','site','www','valleyflyers','club','websi te','event','poster','bottom','page','testesteteststst','asked','umbrella','markings','all ied','green','bobcat','nacelle','kill','notated','top','cover','aircraft','p-38s','shown','use','marking','depicting','cane','hat','fighter','escort','bombers','broom' ,'cap','mission','types','variety','targets','missions','four','aerial','victories','swast ikas','38s','pilot','ryan','thrill','honor','enjoying','flying','nice','buddy','presentati on','enjoy','things','whim','folks','giving','back','talents','rc','community','modeling', 'cherish','hold','dear','personally','mine','title','retractable','light','modification',' exhaust','manifold','eyes','used','flown','trim','add','bit','flaps','positions','trimmed' ,'tendency','roll','thinking','plains','slightly','sync','slight','difference','lot','surf ace','travel','adjustment','move','elevator','zeroed','fast','surfaces','stop','arguing',' slows','don','off','pleanty','speed','quickly','anxious','stretch','skill','match','forwar d','bring','anticipation','delivery','overwhelming','reading','history','purpose','tactics ','theaters','painting','black','white','strips','help','stand','videos','awesome','https' ,'youtube','watch','3y-rmagfxjs','rmagfxjs','80mm','edf','vs','freewing','a6','intruder','model','12','blade','du cted','fan','weaken','foam','frame','abilities','questionable','read','couple','reviews',' claiming','powered','plant','knows','spent','years','a6a','avionics','know','designed','ha ll','28','500','pounders','14000','lbs','hi-speed','provide','maneuverability','thoughts','advice','greatly','appreciated','advance',' skip','static','shot','p-38','38','size','increase','default','setting','waaaay','small','simple','change','admin', 'hardcode','tweaked','edited','css','rest','assured','features','fixed','asap','coming','a ccomplished','junior','member','happy','join','flights','t-45','mg-we6bbde4','doug','mg','we6bbde4','video','quick','overview','demo','xk6stui-alm','xk6stui','alm','assembly','decaling','shows','fairly','straightforward','process','c vd9nthz7s4','la-7','easily','put','boring','most','presented','real','time','sense','box','t4xib9xqaaw','l a','covering','hey','konrad','laminate','wouldn','sharing','wondered','kind','camera','loo kin','pretty','dang','sweet','call','earlier','questions','administrator','hawksky','v2',' spoke','talking','love','version','maiden','past','anytime','planes','easy','fly','enjoyab le','wanted','info','pics','belongs','urrl','canon','g20','camcorder','forum','powerful',' nimble','lands','slow','yyyyeeeessss','hangar','field','guess','isn','answer','reason','ra zorback','idea','1100','people','opinion','settings','temporary','password','permanent','r ecognizing','temp','old','sign','wrong','su-35','spektrum','dx7','problem','thrust','vectoring','su','35','vids','owls','gotta','mmmmm m','zinc','chromate','cool','upgrade','strange','a-6','stock','12-blade','setup','jet','means','barn','burner','underpowered','scale-like','handles','key','max','4000mah','lipo','clean','fuel','tanks','anymore','bomb','rack s','configuration','flies','loop','walking','pace','full','minimal','thing','turns','rule' ,'excellent','scale','jon','person','lighting','thought','paint','looked','accurate','moti onrc','variations','color','rendering','cameras','sounds','assume','result','square','corn ered','boxes','best','first','longtime','rcg','pre-ordering','pre','ordering','hmmm','pass','letting','depends','doculam','carried','liabilit ies','heat','distortion','base','lower','hobby','iron','films','times','find','student','f igured','inlet','feed','larger','counter','productive','possibility','inrunner','probibly' ,'won','low','end','freewing-80m','-motors-black','mirage','2000','f5-es','1850kv','motors','pat','fed','heavier','batteries','upgrades','performance','variable s','conspire','remember','jets','review','wanting','faster','run','landings','guy','200',' mph','bounce','tip','shoot','runway','leave','impression','piloting','skills','90°','cross-wind','numbers','takes','80m','f5','cross','wind','military','service','nation','pnp','for mat','trust','pre-production','prototype','logged','hundreds','unit','fit','diameters','challenge','cg','bas ed','battery','compartment','non-scale','loops','inverted','issues','itching','nonstop','vertical','climbing','recommend',' 100a','production','96oz','6lb','dot','ds821','servos','5oz','ouch','olympus','90oz','5lb' ,'10oz','motor','esc','70a','pull','56a','1050w','nicely','5s','5000mah','zippy','hitech', 'save','3oz','75oz','recall','jr','center','money','70oz-in','torque','snow','night','simulator','practice','days','70oz','eager','report','angel', 'shadow','russian','thread','grossman','dig','records','codes','head','found','tamiya','ch rome','silver','code','x11','works','crow','ass','f-86','sabre','86','google','successfully','clicking','menu','chose','user','account','tab', 'enter','current','twice','verify','worked','doesn','database','finicky','encrypted','pass words','mark','check','youtu','7bspzs5wy0c','wisconsin','john','home','ghoststone','bajora ','straight','line','incorporates','minute','sedated','blueish','receiving','couldn','resi st','preordered','threw','p-51','wheels','mess','bigger','tires','mains','51','gman','jobs','sharp','cheated','ordered ','cal','layout','list','missing','gang','slowly','century','duchess','arlene','bbd','shan gri','hundred','log','books','managed','modifications','replacement','parts','happen','650 ','kv','start','counting','sunday','playing','game','breezy','arrived','bad','blow','sock' ,'ten','heavy','ago','van','respect','daryl','turned','headings','viewing','fill','wasn',' accepted','veiw','doc','west','updated','woohoo','tomorrow','petie','word','190s','shootin g','eye','reviewing','trouble','sorted','reset','worries','phone','lap','open','p38','4s', 'early','morning','contacting','system','properly','yesterday','a-10','mike','retro','calorr','html','t-6a','texan','force','1400','suspension','struts','training','appeal','feel','sell','manufa cture','flightline','brand','prop','tricycle','gear','deceived','control','smallest','poin t','ideas','accurizing','deadline','created','robert','resolution','original','1mb','accom modate','10mb','resize','jam','highly','recommended','area','worth','trip','team','regard' ,'handful','users','appears','guardian','eagletree','flaperons','6-axis','gyro','heading','auto-leveling','mode','moments','depending','transmitter','modes','flap','switch','programmed', 'three','remotely','controlled','choice','auto','level','3d','anti-turbulence','item','hard','beat','imo','price','axis','leveling','anti','turbulence','daun tless','sbd','picked','swap','meet','recently','caught','rut','ground','looped','broke','m as','piece','mods','question','iowa54','installed','chime','executed','cares','modern','er gonomics','classic','kraft','appealing','noted','doctormike','doors','noticed','plastic',' red','yellow','set','durable','wondering','fixing','notification','posts','subscribed','to pics','threads','individuals','email','address','preferences','making','notifications','sq uawk','panel','received','single','aware','issue','development','meantime','mentioned','em ails','inbox','removed','public','internet','unsolicited','prefer','older','style','txs',' metal','case','addressed','appeared','items','observed','recent','channel','show','unread' ,'long','taking','forever','flightlinerc','timed','seconds','figuring','ability','newest', 'versus','aussie','acknowledgement','retract','controller','contribution','august','postin g','referenced','postings','viable','lx','mention','option','aliexpress','grabbed','banana ','bananahobby','psearchqueryid','1671307','pcb','bhlxa10','multiplex','evo','thinner','tx ','indexable','gimbals','map','motion','thumbs','fingers','value','pinchers','intimate','r elationship','cradling','stick','corners','pressing','palms','added','benefit','grounding' ,'afforded','deck','push','signals','synthetic','aka','“dial','crash”','unfounded','term', 'reminds','machine','courtesy','jef','raskin','pioneers','putting','forefront','interface' ,'pll','algorithms','explained','mathematically','null','frequencies','17','hours','ready' ,'seat','yep','stuff','fix','dents','dings','transporting','minwax','measure','accurately' ,'rolleyes','picking','brains','1700mm','p-40','retracts','topic','blog','rcgroups','forums','php','311776','familiar','names','wet', 'pants','called','subscriptions','friend','apologize','inconveniences','migration','flick' ,'living','room','leak','powder','sink','handled','fresh','coat','form','truth','perfect', 'balance','super','sonic','built','precision','bomber','flier','radar','kinda','soup','eat ing','drop','perfection','rolls','semi','decent','knife','edge','clocked','18','guest','cr osswind','glide','feet','100','yard','circles','land','grass','success','flaw','wing','imm ediately','jumping','second','rcsound','beaver','space','limited','andy','significant','ca rving','seats','trade','places','yall','appreciates','place','share','knowledge','luck','i mpressive','actuating','deployed','sequencer','led','module','y-harnesses','sides','addition','flashing','outputs','remaining','dimensions','modules','fun ctionality','harnesses','owner','msg','today','mod','close','cowl','pandora','impressed',' skilled','haven','flow','building','airplanes','kid','1974','told','stare','beautiful','pr ivate','helicopter','started','father','owns','enstrom','f-28c','instructor','grown','college','campus','weather','arizona','helis','backyard','28c', 'my','russia','composite','amazing','quality','vladimir','shipped','san','francisco','seb art','distributor','reported','weeks','afraid','fair','amount','roads','packed','entire',' loaded','string','reduced','view','resulted','instructions','highlight','screen','conversa tion','detail','display','dropdown','choose','notice','normal','pages','bug','updates','re quests','primary','discuss','latest','fixes','relative','experience','continued','support' ,'tips','aros','trial','error','hobbysquawk','assistance','send','message','forgot','appar ently','biggie','differences','eventually','advantages','grossman56','pic','wow','wings',' aileron','trainer','ship','extended','simulators','helps','visual','clues','wash','warm',' sticks','sort','decal','sheets','cut','scalloping','hand','sized','circle','traced','sheet ','measured','width','busy','scissors','pieces','trailing','hornet','logo','net','simply', 'printed','clear','paper','wait','fantastic','charlie','micro','switches','bane','shocked' ,'learn','mechanical','contact','problems','effect','sensor','solution','controllers','hit s','brushes','holding','stalled','condition','worse','crushed','locking','bar','smashes',' running','adam','active','rctruth','shut','catch','bruce','simpson','saga','aggelos','job' ,'thinned','cardboard','laid','lines','sprayed','insignia','makes','specific','type','conv ersions','f-106','parked','f-104','t-33','f9f','panther','106','104','inch','corvalis','spacewalker','nemesis','thicker','ail', 'elv','throttle','carry','car','round','beer','cooler','sporty','pylon','racer','thrills', 'spills','distort','hurt','hot','water','sorts','strengthen','hate','input','hear','rct',' fold','drama','eps','epo','encourage','scientist','engineer','emotional','commitment','sys tematic','results','efforts','lol','incidents','ca','correct','experiment','funny','meant' ,'improved','eek','learned','everyday','smartphone','enable','regular','desktop','allowed' ,'adjust','tone','saves','ton','prepping','masking','areas','ga-ga','belong','crap','sites','contribute','balanced','70mm','explain','rearward','purposes' ,'reward','folding','important','information','explains','app','android','mobius','downloa d','experimenting','plugging','hour','free','easier','mind','paying','fee','buy','bought', 'changing','wanna','pita','unable','hs','steps','instructed','entered','details','forget', 'sensitive','entering','rush','probs','agree','apprentice','corsair','2nd','replies','brya n','touch','bill','rocketeer','heard','gal','lauren','joined','tremendously','varathane',' waterbase','protectant','requires','require','2-4','happened','links','suggested','products','rc-airplanes','propeller-airplanes','linked','longer','copy','paste','propeller','2009','1450mm','brings','memories ','totally','guessing','limiter','expensive','design','cases','experienced','shuts','minor ','binding','movement','actual','stall','currents','observation','circuits','strain','exte rnal','cnc','plates','003','004','etracts','aggressive','tightening','undue','friction','t runnion','pivot','pin','lock','slide','groove','plate','frustration','fully','understood', 'coupled','longevity','etract','life','repair','costs','modders','perspective','circuit',' card','initial','expenses','warbirds','modified','001','005','1600','birds','deal','mainte nance','expense','live','joy','confident','transited','hobbyzone','supercub','known','weed wacker','clarify','beginner','intermediate','wife','professional','instruction','nervous', 'chance','relax','ailerons','bat','hindsight','least','brought','landed','proof','matter', 'airplane','turn','final','establish','descent','nears','raise','pandoras','safety','recei ver','suppose','wacks','dealing','dragger','factor','street','road','al3','loved','respons e','gyros','adding','mix','confidence','stepped','p51','ease','consideration','levels','bu ild','dream','towels','wipe','drool','keyboard','missed','answering','occurred','kick','sc hedule','request','war','mustang','p-47','thunderbolt','decided','combine','talk','pictures','file','2mb','lots','friday','wait ed','install','ball','p51b','compared','struggle','changed','p51d','investment','canyank', 'canned','gold','stars','*****ed','degree','reference','designated','reflective','individu al','prefers','miss','twins','reasoning','rash','inappropriate','hyundai','genesis','coupe s','spacious','tdevince','corrected','cheaper','colouring','poor','qualities','door','pain ted','painters','colours','colour','darker','saving','cents','selling','4mb','mate','todd' ,'wheel','hub','graphic','darned','finding','kinds','unchecked','subscribe','pms','bold',' refresh','correctly','tracking','minutes','detailing','1600mm','beginning','potential','or der','accomplish','modeler','pop','moved','main','replaced','dubro','treaded','dark','mask ed','spray','cone','krylon','1030','5-10','chipping','propellers','brown','flat','guns','airbrushed','washes','turbochargers','m att','dry','chalks','depth','radio','weathered','face','inside','cowls','plan','fabricate' ,'quick-release','aerials','extend','stab','converging','stay','tuned','possibilities','quot','gun ','barrels','hollowed','equipment','removable','antenna','cockpit','tape','cylinder','subt le','weathering','turbocharger','gradually','natural','drybrushed','faded','panels','traff ic','wear','strut','release','neat','simpler','future','holds','t-cat','web','standards','includes','completely','responsive','front','grow','shrink','navig ate','portrait','narrow','usable','turning','sideways','landscape','graphics','stats','fee dback','cat','including','manually','backend','pattern','staff','settled','sincerely','650 kv','drilling','required','bang','buck','airzipper','zip','standard','donk','imagine','zer o','polishing','american','behold','separated','wingtip','servo','horn','hinges','ripped', 'warbird','bird','hinge','arrangement','balsa','transport','btw','ran','polyurethane','glu e','uhu','por','fond','flapping','bluenosers','feels','sorta','solid','forced','showing',' blokes','needless','reports','leaning','dday','stripes','sick','540kv','620','watts','soo' ,'keen','550','6s','vid','play','ipad','repost','thingy','sticker','hoping','damage','snag ged','moving','truck','faired','idiot','pay','attention','loading','unloading','shirty','n on-fms','separate','razor','reattached','glued','drill','hole','toothpick','pulling','loose', 'repeat','separating','signs','separation','include','covers','12c','direct','ramoser','de ','hobbies','slam','stupid','pissing','contest','diane','spring','pauly','designer','progr am','gather','fpv','month','kit','swapped','rock','selected','receive','likes','tablet','t itles','recorded','bunch','convenience','variants','re-maiden','comms','preorders','filled','la7','seafury','reached','raramsey331','hotmail','57 4','309','1921','orders','cold','released','tiger','moth','conscendo','p40b','capturing',' shots','fyi','screws','phillips','follow','jis','tighten','screwdrivers','screwdriver','tr ue','models','switching','socket','torx','valid','path','proper','length','diameter','beat en','1943','movie','chronicles','b-17','crew','note','footage','p-39','airacobra','favorite','5743091921','number','online','rough','f-102','thud','sea','fleet','102','marketing','concept','dumb','thumb','rarely','airframe',' damaged','survive','supplied','economically','replace','effort','recover','totaled','spare s','me-262','airframes','offered','purchases','banged','f5-e','pleasantly','rebuild','losses','improvements','replacements','beneficial','power-plant','crash','crushing','262','applied','spare','rotor','fod','ended','photo','6skd6l29d 6c','t6','yank','raf','scene','spits','hurri','adversaries','plenty','appearances','pre-order','kits','goodies','blood','chit','shirt','wristbands','extra','blades','f102','twin' ,'f101b','101b','present','challenges','foamie','unique','embedding','urls','vimeo','situa tion','exist','vbulletin','plug-in','embed','confess','plug','embedded','advanced','editor','insert','icon','reel','url',' increased','uploaded','thumbnail','gallery','subscription','reply','alerts','complex','res olve','incorrect','faves','manage','gorgeous','market','suggestions','removing','decals',' replacing','replicate','fhc','airbrush','powdered','graphite','fro','marks','streaks','lun ch','break','qxlk-xkkfvu','qxlk','xkkfvu','float','scenery','battle','britain','midway','hd','wide','monitor ','spitfires','hurricanes','spit','colors','hit','f-22','quad','b-1','swing','tomcat','saved','ha-ha','sr-71','f-117','b-2','shuttle','22','sr','71','117','hippie','winter','mini-8','advent','flip','screens','eyepiece','focused','steady','pressed','nowadays','track','a rms','sore','amazon','680','closer','800','b00awzfhg0','ref','sr_1_1','utf8','qid','145462 0103','8-1','keywords','mini','vixia','internal','memory','proportion','f-18','remake','offering','refused','purchase','la-7s','began','shipping','week','sound','fitting','tool','asia','screw','japanese','industri al','opposed','usa','manufactures','reed','prince','philips','fasteners','revlimiter','201 4','-screwdrivers','wikipedia','wiki','list_of_screw_drives','jit','drivers','house','sourced', 'tooling','budget','epoxy','film','ucontrol','zinger','leapin','lena','stuntwagon','jetex' ,'rocket','flybar---','burn','autorotate','ama','approve','series','lanier','arfs','fuselages','covered','core s','empennages','dynajet','part','hearing','loss','flybar','saturday','sunlight','vince',' cheers','lon','iphone','blue','offset','avatars','screwed','viewed','mobile','device','tak e-off','skids','high','efflux','fsa','voltage','dead','pits','crossbar','table','sheared','c anopy','plans','patterns','intersted','held','pitts','scratchbuilt','prompt','patient','ch ecking','upgrading','bugs','exorcised','retirement','donsrc','stellar','company','minds',' failures','tools','foundation','progress','grows','sill','wringing','varying','degrees','d efinite','season','wrapped','confidently','apply','method','skillset','f104','published',' aviation','closed','planned','aslo','attorney','files','paypal','complaint','lies','provin g','contrary','clue','messed','sold','claimed','defective','damages','refund','admitted',' letter','demanding','sue','defamation','character','terms','claims','court','washington',' misrepresentation','failure','supply','warranty','nut','banned','multiple','gave','account s','usernames','transaction','ruled','rules','reverse','threatened','legal','action','ban' ,'straw','behavior','sit','re-evaluate','nasty','dad','ultralight','business','states','defend','000','1000','lawsuit',' guide','settle','aggravation','pulled','months','bittersweet','speak','news','jay','smith' ,'column','park','magazine','rubber','band','quarterly','geared','product','fits','hanging ','evaluate','hubs','board','cars','weak','acrylic','lay','hair','dryer','carefully','caut ion','careful','layers','broken','hesitant','shangrila','billings','depot','lowes','coats' ,'party','okkkk','searched','explored','access','configured','handy','dandy','holder','str apped','bed','pickup','2x6','infront','gate','fat','elastic','bands','fuse','wyoming','pur posely','pylons','strap','aft','remove','fancy','bungee','chord','looping','locked','ignor e','felt','angry','chatting','experiences','group','itchy','sim','48','compressor','nozzle ','cracked','alternative','spectacular','hellcat','hands','rail','wonderfully','windy','he lped','compensate','gusts','ounces','target','stickey','blinking','signify','pvc','alot',' talent','lucky','formula','2-bladed','3-bladed','pitch','x7','chart','bladed','liking','tweaks','happening','everytime','higher',' askin','cannon','rebel','capable','finder','repaint','robin','olds','scat','iii','masters' ,'g58','g59','needles','converted','hesitate','dslr','extenders','cups','essentially','vie wfinder','comments','hadn','late','2015','compliment','owning','repainting','waiting','bre aks','admit','circus','paintings','frustrating','pick','sunny','lapse','7oslbgtgu44','scro ll','cup','block','eliminate','glare','rocks','manual','comparison','restore','stories','t all','bearcat','wwii','korea','overlooked','warrior','2016','70th','anniversary','angels', 'demonstration','care','protective','coating','valspar','olwarbirds','mot','d-requests-etc','create','banner','offer','situations','cement','medium','bead','approx','2mm','16in' ,'1min','15mins','connect','pushrod','clevis','foamies','watched','viedeo','rich','rcinfor mer','capture','sticky','moderators','admins','messages','stickys','communicate','attached ','picture','emailed','hopeful','god','continue','accept','kicking','attempt','blowing','d og','chain','count','requested','provider','inconvenience','tnx','attachments','awhile','m aidend','lost','sweetheart','planning','davenport','kevin','checked','enabled','automatica lly','unsubscribe','activities','orange','ish','rake','supports','rear','straighten','ends ','fellas','dodgy','perth','spin','nailed','reckon','crabbing','110f','imperial','total',' fire','due','risk','con','swimming','pools','browser','attachment','moment','clicked','com prising','giant','showed','step','locate','arrow','tabs','privacy','subcategory','listed', 'activity','continuously','bugging','adv','troubleshoot','misunderstanding','boards','isol ated','starting','markymark','replied','logging','microsoft','cookie','javascript','lackin g','acess','crazy','huh','woodie','tied','safari','browsers','editing','existing','apple', 'expected','surmise','ios','devices','developers','common','denominator','grief','fwiw','f irefox','ff','phoenix','bee','finished','cell','calls','sport','wingspan','459','additiona l','a-4','skyhawk','super-scale','marine','hump','navy','configurations','guaranteed','bucket','marines','versions', 'korean','vietnam','f9fs','suffered','lack','china','lake','confusing','bob','enthusiasts' ,'wrap','article','renewed','sfo','bay','sneak','peek','march','joint','writer','onboard', 'lens','cradle','sunk','holes','directly','hardpoint','countersunk','peasy','shelters','co ncrete','fueling','startup','turbine','hmmmmm','forgotten','seagull','rig','north','sonoma ','county','8-11am','11am','chatter','large','widespread','win','wood','sets','tension','wire','material ','inventory','intend','arrival','shipment','torment','excited','delivered','setups','viny l','extremely','fortunate','anticipating','outing','wake','submitted','fantastically','non-subscribers','digital','print','subscribers','beast','focusing','ring','nah','signing','en counter','stumbling','world','feeling','outfitted','dslrs','diopter','reluctant','attach', 'included','glass','overlay','body','double','sided','serves','bonus','protection','lcd',' magnification','focus','bow','adept','chief','wishlist','backstory','unfortunate','underst and','hurts','hounded','lining','loving','speaking','overseeing','media','initiatives','fo reseeable','partnerships','major','publications','component','congratulations','appointmen t','frequent','function','structure','extreme','aerobatics','suffer','precisionaerobatics' ,'index','extremeflightrc','robust','weights','rc-','5-wingspan-pnp','shop','runways','abandoned','plunge','destroying','repeatedly','nosing','closely','p arkzone','cub','choices','comment','wires','loosened','props','hint','oh-58d','kiowa','ah-1f','cobras','uh-1','huey','oh-58','seasons','sight-seeing','tours','smoky','mountains','bell','rangers','germany','east','border','opened','d esert','storm','kosovo','oif','5000','hang','medical','reasons','duke','serbia','58d','sig ht','underground','wunderground','stations','mile','real-time','forecasts','onlineconversion','convert','grams','millimeters','inches','thank-you','alph','shout','customer','randy','rivers','stuka82','knology','trainers','attending' ,'pusher','beginners','kids','games','transition','sales','dropped','50-64mm','units','significantly','edfs','affordable','worst','earned','sucks','frequently','l andfill','strip','_dkixuulfws','rolled','900','fairway','golf','50','64mm','tinkering','70 ','previous','firmware','125amp','gecko','85amp','resolved','members','jack','closing','te chnical','inquiries','64','mm','runner','combo','comparable','3500kv','12blade','pitched', 'whine','organic','runners','flys','maneuver','wedge','fuselage','effected','gripe','slabs ','badly','warped','cured','eli','royal','maces','a-18','balances','perfectly','admiral','50c','pushed','adequate','climb','rate','candidate', 'launch','accomodate','similar','jeez','kidding','keeping','callie','loooonnnngggg','mold' ,'ipa','bind','gluing','packing','bent','180','peeled','ice','household','latex','hide','b eads','waco','shine','armor','wax','dave','patterned','scott','spinner','scans','mixed','m aximum','concern','danloc','unsure','nosed','difficult','weakness','shaft','mid','locktite d','panic','collected','wits','proceeded','successful','speaks','volumes','flyablity','hec k','tough','spots','hammer','memorize','approach','25-30','chop','loves','lined','corrections','easing','touchdown','bump','airborne','flipping' ,'kindly','laugh','motionr','blame','recommendations','personal','decorated','syllables',' paintwork','wiggled','afford','tails','freewing-reb','m-edf-jet-pnp','basic','hershey','great-planes','-wingspan-rxr','e-flite-puls','-wingspan-pnp','dynam','meteor','reb','rxr','flite','puls','discharge','station','schematic','notes' ,'photobucket','s282','blackstar_1961','library','20discharge','lingo','wattmeter','diffic ulties','upside','vtif6szr-xs','vtif6szr','fa18','performs','noseart','installing','friendly','reminder','brother','l ubricate','builder','petroleum','jelly','balsas','vaseline','30min','silicon','foamy','con tacted','vendor','assign','developer','investigate','shortly','complexity','1st','p-61','mantra','popular','seldom','modeled','2000mm','category','rattler','desire','uncheck' ,'smart','b-day','fear','age','date','birth','crusty','suggest','buying','signatures','registered','se ction','labeled','automatic','crossroad','limitations','rotten','audio','shallow','record' ,'rolling','shutter','blurred','background','focuses','suck','f-stop','zoom','moves','causing','3inch','indication','subject','crybabies','grounds','flowe r','tree','object','sensors','harder','hunting','yuck','upset','selection','shell','mercy' ,'cope','filming','aperture','zooming','stable','stopped','cinema','shake','bars','grading ','strong','southerlies','rain','washout','alarm','forecast','sleep','astray','dollars','f ailed','cycle','command','cycling','pearler','prevalent','six','cards','preflight','checks ','sony','a6000','mentioning','successor','a6300','dpreview','sonys','tempting','invested' ,'411','sitting','functional','indoor','j3','completed','workbench','alternate','perspecti ves','opinions','browse','mileage','signature','twenty','reverts','gross','underneath','re verting','unedited','claim','on','prob','haaarrr','b17s','martin','caiden','wrote','book', 'flak','tells','tale','resurrecting','england','lover','falling','boys','clip','bastards', 'swear','chunk','fighters','texas','owned','fellows','reaching','hasn','me109s','disassemb led','restorers','spitfire','fact','liquitex','realize','tubes','interesting','supposedly' ,'canopies','boy','dedicated','dx8','safer','rigged','accident','procedure','purchased','d x6','programed','cuts','envy','smoothly','opening','stiff','over-work','thin','pinned','crossways');
exception_trace
***************** end of error ************
I tried to rebuild several times and it keeps dying near 18,000 records. I have memory set to 256M. I have tried indexing 100, 500, 1000 records at one time and it keeps dying at 18000
Second method I tried was using the command line
I ran the following in Centos Linux:
php searchindex.php
I then entered the path to my files, and the system returned this error:
PHP Parse error: syntax error, unexpected '>' in /var/www/vhosts/hobbysquawk.com/vbulletin/core/vb/library/node.php on line 1789
I looked at the file and this is what i found:
1789: usort($attachments, function($a, $b) {return $a['displayorder'] <=> $b['displayorder'];});
VB support said that the code above is correct, so I have no idea where to go from here.
My Maria DB and PHP specs are in my signature. Any help from VB support or the community would be greatly appreciated.
Mark
First method I tried was via Admin CP
at approx 18000 items the search throws the following error:
********* Begin error capture **************
Error Invalid SQL: SELECT * FROM words WHERE `word` IN ('yeah','data','platform','migrations','aren','smooth','one','hope','techone','air','titan ','big','bright','plane','great','handling','wider','range','flight','conditions','smaller ','fms','firefly','compact','environments','glad','give','us','pilots','options','sizes',' pricepoints','man','alpha','electric','festival','meeting','attend','day','asst','guys','m rc','sending','last','weekend','february','http','azelectricfestival','org','brandon','upp er','window','select','profile','left','side','avatar','hover','mouse','edit','button','cl ick','upload','new','image','make','promises','working','two','superstition','year','featu re','me','p-40b','40b','1400mm','fw','90mm','f-15','burners','15','photos','want','work','surprised','delay','good','test','post','huge', 'software','update','didn','link','retired','december','better','spend','city','short','dr ive','viva','las','vegas','finally','flew','10','packs','2200','2500','needed','nose','wei ght','3000','3600','fine','cowling','overs','learning','power','landing','till','made','ta il','stuck','half','fun','flyer','load','figure','site','www','valleyflyers','club','websi te','event','poster','bottom','page','testesteteststst','asked','umbrella','markings','all ied','green','bobcat','nacelle','kill','notated','top','cover','aircraft','p-38s','shown','use','marking','depicting','cane','hat','fighter','escort','bombers','broom' ,'cap','mission','types','variety','targets','missions','four','aerial','victories','swast ikas','38s','pilot','ryan','thrill','honor','enjoying','flying','nice','buddy','presentati on','enjoy','things','whim','folks','giving','back','talents','rc','community','modeling', 'cherish','hold','dear','personally','mine','title','retractable','light','modification',' exhaust','manifold','eyes','used','flown','trim','add','bit','flaps','positions','trimmed' ,'tendency','roll','thinking','plains','slightly','sync','slight','difference','lot','surf ace','travel','adjustment','move','elevator','zeroed','fast','surfaces','stop','arguing',' slows','don','off','pleanty','speed','quickly','anxious','stretch','skill','match','forwar d','bring','anticipation','delivery','overwhelming','reading','history','purpose','tactics ','theaters','painting','black','white','strips','help','stand','videos','awesome','https' ,'youtube','watch','3y-rmagfxjs','rmagfxjs','80mm','edf','vs','freewing','a6','intruder','model','12','blade','du cted','fan','weaken','foam','frame','abilities','questionable','read','couple','reviews',' claiming','powered','plant','knows','spent','years','a6a','avionics','know','designed','ha ll','28','500','pounders','14000','lbs','hi-speed','provide','maneuverability','thoughts','advice','greatly','appreciated','advance',' skip','static','shot','p-38','38','size','increase','default','setting','waaaay','small','simple','change','admin', 'hardcode','tweaked','edited','css','rest','assured','features','fixed','asap','coming','a ccomplished','junior','member','happy','join','flights','t-45','mg-we6bbde4','doug','mg','we6bbde4','video','quick','overview','demo','xk6stui-alm','xk6stui','alm','assembly','decaling','shows','fairly','straightforward','process','c vd9nthz7s4','la-7','easily','put','boring','most','presented','real','time','sense','box','t4xib9xqaaw','l a','covering','hey','konrad','laminate','wouldn','sharing','wondered','kind','camera','loo kin','pretty','dang','sweet','call','earlier','questions','administrator','hawksky','v2',' spoke','talking','love','version','maiden','past','anytime','planes','easy','fly','enjoyab le','wanted','info','pics','belongs','urrl','canon','g20','camcorder','forum','powerful',' nimble','lands','slow','yyyyeeeessss','hangar','field','guess','isn','answer','reason','ra zorback','idea','1100','people','opinion','settings','temporary','password','permanent','r ecognizing','temp','old','sign','wrong','su-35','spektrum','dx7','problem','thrust','vectoring','su','35','vids','owls','gotta','mmmmm m','zinc','chromate','cool','upgrade','strange','a-6','stock','12-blade','setup','jet','means','barn','burner','underpowered','scale-like','handles','key','max','4000mah','lipo','clean','fuel','tanks','anymore','bomb','rack s','configuration','flies','loop','walking','pace','full','minimal','thing','turns','rule' ,'excellent','scale','jon','person','lighting','thought','paint','looked','accurate','moti onrc','variations','color','rendering','cameras','sounds','assume','result','square','corn ered','boxes','best','first','longtime','rcg','pre-ordering','pre','ordering','hmmm','pass','letting','depends','doculam','carried','liabilit ies','heat','distortion','base','lower','hobby','iron','films','times','find','student','f igured','inlet','feed','larger','counter','productive','possibility','inrunner','probibly' ,'won','low','end','freewing-80m','-motors-black','mirage','2000','f5-es','1850kv','motors','pat','fed','heavier','batteries','upgrades','performance','variable s','conspire','remember','jets','review','wanting','faster','run','landings','guy','200',' mph','bounce','tip','shoot','runway','leave','impression','piloting','skills','90°','cross-wind','numbers','takes','80m','f5','cross','wind','military','service','nation','pnp','for mat','trust','pre-production','prototype','logged','hundreds','unit','fit','diameters','challenge','cg','bas ed','battery','compartment','non-scale','loops','inverted','issues','itching','nonstop','vertical','climbing','recommend',' 100a','production','96oz','6lb','dot','ds821','servos','5oz','ouch','olympus','90oz','5lb' ,'10oz','motor','esc','70a','pull','56a','1050w','nicely','5s','5000mah','zippy','hitech', 'save','3oz','75oz','recall','jr','center','money','70oz-in','torque','snow','night','simulator','practice','days','70oz','eager','report','angel', 'shadow','russian','thread','grossman','dig','records','codes','head','found','tamiya','ch rome','silver','code','x11','works','crow','ass','f-86','sabre','86','google','successfully','clicking','menu','chose','user','account','tab', 'enter','current','twice','verify','worked','doesn','database','finicky','encrypted','pass words','mark','check','youtu','7bspzs5wy0c','wisconsin','john','home','ghoststone','bajora ','straight','line','incorporates','minute','sedated','blueish','receiving','couldn','resi st','preordered','threw','p-51','wheels','mess','bigger','tires','mains','51','gman','jobs','sharp','cheated','ordered ','cal','layout','list','missing','gang','slowly','century','duchess','arlene','bbd','shan gri','hundred','log','books','managed','modifications','replacement','parts','happen','650 ','kv','start','counting','sunday','playing','game','breezy','arrived','bad','blow','sock' ,'ten','heavy','ago','van','respect','daryl','turned','headings','viewing','fill','wasn',' accepted','veiw','doc','west','updated','woohoo','tomorrow','petie','word','190s','shootin g','eye','reviewing','trouble','sorted','reset','worries','phone','lap','open','p38','4s', 'early','morning','contacting','system','properly','yesterday','a-10','mike','retro','calorr','html','t-6a','texan','force','1400','suspension','struts','training','appeal','feel','sell','manufa cture','flightline','brand','prop','tricycle','gear','deceived','control','smallest','poin t','ideas','accurizing','deadline','created','robert','resolution','original','1mb','accom modate','10mb','resize','jam','highly','recommended','area','worth','trip','team','regard' ,'handful','users','appears','guardian','eagletree','flaperons','6-axis','gyro','heading','auto-leveling','mode','moments','depending','transmitter','modes','flap','switch','programmed', 'three','remotely','controlled','choice','auto','level','3d','anti-turbulence','item','hard','beat','imo','price','axis','leveling','anti','turbulence','daun tless','sbd','picked','swap','meet','recently','caught','rut','ground','looped','broke','m as','piece','mods','question','iowa54','installed','chime','executed','cares','modern','er gonomics','classic','kraft','appealing','noted','doctormike','doors','noticed','plastic',' red','yellow','set','durable','wondering','fixing','notification','posts','subscribed','to pics','threads','individuals','email','address','preferences','making','notifications','sq uawk','panel','received','single','aware','issue','development','meantime','mentioned','em ails','inbox','removed','public','internet','unsolicited','prefer','older','style','txs',' metal','case','addressed','appeared','items','observed','recent','channel','show','unread' ,'long','taking','forever','flightlinerc','timed','seconds','figuring','ability','newest', 'versus','aussie','acknowledgement','retract','controller','contribution','august','postin g','referenced','postings','viable','lx','mention','option','aliexpress','grabbed','banana ','bananahobby','psearchqueryid','1671307','pcb','bhlxa10','multiplex','evo','thinner','tx ','indexable','gimbals','map','motion','thumbs','fingers','value','pinchers','intimate','r elationship','cradling','stick','corners','pressing','palms','added','benefit','grounding' ,'afforded','deck','push','signals','synthetic','aka','“dial','crash”','unfounded','term', 'reminds','machine','courtesy','jef','raskin','pioneers','putting','forefront','interface' ,'pll','algorithms','explained','mathematically','null','frequencies','17','hours','ready' ,'seat','yep','stuff','fix','dents','dings','transporting','minwax','measure','accurately' ,'rolleyes','picking','brains','1700mm','p-40','retracts','topic','blog','rcgroups','forums','php','311776','familiar','names','wet', 'pants','called','subscriptions','friend','apologize','inconveniences','migration','flick' ,'living','room','leak','powder','sink','handled','fresh','coat','form','truth','perfect', 'balance','super','sonic','built','precision','bomber','flier','radar','kinda','soup','eat ing','drop','perfection','rolls','semi','decent','knife','edge','clocked','18','guest','cr osswind','glide','feet','100','yard','circles','land','grass','success','flaw','wing','imm ediately','jumping','second','rcsound','beaver','space','limited','andy','significant','ca rving','seats','trade','places','yall','appreciates','place','share','knowledge','luck','i mpressive','actuating','deployed','sequencer','led','module','y-harnesses','sides','addition','flashing','outputs','remaining','dimensions','modules','fun ctionality','harnesses','owner','msg','today','mod','close','cowl','pandora','impressed',' skilled','haven','flow','building','airplanes','kid','1974','told','stare','beautiful','pr ivate','helicopter','started','father','owns','enstrom','f-28c','instructor','grown','college','campus','weather','arizona','helis','backyard','28c', 'my','russia','composite','amazing','quality','vladimir','shipped','san','francisco','seb art','distributor','reported','weeks','afraid','fair','amount','roads','packed','entire',' loaded','string','reduced','view','resulted','instructions','highlight','screen','conversa tion','detail','display','dropdown','choose','notice','normal','pages','bug','updates','re quests','primary','discuss','latest','fixes','relative','experience','continued','support' ,'tips','aros','trial','error','hobbysquawk','assistance','send','message','forgot','appar ently','biggie','differences','eventually','advantages','grossman56','pic','wow','wings',' aileron','trainer','ship','extended','simulators','helps','visual','clues','wash','warm',' sticks','sort','decal','sheets','cut','scalloping','hand','sized','circle','traced','sheet ','measured','width','busy','scissors','pieces','trailing','hornet','logo','net','simply', 'printed','clear','paper','wait','fantastic','charlie','micro','switches','bane','shocked' ,'learn','mechanical','contact','problems','effect','sensor','solution','controllers','hit s','brushes','holding','stalled','condition','worse','crushed','locking','bar','smashes',' running','adam','active','rctruth','shut','catch','bruce','simpson','saga','aggelos','job' ,'thinned','cardboard','laid','lines','sprayed','insignia','makes','specific','type','conv ersions','f-106','parked','f-104','t-33','f9f','panther','106','104','inch','corvalis','spacewalker','nemesis','thicker','ail', 'elv','throttle','carry','car','round','beer','cooler','sporty','pylon','racer','thrills', 'spills','distort','hurt','hot','water','sorts','strengthen','hate','input','hear','rct',' fold','drama','eps','epo','encourage','scientist','engineer','emotional','commitment','sys tematic','results','efforts','lol','incidents','ca','correct','experiment','funny','meant' ,'improved','eek','learned','everyday','smartphone','enable','regular','desktop','allowed' ,'adjust','tone','saves','ton','prepping','masking','areas','ga-ga','belong','crap','sites','contribute','balanced','70mm','explain','rearward','purposes' ,'reward','folding','important','information','explains','app','android','mobius','downloa d','experimenting','plugging','hour','free','easier','mind','paying','fee','buy','bought', 'changing','wanna','pita','unable','hs','steps','instructed','entered','details','forget', 'sensitive','entering','rush','probs','agree','apprentice','corsair','2nd','replies','brya n','touch','bill','rocketeer','heard','gal','lauren','joined','tremendously','varathane',' waterbase','protectant','requires','require','2-4','happened','links','suggested','products','rc-airplanes','propeller-airplanes','linked','longer','copy','paste','propeller','2009','1450mm','brings','memories ','totally','guessing','limiter','expensive','design','cases','experienced','shuts','minor ','binding','movement','actual','stall','currents','observation','circuits','strain','exte rnal','cnc','plates','003','004','etracts','aggressive','tightening','undue','friction','t runnion','pivot','pin','lock','slide','groove','plate','frustration','fully','understood', 'coupled','longevity','etract','life','repair','costs','modders','perspective','circuit',' card','initial','expenses','warbirds','modified','001','005','1600','birds','deal','mainte nance','expense','live','joy','confident','transited','hobbyzone','supercub','known','weed wacker','clarify','beginner','intermediate','wife','professional','instruction','nervous', 'chance','relax','ailerons','bat','hindsight','least','brought','landed','proof','matter', 'airplane','turn','final','establish','descent','nears','raise','pandoras','safety','recei ver','suppose','wacks','dealing','dragger','factor','street','road','al3','loved','respons e','gyros','adding','mix','confidence','stepped','p51','ease','consideration','levels','bu ild','dream','towels','wipe','drool','keyboard','missed','answering','occurred','kick','sc hedule','request','war','mustang','p-47','thunderbolt','decided','combine','talk','pictures','file','2mb','lots','friday','wait ed','install','ball','p51b','compared','struggle','changed','p51d','investment','canyank', 'canned','gold','stars','*****ed','degree','reference','designated','reflective','individu al','prefers','miss','twins','reasoning','rash','inappropriate','hyundai','genesis','coupe s','spacious','tdevince','corrected','cheaper','colouring','poor','qualities','door','pain ted','painters','colours','colour','darker','saving','cents','selling','4mb','mate','todd' ,'wheel','hub','graphic','darned','finding','kinds','unchecked','subscribe','pms','bold',' refresh','correctly','tracking','minutes','detailing','1600mm','beginning','potential','or der','accomplish','modeler','pop','moved','main','replaced','dubro','treaded','dark','mask ed','spray','cone','krylon','1030','5-10','chipping','propellers','brown','flat','guns','airbrushed','washes','turbochargers','m att','dry','chalks','depth','radio','weathered','face','inside','cowls','plan','fabricate' ,'quick-release','aerials','extend','stab','converging','stay','tuned','possibilities','quot','gun ','barrels','hollowed','equipment','removable','antenna','cockpit','tape','cylinder','subt le','weathering','turbocharger','gradually','natural','drybrushed','faded','panels','traff ic','wear','strut','release','neat','simpler','future','holds','t-cat','web','standards','includes','completely','responsive','front','grow','shrink','navig ate','portrait','narrow','usable','turning','sideways','landscape','graphics','stats','fee dback','cat','including','manually','backend','pattern','staff','settled','sincerely','650 kv','drilling','required','bang','buck','airzipper','zip','standard','donk','imagine','zer o','polishing','american','behold','separated','wingtip','servo','horn','hinges','ripped', 'warbird','bird','hinge','arrangement','balsa','transport','btw','ran','polyurethane','glu e','uhu','por','fond','flapping','bluenosers','feels','sorta','solid','forced','showing',' blokes','needless','reports','leaning','dday','stripes','sick','540kv','620','watts','soo' ,'keen','550','6s','vid','play','ipad','repost','thingy','sticker','hoping','damage','snag ged','moving','truck','faired','idiot','pay','attention','loading','unloading','shirty','n on-fms','separate','razor','reattached','glued','drill','hole','toothpick','pulling','loose', 'repeat','separating','signs','separation','include','covers','12c','direct','ramoser','de ','hobbies','slam','stupid','pissing','contest','diane','spring','pauly','designer','progr am','gather','fpv','month','kit','swapped','rock','selected','receive','likes','tablet','t itles','recorded','bunch','convenience','variants','re-maiden','comms','preorders','filled','la7','seafury','reached','raramsey331','hotmail','57 4','309','1921','orders','cold','released','tiger','moth','conscendo','p40b','capturing',' shots','fyi','screws','phillips','follow','jis','tighten','screwdrivers','screwdriver','tr ue','models','switching','socket','torx','valid','path','proper','length','diameter','beat en','1943','movie','chronicles','b-17','crew','note','footage','p-39','airacobra','favorite','5743091921','number','online','rough','f-102','thud','sea','fleet','102','marketing','concept','dumb','thumb','rarely','airframe',' damaged','survive','supplied','economically','replace','effort','recover','totaled','spare s','me-262','airframes','offered','purchases','banged','f5-e','pleasantly','rebuild','losses','improvements','replacements','beneficial','power-plant','crash','crushing','262','applied','spare','rotor','fod','ended','photo','6skd6l29d 6c','t6','yank','raf','scene','spits','hurri','adversaries','plenty','appearances','pre-order','kits','goodies','blood','chit','shirt','wristbands','extra','blades','f102','twin' ,'f101b','101b','present','challenges','foamie','unique','embedding','urls','vimeo','situa tion','exist','vbulletin','plug-in','embed','confess','plug','embedded','advanced','editor','insert','icon','reel','url',' increased','uploaded','thumbnail','gallery','subscription','reply','alerts','complex','res olve','incorrect','faves','manage','gorgeous','market','suggestions','removing','decals',' replacing','replicate','fhc','airbrush','powdered','graphite','fro','marks','streaks','lun ch','break','qxlk-xkkfvu','qxlk','xkkfvu','float','scenery','battle','britain','midway','hd','wide','monitor ','spitfires','hurricanes','spit','colors','hit','f-22','quad','b-1','swing','tomcat','saved','ha-ha','sr-71','f-117','b-2','shuttle','22','sr','71','117','hippie','winter','mini-8','advent','flip','screens','eyepiece','focused','steady','pressed','nowadays','track','a rms','sore','amazon','680','closer','800','b00awzfhg0','ref','sr_1_1','utf8','qid','145462 0103','8-1','keywords','mini','vixia','internal','memory','proportion','f-18','remake','offering','refused','purchase','la-7s','began','shipping','week','sound','fitting','tool','asia','screw','japanese','industri al','opposed','usa','manufactures','reed','prince','philips','fasteners','revlimiter','201 4','-screwdrivers','wikipedia','wiki','list_of_screw_drives','jit','drivers','house','sourced', 'tooling','budget','epoxy','film','ucontrol','zinger','leapin','lena','stuntwagon','jetex' ,'rocket','flybar---','burn','autorotate','ama','approve','series','lanier','arfs','fuselages','covered','core s','empennages','dynajet','part','hearing','loss','flybar','saturday','sunlight','vince',' cheers','lon','iphone','blue','offset','avatars','screwed','viewed','mobile','device','tak e-off','skids','high','efflux','fsa','voltage','dead','pits','crossbar','table','sheared','c anopy','plans','patterns','intersted','held','pitts','scratchbuilt','prompt','patient','ch ecking','upgrading','bugs','exorcised','retirement','donsrc','stellar','company','minds',' failures','tools','foundation','progress','grows','sill','wringing','varying','degrees','d efinite','season','wrapped','confidently','apply','method','skillset','f104','published',' aviation','closed','planned','aslo','attorney','files','paypal','complaint','lies','provin g','contrary','clue','messed','sold','claimed','defective','damages','refund','admitted',' letter','demanding','sue','defamation','character','terms','claims','court','washington',' misrepresentation','failure','supply','warranty','nut','banned','multiple','gave','account s','usernames','transaction','ruled','rules','reverse','threatened','legal','action','ban' ,'straw','behavior','sit','re-evaluate','nasty','dad','ultralight','business','states','defend','000','1000','lawsuit',' guide','settle','aggravation','pulled','months','bittersweet','speak','news','jay','smith' ,'column','park','magazine','rubber','band','quarterly','geared','product','fits','hanging ','evaluate','hubs','board','cars','weak','acrylic','lay','hair','dryer','carefully','caut ion','careful','layers','broken','hesitant','shangrila','billings','depot','lowes','coats' ,'party','okkkk','searched','explored','access','configured','handy','dandy','holder','str apped','bed','pickup','2x6','infront','gate','fat','elastic','bands','fuse','wyoming','pur posely','pylons','strap','aft','remove','fancy','bungee','chord','looping','locked','ignor e','felt','angry','chatting','experiences','group','itchy','sim','48','compressor','nozzle ','cracked','alternative','spectacular','hellcat','hands','rail','wonderfully','windy','he lped','compensate','gusts','ounces','target','stickey','blinking','signify','pvc','alot',' talent','lucky','formula','2-bladed','3-bladed','pitch','x7','chart','bladed','liking','tweaks','happening','everytime','higher',' askin','cannon','rebel','capable','finder','repaint','robin','olds','scat','iii','masters' ,'g58','g59','needles','converted','hesitate','dslr','extenders','cups','essentially','vie wfinder','comments','hadn','late','2015','compliment','owning','repainting','waiting','bre aks','admit','circus','paintings','frustrating','pick','sunny','lapse','7oslbgtgu44','scro ll','cup','block','eliminate','glare','rocks','manual','comparison','restore','stories','t all','bearcat','wwii','korea','overlooked','warrior','2016','70th','anniversary','angels', 'demonstration','care','protective','coating','valspar','olwarbirds','mot','d-requests-etc','create','banner','offer','situations','cement','medium','bead','approx','2mm','16in' ,'1min','15mins','connect','pushrod','clevis','foamies','watched','viedeo','rich','rcinfor mer','capture','sticky','moderators','admins','messages','stickys','communicate','attached ','picture','emailed','hopeful','god','continue','accept','kicking','attempt','blowing','d og','chain','count','requested','provider','inconvenience','tnx','attachments','awhile','m aidend','lost','sweetheart','planning','davenport','kevin','checked','enabled','automatica lly','unsubscribe','activities','orange','ish','rake','supports','rear','straighten','ends ','fellas','dodgy','perth','spin','nailed','reckon','crabbing','110f','imperial','total',' fire','due','risk','con','swimming','pools','browser','attachment','moment','clicked','com prising','giant','showed','step','locate','arrow','tabs','privacy','subcategory','listed', 'activity','continuously','bugging','adv','troubleshoot','misunderstanding','boards','isol ated','starting','markymark','replied','logging','microsoft','cookie','javascript','lackin g','acess','crazy','huh','woodie','tied','safari','browsers','editing','existing','apple', 'expected','surmise','ios','devices','developers','common','denominator','grief','fwiw','f irefox','ff','phoenix','bee','finished','cell','calls','sport','wingspan','459','additiona l','a-4','skyhawk','super-scale','marine','hump','navy','configurations','guaranteed','bucket','marines','versions', 'korean','vietnam','f9fs','suffered','lack','china','lake','confusing','bob','enthusiasts' ,'wrap','article','renewed','sfo','bay','sneak','peek','march','joint','writer','onboard', 'lens','cradle','sunk','holes','directly','hardpoint','countersunk','peasy','shelters','co ncrete','fueling','startup','turbine','hmmmmm','forgotten','seagull','rig','north','sonoma ','county','8-11am','11am','chatter','large','widespread','win','wood','sets','tension','wire','material ','inventory','intend','arrival','shipment','torment','excited','delivered','setups','viny l','extremely','fortunate','anticipating','outing','wake','submitted','fantastically','non-subscribers','digital','print','subscribers','beast','focusing','ring','nah','signing','en counter','stumbling','world','feeling','outfitted','dslrs','diopter','reluctant','attach', 'included','glass','overlay','body','double','sided','serves','bonus','protection','lcd',' magnification','focus','bow','adept','chief','wishlist','backstory','unfortunate','underst and','hurts','hounded','lining','loving','speaking','overseeing','media','initiatives','fo reseeable','partnerships','major','publications','component','congratulations','appointmen t','frequent','function','structure','extreme','aerobatics','suffer','precisionaerobatics' ,'index','extremeflightrc','robust','weights','rc-','5-wingspan-pnp','shop','runways','abandoned','plunge','destroying','repeatedly','nosing','closely','p arkzone','cub','choices','comment','wires','loosened','props','hint','oh-58d','kiowa','ah-1f','cobras','uh-1','huey','oh-58','seasons','sight-seeing','tours','smoky','mountains','bell','rangers','germany','east','border','opened','d esert','storm','kosovo','oif','5000','hang','medical','reasons','duke','serbia','58d','sig ht','underground','wunderground','stations','mile','real-time','forecasts','onlineconversion','convert','grams','millimeters','inches','thank-you','alph','shout','customer','randy','rivers','stuka82','knology','trainers','attending' ,'pusher','beginners','kids','games','transition','sales','dropped','50-64mm','units','significantly','edfs','affordable','worst','earned','sucks','frequently','l andfill','strip','_dkixuulfws','rolled','900','fairway','golf','50','64mm','tinkering','70 ','previous','firmware','125amp','gecko','85amp','resolved','members','jack','closing','te chnical','inquiries','64','mm','runner','combo','comparable','3500kv','12blade','pitched', 'whine','organic','runners','flys','maneuver','wedge','fuselage','effected','gripe','slabs ','badly','warped','cured','eli','royal','maces','a-18','balances','perfectly','admiral','50c','pushed','adequate','climb','rate','candidate', 'launch','accomodate','similar','jeez','kidding','keeping','callie','loooonnnngggg','mold' ,'ipa','bind','gluing','packing','bent','180','peeled','ice','household','latex','hide','b eads','waco','shine','armor','wax','dave','patterned','scott','spinner','scans','mixed','m aximum','concern','danloc','unsure','nosed','difficult','weakness','shaft','mid','locktite d','panic','collected','wits','proceeded','successful','speaks','volumes','flyablity','hec k','tough','spots','hammer','memorize','approach','25-30','chop','loves','lined','corrections','easing','touchdown','bump','airborne','flipping' ,'kindly','laugh','motionr','blame','recommendations','personal','decorated','syllables',' paintwork','wiggled','afford','tails','freewing-reb','m-edf-jet-pnp','basic','hershey','great-planes','-wingspan-rxr','e-flite-puls','-wingspan-pnp','dynam','meteor','reb','rxr','flite','puls','discharge','station','schematic','notes' ,'photobucket','s282','blackstar_1961','library','20discharge','lingo','wattmeter','diffic ulties','upside','vtif6szr-xs','vtif6szr','fa18','performs','noseart','installing','friendly','reminder','brother','l ubricate','builder','petroleum','jelly','balsas','vaseline','30min','silicon','foamy','con tacted','vendor','assign','developer','investigate','shortly','complexity','1st','p-61','mantra','popular','seldom','modeled','2000mm','category','rattler','desire','uncheck' ,'smart','b-day','fear','age','date','birth','crusty','suggest','buying','signatures','registered','se ction','labeled','automatic','crossroad','limitations','rotten','audio','shallow','record' ,'rolling','shutter','blurred','background','focuses','suck','f-stop','zoom','moves','causing','3inch','indication','subject','crybabies','grounds','flowe r','tree','object','sensors','harder','hunting','yuck','upset','selection','shell','mercy' ,'cope','filming','aperture','zooming','stable','stopped','cinema','shake','bars','grading ','strong','southerlies','rain','washout','alarm','forecast','sleep','astray','dollars','f ailed','cycle','command','cycling','pearler','prevalent','six','cards','preflight','checks ','sony','a6000','mentioning','successor','a6300','dpreview','sonys','tempting','invested' ,'411','sitting','functional','indoor','j3','completed','workbench','alternate','perspecti ves','opinions','browse','mileage','signature','twenty','reverts','gross','underneath','re verting','unedited','claim','on','prob','haaarrr','b17s','martin','caiden','wrote','book', 'flak','tells','tale','resurrecting','england','lover','falling','boys','clip','bastards', 'swear','chunk','fighters','texas','owned','fellows','reaching','hasn','me109s','disassemb led','restorers','spitfire','fact','liquitex','realize','tubes','interesting','supposedly' ,'canopies','boy','dedicated','dx8','safer','rigged','accident','procedure','purchased','d x6','programed','cuts','envy','smoothly','opening','stiff','over-work','thin','pinned','crossways');
exception_trace
***************** end of error ************
I tried to rebuild several times and it keeps dying near 18,000 records. I have memory set to 256M. I have tried indexing 100, 500, 1000 records at one time and it keeps dying at 18000
Second method I tried was using the command line
I ran the following in Centos Linux:
php searchindex.php
I then entered the path to my files, and the system returned this error:
PHP Parse error: syntax error, unexpected '>' in /var/www/vhosts/hobbysquawk.com/vbulletin/core/vb/library/node.php on line 1789
I looked at the file and this is what i found:
1789: usort($attachments, function($a, $b) {return $a['displayorder'] <=> $b['displayorder'];});
VB support said that the code above is correct, so I have no idea where to go from here.
My Maria DB and PHP specs are in my signature. Any help from VB support or the community would be greatly appreciated.
Mark
Comment