By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,056 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Kindly, help fixing error 1064

P: 1
Hello everyone and thank you in advance,

This is been driving me crazy, in running the following query, I get the error 1064, below please find the full query and the error message.
There must be errors everywhere becuase I tried removing one line at a time to pinpoint the error, and the error comes up the same on the lines I did not remove.

Note: the syntax error is in the:
Tabellenstruktur für Tabelle `hdb_member`
And in the:
Tabellenstruktur für Tabelle `rpf_upload`

I was able to Successfully run the:
Tabellenstruktur für Tabelle `hdb_config`


Full query:

-- phpMyAdmin SQL Dump
-- version 2.11.9.1
-- http://www.phpmyadmin.net
--
-- Host: `localhost`
-- Erstellungszeit: 06. Oktober 2009 um 20:31
-- Server Version: 5.0.32
-- PHP-Version: 5.2.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `tdcocom_Ao0Pj65`
--

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

--
-- Tabellenstruktur für Tabelle `hdb_config`
--

DROP TABLE IF EXISTS `hdb_config`;
CREATE TABLE IF NOT EXISTS `hdb_config` (
`id` int(1) NOT NULL,
`login` text collate latin1_german2_ci NOT NULL,
`passw` text collate latin1_german2_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

--
-- Daten für Tabelle `hdb_config`
--

INSERT INTO `hdb_config` (`id`, `login`, `passw`) VALUES
(0, 'admin', 'ViCoM');

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

--
-- Tabellenstruktur für Tabelle `hdb_member`
--

DROP TABLE IF EXISTS `hdb_member`;
CREATE TABLE IF NOT EXISTS `hdb_member` (
`id` int(11) NOT NULL,
`since` varchar(10) collate latin1_german2_ci NOT NULL,
`anrede` tinytext collate latin1_german2_ci NOT NULL,
`name` text collate latin1_german2_ci NOT NULL,
`vorname` text collate latin1_german2_ci NOT NULL,
`strasse` text collate latin1_german2_ci NOT NULL,
`plz` varchar(5) collate latin1_german2_ci NOT NULL,
`ort` text collate latin1_german2_ci NOT NULL,
`telefon` text collate latin1_german2_ci NOT NULL,
`email` text collate latin1_german2_ci NOT NULL,
`bezahlt` int(1) NOT NULL,
`aktiv` int(1) NOT NULL,
`benutzername` text collate latin1_german2_ci NOT NULL,
`passwort` varchar(25) collate latin1_german2_ci NOT NULL,
`mailgesendet` int(11) NOT NULL,
KEY `id` (`id`)
ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci);

--
-- Daten für Tabelle `hdb_member`
--

INSERT INTO `hdb_member` (`id`, `since`, `anrede`, `name`, `vorname`, `strasse`, `plz`, `ort`, `telefon`, `email`, `bezahlt`, `aktiv`, `benutzername`, `passwort`, `mailgesendet`) VALUES
(1, '1254489156', 'Herr', 'Testarius', 'Testermann', 'Testweg 12', '11223', 'Teststadt', '1231212', 'tester@vionlink.de', 1, 0, 'test', '123456', 1),
(2, '1254556333', 'Herr', 'Testfrau', 'Zwotarius', 'Teststrasa 34', '12345', 'Bremen', '1212112121', 'unicef@vionlink.de', 0, 0, '', '', 0),
(3, '1254562681', 'Herr', 'tester', 'tester', 'testsrt', '46240', 'Bottrop', '02041', 'mh@mhproducts.de', 0, 0, '', '', 0),
(4, '1254569093', 'Herr', 'xxxxxxx', 'xxxxxxxxxxxxxx', 'xxxxxxxxxxxxx', '46240', 'xxxxxxxxxxx', '00000', 'mhp@mhproducts.de', 0, 0, '', '', 0),
(5, '1254765478', 'Herr', 'test', 'tester', 'gdgdgdg.12', '46240', 'Bottrop', '212121', '2@lust-amateure.de', 0, 0, '', '', 0),
(6, '1254844588', 'Herr', 'hhh', 'dd', 'dddd', '4546', 'Bottrop', '12', 'mh@mhproducts.de', 0, 0, '', '', 0),
(7, '1254846743', 'Herr', 'rrrrr', 'rrrrrr', 'fffffffffffff', '34567', 'Bottrop', '12', 'mh@mhproducts.de', 0, 0, '', '', 0),
(8, '1254847178', 'Herr', 'ggg', 'ss', 'sssssss', '46240', 'Bottrop', '12', 'mh@mhproducts.de', 0, 0, '', '', 0),
(9, '1254847544', 'Herr', 'rainer', 'jjjjs', 'ssssssss', '58965', 'Bottrop', '23', 'mh@mhproducts.de', 0, 0, '', '', 0),
(10, '1254848248', 'Herr', 'ee', 'eeeeee', 'eeeeeeeee', '46240', 'eeeeee', '020415', 'mh@mhproducts.de', 0, 0, '', '', 0),
(11, '1254848583', 'Herr', 'ttttt', 'ssssss', 'sssss', '46240', 'ssss', '45454', 'mh@mhproducts.de', 0, 0, '', '', 0),
(12, '1254853231', 'Herr', 'tettttd', 'ddddd', 'ddddddddddd', '46240', 'Bottrop', '456845', 'mh@mhproducts.de', 0, 0, '', '', 0);

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

--
-- Tabellenstruktur für Tabelle `rpf_upload`
--

DROP TABLE IF EXISTS `rpf_upload`;
CREATE TABLE IF NOT EXISTS `rpf_upload` (
`id` int(11) NOT NULL auto_increment,
`titel` varchar(80) collate latin1_german2_ci default NULL,
`text` text collate latin1_german2_ci,
`fname` varchar(80) collate latin1_german2_ci default NULL,
`size` int(11) default '0',
`datum` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=8 ;

--
-- Daten für Tabelle `rpf_upload`
--

INSERT INTO `rpf_upload` (`id`, `titel`, `text`, `fname`, `size`, `datum`) VALUES
(6, 'Heißes Shooting', 'Hier ein Bilderpack von mir mit 50 heißen Fotos. Seht hocherotische Aufnahmen von mir Nackt und in verschiedenen heißen Outfits und Reizwäsche.', 'Video2.flv', 12752, '2009-10-06 15:18:28'),
(7, 'Der Frauen Besuch', 'Man sagt doch so schön... ein wenig Bi schadet nie... auch ich bin dieser Vorliebe nicht abgeneigt wir ihr in diesem Video sehen könnt. Hardcore Pur !', 'Video3.flv', 12752, '2009-10-06 15:23:25');


************************************************** *******

Error

SQL query:

CREATE TABLE IF NOT EXISTS `hdb_member` (
`id` int( 11 ) NOT NULL ,
`since` varchar( 10 ) COLLATE latin1_german2_ci NOT NULL ,
`anrede` tinytext COLLATE latin1_german2_ci NOT NULL ,
`name` text COLLATE latin1_german2_ci NOT NULL ,
`vorname` text COLLATE latin1_german2_ci NOT NULL ,
`strasse` text COLLATE latin1_german2_ci NOT NULL ,
`plz` varchar( 5 ) COLLATE latin1_german2_ci NOT NULL ,
`ort` text COLLATE latin1_german2_ci NOT NULL ,
`telefon` text COLLATE latin1_german2_ci NOT NULL ,
`email` text COLLATE latin1_german2_ci NOT NULL ,
`bezahlt` int( 1 ) NOT NULL ,
`aktiv` int( 1 ) NOT NULL ,
`benutzername` text COLLATE latin1_german2_ci NOT NULL ,
`passwort` varchar( 25 ) COLLATE latin1_german2_ci NOT NULL ,
`mailgesendet` int( 11 ) NOT NULL ,
KEY `id` ( `id` ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_german2_ci
);

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 'ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci)' at line 18

Kind regards, Vincent
Jan 4 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.