Wo liegt der Fehler? (MySQL)

Donkey

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:

Code

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

Bandit

Zitat

Hab mir so ein Script runtergeladen

Da würde ich bei Problemen aber erst mal den Hersteller befragen.

Und Der SQL-Import nutzt uns auch nicht wirklich was, denn der Fehler kommt ja beim Scriptaufruf und nicht beim Import.

Ich würde nochmal die neuste Version ausprobieren, du hast 3.0.1, aktuell ist 3.0.4

Donkey

Danke für die rasche Antwort.

Mit der neuesten Version tritt das gleiche Problem auf.

Dann frag ich mal den Hersteller

Gruss Donkey

Wo liegt der Fehler? (MySQL)

Tags

Benutzer online in diesem Thema