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:
Tabellenstruktu r für Tabelle `hdb_member`
And in the:
Tabellenstruktu r für Tabelle `rpf_upload`
I was able to Successfully run the:
Tabellenstruktu r 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_AU TO_VALUE_ON_ZER O";
--
-- Datenbank: `tdcocom_Ao0Pj6 5`
--
-- --------------------------------------------------------
--
-- Tabellenstruktu r 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');
-- --------------------------------------------------------
--
-- Tabellenstruktu r 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@vionlin k.de', 1, 0, 'test', '123456', 1),
(2, '1254556333', 'Herr', 'Testfrau', 'Zwotarius', 'Teststrasa 34', '12345', 'Bremen', '1212112121', 'unicef@vionlin k.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);
-- --------------------------------------------------------
--
-- Tabellenstruktu r 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_TIMESTA MP on update CURRENT_TIMESTA MP,
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