whats my error
Collapse
X
-
. .
INSERT INTO `ibwf_articles` (`id`, `name`) VALUES
(1, 'World News'),
(2, 'Local News'),
(9, 'Tech News'),
(4, 'Showbiz News'),
(5, 'Mobile Networks'),
(6, 'Tips and Tricks'),
(7, 'Bible Chapters'),
(8, 'Love Story'),
(10, 'Lyrics'),
(11, 'Recipies'),
(12, 'Jokes'),
2(13, 'Novel'),
(14, 'Poetry'),
(15, 'Adult Stories');
Leave a comment:
-
Here it is:Originally posted by tsinelas View Postcn u upload it in .txt? Im on mobile now..tnxAttached Files
Leave a comment:
-
try:
PHP Code:CREATE TABLE `ibwf_articles` (
`id` int(100) NOT NULL auto_increment,
`name` varchar(35) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
Leave a comment:
-
oh i wil try..
Added after 8 minutes:
stil got the error its not importing.
Added after 34 minutes:
i try dis
CREATE TABLE IF NOT EXISTS
`ibwf_articles` (
`id` int(100) NOT NULL DEFAULT '0',
`name` varchar(35) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table
`ibwf_articles`
--
INSERT INTO `ibwf_articles` (`id`, `name`) VALUES
(1, 'World News'),
(2, 'Local News'),
(9, 'Tech News'),
(4, 'Showbiz News'),
(5, 'Mobile Networks'),
(6, 'Tips and Tricks'),
(7, 'Bible Chapters'),
(8, 'Love Story'),
(10, 'Lyrics'),
(11, 'Recipies'),
(12, 'Jokes'),
(13, 'Novel'),
(14, 'Poetry'),
(15, 'Adult Stories');
And it says
MySQL said:
# 1 0 6 4 - Y o u h a v e a n e r r o r i n
y o u r S Q L s y n t a x ; c h e c k t h e
ma n u a l t h a t c o r r e s p o n d s t o
y o u r M y S Q L s e r v e r v e r s i o n
f o r t h e r i g h t s y n t a x t o u s e
n e a r ' C ' a t l i n e 1Last edited by tsinelas; 09.08.10, 01:36.
Leave a comment:
-
what error!!Originally posted by tsinelas View Post-- phpMyAdmin SQL Dump
-- version 2.10.3
-- phpMyAdmin
--
-- Host: localhost
-- Generation Time: Jun 03, 2010 at 08:49 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `can`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_articles`
--
CREATE TABLE IF NOT EXISTS `ibwf_articles` (
`id` int(100) NOT NULL DEFAULT '0',
`name` varchar(35) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ibwf_articles`
--
INSERT INTO `ibwf_articles` (`id`, `name`) VALUES
(1, 'World News'),
(2, 'Local News'),
(9, 'Tech News'),
(4, 'Showbiz News'),
(5, 'Mobile Networks'),
(6, 'Tips and Tricks'),
(7, 'Bible Chapters'),
(8, 'Love Story'),
(10, 'Lyrics'),
(11, 'Recipies'),
(12, 'Jokes'),
2(13, 'Novel'),
(14, 'Poetry'),
(15, 'Adult Stories');
I try to import it but it gvs me error whats the problem?
Try deleting this
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
Leave a comment:
-
whats my error
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 03, 2010 at 08:49 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `can`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_articles`
--
CREATE TABLE IF NOT EXISTS `ibwf_articles` (
`id` int(100) NOT NULL DEFAULT '0',
`name` varchar(35) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ibwf_articles`
--
INSERT INTO `ibwf_articles` (`id`, `name`) VALUES
(1, 'World News'),
(2, 'Local News'),
(9, 'Tech News'),
(4, 'Showbiz News'),
(5, 'Mobile Networks'),
(6, 'Tips and Tricks'),
(7, 'Bible Chapters'),
(8, 'Love Story'),
(10, 'Lyrics'),
(11, 'Recipies'),
(12, 'Jokes'),
2(13, 'Novel'),
(14, 'Poetry'),
(15, 'Adult Stories');
I try to import it but it gvs me error whats the problem?Tags: None
Leave a comment: