السلام عليكم ورحمة الله وبركاته
المشكله
الحل حذف الجداول التاليه ومن ثم زراعتهم بأخري
usertextfield
profilefield
userfield
لزرع الجداول من جديد
المشكله
كود:
Database error in vBulletin 3.8.7:
Invalid SQL:
INSERT INTO userfield
(field1, field2, field3, field4, userid)
VALUES
('', '', '', '', 427);
MySQL Error : Duplicate entry '427' for key 'PRIMARY'
Error Number : 1062
Request Date : Sunday, April 1st 2012 @ 12:08:17 AM
Error Date : Sunday, April 1st 2012 @ 12:08:18 AM
Script : http://www.example.com/vb/user.php?do=update
Referrer : http://www.example.com/vb/user.php?do=add
IP Address : 00.00.00.00
Username : Support
Classname : vB_Database
MySQL Version : 5.1.61
usertextfield
profilefield
userfield
لزرع الجداول من جديد
PHP:
CREATE TABLE `usertextfield` (
`userid` int(10) unsigned NOT NULL default '0',
`subfolders` mediumtext,
`pmfolders` mediumtext,
`buddylist` mediumtext,
`ignorelist` mediumtext,
`signature` mediumtext,
`searchprefs` mediumtext,
`rank` mediumtext,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;# MySQL returned an empty result set (i.e. zero rows).
--
-- Dumping data for table `usertextfield`
--
INSERT INTO `usertextfield` VALUES (1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);# 1 row affected.
الجدول التاني
PHP:
CREATE TABLE `userfield` (
`userid` int(10) unsigned NOT NULL default '0',
`temp` mediumtext,
`field1` mediumtext,
`field2` mediumtext,
`field3` mediumtext,
`field4` mediumtext,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `userfield`
--
INSERT INTO `userfield` VALUES (1, NULL, '', '', '', '');
الجدول الثالث
وبالتوفيق للجميع ..
PHP:
CREATE TABLE `profilefield` (
`profilefieldid` smallint(5) unsigned NOT NULL auto_increment,
`profilefieldcategoryid` smallint(5) unsigned NOT NULL default '0',
`required` smallint(6) NOT NULL default '0',
`hidden` smallint(6) NOT NULL default '0',
`maxlength` smallint(6) NOT NULL default '250',
`size` smallint(6) NOT NULL default '25',
`displayorder` smallint(6) NOT NULL default '0',
`editable` smallint(6) NOT NULL default '1',
`type` enum('input','select','radio','textarea','checkbox','select_multiple') NOT NULL default 'input',
`data` mediumtext,
`height` smallint(6) NOT NULL default '0',
`def` smallint(6) NOT NULL default '0',
`optional` smallint(5) unsigned NOT NULL default '0',
`searchable` smallint(6) NOT NULL default '0',
`memberlist` smallint(6) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
`form` smallint(6) NOT NULL default '0',
`html` smallint(6) NOT NULL default '0',
`perline` smallint(6) NOT NULL default '0',
PRIMARY KEY (`profilefieldid`),
KEY `editable` (`editable`),
KEY `profilefieldcategoryid` (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `profilefield`
--
INSERT INTO `profilefield` VALUES (1, 0, 0, 0, 100, 25, 1, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0);
INSERT INTO `profilefield` VALUES (2, 0, 0, 0, 100, 25, 2, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0);
INSERT INTO `profilefield` VALUES (3, 0, 0, 0, 100, 25, 3, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0);
INSERT INTO `profilefield` VALUES (4, 0, 0, 0, 100, 25, 4, 1, 'input', '', 0, 0, 0, 1, 1, '', 0, 0, 0);
وبالتوفيق للجميع ..