Cyberdog Posted February 7, 2010 Share Posted February 7, 2010 Hi, I have uploaded a website to my webserver. However when i log into phpMy admin, and try to import my database i get the following error code. I would appreciate some help with this please, because i have not got a clue. Error SQL query: -- -- Dumping data for table `bak_banner` -- INSERT INTO `bak_banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`, `catid`, `description`, `sticky`, `ordering`, `publish_up`, `publish_down`, `tags`, `params`) VALUES (1, 1, 'banner', 'OSM 1', 'osm-1', 0, 43, 0, 'osmbanner1.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 62, '2010-01-24 15:54:36', '', '', 13, '', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (2, 1, 'banner', 'OSM 2', 'osm-2', 0, 49, 0, 'osmbanner2.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 62, '2010-01-24 15:55:43', '', '', 13, '', 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (3, 1, '', 'Joomla!', 'joomla', 0, 39, 0, '', 'http://www.joomla.org', '2006-05-29 14:21:28', 1, 62, '2010-01-24 15:56:04', '', '{NAME}\r\n MySQL said: Documentation #1062 - Duplicate entry '1' for key 'PRIMARY' Quote Link to comment https://forums.phpfreaks.com/topic/191290-php-error-code-help/ Share on other sites More sharing options...
gizmola Posted February 7, 2010 Share Posted February 7, 2010 Well it looks like there is already data in the bak_banner table. Quote Link to comment https://forums.phpfreaks.com/topic/191290-php-error-code-help/#findComment-1008589 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.