azlezoo
11-11-06, 10:22 PM
I've been trying to import a table into one of my databases, however, I keep getting the following error. I've looked in the MySQL documentation and the forum here but I'm at a loss what to do next. Any ideas would be greatly appreciated! TIA!
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custsql-pow13
-- Generation Time: Nov 11, 2006 at 03:24 PM
-- Server version: 4.1.18
-- PHP Version: 4.4.4
--
-- Database: `dfwcfids`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_content`
--
CREATE TABLE `jos_content` (
`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`title` varchar( 100 ) NOT NULL default '',
`title_alias` varchar( 100 ) NOT NULL default '',
`introtext` mediumtext NOT NULL ,
`fulltext` mediumtext NOT NULL ,
`state` tinyint( 3 ) NOT NULL default '0',
`sectionid` int( 11 ) unsigned NOT NULL default '0',
`mask` int( 11 ) unsigned NOT NULL default '0',
`catid` int( 11 ) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int( 11 ) unsigned NOT NULL default '0',
`created_by_alias` varchar( 100 ) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int( 11 ) unsigned NOT NULL default '0',
`checked_out` int( 11 ) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL ,
`urls` text NOT NULL ,
`attribs` text NOT NULL ,
`version` int( 11 ) unsigned NOT NULL default '1',
`parentid` int( 11 ) unsigned NOT NULL default '0',
`ordering` int( 11 ) NOT NULL default '0',
`metakey` text NOT NULL ,
`metadesc` text NOT NULL ,
`access` int( 11 ) unsigned NOT NULL default '0',
`hits` int( 11 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `idx_section` ( `sectionid` ) ,
KEY `idx_access` ( `access` ) ,
KEY `idx_checkout` ( `checked_out` ) ,
KEY `idx_state` ( `state` ) ,
KEY `idx_catid` ( `catid` ) ,
KEY `idx_mask` ( `mask` )
) ENGINE = MYISAM AUTO_INCREMENT =98;
MySQL said: Documentation
#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 `jos_content` (
`id` int(11) unsigned NOT NULL auto_increme' at line 1
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custsql-pow13
-- Generation Time: Nov 11, 2006 at 03:24 PM
-- Server version: 4.1.18
-- PHP Version: 4.4.4
--
-- Database: `dfwcfids`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_content`
--
CREATE TABLE `jos_content` (
`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`title` varchar( 100 ) NOT NULL default '',
`title_alias` varchar( 100 ) NOT NULL default '',
`introtext` mediumtext NOT NULL ,
`fulltext` mediumtext NOT NULL ,
`state` tinyint( 3 ) NOT NULL default '0',
`sectionid` int( 11 ) unsigned NOT NULL default '0',
`mask` int( 11 ) unsigned NOT NULL default '0',
`catid` int( 11 ) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int( 11 ) unsigned NOT NULL default '0',
`created_by_alias` varchar( 100 ) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int( 11 ) unsigned NOT NULL default '0',
`checked_out` int( 11 ) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL ,
`urls` text NOT NULL ,
`attribs` text NOT NULL ,
`version` int( 11 ) unsigned NOT NULL default '1',
`parentid` int( 11 ) unsigned NOT NULL default '0',
`ordering` int( 11 ) NOT NULL default '0',
`metakey` text NOT NULL ,
`metadesc` text NOT NULL ,
`access` int( 11 ) unsigned NOT NULL default '0',
`hits` int( 11 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `idx_section` ( `sectionid` ) ,
KEY `idx_access` ( `access` ) ,
KEY `idx_checkout` ( `checked_out` ) ,
KEY `idx_state` ( `state` ) ,
KEY `idx_catid` ( `catid` ) ,
KEY `idx_mask` ( `mask` )
) ENGINE = MYISAM AUTO_INCREMENT =98;
MySQL said: Documentation
#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 `jos_content` (
`id` int(11) unsigned NOT NULL auto_increme' at line 1