Bu sorunun nedeni yada kaynağı nedir acaba ? Yardımcı olabilirseniz sevinirim.
INSERT INTO `phpbb_users` VALUES (-1, 0, 'Anonymous', '', 0, 0, 0, 1137333702, 0, 0, 0.00, NULL, '', '', 0, 0, 0, NULL, 0, 0, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, '', '', '', '', '', NULL, '', '', '', '', '', '', '', 0, 0);
SQL-query:
INSERT INTO `phpbb_users`
VALUES (
-1, 0, 'Anonymous', '', 0, 0, 0, 1137333702, 0, 0, 0.00, NULL , '', '', 0, 0, 0, NULL , 0, 0, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL , '', 0, '', '', '', '', '', NULL , '', '', '', '', '', '', '', 0, 0
)
MySQL said:
#1136 - Column count doesn't match value count at row 1
UPDATE `phpbb_users` SET `user_id` = '-1',
`user_active` = '0',
`username` = '',
`user_password` = '',
`user_style` = NULL ,
`user_lang` = NULL ,
`user_emailtime` = NULL ,
`user_email` = NULL ,
`user_website` = '',
`user_from` = '',
`user_sig` = '',
`user_sig_bbcode_uid` = '',
`user_newpasswd` = NULL ,
`user_quickreply` = '' WHERE `user_id` = '44' LIMIT 1
MySQL said:
#1062 - Duplicate entry '-1' for key 1
INSERT INTO `phpbb_users` VALUES (-1, 0, 'Kullanıcı_adı', '', 0, 0, 0, 1124871392, 0, 5, '0.00', NULL, '', '', 0, 0, 0, NULL, 0, 0, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, '', '', '', '', '', NULL, '', '', '', '', '', '', '', 0);
--
-- Tablo yapısı : `phpbb_users`
--
CREATE TABLE `phpbb_users` (
`user_id` mediumint(8) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`username` varchar(25) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_regdate` int(11) NOT NULL default '0',
`user_level` tinyint(4) default '0',
`user_posts` mediumint(8) unsigned NOT NULL default '0',
`user_timezone` decimal(5,2) NOT NULL default '0.00',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) default NULL,
`user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_login_tries` smallint(5) unsigned NOT NULL default '0',
`user_last_login_try` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_viewemail` tinyint(1) default NULL,
`user_attachsig` tinyint(1) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '1',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_rank` int(11) default '0',
`user_avatar` varchar(100) default NULL,
`user_avatar_type` tinyint(4) NOT NULL default '0',
`user_email` varchar(255) default NULL,
`user_icq` varchar(15) default NULL,
`user_website` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_sig` text,
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_aim` varchar(255) default NULL,
`user_yim` varchar(255) default NULL,
`user_msnm` varchar(255) default NULL,
`user_occ` varchar(100) default NULL,
`user_interests` varchar(255) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`user_quickreply` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`user_id`),
KEY `user_session_time` (`user_session_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Tablo döküm verisi `phpbb_users`
--
INSERT INTO `phpbb_users` VALUES (2, 1, 'admin', '743894a0e4a801fc3', 1142852118, 0, 1142809443, 1142087623, 1, 2, 0.00, 1, 'turkish', 'd M Y h:i a', 0, 0, 0, 0, 0, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, '', 0, 'xx@msn.com', '', '', '', '', NULL, '', '', '', '', '', '', '', 1);
INSERT INTO `phpbb_users` VALUES (3, 1, 'xscore', '963e2ac9d0813e63c', 1142852089, 0, 1142848169, 1142096209, 1, 139, 0.00, 2, 'turkish', 'D M d, Y g:i a', 0, 0, 1142799548, 0, 0, NULL, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 0, '', 0, 'xx@hotmail.com', '', '', '', 'Forever', 'cc83570e19', '', '', '', '', '', '', NULL, 1);
INSERT INTO `phpbb_users` VALUES (-1, 0, 'Anonymous', '', 0, 0, 0, 1137333702, 0,0, 0.00, NULL, '', '', 0, 0, 0, 0, 0, NULL, 0, 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, '', 0, '', '', '', '', '', NULL, '', '', '', '', '', '', '', 0);
INSERT INTO `phpbb_users` ( `user_id` , `user_active` , `username` , `user_password` , `user_session_time` , `user_session_page` , `user_lastvisit` , `user_regdate` , `user_level` , `user_posts` , `user_timezone` , `user_style` , `user_lang` , `user_dateformat` , `user_new_privmsg` , `user_unread_privmsg` , `user_last_privmsg` , `user_emailtime` , `user_viewemail` , `user_attachsig` , `user_allowhtml` , `user_allowbbcode` , `user_allowsmile` , `user_allowavatar` , `user_allow_pm` , `user_allow_viewonline` , `user_notify` , `user_notify_pm` , `user_popup_pm` , `user_rank` , `user_avatar` , `user_avatar_type` , `user_email` , `user_icq` , `user_website` , `user_from` , `user_sig` , `user_sig_bbcode_uid` , `user_aim` , `user_yim` , `user_msnm` , `user_occ` , `user_interests` , `user_actkey` , `user_newpasswd` )
VALUES (
-1, 0, 'Anonymous', '', 0, 0, 0, 1141650596, 0, 0, 0.00, NULL , '', '', 0, 0, 0, NULL , 0, 0, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL , '', 0, '', '', '', '', '', NULL , '', '', '', '', '', '', ''
)
INSERT INTO `phpbb_users`VALUES ( -1, 0, 'Anonymous', '', 0, 0, 0, 1141650596, 0, 0, 0.00, NULL , '', '', 0, 0, 0, NULL , 0, 0, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL , '', 0, '', '', '', '', '', NULL , '', '', '', '', '', '', '' )
Bu forumu görüntüleyenler: Kayıtlı kullanıcı yok ve 0 misafir