Posting Bug

If you have any suggestions for the forums, would like to request a change, question moderator action etc, post here.
Post Reply
User avatar
Pascal
Inscrutable Pi
Posts: 286
Joined: Sat Apr 14, 2007 2:50 pm
Location: Austin, TX

Posting Bug

Post by Pascal » Tue Apr 15, 2008 3:22 pm

I was trying to make a post giving everyone a heads up to the ACL lineup this year (its explained in the post), but each time I hit submit, I get the following the message below. Not every word made the list, just most of 'em. Wasn't using any special code other than bolding. Halp?


Could not insert new word matches

DEBUG MODE

SQL Error : 1271 Illegal mix of collations for operation ' IN '

INSERT INTO afh_search_wordmatch (post_id, word_id, title_match) SELECT 15699, word_id, 0 FROM afh_search_wordlist WHERE word_text IN ('youve', 'heard', 'guys', 'bolded', 'few', 'particular', 'bands', 'frankly', 'make', 'pants', 'tight', 'think', 'seeing', 'live', 'acl', '2008', 'band', 'lineup', 'foo', 'fighters', 'robert', 'plant', 'alison', 'krauss', 'beck', 'manu', 'chao', 'john', 'fogerty', 'david', 'byrne', 'raconteurs', 'mars', 'volta', 'gnarls', 'barkley', 'conor', 'oberst', 'mystic', 'valley', 'e', 'd', 'erykah', 'badu', 'earl', 'keen', 'patty', 'griffin', 'tegan', 'amp', 'sara', 'iron', 'wine', 'love', 'special', 'sauce', 'neko', 'case', 'horses', 'swell', 'season', 'silversun', 'pickups', 'gogol', 'bordello', 'gillian', 'welch', 'eli', 'young', 'black', 'keys', 'against', 'jakob', 'dylan', 'gold', 'mountain', 'rebels', 'okkervil', 'river', 'galactic', 'kevin', 'fowler', 'sharon', 'jones', 'dap', 'kings', 'hot', 'chip', 'vampire', 'weekend', 'slightly', 'stoopid', 'duffy', 'alejandro', 'escovedo', 'roky', 'erickson', 'yonder', 'string', 'spiritualized', 'flyleaf', 'driveby', 'truckers', 'ingrid', 'michaelson', 'stars', 'jose', 'gonzales', 'css', 'del', 'funky', 'homosapien', 'man', 'jamie', 'lidell', 'mgmt', 'made', 'milwaukee', 'famous', 'jenny', 'lewis', 'ward', 'asleep', 'wheel', 'mason', 'jennings', 'heartless', 'bastards', 'anitbalas', 'nachito', 'herrera', 'allstars', 'shooter', 'xavier', 'rudd', 'yeasayer', 'octopus', 'project', 'joe', 'bonamassa', 'kills', 'white', 'denim', 'louis', 'xiv', 'delta', 'spirit', 'mates', 'state', 'nicole', 'atkins', 'sea', 'electric', 'touch', 'honey', 'bears', 'back', 'door', 'slam', 'tristan', 'prettyman', 'strange', 'boys', 'ryan', 'bingham', 'scott', 'biram', 'freddy', 'color', 'revolt', 'five', 'august', 'langhorne', 'slim', 'sybris', '?paper', 'boy?', 'reed', 'loves', 'bavu', 'blakes', 'extra', 'plairs', 'bondy', 'christopher', 'denny', 'mike', 'farris', 'lee', 'south', 'austin', 'jug', 'american', 'bang', 'bobby', 'bare', 'massacoustics', 'belleville', 'outfit', '11', 'heathens', 'city', 'sunny', 'sweeney', 'elizabeth', 'wills', 'autamata', 'bonnie', 'bishop', 'ben', 'solee', 'cylus', 'concert', 'supremes', 'christionettes', 'sheilds', 'faith', 'family', 'singers', 'nakia', 'southern', 'cousins', 'brotherly', 'luv', 'hensley', 'ensemble', 'school', 'rock', 'jambo', 'brothers', 'buck', 'howdy', 'uncle', 'don', 'ray', 'jimmies')

Line : 251
File : functions_search.php

Wyscor
Just Plain Old Pie
Posts: 10
Joined: Mon Sep 01, 2008 6:12 pm

Post by Wyscor » Wed Sep 03, 2008 4:44 pm

Similar problem. I tried to post an ascension log which had the bold BBCode and got this message.

Could not insert new word matches

DEBUG MODE

SQL Error : 1271 Illegal mix of collations for operation ' IN '

INSERT INTO afh_search_wordmatch (post_id, word_id, title_match) SELECT 21957, word_id, 0 FROM afh_search_wordlist WHERE word_text IN ('proper', 'logs', 'day', 'april', 'oyster', 'egg', 'started', 'level', 'adventures', 'remaining', 'skills', 'hand', 'pride', 'spent', '300', 'meat', 'basket', 'equipped', 'advs', 'spooky', 'forest', 'larvae', 'puce', 'polkadot', '11', 'used', '8', 'remainder', 'saved', 'moxie', 'lvl', 'quest', 'completed', 'bought', 'terrarium', 'envy', 'haunted', 'kitchen', 'leftovers', 'blue', '1', 'sewer', '2', 'worthless', 'gewgaw', 'volleyball', 'seal', 'tooth', 'bloodfaced', 'took', 'tavern', 'tap', 'first', 'decided', 'skip', 'rat', 'boss', 'whiskers', 'sold', 'artist', 'haiku', 'dungeon', 'gravy', 'bugbear', 'beanie', 'degrassi', 'knoll', 'red', 'untinker?s', 'drink', 'screwdriver', '3', 'bottle', 'cooking', 'sherry', 'eat', 'ancient', 'frozen', 'dinner', 'dire', 'fudge', 'learned', 'amphibian', 'sympathy', 'finally', 'empty', 'tank', 'one', 'packet', 'ketchup', 'mushroom', 'bungguard', 'barrels', 'vodka', 'martini', 'billards', 'room', 'lavender', 'striped', 'save', 'nightcap', 'accidental', 'cider', 'notes', 'items', 'backfarm', 'frilly', 'skirts', 'sapling', 'spookygro', 'fertilizer', 'temple', 'map', 'end', 'stats', 'newt', 'herder', 'muscle', 'points', 'next', 'iii', 'patience', 'tortoise')

Line : 251
File : functions_search.php

-----
Edit: Apparently my many tries did get posted and now I seem to have an overtly high post count :shock:

Post Reply