[OPGELOST] MySQL error??

Hoi

Als ik een MySQL database wil installeren, zie ik deze error:

LINE #1: 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 '-- phpMyAdmin SQL Dump' at line 1

Dit is mijn database code:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `demo_demo`
-- 

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

-- 
-- Table structure for table `admins`
-- 

DROP TABLE IF EXISTS `admins`;
CREATE TABLE IF NOT EXISTS `admins` (
 `id` int(11) unsigned NOT NULL auto_increment,
 `login` varchar(255) NOT NULL default '',
 `password` varchar(255) NOT NULL default '',
 `permissions` text,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `admins`
-- 

INSERT INTO `admins` (`id`, `login`, `password`, `permissions`) VALUES (1, 'admin', 'admin', NULL);

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

-- 
-- Table structure for table `any`
-- 

DROP TABLE IF EXISTS `any`;
CREATE TABLE IF NOT EXISTS `any` (
 `id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',
 `created` datetime default NULL COMMENT 'Creation Time',
 `updated` datetime default NULL COMMENT 'Modification Time',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `any`
-- 


-- --------------------------------------------------------
-- 
-- Table structure for table `categories`
-- 

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
 `id` int(11) NOT NULL auto_increment,
 `categories` varchar(255) default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `categories`
-- 

INSERT INTO `categories` (`id`, `categories`) VALUES (1, 'Admin Features');
INSERT INTO `categories` (`id`, `categories`) VALUES (2, 'My Ads');

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

-- 
-- Table structure for table `fieldsprop`
-- 

DROP TABLE IF EXISTS `fieldsprop`;
CREATE TABLE IF NOT EXISTS `fieldsprop` (
 `id` int(11) NOT NULL auto_increment,
 `table_name` varchar(255) default NULL,
 `field_name` varchar(255) default NULL,
 `full_name` varchar(255) default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=108 ;

-- 
-- Dumping data for table `fieldsprop`
-- 

INSERT INTO `fieldsprop` (`id`, `table_name`, `field_name`, `full_name`) VALUES (1, 'banner', 'id', 'ID');
INSERT INTO `fieldsprop` (`id`, `table_name`, `field_name`, `full_name`) VALUES (2, 'banner', 'created', 'Creation Time');
INSERT INTO `fieldsprop` (`id`, `table_name`, `field_name`, `full_name`) VALUES (3, 'banner', 'updated', 'Modification Time');

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

-- 
-- Table structure for table `scripts`
-- 

DROP TABLE IF EXISTS `scripts`;
CREATE TABLE IF NOT EXISTS `scripts` (
 `id` int(11) NOT NULL auto_increment,
 `script_name` varchar(255) default NULL,
 `table_name` varchar(255) default NULL,
 `name` varchar(255) default NULL,
 `cat_id` int(2) default NULL,
 `flag` int(1) default '1',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `scripts`
-- 

INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (1, 'change_password.php', '', 'Change Password', 1, 2);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (2, 'edit_categories.php', '', 'Edit Categories', 1, 0);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (3, 'edit_scripts.php', '', 'Edit Features', 1, 0);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (4, 'logout.php', '', 'Logout', 1, 2);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (5, 'data_manager.php?i=5', 'banner', 'Banner Ads', 2, 1);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (6, 'data_manager.php?i=6', 'solo', 'Solo Ads', 2, 1);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (7, 'data_manager.php?i=7', 'class', 'Classified Ads', 2, 1);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (8, 'data_manager.php?i=8', 'other', 'Other Ads', 2, 1);

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

-- 
-- Table structure for table `solo`
-- 

DROP TABLE IF EXISTS `solo`;
CREATE TABLE IF NOT EXISTS `solo` (
 `id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',
 `created` datetime default NULL COMMENT 'Creation Time',
 `updated` datetime default NULL COMMENT 'Modification Time',
 `prod` varchar(255) default NULL COMMENT 'Product Name',
 `url` varchar(254) default NULL COMMENT 'Product URL',
 `head` varchar(255) default NULL COMMENT 'Headline',
 `ad` text COMMENT 'Solo Ad',
 `date` date default NULL COMMENT 'Test Date',
 `list` varchar(255) default NULL COMMENT 'List Name',
 `subscr` varchar(255) default NULL COMMENT 'N° Of Subscribers',
 `clicks` varchar(255) default NULL COMMENT 'Clicks',
 `clthru` varchar(255) default NULL COMMENT 'Clicktrough Rate In %',
 `Sales` varchar(255) default NULL COMMENT 'Sales',
 `conv` varchar(255) default NULL COMMENT 'Conversion Ratio In %',
 `cost` varchar(255) default NULL COMMENT 'Cost',
 `result` varchar(255) default NULL COMMENT 'Result',
 `profit` varchar(255) default NULL COMMENT 'Profit',
 `rec` enum('Yes','No','Needs (more) testing') default NULL COMMENT 'Recommended?',
 `notes` text COMMENT 'Notes',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `solo`

Kan iemand me weer op weg helpen?

Groetjes,

Mieke

Wanneer krijg je deze melding? Bij het aanmaken van de database? Of bij het aanroepen van een bepaalde actie?

Opgelost!

Ik had het file opgeslagen in een verkeerd formaat (UTF-8 i.p.v. ANSI)

ja dat zijn de kleinigheidjes die je altijd blijft behouden natuurlijk

-discussie gesloten-

Mv.Gr

Yannick