hey leute,
ich habe ein problem was ich irgendwie nicht finde.
Ich will in meine Datenbank eine SQL importieren.
Nach dem Import erscheint dieser Fehler:
Finde den Fehler nicht!! Ich brauch dringend Hilfe!
Meine SQL werte was ich importieren will:
ich habe ein problem was ich irgendwie nicht finde.
Ich will in meine Datenbank eine SQL importieren.
Nach dem Import erscheint dieser Fehler:
Code:
SQL-Befehl: -- -- Dumping data for table `messages` -- INSERT INTO `messages` (`msg_id`, `header`, `date`, `message`) VALUES (1, 'A little guide - Fairly instant 15 bucks!', 'April 23rd, 2012', 'Hey, having some issues getting points?\r\n\r\nLet me help you out there.\r\n\r\nWithin Super Rewards we have two free trial offers that convert very quickly.\r\n\r\nTo do them, do the NetFlix offer with either your credit/debit card, or your paypal.\r\n\r\nAlong with 858 points, you will get access to NetFlix. Who DOESN''T want NetFlix?\r\n\r\nNow go do the same with Block Buster. You will have to use a valid credit card here. But it IS free. If you aren''t happy with Block Buster, you do not have to continue with the free trial, so it will cost you nothing!'), -- -------------------------------------------------------- -- -- Table structure for table `postback_logs` -- CREATE TABLE IF NOT EXISTS `postback_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` timestamp NOT NULL DEFAULT CURRENT_TI[...] MySQL meldet: Dokumentation #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 'CREATE TABLE IF NOT EXISTS `postback_logs` ( `id` int(11) NOT NULL AUTO_INCREM' at line 14
Meine SQL werte was ich importieren will:
PHP-Code:
-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost@Davidmedianet
-- Generation Time: May 04, 2014 at 07:31 PM
-- Server version: 5.5.21
-- PHP Version: 5.2.17
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 */;
--
-- Database: `interfa1_silent`
--
-- --------------------------------------------------------
--
-- Table structure for table `invites`
--
CREATE TABLE IF NOT EXISTS `invites` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`code` varchar(255) NOT NULL,
`isactive` tinyint(1) NOT NULL DEFAULT '1',
`creationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `invites`
--
INSERT INTO `invites` (`id`, `uid`, `code`, `isactive`, `creationdate`) VALUES
(1, 1, 'NOREFERRAL', 1, '2012-03-05 06:04:05');
-- --------------------------------------------------------
--
-- Table structure for table `ip_logs`
--
CREATE TABLE IF NOT EXISTS `ip_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`username` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `ip_logs`
--
INSERT INTO `ip_logs` (`id`, `uid`, `username`, `ip`, `date_added`) VALUES
(1, 7473, 'xtest', '67.166.97.3', '2012-03-23 17:07:58');
-- --------------------------------------------------------
--
-- Table structure for table `members`
--
CREATE TABLE IF NOT EXISTS `members` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`is_fake` tinyint(1) NOT NULL DEFAULT '0',
`referral_percent` int(11) NOT NULL DEFAULT '25',
`password` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`total_points_earned` int(255) NOT NULL DEFAULT '100',
`points` int(255) NOT NULL,
`contest_points` int(11) NOT NULL,
`is_lottery` tinyint(1) NOT NULL DEFAULT '0',
`contest_lottery` int(255) NOT NULL DEFAULT '0',
`lottery_percent` int(255) NOT NULL DEFAULT '10',
`referral_points_total` int(255) NOT NULL,
`completed_surveys` varchar(255) NOT NULL,
`referral_ID` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`state` varchar(255) NOT NULL,
`zip` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`address` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`firstname` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`notes` text NOT NULL,
`isbanned` int(1) NOT NULL DEFAULT '0',
`banner_views` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `members`
--
INSERT INTO `members` (`id`, `username`, `is_fake`, `referral_percent`, `password`, `email`, `total_points_earned`, `points`, `contest_points`, `is_lottery`, `contest_lottery`, `lottery_percent`, `referral_points_total`, `completed_surveys`, `referral_ID`, `ip`, `date`, `state`, `zip`, `country`, `city`, `address`, `lastname`, `firstname`, `phone`, `notes`, `isbanned`, `banner_views`) VALUES
(1, 'xtest', 0, 25, 'efc5c71785afc2fe3b9847f1e7eba981e1a33090', 'no@email.com', 250, 45, 0, 1, 5, 10, 0, '5', '7485', '67.166.97.3', '05-03-2012', 'ad', '54678', 'US', 'alkdjas', 'sadjladl', 'asdf', 'Landon', '4564568456', 'Apr.11.12 4:43 am<br />landon is god<BR><BR>Apr.11.12 4:44 am<br />god again?', 0, 53);
-- --------------------------------------------------------
--
-- Table structure for table `messages`
--
CREATE TABLE IF NOT EXISTS `messages` (
`msg_id` int(11) NOT NULL AUTO_INCREMENT,
`header` text NOT NULL,
`date` text NOT NULL,
`message` text,
PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `messages`
--
INSERT INTO `messages` (`msg_id`, `header`, `date`, `message`) VALUES
(1, 'A little guide - Fairly instant 15 bucks!', 'April 23rd, 2012', 'Hey, having some issues getting points?\r\n\r\nLet me help you out there.\r\n\r\nWithin Super Rewards we have two free trial offers that convert very quickly.\r\n\r\nTo do them, do the NetFlix offer with either your credit/debit card, or your paypal.\r\n\r\nAlong with 858 points, you will get access to NetFlix. Who DOESN''T want NetFlix?\r\n\r\nNow go do the same with Block Buster. You will have to use a valid credit card here. But it IS free. If you aren''t happy with Block Buster, you do not have to continue with the free trial, so it will cost you nothing!'),
-- --------------------------------------------------------
--
-- Table structure for table `postback_logs`
--
CREATE TABLE IF NOT EXISTS `postback_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`username` varchar(255) NOT NULL,
`is_fake` tinyint(1) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL,
`points_added` int(11) NOT NULL,
`total_points` int(11) NOT NULL,
`referral_username` varchar(255) NOT NULL,
`referral_uid` int(11) NOT NULL,
`referral_points_added` int(11) NOT NULL,
`referral_total_points` int(11) NOT NULL,
`offer_network` varchar(255) NOT NULL,
`transaction_id` varchar(255) NOT NULL,
`survey_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `postback_logs`
--
INSERT INTO `postback_logs` (`id`, `date`, `username`, `is_fake`, `uid`, `points_added`, `total_points`, `referral_username`, `referral_uid`, `referral_points_added`, `referral_total_points`, `offer_network`, `transaction_id`, `survey_id`) VALUES
(1, '2012-04-12 16:52:45', 'xtest', 0, 7601, 6, 638, '', 1, 0, 0, 'radium', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `request_logs`
--
CREATE TABLE IF NOT EXISTS `request_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`username` varchar(255) NOT NULL,
`request` varchar(255) NOT NULL,
`uid` int(11) NOT NULL,
`points_removed` int(11) NOT NULL,
`remaining_points` int(11) NOT NULL,
`status` varchar(255) NOT NULL,
`stage` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `request_logs`
--
INSERT INTO `request_logs` (`id`, `date`, `username`, `request`, `uid`, `points_removed`, `remaining_points`, `status`, `stage`) VALUES
(1, '2012-04-14 02:12:31', 'xtest', 'Amazon.com Gift Card | $16.50', 7567, 1650, 8, 'Processed', 3);
-- --------------------------------------------------------
--
-- Table structure for table `to_do`
--
CREATE TABLE IF NOT EXISTS `to_do` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`is_complete` tinyint(1) NOT NULL DEFAULT '0',
`date_added` text NOT NULL,
`date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`task` text NOT NULL,
`description` text NOT NULL,
`priority` float NOT NULL,
`estimated_time` time NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
/*!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 */;
)
Kommentar