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

Home » FUDforum » How To » SQL Error
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
SQL Error [message #167984] Mon, 03 December 2012 11:07 Go to next message
WhiteTiger is currently offline  WhiteTiger   Italy
Messages: 40
Registered: April 2012
Karma: 0
Member
From same day I read in the log this SQL error.
The name reported in the log is maybe a user collected from Usenet.

Any suggestion?
Thanks in advance


(/domain-address/private_html/fudfdata/include/theme/default/db.inc:104
/domain-address/private_html/fudfdata/include/theme/default/db.inc:211
/domain-address/private_html/fudfdata/include/theme/default/users_reg.inc:2 10
/domain-address/private_html/fudfdata/include/scripts_common.inc:73
/domain-address/private_html/fudfdata/include/scripts_common.inc:29
/domain-address/private_html/fudfdata/scripts/nntp.php:198
) 1062: Duplicate entry 'ciccioalby123[1][2][3][' for key 'fudfci_users_i_a'
Query: INSERT INTO fudfci_users ( login, alias, passwd, salt, name, email, avatar, avatar_loc, icq, aim, yahoo, msnm, jabber, affero, google, skype, twitter, posts_ppg, time_zone, birthday, last_visit, conf_key, user_image, join_date, location, theme, occupation, interests, referer_id, last_read, sig, home_page, bio, users_opt, registration_ip, topics_per_page, flag_cc, flag_country, custom_fields ) VALUES ( 'ciccioalby123[1][2][3][4][5]', 'ciccioalby123[1][2][3][4]', '4cd44aeeb82a0a103b806f7e6fbb76f3ee986a16', '26e90ff41', 'Ciccioalby123', 'uimhc0iogv1qttazxmhz1gzumpzddhll(at)user(dot)narkive(dot)com', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 40, 'Europe/Rome', NULL, 1354532401, '', NULL, 1349034087, NULL, 1, NULL, NULL, 0, 1354532401, NULL, NULL, NULL, 4356884, '::1', 40, NULL, NULL, '' )
Database version: 5.1.59-log


Re: SQL Error [message #167987 is a reply to message #167984] Mon, 03 December 2012 17:44 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
This patch may help:
https://sourceforge.net/apps/trac/fudforum/changeset/5560
Re: SQL Error [message #167992 is a reply to message #167987] Tue, 04 December 2012 16:56 Go to previous message
WhiteTiger is currently offline  WhiteTiger   Italy
Messages: 40
Registered: April 2012
Karma: 0
Member
Yes, thanks.

I see that after applied this patch I can collect again the messages from the usenet newsgroups.
In other words the problem in the SQL has blocked also the newsgroups reader.


  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: how to create an automatic process to add a list of users
Next Topic: Problem with USENET (it.comp.java)
Goto Forum:
  

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

Current Time: Sat Jun 01 04:06:03 GMT 2024

Total time taken to generate the page: 0.02837 seconds