Hallo und Guten Abend zusammen,
Ich habe gerade Versucht eine Datei zu Importieren leider ohne Erfolg bzw mit diesem Fehlercode:
und das die zu Importierende Datei:
Die Version hab ich schon überprüft und ist 5........
Ich hoffe mir kann da einer weiterhelfen
Ich habe gerade Versucht eine Datei zu Importieren leider ohne Erfolg bzw mit diesem Fehlercode:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1134411584' at line 21
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 12, 2005 at 02:21 PM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
--
-- Database: `bpscom_buypix`
--
-- --------------------------------------------------------
--
-- Table structure for table `area`
--
DROP TABLE IF EXISTS `area`;
CREATE TABLE IF NOT EXISTS `area` (
`id` int(10) unsigned NOT NULL auto_increment,
`x1` int(11) NOT NULL default '0',
`y1` int(11) NOT NULL default '0',
`x2` int(11) NOT NULL default '0',
`y2` int(11) NOT NULL default '0',
`url` varchar(80) NOT NULL default '',
`title` varchar(80) NOT NULL default '',
`name` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`amount` varchar(20) NOT NULL default '',
`cnf_check` int(11) NOT NULL default '0',
`image_id` varchar(120) NOT NULL default '',
`img_name` varchar(40) NOT NULL default '',
`img_type` varchar(40) NOT NULL default '',
`img_filesize` varchar(40) NOT NULL default '',
`img_content` blob NOT NULL,
`paypal_txn_id` varchar(50) NOT NULL default '',
`clicks` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1134411584 ;
-- --------------------------------------------------------
--
-- Table structure for table `blog`
--
DROP TABLE IF EXISTS `blog`;
CREATE TABLE IF NOT EXISTS `blog` (
`added` datetime default NULL,
`title` text NOT NULL,
`message` text NOT NULL,
`postedby` varchar(40) NOT NULL default '',
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=21 ;
-- --------------------------------------------------------
--
-- Table structure for table `email`
--
DROP TABLE IF EXISTS `email`;
CREATE TABLE IF NOT EXISTS `email` (
`message` text NOT NULL,
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`),
FULLTEXT KEY `message` (`message`),
FULLTEXT KEY `message_2` (`message`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `paypal_details`
--
DROP TABLE IF EXISTS `paypal_details`;
CREATE TABLE IF NOT EXISTS `paypal_details` (
`mc_gross` varchar(255) NOT NULL default '',
`address_status` varchar(255) NOT NULL default '',
`payer_id` varchar(255) NOT NULL default '',
`tax` varchar(255) NOT NULL default '',
`address_street` varchar(255) NOT NULL default '',
`payment_date` varchar(255) NOT NULL default '',
`payment_status` varchar(255) NOT NULL default '',
`charset` varchar(255) NOT NULL default '',
`address_zip` varchar(255) NOT NULL default '',
`first_name` varchar(255) NOT NULL default '',
`address_country_code` varchar(255) NOT NULL default '',
`address_name` varchar(255) NOT NULL default '',
`address_version` varchar(255) NOT NULL default '',
`notify_version` varchar(255) NOT NULL default '',
`custom` varchar(255) NOT NULL default '',
`payer_status` varchar(255) NOT NULL default '',
`business` varchar(255) NOT NULL default '',
`payer_email` varchar(255) NOT NULL default '',
`txn_id` varchar(255) NOT NULL default '',
`payment_type` varchar(255) NOT NULL default '',
`last_name` varchar(255) NOT NULL default '',
`address_state` varchar(255) NOT NULL default '',
`receiver_email` varchar(255) NOT NULL default '',
`receiver_id` varchar(255) NOT NULL default '',
`pending_reason` varchar(255) NOT NULL default '',
`txn_type` varchar(255) NOT NULL default '',
`item_name` varchar(255) NOT NULL default '',
`mc_currency` varchar(255) NOT NULL default '',
`test_ipn` varchar(255) NOT NULL default '',
`payment_gross` varchar(255) NOT NULL default '',
`shipping` varchar(255) NOT NULL default '',
PRIMARY KEY (`txn_id`),
FULLTEXT KEY `receiver_id` (`receiver_id`),
FULLTEXT KEY `receiver_id_2` (`receiver_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
`key` varchar(32) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`key`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`key`, `value`) VALUES ('admin_password', 'demo');
INSERT INTO `settings` (`key`, `value`) VALUES ('website_url', 'http://www.buypixelscript.com/');
INSERT INTO `settings` (`key`, `value`) VALUES ('square_price', '1.00');
--
-- Table structure for table `temp`
--
DROP TABLE IF EXISTS `temp`;
CREATE TABLE IF NOT EXISTS `temp` (
`id` varchar(120) NOT NULL default '',
`x1` int(11) NOT NULL default '0',
`y1` int(11) NOT NULL default '0',
`x2` int(11) NOT NULL default '0',
`y2` int(11) NOT NULL default '0',
`url` varchar(80) NOT NULL default '',
`title` varchar(80) NOT NULL default '',
`name` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`amount` varchar(20) NOT NULL default '',
`cnf_check` int(11) NOT NULL default '0',
`img_name` varchar(40) NOT NULL default '',
`img_type` varchar(40) NOT NULL default '',
`img_filesize` varchar(40) NOT NULL default '',
`img_content` blob NOT NULL,
`paypal_txn_id` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `paypal_txn_id` (`paypal_txn_id`)
) TYPE=MyISAM;
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 12, 2005 at 02:21 PM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
--
-- Database: `bpscom_buypix`
--
-- --------------------------------------------------------
--
-- Table structure for table `area`
--
DROP TABLE IF EXISTS `area`;
CREATE TABLE IF NOT EXISTS `area` (
`id` int(10) unsigned NOT NULL auto_increment,
`x1` int(11) NOT NULL default '0',
`y1` int(11) NOT NULL default '0',
`x2` int(11) NOT NULL default '0',
`y2` int(11) NOT NULL default '0',
`url` varchar(80) NOT NULL default '',
`title` varchar(80) NOT NULL default '',
`name` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`amount` varchar(20) NOT NULL default '',
`cnf_check` int(11) NOT NULL default '0',
`image_id` varchar(120) NOT NULL default '',
`img_name` varchar(40) NOT NULL default '',
`img_type` varchar(40) NOT NULL default '',
`img_filesize` varchar(40) NOT NULL default '',
`img_content` blob NOT NULL,
`paypal_txn_id` varchar(50) NOT NULL default '',
`clicks` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1134411584 ;
-- --------------------------------------------------------
--
-- Table structure for table `blog`
--
DROP TABLE IF EXISTS `blog`;
CREATE TABLE IF NOT EXISTS `blog` (
`added` datetime default NULL,
`title` text NOT NULL,
`message` text NOT NULL,
`postedby` varchar(40) NOT NULL default '',
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=21 ;
-- --------------------------------------------------------
--
-- Table structure for table `email`
--
DROP TABLE IF EXISTS `email`;
CREATE TABLE IF NOT EXISTS `email` (
`message` text NOT NULL,
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`),
FULLTEXT KEY `message` (`message`),
FULLTEXT KEY `message_2` (`message`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `paypal_details`
--
DROP TABLE IF EXISTS `paypal_details`;
CREATE TABLE IF NOT EXISTS `paypal_details` (
`mc_gross` varchar(255) NOT NULL default '',
`address_status` varchar(255) NOT NULL default '',
`payer_id` varchar(255) NOT NULL default '',
`tax` varchar(255) NOT NULL default '',
`address_street` varchar(255) NOT NULL default '',
`payment_date` varchar(255) NOT NULL default '',
`payment_status` varchar(255) NOT NULL default '',
`charset` varchar(255) NOT NULL default '',
`address_zip` varchar(255) NOT NULL default '',
`first_name` varchar(255) NOT NULL default '',
`address_country_code` varchar(255) NOT NULL default '',
`address_name` varchar(255) NOT NULL default '',
`address_version` varchar(255) NOT NULL default '',
`notify_version` varchar(255) NOT NULL default '',
`custom` varchar(255) NOT NULL default '',
`payer_status` varchar(255) NOT NULL default '',
`business` varchar(255) NOT NULL default '',
`payer_email` varchar(255) NOT NULL default '',
`txn_id` varchar(255) NOT NULL default '',
`payment_type` varchar(255) NOT NULL default '',
`last_name` varchar(255) NOT NULL default '',
`address_state` varchar(255) NOT NULL default '',
`receiver_email` varchar(255) NOT NULL default '',
`receiver_id` varchar(255) NOT NULL default '',
`pending_reason` varchar(255) NOT NULL default '',
`txn_type` varchar(255) NOT NULL default '',
`item_name` varchar(255) NOT NULL default '',
`mc_currency` varchar(255) NOT NULL default '',
`test_ipn` varchar(255) NOT NULL default '',
`payment_gross` varchar(255) NOT NULL default '',
`shipping` varchar(255) NOT NULL default '',
PRIMARY KEY (`txn_id`),
FULLTEXT KEY `receiver_id` (`receiver_id`),
FULLTEXT KEY `receiver_id_2` (`receiver_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
`key` varchar(32) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`key`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`key`, `value`) VALUES ('admin_password', 'demo');
INSERT INTO `settings` (`key`, `value`) VALUES ('website_url', 'http://www.buypixelscript.com/');
INSERT INTO `settings` (`key`, `value`) VALUES ('square_price', '1.00');
--
-- Table structure for table `temp`
--
DROP TABLE IF EXISTS `temp`;
CREATE TABLE IF NOT EXISTS `temp` (
`id` varchar(120) NOT NULL default '',
`x1` int(11) NOT NULL default '0',
`y1` int(11) NOT NULL default '0',
`x2` int(11) NOT NULL default '0',
`y2` int(11) NOT NULL default '0',
`url` varchar(80) NOT NULL default '',
`title` varchar(80) NOT NULL default '',
`name` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`amount` varchar(20) NOT NULL default '',
`cnf_check` int(11) NOT NULL default '0',
`img_name` varchar(40) NOT NULL default '',
`img_type` varchar(40) NOT NULL default '',
`img_filesize` varchar(40) NOT NULL default '',
`img_content` blob NOT NULL,
`paypal_txn_id` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `paypal_txn_id` (`paypal_txn_id`)
) TYPE=MyISAM;
Ich hoffe mir kann da einer weiterhelfen
Kommentar