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 
Switch to threaded view of this topic Create a new topic Submit Reply
Small Upgrade Problems with ' and "Duplicate entry" [message #161829] Thu, 11 February 2010 15:24 Go to next message
alopezie is currently offline  alopezie   Germany
Messages: 92
Registered: September 2003
Karma: 1
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

Re: Small Upgrade Problems with ' and "Duplicate entry" [message #161837 is a reply to message #161829] Fri, 12 February 2010 10:23 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3645
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Patch committed - http://fudforum.svn.sourceforge.net/viewvc/fudforum?view=rev&revision=4 908

I trust it won't be necessary to make a new release available. Users that want to upgrade from very old releases will have to apply the fix themselves (for now at least).
Re: Small Upgrade Problems with ' and "Duplicate entry" [message #186747 is a reply to message #161837] Thu, 05 February 2015 18:49 Go to previous messageGo to next message
WhiteFire is currently offline  WhiteFire   United States
Messages: 16
Registered: March 2002
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
And with that winning bit of support I think it's time to convert to SMF after... what... oh we have been running it since at least 2003 at Tapestries.

Oh well.
Re: Small Upgrade Problems with ' and "Duplicate entry" [message #186748 is a reply to message #186747] Fri, 06 February 2015 01:03 Go to previous message
naudefj is currently offline  naudefj   
Messages: 3645
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
SMF is one of the better choices - good luck!

For those who stay behind, this patch is part of the latest release.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Sat Apr 21 05:57:29 EDT 2018

Total time taken to generate the page: 0.00775 seconds