Announcement

Collapse
No announcement yet.

Search not indexing after upgrade from v4.2.5 to v5.5.4

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

  • Search not indexing after upgrade from v4.2.5 to v5.5.4

    I had the error, "invalid SQL," on building the search index. It occurs with both the command line and web method.

    With the web interface, the query seems to have run successfully twice, since I set the number of records to 20 (instead of the default 250 - since it had failed previously with 250). There was a message "Building Search Index Forum 40 :: 60" above the query failure message.

    The query failure message was
    Error Invalid SQL: SELECT * FROM words WHERE `word` IN ('woodshed','reported','posts','infractions','punishments','broad','daylight','heretics',' message','world','baptized','saved','thread','expected','spreading','destructive','doctrin es','forum','o2bewise','september','salvation','baptism','satan','embraces','promotes','do ctrine','eternal','faith','requirement','attains','simple','belief','person','jesus','word s','believes','addressing','people','asked','works','requires','answered','28-29','mention','clear','enters','apparently','misspoken','fellow','believers','devilish','d egrades','speaks','stating','required','direct','opposition','unbelievers','disciples','re plied','christ','household','listen','wicked','archive','trade','towers','blown','heard',' plane','turned','flames','directly','tower','middle','eastern','suicide','bomber','report' ,'important','question','answer','determine','quality','lived','eternity','accepted','god‚ €™s','church','knowledge','enjoy','loving','relationship','creation','decide','accept','sp end','burdened','horrible','consequences','gentleman','force','choice','reject','bible','t ells','great','mercy','romans','sinned','short','glory','price','separation','wages','deat h‚€¶','payment','fellowship','children','father','simply','pretend','union','maintain','ju stice','blood','demonstrates','sinners','matter','wonderful','useless','order','benefit',' sacrifice','states','confess','mouth','heart','raised','putting','vital','humble','admit', 'sinner','realize','death','personal','showing','entire','universe','billions','stars','pl anets','galaxies','constructed','incredible','complexity','human','brain','holds','power', 'spoken','humbled','beaten','suffer','cross','praise','forever','geoff','colossal','contra diction','subtitled','conversion','theism','information','defender','closed','verses','fut ure','uncertainties','contingencies','classic','exhaustively','fixed','singular','truth',' outcome','variation','uncertainty','allowed','today','seemingly','reversed','demonstration ','examine','dated','repent','attributes','warning','follow','depiction','shocking','irrat ional','viewer','discretion','advised','quoted','responded','suggested','partial','forekno wledge','grant','defense','supposed','capacity','things','exist','position','defend','shoc kingly','exact','version','plans','happen','present','accumulated','includes','opposed','i nconsistent','theology','finally','begun','presented','amazing','attack','america','christ ian','response','enyart','pastor','denver','partly','delivered','radio','fully','security' ,'airline','hijackings','failure','airport','personnel','strategy','hijackers','weapons',' airplanes','ceramic','plastic','knives','invisible','metal','detectors','pilots','armed',' crewmembers','access','israel‚€™s','airlines','undercover','guards','random','flights','po lice','government','officials','hijacking','succeeded','self-defense','heroism','flight','crashed','pennsylvania','prevented','crashing','white','house ','offices','encourage','teach','created','victim','mentality','heretofore','taught','comp ly','consistent','victim-mentality','enable','deter','criminals','prosecution','legislation','prosecute','members', 'terrorist','organizations','murder','supporters','conspiracy','deterrence','foreign','nat ion','harbors','supports','terrorists','dismantle','nations','responsibility','perpetrated ','punish','destroy','governments','supporting','terrorism','osama','laden','crises','unfo lded','studio','network','final','responsible','stated','palestinians','incapable','terror ','behalf','radical','islamic','international','protected','taliban','afghanistan','intell igence','public','promise','effort','american','monitored','training','americans','‚€œblow ','buildings','recently','videotape','effectively','claimed','bombing','actions','provided ','sufficient','pursue','assassinate','apprehend','execute','trial','relations','israel',' condemn','punishing','unwittingly','generally','respecting','treating','dignitaries','regi mes','valid','invites','conduct','diplomacy','yasser','arafat','validate','tactics','young ','justification','bring','compatriots','bargaining','table','leaders','allies','enemies', 'widespread','palestinian','celebration','spontaneous','dancing','streets','tragedy','decl are','national','mourning','contrast','strong','evidence','enemy','fastidiously','memories ','wrong','swiftly','painfully','years','increasing','bitterness','welfare','individuals', 'corporations','countries','individual','privately','freely','dollars','charity','counties ','coerced','forced','including','creates','unnecessary','animosity','countless','millions ','believing','immoral','culture','threatening','families','america‚€™s','seducing','attra cted','hollywood‚€™s','videos','satellite','transmissions','destroyed','exporting','immora lity','teenage','employed','laundry','western','hotel','sneaks','rooms','watch','naked','l esbians','movies','broken','homes','exported','begins','oppose','sexual','pornography','fo rnication','adultery','no-fault','divorce','marriage','abortion','euthanasia','charges','hatred','islam‚€™s','longst anding','intensified','needlessly','increased','clinton','bombed','arabs','night','televis ed','monica','lewinski','deposition','media','majority','reporters','believed','sudan','di version','virtually','concurred','assessment','planes','cover-up','scandal','announced','beginning','immediately','doubted','predicting','one-time','distraction','started','ended','press','corps','remember','learned','group','theate r','watching','movie','hollywood','inspired','president','involved','horrendous','artifici al','distract','played','widely','internationally','impact','congress','condemned','behavi or','investigated','apologized','social','religious','fundamentalists','killing','infidels ','non-islamic','democracy','problems','limited','infrastructure','functions','education','health ','farming','full-time','campaign','democratic','turns','campaigners','campaigning','florida','hijacked','ce nter','govern','grade','classroom','focus','focuses','parents','primary','educating','gove rning','successful','business','branches','thirty','areas','typically','poorly','original' ,'limit','maintaining','liberty','property','criminal','system','military','cultural','wor ldviews','promote','inherently','destabilizing','cultures','openly','acceptable','solve',' disable','standard','deterrents','universities','growing','epidemic','harris','klebold','a ssumed','escape','punishment','columbine','killed','hands','judge','shedding','innocent',' kamikazes','pearl','harbor','islam','japanese','empire','judaeo-christian','teaching','afterlife','attacks','kamikaze','zealots','normal','capable','eager ness','recognize','energy','independence','commitment','explore','alaska','lands','oceans' ,'reduce','transfer','annually','quickest','strongly','threaten','emergency','mobilization ','conclusion','policy','wisdom','right-wing','christians','objectives','secular','ignores','carefully','study','qualified','gover ned','let‚€™s','change','terrorists‚€™','point','battle','assist','discussion','comments', 'realaudio','online','call-in','mondays','1-800-8enyart','fault','cover','judaeo','8enyart','testing','differ','doctor','walked','patients ','smell','pseudomonas','aeroginosa','infection','bacterium','debilitated','patient','mean t','recourse','choose','toxic','antibiotics','safely','fifteen','listening','pharmaceutica l','salesman','telling','antibiotic','dying','familiar','convince','safety','effectiveness ','conservative','unwilling','unfamiliar','failed','found','blamed','failing','situation', 'depends','biblical','pauls','prayer','philippians','fulfilled','bondage','claiming','prom ises','abound','discernment','approve','excellent','sincere','offense','filled','fruits',' righteousness','notice','brethren','hearts','desire','witness','distorted','multiply','per ception','insight','experience','write','knowledgeable','perceptive','insightful','transla tion','misses','greek','dictionary','meaning','means','intransitively','usage','thessaloni ans','writing','thought','wrote','differing','phrase','instructed','continued','judged','s unlight','unalloyed','translate','passage','overflow','inoffensive','central','produces',' flooding','souls','evangelize','discuss','reward','living','lives','spirit','parallel','co lossians','heartily','knowing','receive','inheritance','serve','timothy','diligent','appro ved','worker','ashamed','rightly','dividing','24b-2','minister','stewardship','fulfill','mystery','hidden','generations','revealed','saints' ,'willed','riches','gentiles','preach','perfect','labor','striving','working','mightily',' conflict','laodicea','flesh','encouraged','attaining','assurance','understanding','tendenc y','concentrate','feeling','learn','grace','dispensation','dispensations','theologians','d ebating','catholic','scholar','maintained','systematic','theologian','james','prove','cons istently','subject','coming','called','wondered','addiction','fighting','needed','christs' ,'teachings','kinds','questions','statements','affect','concern','non-christians','surfaced','galatia','amazed','galatians','turning','gospel','trouble','perver t','angel','heaven','preached','accursed','preaches','received','verse','upset','unloving' ,'manner','purpose','commandment','conscience','concerned','stake','afraid','churches','be ggarly','elements','observe','months','seasons','labored','basis','problem','matthew','sho ws','sheep','support','servant','circumcision','confirm','fathers','rejected','commission' ,'peter','eleven','offered','davidic','kingdom','restore','18-21','foretold','prophets','converted','blotted','times','refreshing','presence','restorati on','began','reason','prisoner','revelation','unsearchable','gospels','committed','twelve' ,'circumcised','uncircumcision','contrary','barnabas','uncircumcised','worked','apostleshi p','cephas','pillars','perceived','gentile','mission','15-18','creature','signs','demons','speak','tongues','serpents','drink','deadly','recover','b aptize','effect','opened','perceive','partiality','fears','counted','justifies','ungodly', 'accounted','water','remission','antitype','saves','usbaptism','removal','filth','resurrec tion','greeks','slaves','calling','spiritual','prayers','glorified','commandments','pleasi ng','sight','hears','petitions','thing','pleaded','depart','strength','weakness','gladly', 'boast','infirmities','pleasure','reproaches','persecutions','distresses','anxious','suppl ication','thanksgiving','requests','peace','surpasses','guard','minds','prosperity','gifts ','cleanse','lepers','raise','elders','anointing','forgiven','beloved','prosper','prospers ','exalted','measure','abundance','revelations','thorn','messenger','buffet','longer','sto mach','frequent','trophimus','miletus','believer','brother','sinning','commit','leading',' likewise','alive','election','forgive','trespasses','endures','abide','branch','withered', 'gather','throw','burned','stumble','11-14','chose','foundation','blame','predestined','adoption','obtained','counsel','trusted',' sealed','guarantee','redemption','purchased','possession','grieve','lovingly','share','fai thful','penalty','debate','jeffrey','dahlmer','raped','parts','thirteen','planning','cloth e','educate','medicate','entertain','legally','represent','victims','taxes','comfortable', 'winter','summer','scare','dickens','murderers','interrupting','inmate','cannibal','prison ','practical','grounds','arguing','deterrent','supreme','court','reinstituted','struck','s tate','statutes','earlier','murders','compared','prior','increase','percent','additional', 'child','murderer','saudi','arabia','enforce','swift','violent','crime','singapore','angel es','equivalent','populations','execution','sub-cultures','mafia','powerful','career','double-cross','superiors','fearing','repercussions','moral','morality','arguments','atheists','pe rsuasive','absolute','arbitrary','subjective','opinion','anti-death-penalty','attentively','opponents','intimidate','shying','claim','society','instruct','ide as','popularity','parallels','sustained','profane','keeping','consist','primarily','tooth' ,'slaps','cheek','38-39','forgave','woman','caught','stone','fourth','testament','teaches','bless','persecute', 'curse','repay','avenge','place','wrath','written','vengeance','sixth','shalt','history',' murdered','intuitively','justified','executing','finds','forbade','capital','kills','seven fold','finding','lawlessness','reigned','earth','looked','corrupt','corrupted','violence', 'behold','12-13','account','departure','instituted','interestingly','commands','flood','command','fruit ful','dominion','moves','moving','forbidden','commanded','sheds','mankind','covenant','ren dering','unfortunate','recent','versions','accurately','translated','hebrew','english','in terchangeably','meanings','easily','understood','context','ratsach','appears','slayer','sl ain','slayeth','manslayer','15-harag','surely','forbid','killing1','chapter','giving','number','strikes','mother','kidnap s','curses','unborn','plausible','suppose','contradicted','sentences','delivering','moses' ,'prohibited','insisted','influenced','philosophy','exodus','nicer','lawful','optional','a pplicable','foreigner','country','17-22','maximum','ransom','guilty','pollute','defiles','atonement','31-33','hebrews','affirmed','mosaic','17-19','blasted','pharisees','precedence','transgress','tradition','laying','honor','reaffirm ed','parent','liberal','embarrassed','repeated','caveat','reservation','black','males','te enagers','disrespect','terrible','deaths','enforced','ridiculed','disappear','thousands',' destroys','inflicted','criminals2','crucifixions','mocked','righteous','justly','deeds','n ewly','bottom','punished','angels','principle','waters','equip','witnesses','proceeds','de vours','apostle','sword','patience','object','rights','roman','citizen','defended','volunt eered','endorsement','porcius','festus','governor','caesarea','offender','deserving','accu se','deliver','appeal','caesar','conferred','council','appealed','instructs','revenge','ex plains','proper','channel','authorities','rulers','godly','doers','tormented','dwell','spe cifically','earthly','authority','avenger','practices','scourging','forgive3','large','aut hor','certainty','proves','rejecting','tense','testimony','worse','worthy','trampled','und erfoot','temporal','neglects','scoff','12-14','brings','judgment','rejoice','judges','10-11','produce','repentance','isaiah','shown','proverb','rescue','testaments','repealed','ev ent','story','released','negate','adulterers','gomer','adulteress','demanded','david','psa lm','conscious','decision','nathan','occasion','blaspheme','remained','30-32','adulterer','instance','revoking','disregard','contrariwise','ignore','wanted','rebell ing','revoked','straight-forward','brought','premature','solved','frustrated','clever','answers','thwarted','intent ions','15-22','21-27','13-17','20-26','repeal','practice','furnace','41-42','tittle','breaks','priest','offer','scribes','circumcise','sabbath','receives','angry' ,'completely','19-23','argue','changed','19-20','myriads','zealous','unrepentant','designed','guilt','lawfully','lawless','sodomites', 'kidnappers','perjurers','stopped','establish','tutor','24-25','untutored','evangelistic','resist','pacifists','unworkable','interpretation','imagine ','applying','pacifist','daughter','rapist','honey','similar','perpetrator','avail','onese lf','an-eye-for-an-eye','strictly','concept','falsely','presume','opposes','avoid','render','graciousness','e nduring','virtue','back-handed','insult','punch','right-handed','talking','full-fledged','attempted','repealing','forgiveness','control','governmental','sermon','mount',' rules','principles','upright','blessed','danger','altar','leave','distinction','agree','ad versary','quickly','officer','thrown','assuredly','penny','25-26','uphold','remain','referred','mentioned','begin','application','21-22','27-28','directed','justify','misapplying','prohibitions','neighbor','correcting','misinterpre tations','explaining','attitude','unusual','formulation','quotes','introduced','phrases',' prophet','criticizing','misinterpretation','obvious','realized','corrects','43-44','adjusting','misapplication','traditions','rebuking','misinterpreting','misinterpret', 'literally','losing','lawsuit','double','amount','opponent','borrow','publicly','poorer',' shelter','contradictions','severely','statement','insist','incarcerate','thieves','restitu tion','demand','objectors','sincerely','friend','cancel','assaulted','community','spoke',' confuse','debts','debtors','reasoned','paralyzed','arise','extent','tremendous','sadly','s orrow','agitated','mocks','grief','wound','reopened','photo','newspaper','hypocrites','fol lowers','appearance','golden','inverted','hypocrite','warned','judging','hypocrisy','corre ctly','speck','plank','remove','theme','ministry','56-57','harsh','rebuke','hypocritical','haven','glass','stones','relocate','temple','built',' heavy','compliment','simon','unworthy','smallest','matters','pertain','shame','condemns',' accuses','crimes','delight','blessing','reliable','presumptuously','executed','courts','so lomon','explained','sentence','speedily','appeals','largely','forgotten','deters','evangel ism','obedience','implement','robbers','kleptes','typical','thief','kakourgos','lestes','m ark15','steals','attacked','helped','samaritan','stripped','clothing','wounded','departed' ,'leaving','josephus','first-century','jewish','historian','judas','ezekias','aftermath','herod','palace','sepphoris',' galilee','stole','purposely','vicious','build','reputation','judean','procurator','felix', 'hiring','accomplishment','returned','claims','jerusalem','impure','prohibition','grudge', 'successfully','negated','harag','straight','forward','handed','fledged','century','robert ','nacham','program','anthropomorphism','genesis','repented','silence','deafening','number s','wickedness','intent','thoughts','continually','grieved','beast','creeping','birds','re fers','nachavm','references','italics','pharaoh','philistines','return','egypt','abhor','a shes','listened','aright','horse','rushes','thigh','humiliated','reproach','youth','ephrai m','pleasant','earnestly','yearns','passages','conviction','abhorrence','giants','afterwar d','daughters','mighty','renown','genealogy','stiff-necked','consume','egyptians','mountains','fierce','abraham','isaac','servants','swore','d escendants','inherit','groaning','oppressed','harassed','reverted','behaved','corruptly',' cease','doings','stubborn','anger','transgressed','heeded','voice','drive','joshua','11-29','performed','samuel','cried','early','morning','carmel','monument','passed','gilgal',' bleating','lowing','amalekites','spared','utterly','quiet','tribes','anoint','fight','cons umed','swoop','spoil','obeyed','amalek','plunder','burnt','offerings','sacrifices','obeyin g','rebellion','witchcraft','stubbornness','iniquity','idolatry','feared','pardon','worshi p','seized','mourned','aroused','moved','judah','hundred','thousand','valiant','davids','n umbered','greatly','foolishly','arose','famine','plague','distress','mercies','appointed', 'beersheba','seventy','stretched','destruction','destroying','restrain','threshing','floor ','araunah','jebusite','stood','disaster','ornan','remembered','multitude','mourn','heaven s','purposed','forsaken','backward','stretch','weary','repenting','instant','pluck','plant ','inhabitants','fashioning','devising','hopeless','dictates','cities','overthrew','shouti ng','stand','lords','diminish','calamity','amend','pronounced','micah','moresheth','prophe sied','hezekiah','hosts','plowed','field','heaps','ruins','mountain','hills','forest','fav or','spare','executes','endure','fasting','weeping','garments','gracious','merciful','kind ness','repents','grain','offering','showed','formed','locust','swarms','kings','mowings',' finished','eating','grass','jacob','small','devoured','territory','nineveh','throne','cove red','sackcloth','caused','proclaimed','published','decree','nobles','flock','taste','peri sh','displeased','jonah','exceedingly','prayed','previously','tarshish','abundant','loving kindness','determined','provoked','clearer','compassion','caller','immutable','unchanging' ,'character','sense','based','pagan','philosopher','plato','dialogue','socrates','adeimant us','altered','condition','healthiest','strongest','disturbed','external','affection','lia ble','influences','universally','admits','alteration','fairer','uglier','necessarily','alt ogether','twenty-six','changing','rewarding','appalling','augustine','creator','calvinism','morals','absurd ','disagreed','literal','envious','needy','silly','notions','fancies','women','substance', 'nature','profanity','philosophical','respond','calvinists','contradict','portions','scrip ture','answering','balak','moabites','amorites','messengers','homeland','mesopotamia','soo thsayer','balaam','promising','15-17','yahweh','astray','loved','unrighteousness','rebuked','donkey','speaking','restrained' ,'madness','greedily','error','profit','perished','korah','stick','ordered','delitzsch','p articiple','holaych','imperfect','interchangeable','evident','excited','behaviour','occurr ence','commencement','close','journey','longing','honour','induced','undertake','nearer',' destination','money','honors','casting','winds','imposed','balaams','encounter','welcomed' ,'36-39','favorable','bribe','places','israelites','40-41','altars','11-13','14-18','zophim','pisgah','standing','princes','oracle','zippor','stuff','prophesy','reverse', 'bribed','swayed','bribes','cases','amelikites','infant','nursing','camel','disobeyed','fa tlings','lambs','despised','worthless','regard','13-29','specific','repentant','repeats','making','sworn','melchizedek','swears','unchangeable ','combined','determining','abundantly','heirs','immutability','confirmed','impossible','c onsolation','refuge','priesthood','malachi','shaniti','trustworthiness','anointed','yashuv ','fruit','comprehensive','faithfulness','unconditional','chosen','selah','wonders','assem bly','established','strengthen','firstborn','highest','forsake','judgments','break','trans gression','stripes','alter','holiness','jeremiah','20-22','season','reign','levites','priests','ministers','measured','passion','strongs','naw-kham','primitive','comfort','comforter','console','regret','comforted','niphal','consoled' ,'hithpael','basic','writings','saint','publishers','soothsaying','makes','interprets','om ens','sorcerer','abomination','pleased','sorcery','authors','stiff','necked','twenty','gat hering','friends','topic','religion','don‚€™t','outward','disagrees','epistles','disobedie nt','divine','long-suffering','waited','prepared','ephesians','you‚€™re','doesn‚€™t','scriptures','starts','b aptist','procedures','baptizing','that‚€™s','pretty','messiah','dealing','method','pressin g','apostles','linked','promised','nicodemus','enter','john‚€™s','pentecost','15-16','baptisms','takes','happened','referring','differences','paul‚€™s','waiting','vision', 'special','clean','unclean','animals','24-26','doubt','significant','interrupted','peter‚€™s','preaching','accompanied','dispensatio nal','reveal','34-43','review','investigation','missionary','crispus','gaius','epistle','ritual','faded','in cident','progressive','reached','concluded','unity','dealings','sealing','progressed','rap ture','18-22','search','dispensationally','heifer','store','congregation','purification','purifying' ,'gathers','clothes','evening','statute','stranger','dwells','touches','purify','seventh', 'tabernacle','sprinkled','uncleanness','vessel','fastened','grave','running','hyssop','spr inkle','vessels','persons','touched','bathe','defiled','sanctuary','perpetual','sprinkles' ,'it‚€™s','disputed','baptist‚€™s','multitudes','dispute','compliance','credentials','quot ing','forerunner','accomplished','zacharias‚€™','prophecy','67-77','zacharias','visited','redeemed','perform','prepare','isaiah‚€™s','pointing','tribulat ion','explain','expectation','wondering','interesting','preparation','consecration','41-29','preceded','treasure','named','christ‚€™s','reasonable','16-21','nazareth','custom','synagogue','brokenhearted','proclaim','captives','recovery','blin d','attendant','hearing','fulfillment','crowds','tribe','judea','region','jordan','confess ing','ezekiel','preparing','royal','generation','praises','darkness','marvelous','light',' possibly','permit','fitting','provision','testified','wilderness','crying','‚€˜prepare','p aths','clothed','camel‚€™s','leather','waist','locusts','‚€˜we','confessed','castigated',' lawyers','submit','aspect','humiliating','preferred','submitted','conclusions','initiatory ','confession','resulted','messianic','19-26','requirements','shortly','aorist','participles','syntax','action','precede','viewed',' setting','rituals','ascension','outpouring','‚€˜repent','spirit‚€™','scholars','difficult' ,'affirm','pauline','poses','serious','hermeneutical','reconcile','monumental','grammar',' robertson','tenor','interpreter','grammarian','theological','persuasion','interpret','obje ctive','ascertain','observation','authored','endless','controversy','standpoint','sacramen tal','evangelical','express','doxan','haymon','emphasize','smith','tabulated','occurs','de finite','article','exists','examples','onoma','profaytou','dikaiou','mathaytou','ground',' disciple','quick','robertson‚€™s','driven','linguistics','ironically','source','refute','s trained','common','expression','suitable','displaced','modern','kayrugma','illustrations', 'usages','numerous','koine','honest','essential','mantey','mantey‚€™s','causal','turner',' reply','marcus','observed','causally','decidedly','securing','understand','urging','sought ','citing','obscure','instances','general','sphere','harmony','jonah‚€™s','argument','cont roversial','unsure','stronger','substantiate','asserted','importance','pedobaptist','oscar ','cullman','bound','immersion','practiced','precedent','proselyte','understandable','joha nnine','represented','washing','ordinary','physical','lutheran','expositor','lenski','impe rative','demands','decisive','plural','distributive','adults','difficulty','disappears','p roperly','conceive','separate','symbolical','bestowed','sacrament','degree','deals','unive rsality','preposition','connects','closely','symbol','conveys','pictures','obtain','alters ','persuade','stricken','pointed','absolutely','ananias','washed','connection','lovett','d ealt','commentary','explanation','reasoning','thesis','shaming','crucifying','denied','ack nowledge','lord‚€™s','identification','‚€˜in','nazareth‚€™','acknowledgment','result','pre cious','sanhedrin','hated','solid','identical','phonies','participate','certified','revolu tion','eligible','differs','indicating','apparent','lovett‚€™s','gaebelein','baptistic','d ispensationalist','prominently','conscience-stricken','attached','confusion','water-baptism','saving','ordinance','submission','addressed','disowned','preliminary','necessity ','forget','address','emphasis','cornelius','assembled','illustrates','declared','whosoeve r','believeth','attempt','gromacki','appeared','confident','titles','greater','asserts','e xtra','observable','verbs','parenthetical','actual','audience','gromacki‚€™s','correct','r easons','kasto','distributes','frequently','registered','sound','occurred','confused','lan guage','tongue','edification','interests','supplied','‚€˜know','greatest','accurate','unit ed','societies','petros','autous','faysin','metanoaysate','baptisthayto','hekastos','humon ','onomati','iaysou','cristou','afesin','hamartion','laympsesthe','dorean','hagiou','pneum atos','unaware','partitive','genitive','blass','debrunner','divided','exclusively','anarth rous','substantive','taking','natural','custody','commander','barracks','opportunity','rec ount','devout','dwelt','related','apostolic','spite','facts','highlighted','reformation',' 10-13','temporarily','dramatic','comparison','receiving','ananias‚€™','sensational','events', 'recall','separated','designation','23-26','abrogated','demoted','status','equality','aspects','secret','adapted','endurance','34-42','dramatically','spirit‚€™s','boundary','secondary','we‚€™re','journeys','stephanas‚€™' ,'lydia','jailer','carried','exception','philippian','here‚€™s','dietary','customs','offen d','witnessing','observing','witnessed','legalistic','acted','antioch','criticized','judai zers','ceremonially','purified','corinthians','process','recorded','explicitly','raising', 'exorcism','healing','viper','harmed','issue','declaration','apostles‚€™','18-20','operation','31-34','14-16','stoning','stephen','corinthian','meeting','contiguous','unbelieving','pronounce','fle shly','ordinances','resume','period','cleansing','accordance','relates','reiterate','borde red','gentiles‚€™','corinth','thessalonica','wasn‚€™t','betrayed','bread','letter','apollo s','figuratively','transferred','sakes','puffed','repeat','admonition','record','can‚€™t', 'dangerous','withdraw','walks','disorderly','supper','speculate','shouldn‚€™t','attained', 'perfection','intense','pressure','exhortation','frailty','division','recommended','suspen ded','carnal','baptizes','identifies','burial','suffering','arminianism','openness','sande rs','meticulously','detail','grants','freewill','initiatives','refrained','arminians','sov ereignly','create','humans','revolted','‚€œenabling‚€','irresistible','faced','spurn','con ditioned','conditional','single','atoning','effective','decreed','rapes','oppression','inf lict','midst','attempting','seeks','collaborate','reconciling','chooses','feeding','depend ent','deciding','guide','affected','genuinely','grieves','rejoices','petition','influence' ,'decides','graciously','sovereign','reciprocal','crucial','watershed','centers','respect' ,'ordained','arminius','modified','nature‚€','vastly','soteriology','guidance','unlike','c alvinist','counterparts','responds','agrees','legitimately','subset','arminian','pelagian' ,'socinian','denies','affirms','trinity','desired','rejects','proponents','engaged','‚€œfa mily','squabble‚€','couple','issues','beliefs','weakened','timbers','repair','logically',' timelessness','assert','timeless','logical','transition','involves','succession','deity',' incoherent','timber','exhaustive','contingent','beings','traditionally','helps','scriptura l','texts','‚€œlooks','ahead','overlooked','timelessly','crash','accident','omniscience',' incorrect','occur','ensure','shore-up','traditional','coherently','practically','relevant','shore','moderator','subscriber',' articles','icons','include','topics','beautiful','science','adding','start','click','https ','paypal','subscriptions','webmaster','40theologyonline','item_name','theologyonline','su bscription','item_number','no_shipping','cancel_return','no_note','abortionists','cancer', 'cnsnews','viewforeignbureaus','foreignbureaus','200201','for20020104b','viewculture','200 109','cul20010911a','censorship','kalam','cosmological','alright','existence','refutes','a dmitt','defeat','arguement','minute','objections','misunderstanding','track','premise','on tologically','transcendant','disprove','atheism','causeless','personality','‚€œjudge','rea lizes','repeatedly','insisting','judgment‚€','praised','‚€œrightly','judged‚€','shamed','m atters‚€','‚€œhe','things‚€','‚€œwe','christ‚€','notion','child-molesters','condemnation','rapists','criticism','refrain','arrested','borrowing','characte rs','lewis','junior','demon','wormwood','uncle','screwtape','fiendish','exchange','disposa l','neutralize','one-on-one','approach','inefficient','madison','avenue','marketing','undermine','you‚€™ve','i‚€™m ','highly','productive','frustrate','tempt','dozen','heathens','imple-menting','impair','dedicated','distracted','leader‚€™s','effec-tive','enemy‚€™s','confusing','admonish','hundreds','they‚€™re','causing','leader','not‚€¶ ','paragraph','not‚€','bril-liant‚€¶','won‚€™t','sexually','brilliant','seduce','fol-lowing','instructions','hypo-crites','workers','foolish','precisely','transformed','bureau-crats','drones','mindlessly','dis-pense','misfortune','slave','willingly','obeys','master','conform','instruction','eventual ly','con-fronting','worm-wood','confront','judg-ing','un-believers','professing','deny-ing','underway','is‚€¶','targets','wor-ried','favorite','clich„©','ignorant','warns','‚€œhypocrisy‚€','commanding','‚€œabhor','ev il‚€','unable','hypocrite‚€','‚€œfor','‚€œhypocrites','‚€œwhy','‚€œhypocrite','brother‚€™s ','eye‚€','‚€œthe','god‚€¶','stones‚€','‚€œbuilding‚€','chief','corner','stone‚€','falls', '‚€œwill','grind','powder‚€','crushed','hillary','homosexuals','mantra','masses','mesmeriz ed','intend','range','advanced','babes','preschool','newest','fundamental','‚€œeveryone',' partakes','unskilled','babe‚€','lactose','intolerant','extreme','ignorance','crippled','pa ralysis','slows','denomination','hurting','local','fellowships','percentage','succumbed',' deception','fallen','quarter','suggests','misquote','repeating','deceived','advice','job‚€ ™s','counsels','husband','‚€œcurse','die‚€','ripped','‚€œwent','hanged','himself‚€','‚€œgo ','likewise‚€','lacks','hunger','susceptible','dangers','october','rocky','expressed','jud ge-not','sentiment','advocated','incarceration','‚€œin','image','god‚€','‚€œwrong','writer',' incongruity','basket','describes','flavor','preserves','seductive','spectators','sidelines ','apathy','craving','shirking','‚€œif','house‚€','righteously‚€','16-17','households','eliminate','resign','‚€œdo','you‚€¶‚€','delegates','judgments‚€','almigh ty','commits','obedient','‚€œclearly','preceding','‚€œof','later‚€','aware','notorious','c elebrities','family','concealed','enoch','all‚€','14-15','‚€œjealously','violated','recompense','appeased‚€','34-35','‚€œevery','rises','heritage','lord‚€','‚€œlord','i‚€™ll','‚€œthose','school','student ','danny','rohrbough','forgiving','judgmental','magazine','martyred','‚€œavenge','martyr‚€ ™s','headed','retirement','replaced','arvada','80001','anytime','internet','bob‚€™s','popu lar','unpublished','manuscript','rightstuffmarket','1-888-8enyart','molesters','imple','menting','effec','liant‚€¶','crites','bureau','crats','pense ','fronting','over-population','population','survived','sinking','ocean','afloat','lifeboat','board','carpent er','nurse','elderly','sailor','counselor','students','scenario','overboard','environmenta lists','exercise','eliminating','excess','jacques','cousteau','stabilize','admitted','hitl erian','unesco','courier','november','envirochondriacs','britain','prince','philip','world wide','reincarnated','killer','virus','lower','levels','hivlip','discredited','liberals',' ehrlich','prediction','rationing','thirst','million','brighton','colorado','teacher','memb er','columnist','somalia','nearest','populated','density','square','almanac','apocalyptic' ,'doomsayers','enviro-chondriacs','flatly','invent','under-populated','compare','europe','thumb','higher','standards','literacy','rates','expectancie s','austria','belgium','denmark','england','france','germany','ireland','italy','japan','l uxembourg','netherlands','poland','rhode','spain','switzerland','athens','boston','paris', 'sydney','toronto','densities','scarcity','prosperous','desirable','tremendously','dense', 'naples','madrid','over-populated','china','india','taiwan','mainland','assets','liabilities','socialists','commun ists','provide','helpless','dependents','consumers','producers','rampant','north','thousan d-fold','left-wing','five-billion-plus','miles','squeeze','sardines','comfortably','spilling','falling','chicken','purveyor' ,'crowded','orbiting','alien','empty','passengers','attest','economist','1980s','resources ','scarce','minerals','monitor','check','amounted','expensive','reality','reduced','prices ','availability','world-wide','end-of-the-world','global','shortage','soviet','results','false','harmful','religions','interventioni st','agricultural','economic','institute','oxford','university','estimated','current','tec hnology','billion','one-tenth','rapid','progress','aqua-culture','upper','supply','decided','planned','parenthood','founder','longtime','margaret' ,'sanger','handicapped','epileptics','weight','waste','pivot','civilization','libraries',' anti-handicapped','surprising','awards','eliminated','one-for-all','all-for-one','historically','brutal','slaughter','french','philosophers','overcrowding','ancient', 'babylonian','assyrian','accounts','enlil','agreed','humanity','ultimate','wielded','prove rbs','enviro','chondriacs','lousy','angola','bolivi','botswana','congo','liberia','libya', 'mozambique','namibia','niger','panama','paraguay','russia','uruguay','venezuela','zaire', 'zambia','zimbabwe','tenth','pages','directory','webpages','hesitate','recommend','categor ies','‚€œyet','worshipped','redeems','jehovah‚€™s','‚€œand','charles','russell','logos','‚ €œthis','readily','precedes','‚€˜god','reads','theos','‚€™‚€','absence','‚€œwhose','blinde d','shine','handled','theon','‚€œnot','theou','forms','‚€œas','speech','invaluable','gaini ng','precision','predicate','strict','accord','idiom','perfectly','egeneto','scientificall y','calculate','ghost','manifest','manifests','supernaturally','‚€œbaptizing','inferior',' ‚€œthus','jehovah','redeemer','stretches','spreads','abroad','‚€œby','talked','sodom', '16-19','abraham‚€','‚€œthen','rained','brimstone','gomorrah','heavens‚€','manifestations','‚€ œwho','robbery','equal','likeness','belonged','thomas','‚€œmy','kurio','didn‚€™t','‚€œform ‚€','‚€œman','indwelled','‚€œyou','father‚€','‚€œabraham','rejoiced','day‚€','‚€œfifty','‚ €œmost','septuagint6','‚€˜the','memorial','pointedly','‚€œbefore','genesqai','alpha','omeg a','beafraid','smyrna','‚€œthese','spread','savior','infinitely','infinite','complete','‚€ œeven','mistranslates','shepherd','surrender','manifested','incomprehensible','blurring',' godhead','17-26','orphans','‚€œjesus','‚€˜if','loves','‚€˜and','‚€˜but','helper','remembrance','dwelled ','‚€œbut','‚€˜your','scepter','reports','‚€˜let','‚€œtherefore','equated','function','equ ally','redeem','body‚€','records','‚€œpeter','‚€˜ananias','‚€œacts','conceived','lying','f inite','comprehension','readiness','definition','clause','wouldn‚€™t','reproduced','permis sion','biblicalanswers','closet','supportive','homophobic','homophobia','genetic','involun tary','reactions','homosexual','stimuli','glance','romantically','man‚€™s','lunch','vomit' ,'grosses','inborn','mechanism','protect','bodily','putrid','animal','carcass','terribly', 'fatally','congenital','ingesting','poison','gagging','rotting','poisons','wondrous','abil ity','mechanisms','genetically','inherited','revulsion','homosexuality','earliest','homoph obe','approached','i‚€™ve','fulfilling','homophobes','predisposed','homos','terms','queer' ,'adopting','description','badge','values','surgery','donor','diseases','carry','promiscuo us','donating','quintana','fungus','throat','courtroom','suing','fewer','partners','promis cuity','threshold','scoutmasters','scout','heterosexually','molested','one-third','psychological','327-337','activists','absurdly','penetrates','committing','molestation','girls','bisexuals','a verage','avoids','expectancy','figures','research','washington','obituaries','newspapers', 'lowers','schools','denver‚€™s','resource','brochure','titled','lesbian','scared','step-by-step','holding','kissing','hugging','stroking','rubbing','bodies','inserting','fingers','o ther‚€™s','vaginas','stimulating','genitals','pamphlet','disgusting','‚€œother','morally', 'bankrupt','boldly','‚€œour','ready','educators','satisfaction','heavily','association','r esolution','promotion','‚€œobservances','curricula','hoping','anymore','complaining','defe nding','nation‚€™s','maves','‚€œhow','missed','valuable','liberating','initiated','sexuali ty','weren‚€™t','so-called','‚€œgetting','advocate','slogan','nambla','man-boy','‚€œsex','printed','piece','melzer','editor','nambla‚€™s','journal','‚€œnambla','tomo rrow','surprised','*****es','melzer‚€™s','alleged','filipino','abused','‚€œor','chanted',' march','‚€œten','recruit','perverted','26-27','totally','proud');

    exception_trace

    Interestingly, I pasted the same query into phpMyAdmin and it worked. This was the same server, the same database.

    The fix below did not work (mentioned in https://forum.vbulletin.com/forum/vb...92#post4415892)

    $config['Mysqli']['charset'] = 'utf8mb4';

    did not work.

    I ran this query below:

    SHOW VARIABLES LIKE 'character\_set\_%';

    wit this result:

    Variable_name Value

    character_set_client utf8mb4
    character_set_connection utf8mb4
    character_set_database utf8mb4
    character_set_filesystem binary
    character_set_results utf8mb4
    character_set_server utf8mb4
    character_set_system utf8


    Server info is below. Are there any suggestions on getting this to work?

    Click image for larger version  Name:	server48570.png Views:	0 Size:	56.5 KB ID:	4422547

  • #2
    Here is more info about the MySQL error:

    MySQL Error : Illegal mix of collations for operation ' IN '

    Error Number : 1271

    Classname : vB_Database_MySQLi
    MySQL Version : 10.0.38-MariaDB-0ubuntu0.16.04.1

    Comment


    • #3
      Here is the stack trace:

      I see that [path] below seems to be [web-root]/core/.

      Stack Trace:
      #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
      #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
      #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 576
      #3 vB_Database->query_read() called in [path]/vb/db/result.php on line 144
      #4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 68
      #5 vB_dB_Result->__construct() called in [path]/vb/db/query/select.php on line 121
      #6 vB_dB_Query_Select->doSelect() called in [path]/vb/db/query/select.php on line 98
      #7 vB_dB_Query_Select->execSQL() called in [path]/vb/db/assertor.php on line 301
      #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 [path]/vb/search/core.php on line 256
      #11 vB_Search_Core->indexBatch() called in [path]/vb/library/search.php on line 95
      #12 vB_Library_Search->indexRangeFromNode() called in [path]/admincp/misc.php on line 230
      #13 require_once([path]/admincp/misc.php) called in ...[web-root]/includes/api/interface/collapsed.php on line 142
      #14 Api_Interface_Collapsed->relay() called in ...[web-root]/includes/vb5/frontend/controller/relay.php on line 33
      #15 vB5_Frontend_Controller_Relay->admincp() called in ...[web-root]/index.php on line 74

      Comment


      • #4
        An illegal mix of collations means that some of your tables and their fields are not using a utf8mb4 collation.

        Since you're using English, follow these steps:
        1. Look in the /do_not_upload/dbtools directory in your download package.
        2. Rename vbutil_config.php.new to vbutil_config.php.
        3. Fill out the variables.
        4. Upload utf8tablefix.phar and vbutil_config.php to your vBulletin directory.
        5. Turn off your vBulletin.
        6. Create a database backup.
        7. From the server's command line, run php utf8tablefix.phar.
        8. Delete utf8tablefix.phar and vbutil_config.php from your server.
        9. Rebuild the search index for your site.
        10. Turn on your vBulletin.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment


        • #5
          Also I changed the collation of the table "words"

          from utf8-general-ci
          to utf8-mb4-unicode-ci

          which did not fix the issue.

          EDIT - I entered this before seeing your comment above. I will try what you suggested and try to update the result here. Thanks!

          Comment


          • #6
            I tried this, which did update many tables, but then failed around table userban; below is part of the output:

            $ php utf8tablefix.phar
            updating collation for ad ... DONE
            updating collation for adcriteria ... DONE
            ...
            ...
            updating collation for userban ... DONE
            updating collation for userchangelog ...PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes in phar://[web-root]/utf8tablefix.phar/includes/dbtools.php:378
            Stack trace:
            #0 phar://[web-root]/utf8tablefix.phar/includes/dbtools.php(378): PDO->exec('ALTER TABLE use...')
            #1 phar://[web-root]/utf8tablefix.phar/utf8tablefix.php(64): vB_Db_Mysql_Tools->setCharset('userchangelog', 'utf8mb4', 'utf8mb4_general...', 'utf8mb4_bin')
            #2 [web-root]/utf8tablefix.phar(4): require_once('phar:///var/www...')
            #3 {main}
            thrown in phar://[web-root]/utf8tablefix.phar/includes/dbtools.php on line 378
            Last edited by artlserver; Mon 23rd Sep '19, 6:25pm.

            Comment


            • #7
              Since utf8tablefix.phar quit at table userchangelog, I manually tried changing the collation of that table's columns. This failed for column fieldname with the same error, 1071. Since the data type was varchar 250, and 4 times that is 1000, which is mentioned in the error message (as the max key length) - and this field was a key - I reduced this field to varchar 191. Then the collation change worked.

              I tried with other columns in the same table, without changing from varchar 250 (just out of curiosity) and they worked also. Suspecting the program could also change collation if I was able to now, I tried running utf8tablefix.phar again. It ran and ended without error, completing.

              Then I tried rebuilding the search index, which did NOT error out, and is building now.

              So this seems resolved, for now.

              Thanks for the suggestion about utf8tablefix.phar.

              Comment

              Related Topics

              Collapse

              Working...
              X