468,510 Members | 1,736 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,510 developers. It's quick & easy.

Kindly, help fixing error 1064

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
0 1186

Post your reply

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

Similar topics

reply views Thread by Morten Gulbrandsen | last post: by
reply views Thread by Morten Gulbrandsen | last post: by
3 posts views Thread by supermonkey1 | last post: by
13 posts views Thread by wideangle | last post: by
2 posts views Thread by amaddox | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.