Seyfullah
29-07-2012, 11:56
Merhaba arkadaşlar.
öncelikle herkese hayırlı ramazanlar dilerim.
Soruma gelince, bir tablom var ismi site_kategoriler diyelim, içerisinde 2,8 k çapında kategorilerim mevcut. Bu kategorileri shop modülüme daha doğrusu shop tablosuna ilance_stores_category eklemek istiyorum. Benim phpmyadmin ile pek bilgim yok. Tabloyu export edip yüklemek istediğime import dedim ve hata aldım.
Tablodan küçük bir kısım:
-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 26. Jul 2012 um 05:02
-- Server Version: 5.1.63
-- PHP-Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `XXX`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ilance_stores_category``
--
CREATE TABLE IF NOT EXISTS `ilance_stores_category` (
`cid` int(100) NOT NULL AUTO_INCREMENT,
`parentid` int(100) NOT NULL DEFAULT '0',
`sets` linestring NOT NULL,
`description_ger` varchar(200) NOT NULL,
`title_ger` varchar(200) NOT NULL,
`level` int(5) NOT NULL DEFAULT '1',
`title_eng` mediumtext,
`description_eng` mediumtext,
`canpost` int(1) NOT NULL DEFAULT '1',
`lastpost` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`views` int(100) NOT NULL DEFAULT '0',
`xml` int(1) NOT NULL DEFAULT '0',
`portfolio` int(1) NOT NULL DEFAULT '0',
`newsletter` int(1) NOT NULL DEFAULT '0',
`auctioncount` int(10) NOT NULL DEFAULT '0',
`budgetgroup` varchar(250) NOT NULL DEFAULT '',
`insertiongroup` varchar(250) NOT NULL DEFAULT '',
`finalvaluegroup` varchar(250) NOT NULL DEFAULT '',
`incrementgroup` varchar(250) NOT NULL DEFAULT '',
`cattype` enum('service','product') NOT NULL DEFAULT 'service',
`bidamounttypes` mediumtext,
`usefixedfees` int(1) NOT NULL DEFAULT '0',
`fixedfeeamount` double(10,2) NOT NULL DEFAULT '0.00',
`nondisclosefeeamount` double(10,2) NOT NULL DEFAULT '0.00',
`multipleaward` int(1) NOT NULL DEFAULT '0',
`bidgrouping` int(1) NOT NULL DEFAULT '0',
`bidgroupdisplay` enum('lowest','highest') NOT NULL DEFAULT 'lowest',
`hidebuynow` int(1) DEFAULT '0',
`useproxybid` int(1) NOT NULL DEFAULT '0',
`usereserveprice` int(1) NOT NULL DEFAULT '1',
`useantisnipe` int(1) NOT NULL DEFAULT '0',
`bidfields` mediumtext,
`catimage` varchar(250) NOT NULL DEFAULT '',
`durationdays` mediumtext NOT NULL,
`durationhours` mediumtext NOT NULL,
`durationminutes` mediumtext NOT NULL,
`keywords_ger` varchar(250) NOT NULL DEFAULT '',
`keywords_eng` mediumtext,
`visible` int(1) NOT NULL DEFAULT '1',
`sort` int(3) NOT NULL DEFAULT '0',
`lft` int(10) NOT NULL,
`rgt` int(10) NOT NULL,
PRIMARY KEY (`cid`),
KEY `parentid` (`parentid`),
KEY `level` (`level`),
KEY `cattype` (`cattype`),
KEY `bidgroupdisplay` (`bidgroupdisplay`),
KEY `budgetgroup` (`budgetgroup`),
KEY `insertiongroup` (`insertiongroup`),
KEY `finalvaluegroup` (`finalvaluegroup`),
KEY `incrementgroup` (`incrementgroup`),
SPATIAL KEY `sx_categories_sets` (`sets`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2620 ;
--
-- Daten für Tabelle `ilance_stores_category`
--
INSERT INTO `ilance_stores_category` (`cid`, `parentid`, `sets`, `description_ger`, `title_ger`, `level`, `title_eng`, `description_eng`, `canpost`, `lastpost`, `views`, `xml`, `portfolio`, `newsletter`, `auctioncount`, `budgetgroup`, `insertiongroup`, `finalvaluegroup`, `incrementgroup`, `cattype`, `bidamounttypes`, `usefixedfees`, `fixedfeeamount`, `nondisclosefeeamount`, `multipleaward`, `bidgrouping`, `bidgroupdisplay`, `hidebuynow`, `useproxybid`, `usereserveprice`, `useantisnipe`, `bidfields`, `catimage`, `durationdays`, `durationhours`, `durationminutes`, `keywords_ger`, `keywords_eng`, `visible`, `sort`, `lft`, `rgt`) VALUES
(3, 0, 0x00000000010200000002000000000000000000f0bf000000 0000709d40000000000000f03f00000000008ea040, '', 'Computer, Tablets & Netzwerk', 1, 'Computer, Tablets & Netzwerk', '', 1, '0000-00-00 00:00:00', 23, 1, 0, 1, 0, '', '0', 'Standard', 'standard', 'product', '', 0, 0.00, 0.00, 0, 0, 'lowest', 0, 1, 1, 0, '', '', '', '', '', 'Computer, Tablets & Netzwerk', 'Computer, Tablets & Netzwerk', 1, 0, 1884, 2119);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Bunu nasıl yapabilirim, yardımcı olabilecek olan var mı? :anlamamis:
öncelikle herkese hayırlı ramazanlar dilerim.
Soruma gelince, bir tablom var ismi site_kategoriler diyelim, içerisinde 2,8 k çapında kategorilerim mevcut. Bu kategorileri shop modülüme daha doğrusu shop tablosuna ilance_stores_category eklemek istiyorum. Benim phpmyadmin ile pek bilgim yok. Tabloyu export edip yüklemek istediğime import dedim ve hata aldım.
Tablodan küçük bir kısım:
-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 26. Jul 2012 um 05:02
-- Server Version: 5.1.63
-- PHP-Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `XXX`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ilance_stores_category``
--
CREATE TABLE IF NOT EXISTS `ilance_stores_category` (
`cid` int(100) NOT NULL AUTO_INCREMENT,
`parentid` int(100) NOT NULL DEFAULT '0',
`sets` linestring NOT NULL,
`description_ger` varchar(200) NOT NULL,
`title_ger` varchar(200) NOT NULL,
`level` int(5) NOT NULL DEFAULT '1',
`title_eng` mediumtext,
`description_eng` mediumtext,
`canpost` int(1) NOT NULL DEFAULT '1',
`lastpost` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`views` int(100) NOT NULL DEFAULT '0',
`xml` int(1) NOT NULL DEFAULT '0',
`portfolio` int(1) NOT NULL DEFAULT '0',
`newsletter` int(1) NOT NULL DEFAULT '0',
`auctioncount` int(10) NOT NULL DEFAULT '0',
`budgetgroup` varchar(250) NOT NULL DEFAULT '',
`insertiongroup` varchar(250) NOT NULL DEFAULT '',
`finalvaluegroup` varchar(250) NOT NULL DEFAULT '',
`incrementgroup` varchar(250) NOT NULL DEFAULT '',
`cattype` enum('service','product') NOT NULL DEFAULT 'service',
`bidamounttypes` mediumtext,
`usefixedfees` int(1) NOT NULL DEFAULT '0',
`fixedfeeamount` double(10,2) NOT NULL DEFAULT '0.00',
`nondisclosefeeamount` double(10,2) NOT NULL DEFAULT '0.00',
`multipleaward` int(1) NOT NULL DEFAULT '0',
`bidgrouping` int(1) NOT NULL DEFAULT '0',
`bidgroupdisplay` enum('lowest','highest') NOT NULL DEFAULT 'lowest',
`hidebuynow` int(1) DEFAULT '0',
`useproxybid` int(1) NOT NULL DEFAULT '0',
`usereserveprice` int(1) NOT NULL DEFAULT '1',
`useantisnipe` int(1) NOT NULL DEFAULT '0',
`bidfields` mediumtext,
`catimage` varchar(250) NOT NULL DEFAULT '',
`durationdays` mediumtext NOT NULL,
`durationhours` mediumtext NOT NULL,
`durationminutes` mediumtext NOT NULL,
`keywords_ger` varchar(250) NOT NULL DEFAULT '',
`keywords_eng` mediumtext,
`visible` int(1) NOT NULL DEFAULT '1',
`sort` int(3) NOT NULL DEFAULT '0',
`lft` int(10) NOT NULL,
`rgt` int(10) NOT NULL,
PRIMARY KEY (`cid`),
KEY `parentid` (`parentid`),
KEY `level` (`level`),
KEY `cattype` (`cattype`),
KEY `bidgroupdisplay` (`bidgroupdisplay`),
KEY `budgetgroup` (`budgetgroup`),
KEY `insertiongroup` (`insertiongroup`),
KEY `finalvaluegroup` (`finalvaluegroup`),
KEY `incrementgroup` (`incrementgroup`),
SPATIAL KEY `sx_categories_sets` (`sets`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2620 ;
--
-- Daten für Tabelle `ilance_stores_category`
--
INSERT INTO `ilance_stores_category` (`cid`, `parentid`, `sets`, `description_ger`, `title_ger`, `level`, `title_eng`, `description_eng`, `canpost`, `lastpost`, `views`, `xml`, `portfolio`, `newsletter`, `auctioncount`, `budgetgroup`, `insertiongroup`, `finalvaluegroup`, `incrementgroup`, `cattype`, `bidamounttypes`, `usefixedfees`, `fixedfeeamount`, `nondisclosefeeamount`, `multipleaward`, `bidgrouping`, `bidgroupdisplay`, `hidebuynow`, `useproxybid`, `usereserveprice`, `useantisnipe`, `bidfields`, `catimage`, `durationdays`, `durationhours`, `durationminutes`, `keywords_ger`, `keywords_eng`, `visible`, `sort`, `lft`, `rgt`) VALUES
(3, 0, 0x00000000010200000002000000000000000000f0bf000000 0000709d40000000000000f03f00000000008ea040, '', 'Computer, Tablets & Netzwerk', 1, 'Computer, Tablets & Netzwerk', '', 1, '0000-00-00 00:00:00', 23, 1, 0, 1, 0, '', '0', 'Standard', 'standard', 'product', '', 0, 0.00, 0.00, 0, 0, 'lowest', 0, 1, 1, 0, '', '', '', '', '', 'Computer, Tablets & Netzwerk', 'Computer, Tablets & Netzwerk', 1, 0, 1884, 2119);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Bunu nasıl yapabilirim, yardımcı olabilecek olan var mı? :anlamamis: