FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Small Upgrade Problems with ' and "Duplicate entry" (Duplicate entry error)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Return to the default flat view Create a new topic Submit Reply
Small Upgrade Problems with ' and "Duplicate entry" [message #161829] Thu, 11 February 2010 15:24 Go to previous message
alopezie is currently offline  alopezie   Germany
Messages: 98
Registered: September 2003
Karma:
Member
add to buddy list
ignore all messages by this user
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 04:29]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
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) ] [ RSS ]

Current Time: Sun Jul 15 17:22:44 EDT 2018

Total time taken to generate the page: 0.00734 seconds