whats my error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    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?

    #2
    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?
    what error!!
    Try deleting this
    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

    Comment


      #3
      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 1
      Last edited by tsinelas; 09.08.10, 01:36.

      Comment


        #4
        try:
        PHP Code:
        CREATE TABLE `ibwf_articles` (
          `
        idint(100NOT NULL auto_increment,
          `
        namevarchar(35NOT NULL,
          
        PRIMARY KEY  (`id`),
        UNIQUE KEY `name` (`name`)
        ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=

        Comment


          #5
          cn u upload it in .txt? Im on mobile now..tnx

          Comment


            #6
            Originally posted by tsinelas View Post
            cn u upload it in .txt? Im on mobile now..tnx
            Here it is:
            Attached Files

            Comment


              #7
              . .
              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');
              Last edited by kei_ki7; 09.08.10, 05:19. Reason: I forgot to quote my message
              Did I help you?
              You can help me too
              Your donations will help me finance my studies.

              Comment


                #8
                2 is by my mistake in posting..

                Comment


                  #9
                  unlucky 13 lol

                  Comment


                    #10
                    haha..ei bro how to insert mods in lava like jueteng and pet..?

                    Comment

                    Working...
                    X