Menu

#21 Duplicate entry

open
nobody
5
2006-08-16
2006-08-16
NaviFriends
No

Olympus Beta2

users_upgrade from:
Modified Mon Aug 14 21:19:57 2006 UTC (34 hours, 36
minutes ago) by highwayoflife

SQL ERROR [ mysql4 ]

Duplicate entry '7' for key 1 [1062]

SQL

INSERT INTO phpbb_users (user_id, user_type, group_id,
user_permissions, user_perm_from, user_ip,
user_regdate, username, user_password, user_passchg,
user_email, user_email_hash, user_birthday,
user_lastvisit, user_lastmark, user_lastpost_time,
user_lastpage, user_last_confirm_key, user_last_search,
user_warnings, user_last_warning, user_login_attempts,
user_posts, user_lang, user_timezone, user_dst,
user_dateformat, user_style, user_colour,
user_new_privmsg, user_unread_privmsg,
user_last_privmsg, user_message_rules,
user_full_folder, user_emailtime, user_topic_show_days,
user_topic_sortby_type, user_topic_sortby_dir,
user_post_show_days, user_post_sortby_type,
user_post_sortby_dir, user_notify, user_notify_pm,
user_notify_type, user_allow_pm, user_allow_email,
user_allow_viewonline, user_allow_viewemail,
user_allow_massemail, user_options, user_avatar,
user_avatar_type, user_avatar_width,
user_avatar_height, user_sig, user_sig_bbcode_uid,
user_sig_bbcode_bitfield, user_from, user_icq,
user_aim, user_yim, user_msnm, user_jabber,
user_website, user_occ, user_interests, user_actkey,
user_newpasswd, user_rank) VALUES (7, '0', '7', '',
'0', '', 'xx', 'xx', 'xx', '0', 'xx', 'xx', '', 'xx',
'xx', 'xx', '', '', '0', '0', '0', '0', '3085', 'en',
'2.00', '0', 'd.m.Y G:i s', '1', '', '12', '1', 'xx',
'0', '-3', '', '0', 't', 'd', '0', 't', 'a', '0', '0',
'0', '1', '1', '1', '1', '1', '893', 'xx', '1', 0, 0,
'xx', '5c783', 'CA==', 'xx', '', '', '', '', '', '',
'MN|5.1', 'H2210', '', '', '1')

BACKTRACE

FILE: includes/db/mysql4.php
LINE: 120
CALL: dbal_mysql4->sql_error()

FILE: upgrade/users_upgrade.php
LINE: 282
CALL: dbal_mysql4->sql_query()

FILE: upgrade/index.php
LINE: 207
CALL: include_once('upgrade/users_upgrade.php')

Discussion


Log in to post a comment.