FUDforum: FUDforum Installation Issues » Small Upgrade Problems with ' and "Duplicate entry"

Home » FUDforum » FUDforum Installation Issues » Small Upgrade Problems with ' and "Duplicate entry" (Duplicate entry error)

Show: Today's Messages :: Polls :: Message Navigator

Small Upgrade Problems with ' and "Duplicate entry" [message #161829]

Thu, 11 February 2010 20:24

alopezie

Messages: 106
Registered: September 2003

Karma:

Senior Member

Its been reported in other posts, but seems still to be there:

Having an ' in user name OR in the search database seems to make problems,

Zitat:

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's' LIMIT 1' at line 1
QUERY: DELETE FROM bb_search WHERE word='war's' LIMIT 1

Also I got a number of "Duplicate entry 'xxx' in key 2" errors.

Zitat:

ERROR: Duplicate entry 'groÃŸe' for key 2
QUERY: ALTER TABLE bb_search CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

Always German characters here (groÃŸe = große), and none (!) of these real duplicates

Removing "unique" from the index in search database solved the problem, but took its time to look for it ...

Alopezie.de - das Forum zum Thema Haarausfall

[Updated on: Fri, 12 February 2010 09:29]

Report message to a moderator

[Message index]

		Small Upgrade Problems with ' and "Duplicate entry" By: alopezie on Thu, 11 February 2010 20:24
		Re: Small Upgrade Problems with ' and "Duplicate entry" By: naudefj on Fri, 12 February 2010 15:23
		Re: Small Upgrade Problems with ' and "Duplicate entry" By: WhiteFire on Thu, 05 February 2015 23:49
		Re: Small Upgrade Problems with ' and "Duplicate entry" By: naudefj on Fri, 06 February 2015 06:03

Previous Topic:	POP3 configuration
Next Topic:	FATAL ERROR: could not open message store for forum id#60000 fudforum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 28 15:20:05 GMT 2024

Total time taken to generate the page: 0.04684 seconds