#3 Problem Importing Database Items

[Anonymous]

Hello-

The script looks awesome, and I am excited to use it...

But, one problem. I can't get a table to work.

I use PHPMyAdmin, and when importing the script, it
tells the following error:

SQL-query:

--
-- Dumping data for table `shows`
--

MySQL said:

#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 '--' at line 3

Because the show link doesn't work...

FYI, here is the table supplied (I for one can't find a
syntax error):

-- --------------------------------------------------------

--
-- Table structure for table `shows`
--

CREATE TABLE `shows` (
`rec_id` int(7) NOT NULL auto_increment,
`showdate` date NOT NULL default '0000-00-00',
`venue_name` varchar(255) NOT NULL default '',
`venue_street` varchar(255) NOT NULL default '',
`venue_city` varchar(255) NOT NULL default '',
`venue_state` varchar(255) NOT NULL default '',
`venue_website` varchar(255) NOT NULL default '',
`other_bands` varchar(255) NOT NULL default '',
`doors` varchar(255) NOT NULL default '',
`admission` varchar(255) NOT NULL default '',
`ages` varchar(255) NOT NULL default '',
`comments` mediumtext NOT NULL,
`date_added` date NOT NULL default '0000-00-00',
`flier` varchar(64) NOT NULL default '',
`flier_thumb` varchar(255) NOT NULL default '',
PRIMARY KEY (`rec_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `shows`
--

Thanks in advance for the help!

[karlcore]

Logged In: YES
user_id=1213748

That's odd. Which version of PHPMyAdmin are you using?
Strip the comments and see what happens.

Use this:

CREATE TABLE `shows` (
`rec_id` int(7) NOT NULL auto_increment,
`showdate` date NOT NULL default '0000-00-00',
`venue_name` varchar(255) NOT NULL default '',
`venue_street` varchar(255) NOT NULL default '',
`venue_city` varchar(255) NOT NULL default '',
`venue_state` varchar(255) NOT NULL default '',
`venue_website` varchar(255) NOT NULL default '',
`other_bands` varchar(255) NOT NULL default '',
`doors` varchar(255) NOT NULL default '',
`admission` varchar(255) NOT NULL default '',
`ages` varchar(255) NOT NULL default '',
`comments` mediumtext NOT NULL,
`date_added` date NOT NULL default '0000-00-00',
`flier` varchar(64) NOT NULL default '',
`flier_thumb` varchar(255) NOT NULL default '',
PRIMARY KEY (`rec_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;