FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Bug Reports » nntp import crashed
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
nntp import crashed [message #161041] Wed, 11 November 2009 23:03 Go to next message
jm2morri is currently offline  jm2morri   Canada
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
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 />

Report message to a moderator

Re: nntp import crashed [message #161068 is a reply to message #161041] Thu, 12 November 2009 20:49 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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?

Report message to a moderator

Re: nntp import crashed [message #161089 is a reply to message #161068] Fri, 13 November 2009 12: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
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.

Report message to a moderator

Re: nntp import crashed [message #161097 is a reply to message #161089] Fri, 13 November 2009 21:36 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Before we continue, please run the MySQL Charset converter and post the output here.

Report message to a moderator

Re: nntp import crashed [message #161098 is a reply to message #161097] Sat, 14 November 2009 04: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
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

Report message to a moderator

Re: nntp import crashed [message #161102 is a reply to message #161098] Sat, 14 November 2009 07:22 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
May be the same problem as reported @ http://fudforum.org/forum/index.php?t=msg&th=118831

Report message to a moderator

Re: nntp import crashed [message #161105 is a reply to message #161102] Sat, 14 November 2009 19: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
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.

Report message to a moderator

Re: nntp import crashed [message #161106 is a reply to message #161105] Sat, 14 November 2009 20:52 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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

Report message to a moderator

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

James.

Report message to a moderator

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

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

Current Time: Sun Nov 24 07:17:53 GMT 2024

Total time taken to generate the page: 0.02703 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software