Sie sind nicht angemeldet.

1

Donnerstag, 12. Oktober 2006, 02:49

SQL Fehlermeldung

Hi Leute!

Ich hab mit xxamp offline ne hp programmiert, allerdings habe ich keine chance die Datenbank jetzt online zu importieren. Folgende Meldung kommt --> kann mir evtl. wer helfen?

-- phpMyAdmin SQL Dump
-- version 2.9.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 12. Oktober 2006 um 02:47
-- Server Version: 5.0.24
-- PHP-Version: 5.1.6
--
-- Datenbank: `vgtmv`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `exvg_addressbook_contact`
--
CREATE TABLE `exvg_addressbook_contact` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`user_id` int( 11 ) NOT NULL ,
`firstname` varchar( 100 ) COLLATE latin1_general_ci NOT NULL ,
`lastname` varchar( 100 ) COLLATE latin1_general_ci NOT NULL ,
`address1` varchar( 150 ) COLLATE latin1_general_ci NOT NULL ,
`address2` varchar( 150 ) COLLATE latin1_general_ci NOT NULL ,
`city` varchar( 100 ) COLLATE latin1_general_ci NOT NULL ,
`state` varchar( 2 ) COLLATE latin1_general_ci NOT NULL ,
`zip` varchar( 10 ) COLLATE latin1_general_ci NOT NULL ,
`country` varchar( 50 ) COLLATE latin1_general_ci NOT NULL ,
`email` varchar( 150 ) COLLATE latin1_general_ci NOT NULL ,
`phone` varchar( 20 ) COLLATE latin1_general_ci NOT NULL ,
`cell` varchar( 20 ) COLLATE latin1_general_ci NOT NULL ,
`fax` varchar( 20 ) COLLATE latin1_general_ci NOT NULL ,
`pager` varchar( 20 ) COLLATE latin1_general_ci NOT NULL ,
`notes` text COLLATE latin1_general_ci NOT NULL ,
`webpage` text COLLATE latin1_general_ci NOT NULL ,
`location_data` varchar( 200 ) COLLATE latin1_general_ci NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =1


MySQL meldet: Dokumentation
#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 'collate latin1_general_ci NOT NULL,
`lastname` varchar(100)


Filesharing Hilfe Flirt Forum Computerspiele Forum ToPFreE