Bug #55997

Sync news/mail to forum is broken for typo3-german

Added by Steffen Gebert over 5 years ago. Updated about 2 years ago.

Status:
Rejected
Priority:
Must have
Assignee:
Category:
-
Target version:
-
Start date:
2014-02-14
Due date:
% Done:

100%


Description

The german list / news group isn't synched to the forum currently.

The import fails with an SQL error

1062: Duplicate entry 'J' for key 'fud30_users_i_l'
Query: INSERT INTO fud30_users ( login, alias, ... ) VALUES ( 'J�rg Schaller', 'J�rg Schaller',......' )

Somewhere in the import there's a hiccup with the umlaut so that MySQL seems to truncate the name (because the resulting entry is a "J" only, which already exists for the login column.

History

#1 Updated by Steffen Gebert over 5 years ago

Tim, can you have a look, please?

#2 Updated by Steffen Gebert over 5 years ago

Deactivated sync of typo3-german and typo3-showroom for the moment by changing the host name in the forum's nntp settings.

#3 Updated by Tim Duelken over 5 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

We had that before. For quick solution I renamed the User "J" in the database. As it is not used for matching user it doesn't matter.

I re-enabled the sync as well. Will have a look at the script if this behavior could be avoided.

#4 Updated by Steffen Gebert over 5 years ago

  • Status changed from Resolved to Under Review

Thanks, Tim. I investigated it a bit and am about to post it to the Fudforum.

#5 Updated by Tim Duelken over 5 years ago

Okay - let me know if I could be of any help.

#6 Updated by Steffen Gebert over 5 years ago

Here it is: http://fudforum.org/forum/index.php?t=msg&goto=184912

If you have details, just add them!

Thanks for your quick help!

#7 Updated by Michael Stucki over 5 years ago

Here is one more list which is not synched:

Can you fix that please?

#8 Updated by Michael Stucki over 5 years ago

Reminder

#9 Updated by Tim Duelken over 5 years ago

No replies on Steffens message in the FudForum-Forum. Currently everything works fine as I can see.

#11 Updated by Steffen Gebert about 2 years ago

  • Status changed from Under Review to Rejected

Also available in: Atom PDF