- Joined
- Sep 21, 2003
- Messages
- 31,044
- Location
- Portland, Oregon
- Car(s)
- 2008 Dodge Viper, 2006 MB CLS55 AMG
Okay, we'll rebuild it tomorrow probably.
peter3hg2 said:Just found a new one, quite small but anyway.
When you insert an emoticon the cursor goes to the start of the text box.
I'm sure it used to just continue from where you were.
IE but it seems to be working now. Strange.jeffy777 said:peter3hg2 said:Just found a new one, quite small but anyway.
When you insert an emoticon the cursor goes to the start of the text box.
I'm sure it used to just continue from where you were.
It works perfectly for me in Firefox 2.0 Cursor continues from where you were. What browser are you using?
Could not insert new word matches
DEBUG MODE
SQL Error : 1271 Illegal mix of collations for operation ' IN '
INSERT INTO forum_search_wordmatch (post_id, word_id, title_match) SELECT 340626, word_id, 0 FROM forum_search_wordlist WHERE word_text IN ('clarkson', 'idea', 'again', 'read', 'column', 'career', 'rock', 'god', 'jeremy', 'i?ve', 'spent', 'past', 'years', 'driving', 'round', 'corners', 'while', 'shouting', 'one', 'richard', 'hammond', 'turned', 'upside', 'treadmill', 'stopped', 'sixmonth', 'hole', 'diary', 'there?d', 'show', 'first', 'adult', 'life', 'point', 'explain', 'taken', 'hobbies', 'expert', 'matter', 'decide', 'rush', 'blizzard', 'ignorance', 'hope', 'spend', 'fortune', 'toys', 'house', 'littered', 'toolkits', 'halfmade', 'model', 'helicopters', 'easels', 'fishing', 'rods', 'pianos', 'limited', 'edition', 'replica', 'double', 'bass', 'drum', 'pictures', 'lily', 'kit', 'used', 'keith', 'moon', '1967', 'massive', 'however', 'end', 'gathering', 'dust', 'mission', 'plays', 'james', 'may', 'classically', 'trained', 'pianist', 'producer', 'fancies', 'himself', 'singer', 'learn', 'drums', 'form', 'top', 'gear', 'band', 'christmas', '1', 'cover', 'radar', 'love', 'cheered', 'forward', 'immediately', 'problem', 'turns', 'buy', 'stool', 'sticks', 'cymbals', 'pedals', 'cause', 'two', 'make', 'noise', 'hihat', 'whatever', 'extras', 'bit', 'buying', 'airplane', 'finding', 'box', 'contain', 'wings', 'wheels', 'cockpit', 'canopy', 'engines', 'whole', 'week', 'ready', 'sit', 'start', 'drumming', 'right', 'seen', 'loads', 'gigs', 'sort', 'assumed', 'writhe', 'hit', 'stuff', 'few', 'moments', 'realised', 'wasn?t', 'i', 'rang', 'teacher', 'came', 'introduced', 'score', 'gave', 'lesson', 'i?m', 'uncoordinated', 'keep', 'reasonable', 'move', 'arms', 'leg', 'forgets', 'it?s', 'doing', 'speeds', 'stops', 'altogether', 'knew', 'might', 'happen', 'tried', 'fly', 'helicopter', 'instructor', 'handed', 'controls', 'started', 'crash', 'kept', 'thinking', '?look', 'sarah', 'bloody', 'ferguson', 'can?t', '?', 'couldn?t', 'rub', 'head', 'pat', 'tummy', 'thing', 'people', 'easily', 'usually', 'punching', 'myself', 'face', 'i?d', 'paid', 'hour?s', 'stuck', 'eventually', 'similar', 'fourfour', 'name', 'that?s', 'holy', 'thought', 'drummers', 'they?ve', 'ingested', 'half', 'gallon', 'heroin', 'putting', 'twiddly', 'bits', 'mix', 'passable', 'imitation', 'frank', 'beard?s', 'zz', 'top?s', 'gimme', 'lovin?', 'three', 'wanted', 'it?d', 'someone', 'playing', 'instrument', 'luckily', 'live', 'quite', 'close', 'alex', 'became', 'columnist', 'called', 'independent', 'bassist', 'blur', 'jamming', 'tremendous', 'felt', 'effervescent', 'anything', '?so', 'we?d', 'finished', 'smoke', 'water', 'stare', 'gormless', 'bigger', 'count', 'loud', 'watching', 'lips', 'reading', 'installed', 'room', 'powerful', 'stereo', 'system', 'twirling', 'timber', '500', 'watts', 'drowned', 'completely', 'ways', 'excellent', 'means', 'tottenham', 'court', 'road', 'hifi', 'children', 'trying', 'homework', 'wife', 'nap', 'family', 'london', 'son', 'neighbours', 'morning', 'announced', 'yesterday', 'wants', 'local', 'draw', 'breath', 'already', 'bagged', 'colleagues', 'he?d', 'call', 'steve', 'winwood', 'lives', 'nearby', 'he?s', 'course', 'disloyal', 'disappointment', 'mean', 'takes', 'longer', 'work', 'i?ll', 'let', 'details', 'gig', '2438924039251', 'html')
Line : 251
File : functions_search.php
Viper007Bond said:It still posted, but that shouldn't be happening (thought we fixed it). Damn.
Bouwe said:I was trying to post a new topic, and then this happend:
Could not insert new word matches
DEBUG MODE
SQL Error : 1271 Illegal mix of collations for operation ' IN '
INSERT INTO forum_search_wordmatch (post_id, word_id, title_match) SELECT 340626, word_id, 0 FROM forum_search_wordlist WHERE word_text IN ('clarkson', 'idea', 'again', 'read', 'column', 'career', 'rock', 'god', 'jeremy', 'i?ve', 'spent', 'past', 'years', 'driving', 'round', 'corners', 'while', 'shouting', 'one', 'richard', 'hammond', 'turned', 'upside', 'treadmill', 'stopped', 'sixmonth', 'hole', 'diary', 'there?d', 'show', 'first', 'adult', 'life', 'point', 'explain', 'taken', 'hobbies', 'expert', 'matter', 'decide', 'rush', 'blizzard', 'ignorance', 'hope', 'spend', 'fortune', 'toys', 'house', 'littered', 'toolkits', 'halfmade', 'model', 'helicopters', 'easels', 'fishing', 'rods', 'pianos', 'limited', 'edition', 'replica', 'double', 'bass', 'drum', 'pictures', 'lily', 'kit', 'used', 'keith', 'moon', '1967', 'massive', 'however', 'end', 'gathering', 'dust', 'mission', 'plays', 'james', 'may', 'classically', 'trained', 'pianist', 'producer', 'fancies', 'himself', 'singer', 'learn', 'drums', 'form', 'top', 'gear', 'band', 'christmas', '1', 'cover', 'radar', 'love', 'cheered', 'forward', 'immediately', 'problem', 'turns', 'buy', 'stool', 'sticks', 'cymbals', 'pedals', 'cause', 'two', 'make', 'noise', 'hihat', 'whatever', 'extras', 'bit', 'buying', 'airplane', 'finding', 'box', 'contain', 'wings', 'wheels', 'cockpit', 'canopy', 'engines', 'whole', 'week', 'ready', 'sit', 'start', 'drumming', 'right', 'seen', 'loads', 'gigs', 'sort', 'assumed', 'writhe', 'hit', 'stuff', 'few', 'moments', 'realised', 'wasn?t', 'i', 'rang', 'teacher', 'came', 'introduced', 'score', 'gave', 'lesson', 'i?m', 'uncoordinated', 'keep', 'reasonable', 'move', 'arms', 'leg', 'forgets', 'it?s', 'doing', 'speeds', 'stops', 'altogether', 'knew', 'might', 'happen', 'tried', 'fly', 'helicopter', 'instructor', 'handed', 'controls', 'started', 'crash', 'kept', 'thinking', '?look', 'sarah', 'bloody', 'ferguson', 'can?t', '?', 'couldn?t', 'rub', 'head', 'pat', 'tummy', 'thing', 'people', 'easily', 'usually', 'punching', 'myself', 'face', 'i?d', 'paid', 'hour?s', 'stuck', 'eventually', 'similar', 'fourfour', 'name', 'that?s', 'holy', 'thought', 'drummers', 'they?ve', 'ingested', 'half', 'gallon', 'heroin', 'putting', 'twiddly', 'bits', 'mix', 'passable', 'imitation', 'frank', 'beard?s', 'zz', 'top?s', 'gimme', 'lovin?', 'three', 'wanted', 'it?d', 'someone', 'playing', 'instrument', 'luckily', 'live', 'quite', 'close', 'alex', 'became', 'columnist', 'called', 'independent', 'bassist', 'blur', 'jamming', 'tremendous', 'felt', 'effervescent', 'anything', '?so', 'we?d', 'finished', 'smoke', 'water', 'stare', 'gormless', 'bigger', 'count', 'loud', 'watching', 'lips', 'reading', 'installed', 'room', 'powerful', 'stereo', 'system', 'twirling', 'timber', '500', 'watts', 'drowned', 'completely', 'ways', 'excellent', 'means', 'tottenham', 'court', 'road', 'hifi', 'children', 'trying', 'homework', 'wife', 'nap', 'family', 'london', 'son', 'neighbours', 'morning', 'announced', 'yesterday', 'wants', 'local', 'draw', 'breath', 'already', 'bagged', 'colleagues', 'he?d', 'call', 'steve', 'winwood', 'lives', 'nearby', 'he?s', 'course', 'disloyal', 'disappointment', 'mean', 'takes', 'longer', 'work', 'i?ll', 'let', 'details', 'gig', '2438924039251', 'html')
Line : 251
File : functions_search.php
I've created a thread recently so it isn't a Forum wide problem.SL65AMG~V12~612BHP!!!!!!! said:I've been trying to make a thread all day and I still have the error I posted on page 2
Hopefully you or Quiky can fix it
Quiky said:PhpBB2 is outdated and incompatible with the new MySQL 4.1+ standards for storing and transmitting data.