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

Home » FUDforum » How To » SQL 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
SQL Error [message #167984] Mon, 03 December 2012 06:07 Go to next message
WhiteTiger is currently offline  WhiteTiger   Italy
Messages: 40
Registered: April 2012
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 12:44 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3631
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 11:56 Go to previous message
WhiteTiger is currently offline  WhiteTiger   Italy
Messages: 40
Registered: April 2012
Karma: 0
Member
add to buddy list
ignore all messages by this user
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.


Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Tue Dec 12 07:19:13 EST 2017

Total time taken to generate the page: 0.00731 seconds