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

Home » FUDforum Development » Bug Reports » nntp import crashed
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
nntp import crashed [message #161041] Wed, 11 November 2009 18:03 Go to next message
jm2morri is currently offline  jm2morri   Canada
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Here's what was sent to the terminal...

Importing eagle.support.ger message 21480
Importing eagle.support.ger message 21481
(/var/data/fudforum_data/include/theme/default/db.inc:72<br />
/var/data/fudforum_data/include/theme/default/db.inc:176<br />
/var/data/fudforum_data/include/theme/default/users_reg.inc:166<br />
/var/data/fudforum_data/include/scripts_common.inc:69<br />
/var/data/fudforum_data/include/scripts_common.inc:27<br />
/var/data/fudforum_data/include/nntp.inc:540<br />
/var/data/fudforum_data/scripts/nntp.php:92<br />
) 1062: Duplicate entry 'm' for key 2<br />
Query: INSERT INTO
fud277_users (
login,
alias,
passwd,
name,
email,
icq,
aim,
yahoo,
msnm,
jabber,
affero,
google,
skype,
twitter,
posts_ppg,
time_zone,
bday,
last_visit,
conf_key,
user_image,
join_date,
location,
theme,
occupation,
interests,
referer_id,
last_read,
sig,
home_page,
bio,
users_opt,
reg_ip,
topics_per_page,
flag_cc,
flag_country
) VALUES (
'm?ller',
'm?ller',
'fb52863d72ed74dab57df57899227cbc',
'm?ller',
'm?ller(at)grautier(dot)com',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
40,
'America/Montreal',
0,
1257976925,
'',
NULL,
1243083905,
NULL,
2,
NULL,
NULL,
0,
1257976925,
NULL,
NULL,
NULL,
4356628,
2130706433,
40,
NULL,
NULL
)
<br />
Server Version: 5.0.45<br />
Re: nntp import crashed [message #161068 is a reply to message #161041] Thu, 12 November 2009 15:49 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Looks like entry 'm?ller' is somehow interpreted by the DB as 'm' and there is already an 'm' in the database. What is this table & col's encoding?
Re: nntp import crashed [message #161089 is a reply to message #161068] Fri, 13 November 2009 07:45 Go to previous messageGo to next message
jm2morri is currently offline  jm2morri   Canada
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
naudefj wrote on Thu, 12 November 2009 15:49
Looks like entry 'm?ller' is somehow interpreted by the DB as 'm' and there is already an 'm' in the database. What is this table & col's encoding?


How do I find that out? I can browse through the database using myPhpSql (or whatever that is caused). What am I looking for?

James.
Re: nntp import crashed [message #161097 is a reply to message #161089] Fri, 13 November 2009 16:36 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Before we continue, please run the MySQL Charset converter and post the output here.
Re: nntp import crashed [message #161098 is a reply to message #161097] Fri, 13 November 2009 23:55 Go to previous messageGo to next message
jm2morri is currently offline  jm2morri   Canada
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
naudefj wrote on Fri, 13 November 2009 16:36
Before we continue, please run the MySQL Charset converter and post the output here.


Looks like everything was already converted. Results below...

Table fud277_action_log was already converted
Table fud277_ann_forums was already converted
Table fud277_announce was already converted
Table fud277_attach was already converted
Table fud277_avatar was already converted
Table fud277_blocked_logins was already converted
Table fud277_bookmarks was already converted
Table fud277_buddy was already converted
Table fud277_cat was already converted
Table fud277_custom_tags was already converted
Table fud277_email_block was already converted
Table fud277_ext_block was already converted
Table fud277_fc_view was already converted
Table fud277_fl_10 was already converted
Table fud277_fl_12 was already converted
Table fud277_fl_13 was already converted
Table fud277_fl_14 was already converted
Table fud277_fl_15 was already converted
Table fud277_fl_16 was already converted
Table fud277_fl_17 was already converted
Table fud277_fl_18 was already converted
Table fud277_fl_19 was already converted
Table fud277_fl_23 was already converted
Table fud277_fl_26 was successfully converted.
Table fud277_fl_27 was successfully converted.
Table fud277_fl_28 was successfully converted.
Table fud277_fl_29 was successfully converted.
Table fud277_fl_3 was already converted
Table fud277_fl_30 was successfully converted.
Table fud277_fl_6 was already converted
Table fud277_fl_9 was already converted
Table fud277_fl_pm was already converted
Table fud277_forum was already converted
Table fud277_forum_notify was already converted
Table fud277_forum_read was already converted
Table fud277_geoip was already converted
Table fud277_group_cache was already converted
Table fud277_group_members was already converted
Table fud277_group_resources was already converted
Table fud277_groups was already converted
Table fud277_index was already converted
Table fud277_ip_block was already converted
Table fud277_level was already converted
Table fud277_mime was already converted
Table fud277_mlist was already converted
Table fud277_mod was already converted
Table fud277_mod_que was already converted
Table fud277_msg was already converted
Table fud277_msg_report was already converted
Table fud277_msg_store was already converted
Table fud277_nntp was already converted
Table fud277_pmsg was already converted
Table fud277_poll was already converted
Table fud277_poll_opt was already converted
Table fud277_poll_opt_track was already converted
Table fud277_read was already converted
Table fud277_replace was already converted
Table fud277_search was already converted
Table fud277_search_cache was already converted
Table fud277_ses was already converted
Table fud277_smiley was already converted
Table fud277_stats_cache was already converted
Table fud277_themes was already converted
Table fud277_thr_exchange was already converted
Table fud277_thread was already converted
Table fud277_thread_notify was already converted
Table fud277_thread_rate_track was already converted
Table fud277_title_index was already converted
Table fud277_tv_10 was successfully converted.
Table fud277_tv_12 was successfully converted.
Table fud277_tv_13 was successfully converted.
Table fud277_tv_14 was successfully converted.
Table fud277_tv_15 was successfully converted.
Table fud277_tv_16 was successfully converted.
Table fud277_tv_17 was successfully converted.
Table fud277_tv_18 was successfully converted.
Table fud277_tv_19 was successfully converted.
Table fud277_tv_23 was successfully converted.
Table fud277_tv_26 was successfully converted.
Table fud277_tv_27 was successfully converted.
Table fud277_tv_28 was successfully converted.
Table fud277_tv_29 was successfully converted.
Table fud277_tv_3 was successfully converted.
Table fud277_tv_30 was successfully converted.
Table fud277_tv_6 was successfully converted.
Table fud277_tv_9 was successfully converted.
Table fud277_user_ignore was already converted
Table fud277_users was already converted
Table fud277_xmlagg was already converted
Re: nntp import crashed [message #161102 is a reply to message #161098] Sat, 14 November 2009 02:22 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
May be the same problem as reported @ http://fudforum.org/forum/index.php?t=msg&th=118831
Re: nntp import crashed [message #161105 is a reply to message #161102] Sat, 14 November 2009 14:56 Go to previous messageGo to next message
jm2morri is currently offline  jm2morri   Canada
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
naudefj wrote on Sat, 14 November 2009 02:22
May be the same problem as reported @ http://fudforum.org/forum/index.php?t=msg&th=118831


OK, but I don't quite follow what was actually changed in that thread. I'm not an SQL or DB guy, I just do what I need to get it done. A bit more explanation of what needs to change would be helpful.

James.
Re: nntp import crashed [message #161106 is a reply to message #161105] Sat, 14 November 2009 15:52 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
You need to use a tool like phpMyAdmin to check the encoding of table fud30_users' columns. INVY discovered that values are truncated for columns defined as utf8_bin. He solved the problem by converting these columns to utf8_unicode_ci.

INVY wrote on Sat, 07 November 2009 18:44
YES, resolved Surprised

Table: fud30_users
alias varchar(50) utf8_bin --> alias varchar(50) utf8_unicode_ci

Re: nntp import crashed [message #161122 is a reply to message #161106] Sun, 15 November 2009 17:37 Go to previous message
jm2morri is currently offline  jm2morri   Canada
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
That seems to have fixed this problem for me as well. Thanks for the help.

James.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: NNTP - empty message bodies
Next Topic: nntp import notice
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 23 04:09:24 EDT 2017

Total time taken to generate the page: 0.00773 seconds