Hallo zusammen
Hab mir so ein Script runtergeladen mit dem man einen Chat betreiben kann.
Die Installation hat auch gut geklappt und es funzt auch alles..... Naja fast alles.
Wenn ich das ACP aufrufen will bekomm ich die Meldung:
Zitat
Fehler beim Senden der Abfrage...
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 '' at line 1
Also ich hab überhaupt keine Ahnung von SQL-Programmierung und meine Englischkenntnisse reichen bei weiten nicht um dieses Handbuch zu studieren.
Wär euch wirklich dankbar wenn ihr den Fehler aufspüren könntet
Das ist die .sql:
-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- [URL]http://www.phpmyadmin.net[/URL]
--
-- Host: localhost
-- Erstellungszeit: 18. Dezember 2007 um 14:46
-- Server Version: 5.0.24
-- PHP-Version: 5.2.4
--
-- Datenbank: 'chat'
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_blacklist'
--
DROP TABLE IF EXISTS etchat_blacklist;
-- limit --
CREATE TABLE etchat_blacklist (
etchat_blacklist_id int(8) NOT NULL auto_increment,
etchat_blacklist_ip varchar(255) NOT NULL,
etchat_blacklist_userid int(8) NOT NULL,
etchat_blacklist_time int(30) NOT NULL,
PRIMARY KEY (etchat_blacklist_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_blacklist'
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_messages'
--
DROP TABLE IF EXISTS etchat_messages;
-- limit --
CREATE TABLE etchat_messages (
etchat_id bigint(20) unsigned NOT NULL auto_increment,
etchat_user_fid int(8) NOT NULL,
etchat_text text NOT NULL,
etchat_text_css text NOT NULL,
etchat_timestamp bigint(20) NOT NULL,
etchat_fid_room int(11) NOT NULL default '1',
etchat_privat int(8) default '0',
PRIMARY KEY (etchat_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_messages'
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_rooms'
--
DROP TABLE IF EXISTS etchat_rooms;
-- limit --
CREATE TABLE etchat_rooms (
etchat_id_room int(3) unsigned NOT NULL auto_increment,
etchat_roomname varchar(100) NOT NULL,
PRIMARY KEY (etchat_id_room)
);
-- limit --
--
-- Daten für Tabelle 'etchat_rooms'
--
INSERT INTO etchat_rooms (etchat_id_room, etchat_roomname) VALUES
(1, 'Lobby'),
(2, 'Raum II'),
(3, 'Raum I');
-- limit --
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_smileys'
--
DROP TABLE IF EXISTS etchat_smileys;
-- limit --
CREATE TABLE etchat_smileys (
etchat_smileys_id int(5) NOT NULL auto_increment,
etchat_smileys_sign varchar(20) NOT NULL,
etchat_smileys_img varchar(100) NOT NULL,
PRIMARY KEY (etchat_smileys_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_smileys'
--
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':angry:', 'smilies/angry.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-]', 'smilies/approve.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-}', 'smilies/blushing.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':charming:', 'smilies/charming.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-P', 'smilies/cheeky.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':cheesy:', 'smilies/cheesy.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES ('8-)', 'smilies/cool.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':*(', 'smilies/cry.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES ('x-(', 'smilies/dead.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':dissap:', 'smilies/dissappointed.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':embar:', 'smilies/embarassed.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':evil:', 'smilies/evil.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':goofy:', 'smilies/goofy.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-D', 'smilies/grin.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-?', 'smilies/huh.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':idea:', 'smilies/idea.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-L', 'smilies/laugh.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':lips:', 'smilies/lips.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-x', 'smilies/lipsrsealed.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':mad:', 'smilies/mad.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-K', 'smilies/ok.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':rolleyes:', 'smilies/rolleyes.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-(', 'smilies/sad.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-O', 'smilies/shocked.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':shy:', 'smilies/shy.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':smartass:', 'smilies/smartass.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':smarty:', 'smilies/smarty.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':-)', 'smilies/smiley.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':tongue:', 'smilies/tongue.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':undecided:', 'smilies/undecided.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':veryangry:', 'smilies/veryangry.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (';-)', 'smilies/wink.gif');
-- limit --
INSERT INTO etchat_smileys (etchat_smileys_sign, etchat_smileys_img) VALUES (':worried:', 'smilies/worried.gif');
-- limit --
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_user'
--
DROP TABLE IF EXISTS etchat_user;
-- limit --
CREATE TABLE etchat_user (
etchat_user_id int(8) NOT NULL auto_increment,
etchat_username varchar(200) NOT NULL,
etchat_userpw varchar(40) default NULL,
etchat_userprivilegien varchar(15) NOT NULL default 'gast',
PRIMARY KEY (etchat_user_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_user'
--
INSERT INTO etchat_user (etchat_user_id, etchat_username, etchat_userpw, etchat_userprivilegien) VALUES
(1, '<i>System</i>', NULL, 'system'),
(2, 'Admin', '21232f297a57a5a743894a0e4a801fc3', 'admin');
-- limit --
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle 'etchat_useronline'
--
DROP TABLE IF EXISTS etchat_useronline;
-- limit --
CREATE TABLE etchat_useronline (
etchat_onlineid bigint(20) unsigned NOT NULL auto_increment,
etchat_onlineuser_fid int(8) NOT NULL,
etchat_onlinetimestamp bigint(20) NOT NULL,
etchat_onlineip varchar(255) NOT NULL,
etchat_fid_room int(11) NOT NULL default '1',
etchat_user_online_room_name varchar(100) NOT NULL,
etchat_user_online_user_name varchar(200) NOT NULL,
etchat_user_online_user_priv varchar(20) NOT NULL,
PRIMARY KEY (etchat_onlineid)
);
-- limit --
--
-- Daten für Tabelle 'etchat_useronline'
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `etchat_config`
--
DROP TABLE IF EXISTS etchat_config;
-- limit --
CREATE TABLE etchat_config (
etchat_config_id int(11) NOT NULL auto_increment,
etchat_config_reloadsequenz int(11) NOT NULL,
etchat_config_messages_im_chat int(11) NOT NULL,
etchat_config_style varchar(100) NOT NULL,
etchat_config_loeschen_nach int(11) NOT NULL,
PRIMARY KEY (etchat_config_id)
);
-- limit --
--
-- Daten für Tabelle 'etchat_config'
--
INSERT INTO etchat_config (etchat_config_id, etchat_config_reloadsequenz, etchat_config_messages_im_chat, etchat_config_style, etchat_config_loeschen_nach) VALUES
(1, 4000, 22, 'etchat_white', 1);
Alles anzeigen
Danke schonmal
Gruss Donkey
EDIT:
Achso das ist die Testinstallation: http://kendo-bunker.de/donkey/demo/
und hier sollte man eigentlich ins ACP kommen: http://kendo-bunker.de/donkey/demo/admin