Jetzt bekomme ich folg.Fehlermeldung:
-- phpMyAdmin SQL Dump
-- version 2.10.0.2
--
externer Link
--
-- Host: localhost
-- Erstellungszeit: 10. Mai 2007 um 12:12
-- Server Version: 5.0.32
-- PHP-Version: 5.2.0-8+etch3
--
-- Datenbank: `freehost_1723_1`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur f�r Tabelle `ic1_user` --
CREATE TABLE `ic1_ user ` ( `id` int( 10 ) unsigned NOT NULL
AUTO_INCREMENT ,
`name ` var char( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`pass ` var char( 32 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`rech t ` int ( 1 ) NOT NULL default '0', `post s ` int ( 5 ) NOT NULL
default '0', `cpoi nts ` int ( 6 ) NOT NULL default '0', `fwar n ` int (
6 ) NOT NULL default '0', `meda l ` int ( 6 ) NOT NULL default '0',
`regi st ` int ( 20 ) default NULL ,
`emai l ` var char( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL ,
`llog IN ` int ( 20 ) default NULL ,
`spez rank ` med iumint( 9 ) NOT NULL default '0', `opt_ pm ` tin yint(
1 ) NOT NULL default '0', `opt_ pm_popup ` tin yint( 1 ) NOT NULL
default '0', `opt_ mail ` tin yint( 1 ) NOT NULL default '0', `stat us `
tin yint( 1 ) NOT NULL default '0', `gesc hlecht ` tin yint( 1 ) NOT
NULL default '0', `gebd atum ` dat e NOT NULL default '0000 -00 -00 ',
`wohn ort ` var char( 50 ) NOT NULL default '', `home page ` var char(
100 ) NOT NULL default '', `staa t ` var char( 50 ) NOT NULL default '',
`avat ar ` var char( 100 ) NOT NULL default '', `icq` varchar( 20 ) NOT
NULL default '', `msn` varchar( 50 ) NOT NULL default '', `yaho o ` var
char( 50 ) NOT NULL default '', `aim` varchar( 50 ) NOT NULL default '',
`sig` text NOT NULL ,
PRIMARY KEY ( `id`) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COMMENT =
'powered BY ilch.de ' AUTO_INCREMENT =34;
*MySQL meldet: *Dokumentation
<
dev.mysql.com/doc/refman/4.1/en/error-returns.html>
| #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 utf8_unicode_ci NOT NULL,
`pass` varchar(32) charact |