[OPGELOST] MySQL error??

[lookielookies]

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

[Cicco]

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

[lookielookies]

Opgelost!

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

[Yannick]

ja dat zijn de kleinigheidjes die je altijd blijft behouden natuurlijk

-discussie gesloten-

Mv.Gr

Yannick