Mysql Fehler

[Guest]

Kann mir jemand sagen was diese Fehlermeldung im linken Frame zu bedeuten hat ?

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\apachefriends\xampp\htdocs\i-doit\functions_db_mysql.inc.php on line 85

[Guest]

Hi,

den Fehler haben schon mehrere Benutzer gemeldet und wir sind gerade dabei, das Problem zu untersuchen. Werden dann einen entsprechenden Patch rausbringen.

[Guest]

Wir können den Fehler momentan nicht bei uns rekonstruieren, deshalb bräuchte ich folgende Dinge von dir:

1. Versionsstand deiner Umgebung (Apache, mySQL, PHP)
2. i-doIT Version
3. Screenshot, wo der Fehler drauf auftaucht
4. Ein Abbid deiner Datenbank (der muss mit mysql_dump gemacht werden)

Danke

[Guest]

Hallo,

ich hab die installation auf verschiedenen Platformen getestet, Windows XP + xampp, Suse 9.3, Benhur2 mit den actuellen versionen von Mysql 4.1.8, php 5.03 und phpMyAdmin 2.6.0-pl3

es taucht immer die gleiche Fehlermeldung auf im linken Menueframe oben über dem Menue

[Guest]

sorry, ich verwende die i-doit version 0.8.6

[Guest]

Hi,

ich benötige noch ein Datenbankabbild von dir. Weisst du, wie das geht oder soll ich es kurz erklären?

[Guest]

hollo,
erklär´s mal

[Guest]

Hollo, meint Ihr das:

– phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net

-- Host: localhost
-- Erstellungszeit: 04. Mai 2005 um 10:38
-- Server Version: 4.1.8
-- PHP-Version: 5.0.3

-- Datenbank: doit

---

--
-- Tabellenstruktur für Tabelle calendar

CREATE TABLE calendar (
Id int(10) unsigned NOT NULL auto_increment,
date datetime default NULL,
text varchar(255) collate latin1_general_ci default NULL,
start datetime default NULL,
end datetime default NULL,
PRIMARY KEY (Id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle calendar

---

--
-- Tabellenstruktur für Tabelle configuration

CREATE TABLE configuration (
ID int(11) NOT NULL auto_increment,
magickey varchar(255) collate latin1_general_ci NOT NULL default '',
value text collate latin1_general_ci NOT NULL,
title varchar(255) collate latin1_general_ci NOT NULL default '',
description text collate latin1_general_ci NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=18 ;

--
-- Daten für Tabelle configuration

INSERT INTO configuration VALUES (1, 'theme', '', 'Theme', 'Waehlen Sie hier Ihr individuelles Theme');
INSERT INTO configuration VALUES (2, 'db_user', 'root', 'DB: Benutzer', 'Datenbankbenutzer');
INSERT INTO configuration VALUES (3, 'db_pass', '', 'DB: Passwort', 'Datenbankpasswort');
INSERT INTO configuration VALUES (4, 'db_host', '', 'DB: Host', 'Datenbankhost');
INSERT INTO configuration VALUES (5, 'db_name', '', 'DB: Name', 'Name der Hauptdatenbank (im Normalfall ''doit'')');
INSERT INTO configuration VALUES (6, 'db_type', 'mysql', 'DB: Typ', 'Datenbanktyp - zur Zeit ist nur mySQL implementiert');
INSERT INTO configuration VALUES (7, 'ldap_host', '', 'LDAP: Host', 'Hostname des LDAP-Server (Version 3)');
INSERT INTO configuration VALUES (8, 'ldap_basecontext', '', 'LDAP: Basiskontext', 'Bitte hier Basiskontext der LDAP-Datenbank angeben (bspw. o=doit)');
INSERT INTO configuration VALUES (9, 'ldap_adminuser', '', 'LDAP: Admin-DN', 'Volle DN des Admins');
INSERT INTO configuration VALUES (10, 'ldap_adminpass', '', 'LDAP: Admin-Passwort', 'Passwort des Admins');
INSERT INTO configuration VALUES (11, 'ldap_usercontext', '', 'LDAP: Benutzerkontext', 'Relative DN der OU, in der die Benutzerobjekte sind (bspw. bei einem Basiskontext von o=doit koennte dies ou=users lauten)');
INSERT INTO configuration VALUES (12, 'ldap_groupcontext', '', 'LDAP: Gruppenkontext', 'Analog zum Benutzerkontext');
INSERT INTO configuration VALUES (13, 'ldap_rolecontext', '', 'LDAP: Rollenkontext', 'Analog zum Gruppenkontext');
INSERT INTO configuration VALUES (14, 'dir_documentroot', '', 'DIR: DocumentRoot', 'DocumentRoot des Do-IT!s (bsp.: /)');
INSERT INTO configuration VALUES (15, 'dir_realroot', '', 'DIR: RealRoot', 'Komplettes Basisverzeichnis des Do-IT!s (bsp.: /var/www/localhost/htdocs/');
INSERT INTO configuration VALUES (16, 'file_userfile', '', 'FILE: Benutzerdatei', 'Name der Datei, in der die Benutzer gecached werden, um lange LDAP-Requests zu vermeiden (muss relativ zum Root-Verzeichnis sein)');
INSERT INTO configuration VALUES (17, 'mail_from', '', 'MAIL: Absender', 'Absender fuer alle Mails, die vom Do-IT! versendet werden');

---

--
-- Tabellenstruktur für Tabelle crontab

CREATE TABLE crontab (
ID int(11) NOT NULL auto_increment,
minute varchar(4) collate latin1_general_ci NOT NULL default '',
hour varchar(4) collate latin1_general_ci NOT NULL default '',
day varchar(4) collate latin1_general_ci NOT NULL default '',
month varchar(4) collate latin1_general_ci NOT NULL default '',
dow varchar(4) collate latin1_general_ci NOT NULL default '',
scriptname text collate latin1_general_ci NOT NULL,
description text collate latin1_general_ci NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle crontab

INSERT INTO crontab VALUES (1, '', '', '', '', '*', '/usr/bin/wget http://localhost/modules/checklists/generate_checks.php -o /dev/null', 'Generate the daily checks based on the checklist.');

---

--
-- Tabellenstruktur für Tabelle language

CREATE TABLE language (
Id int(10) unsigned NOT NULL auto_increment,
language char(2) collate latin1_general_ci default NULL,
word varchar(255) collate latin1_general_ci default NULL,
translation text collate latin1_general_ci,
PRIMARY KEY (Id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=353 ;

--
-- Daten für Tabelle language

INSERT INTO language VALUES (1, 'de', 'Mon', 'Montag');
INSERT INTO language VALUES (2, 'de', 'Tue', 'Dienstag');
INSERT INTO language VALUES (3, 'de', 'Wed', 'Mittwoch');
INSERT INTO language VALUES (4, 'de', 'Thu', 'Donnerstag');
INSERT INTO language VALUES (5, 'de', 'Fri', 'Freitag');
INSERT INTO language VALUES (6, 'de', 'Sat', 'Samstag');
INSERT INTO language VALUES (7, 'de', 'Sun', 'Sonntag');
INSERT INTO language VALUES (8, 'de', 'Jan', 'Januar');
INSERT INTO language VALUES (9, 'de', 'Feb', 'Februar');
INSERT INTO language VALUES (10, 'de', 'Mar', 'Maerz');
INSERT INTO language VALUES (11, 'de', 'Apr', 'April');
INSERT INTO language VALUES (12, 'de', 'May', 'Mai');
INSERT INTO language VALUES (13, 'de', 'Jun', 'Juni');
INSERT INTO language VALUES (14, 'de', 'Jul', 'Juli');
INSERT INTO language VALUES (15, 'de', 'Aug', 'August');
INSERT INTO language VALUES (16, 'de', 'Sep', 'September');
INSERT INTO language VALUES (17, 'de', 'Oct', 'Oktober');
INSERT INTO language VALUES (18, 'de', 'Nov', 'Nobember');
INSERT INTO language VALUES (19, 'de', 'Dec', 'Dezember');
INSERT INTO language VALUES (20, 'de', 'register date', 'Termin eintragen');
INSERT INTO language VALUES (21, 'de', 'description', 'Beschreibung');
INSERT INTO language VALUES (22, 'de', 'priority_comment', 'Kommentar zur Prioritaet');
INSERT INTO language VALUES (23, 'de', 'program_name', 'Programmnname');
INSERT INTO language VALUES (24, 'de', 'program_version', 'Programmversion');
INSERT INTO language VALUES (25, 'de', 'date_supply', 'Datum Bereitstellung');
INSERT INTO language VALUES (26, 'de', 'date_finish', 'Datum Produktion');
INSERT INTO language VALUES (27, 'de', 'requester', 'Antragsteller');
INSERT INTO language VALUES (28, 'de', 'priority', 'Prioritaet');
INSERT INTO language VALUES (30, 'de', 'change_type', 'Aenderungsart');
INSERT INTO language VALUES (31, 'de', 'realization', 'Realisierung');
INSERT INTO language VALUES (32, 'de', 'risk', 'Risiko');
INSERT INTO language VALUES (33, 'de', 'version', 'Version');
INSERT INTO language VALUES (34, 'de', 'installation_type', 'Installationsart');
INSERT INTO language VALUES (35, 'de', 'add rfc', 'RfC einstellen');
INSERT INTO language VALUES (36, 'de', 'error please check', 'Fehler! Bitte folgende Felder ueberpruefen');
INSERT INTO language VALUES (37, 'de', 'cancel', 'Abbrechen');
INSERT INTO language VALUES (38, 'de', 'edit_date', 'Bearbeitungsdatum');
INSERT INTO language VALUES (39, 'de', 'risk evaluation', 'Risikobewertung');
INSERT INTO language VALUES (40, 'de', 'comment', 'Kommentar');
INSERT INTO language VALUES (41, 'de', 'client', 'Auftraggeber');
INSERT INTO language VALUES (42, 'de', 'order type', 'Auftragsart');
INSERT INTO language VALUES (43, 'de', 'new task', 'Neuer Arbeitsauftrag');
INSERT INTO language VALUES (44, 'de', 'next', 'weiter');
INSERT INTO language VALUES (45, 'de', 'procurement', 'Beschaffung');
INSERT INTO language VALUES (46, 'de', 'development', 'Entwicklung');
INSERT INTO language VALUES (47, 'de', 'change', 'Aenderung');
INSERT INTO language VALUES (48, 'de', 'critical', 'kritisch');
INSERT INTO language VALUES (49, 'de', 'time near', 'zeitnah');
INSERT INTO language VALUES (50, 'de', 'normal', 'normal');
INSERT INTO language VALUES (51, 'de', 'receiver', 'Empfaenger');
INSERT INTO language VALUES (52, 'de', 'end_date', 'Zieldatum');
INSERT INTO language VALUES (53, 'de', 'element_type', 'Elementart');
INSERT INTO language VALUES (54, 'de', 'add task', 'Arbeitsauftrag eintragen');
INSERT INTO language VALUES (55, 'de', 'task description', 'Auftragsbeschreibung');
INSERT INTO language VALUES (56, 'de', 'creation_date', 'Erstellungsdatum');
INSERT INTO language VALUES (57, 'de', 'task_description', 'Auftrags-
\r\nbeschreibung');
INSERT INTO language VALUES (58, 'de', 'deletion', 'Loeschung');
INSERT INTO language VALUES (59, 'de', 'apply task', 'Arbeitsauftrag uebernehmen');
INSERT INTO language VALUES (60, 'de', 'editor', 'Bearbeiter');
INSERT INTO language VALUES (61, 'de', 'confirmation', 'Bestaetigung');
INSERT INTO language VALUES (62, 'de', 'costs', 'Kosten');
INSERT INTO language VALUES (63, 'de', 'start task', 'Arbeitsauftrag starten');
INSERT INTO language VALUES (64, 'de', 'date', 'Termin');
INSERT INTO language VALUES (65, 'de', 'end task', 'Arbeitsauftrag abschliessen');
INSERT INTO language VALUES (66, 'de', 'open', 'Offen');
INSERT INTO language VALUES (67, 'de', 'assumed', 'uebernommen');
INSERT INTO language VALUES (68, 'de', 'started', 'Begonnen');
INSERT INTO language VALUES (69, 'de', 'done', 'Beendet');
INSERT INTO language VALUES (70, 'de', 'status', 'Status');
INSERT INTO language VALUES (71, 'de', 'my tasks', 'Meine Arbeitsauftraege');
INSERT INTO language VALUES (72, 'de', 'task', 'Auftrag');
INSERT INTO language VALUES (73, 'de', 'back', 'Zurueck');
INSERT INTO language VALUES (74, 'de', 'created tasks', 'Erstellte Arbeitsauftraege');
INSERT INTO language VALUES (75, 'de', 'new element', 'Neuanlage');
INSERT INTO language VALUES (76, 'de', 'finish_date', 'Erledigt bis zum');
INSERT INTO language VALUES (77, 'de', 'expenditure', 'Aufwand');
INSERT INTO language VALUES (78, 'de', 'document', 'Dokument');
INSERT INTO language VALUES (79, 'de', 'low', 'niedrig');
INSERT INTO language VALUES (80, 'de', 'high', 'hoch');
INSERT INTO language VALUES (81, 'de', 'extrem high', 'extrem hoch');
INSERT INTO language VALUES (82, 'de', 'additiv', 'additiv');
INSERT INTO language VALUES (83, 'de', 'deinstallation first', 'Deinstallation vorab');
INSERT INTO language VALUES (84, 'de', 'installation', 'Installation');
INSERT INTO language VALUES (85, 'de', 'hotfix', 'Hotfix');
INSERT INTO language VALUES (86, 'de', 'patch', 'Patch');
INSERT INTO language VALUES (87, 'de', 'configuration', 'Konfiguration');
INSERT INTO language VALUES (88, 'de', 'system', 'System');
INSERT INTO language VALUES (89, 'de', 'release', 'Release');
INSERT INTO language VALUES (90, 'de', 'cost_factor', 'EUR');
INSERT INTO language VALUES (91, 'de', 'finished', 'Beendet');
INSERT INTO language VALUES (92, 'de', 'finished tasks', 'Beendete Arbeitsauftraege');
INSERT INTO language VALUES (93, 'de', 'new obj', 'Neues Element');
INSERT INTO language VALUES (94, 'de', 'tasks', 'Arbeitsauftraege');
INSERT INTO language VALUES (95, 'de', 'error', 'Fehler');
INSERT INTO language VALUES (96, 'de', 'add check', 'taegliche Aufgabe hinzufuegen');
INSERT INTO language VALUES (97, 'de', 'check days', 'Aufgabentag(e)');
INSERT INTO language VALUES (98, 'de', 'checks', 'Taegliche Aufgaben');
INSERT INTO language VALUES (99, 'de', 'timeline', 'Aufgabentag(e)');
INSERT INTO language VALUES (100, 'de', 'check', 'Aufgabe');
INSERT INTO language VALUES (101, 'de', 'finish check', 'Aufgabe abschliessen');
INSERT INTO language VALUES (102, 'de', 'edit', 'Bearbeiten');
INSERT INTO language VALUES (103, 'de', 'delete', 'Loeschen');
INSERT INTO language VALUES (104, 'de', 'overview', 'Ueberblick');
INSERT INTO language VALUES (105, 'de', 'new check', 'Neuer Check');
INSERT INTO language VALUES (106, 'de', 'archiv', 'Archiv');
INSERT INTO language VALUES (107, 'de', 'open tasks', 'offene Arbeitsauftraege');
INSERT INTO language VALUES (108, 'de', 'edit check', 'Check Bearbeiten');
INSERT INTO language VALUES (109, 'de', 'docman', 'IT-Elemente');
INSERT INTO language VALUES (110, 'de', 'expired', 'Abgelaufen');
INSERT INTO language VALUES (111, 'de', 'error_no_items', 'Es wurden keine Eintraege gefunden');
INSERT INTO language VALUES (112, 'de', 'checklists', 'taegliche Aufgaben');
INSERT INTO language VALUES (113, 'de', 'successfull', 'Erfolgreich');
INSERT INTO language VALUES (114, 'de', 'problem', 'Problem');
INSERT INTO language VALUES (115, 'de', 'effect', 'Auswirkung');
INSERT INTO language VALUES (116, 'de', 'measure', 'Massnahmen');
INSERT INTO language VALUES (117, 'de', 'inform', 'informiere');
INSERT INTO language VALUES (118, 'de', 'failed', 'Fehlgeschlagen');
INSERT INTO language VALUES (119, 'de', 'object', 'Objekt');
INSERT INTO language VALUES (120, 'de', 'reaction_time', 'Reaktionszeit');
INSERT INTO language VALUES (121, 'de', 'expiration_date', 'Ablaufdatum');
INSERT INTO language VALUES (122, 'de', 'cost', 'Kosten');
INSERT INTO language VALUES (123, 'de', 'sum costs', 'Gesamtkosten');
INSERT INTO language VALUES (124, 'de', 'new contract', 'neuer Vertrag');
INSERT INTO language VALUES (125, 'de', 'service contract', 'Wartungsvertrag');
INSERT INTO language VALUES (126, 'de', 'new_contract', 'neuer Vertrag');
INSERT INTO language VALUES (127, 'de', 'currency', 'EUR');
INSERT INTO language VALUES (128, 'de', 'add contract', 'Vertrag hinzufuegen');
INSERT INTO language VALUES (129, 'de', 'execution', 'Durchfuehrung am');
INSERT INTO language VALUES (130, 'de', 'recover', 'Wiederherstellen');
INSERT INTO language VALUES (131, 'de', 'login welcome text', 'Willkommen auf der Seite der i-doIT Toolsammlung!');
INSERT INTO language VALUES (132, 'de', 'username', 'Benutzername');
INSERT INTO language VALUES (133, 'de', 'login password', 'Passwort');
INSERT INTO language VALUES (134, 'de', 'login button', 'Anmelden');
INSERT INTO language VALUES (135, 'de', 'main announcements', 'Neuankuendigungen');
INSERT INTO language VALUES (136, 'de', 'main updates', 'Updates der IT-Elemente');
INSERT INTO language VALUES (137, 'de', 'main updates user', 'Benutzer');
INSERT INTO language VALUES (138, 'de', 'main updates date', 'Datum');
INSERT INTO language VALUES (139, 'de', 'main updates type', 'Elementtyp');
INSERT INTO language VALUES (140, 'de', 'main updates object', 'Element');
INSERT INTO language VALUES (141, 'de', 'button search', 'Suchen');
INSERT INTO language VALUES (142, 'de', 'search', 'Suchen');
INSERT INTO language VALUES (143, 'de', 'statistics', 'Statistik');
INSERT INTO language VALUES (144, 'de', 'logout message', 'Sie haben sich erfolgreich aus dem i-doIT System ausgeloggt. Ihre Sitzung wurde geloescht.');
INSERT INTO language VALUES (145, 'de', 'login session expired', 'Ihre Sitzung ist abgelaufen. Bitte loggen Sie sich erneut in der untenstehenden Maske ein.');
INSERT INTO language VALUES (146, 'de', 'logged in users', 'Angemeldete Benutzer');
INSERT INTO language VALUES (147, 'de', 'login error invalid', 'Ungueltiger Login!');
INSERT INTO language VALUES (148, 'de', 'login error enter username and password', 'Benutzername und Passwort eingeben!');
INSERT INTO language VALUES (149, 'de', 'navbar new', 'Neuer Datensatz');
INSERT INTO language VALUES (150, 'de', 'navbar delete', 'Datensatz loeschen');
INSERT INTO language VALUES (151, 'de', 'navbar edit', 'Datensatz bearbeiten');
INSERT INTO language VALUES (152, 'de', 'navbar save', 'Datensatz speichern');
INSERT INTO language VALUES (153, 'de', 'navbar refresh', 'Aktualisieren');
INSERT INTO language VALUES (154, 'de', 'navbar stack', 'Ruecksprung');
INSERT INTO language VALUES (155, 'de', 'navbar empty', '');
INSERT INTO language VALUES (156, 'de', 'navbar previous', 'Vorheriger Datensatz');
INSERT INTO language VALUES (157, 'de', 'navbar next', 'Naechster Datensatz');
INSERT INTO language VALUES (158, 'de', 'navbar deactivated', 'Deaktiviert');
INSERT INTO language VALUES (159, 'de', 'navbar cancel', 'Abbrechen');
INSERT INTO language VALUES (160, 'de', 'new lic', 'Neue Lizenz');
INSERT INTO language VALUES (161, 'de', 'name', 'Name');
INSERT INTO language VALUES (162, 'de', 'min_lics', 'Minimalanzahl');
INSERT INTO language VALUES (163, 'de', 'add licence', 'Lizenz erstellen');
INSERT INTO language VALUES (164, 'de', 'edit lic', 'Lizenz bearbeiten');
INSERT INTO language VALUES (165, 'de', 'lic_name', 'Lizenzname');
INSERT INTO language VALUES (166, 'de', 'minlicences reached', 'Minimalanzahl Lizenzen erreicht');
INSERT INTO language VALUES (167, 'de', 'minlicences', 'Minimalanzahl');
INSERT INTO language VALUES (168, 'de', 'avalible_licences', 'Verfuegbare Lizenzen');
INSERT INTO language VALUES (169, 'de', 'count_lics', 'Anzahl Lizenzen');
INSERT INTO language VALUES (170, 'de', 'used_lics', 'Verwendete Lizenzen');
INSERT INTO language VALUES (171, 'de', 'sum_costs', 'Summe Kosten');
INSERT INTO language VALUES (172, 'de', 'new sub_lic', 'Neue Sublizenz');
INSERT INTO language VALUES (173, 'de', 'parent_lic', 'Basislizenz');
INSERT INTO language VALUES (174, 'de', 'type', 'Lizenztyp');
INSERT INTO language VALUES (175, 'de', 'number of lics', 'Anzahl Lizenzen');
INSERT INTO language VALUES (176, 'de', 'start_date', 'Startdatum');
INSERT INTO language VALUES (177, 'de', 'expire_date', 'Ablaufdatum');
INSERT INTO language VALUES (178, 'de', 'systemname (ldap)', 'Systemname (LDAP)');
INSERT INTO language VALUES (179, 'de', 'add user 2 licence', 'Benutzer hinzufuegen');
INSERT INTO language VALUES (180, 'de', 'delete licence', 'Sublizenz loeschen');
INSERT INTO language VALUES (181, 'de', 'edit licence', 'Lizenz bearbeiten');
INSERT INTO language VALUES (182, 'de', 'free_licences', 'Frei');
INSERT INTO language VALUES (183, 'de', 'running', 'Laufend');
INSERT INTO language VALUES (184, 'de', 'daysleft', 'Tage uebrig');
INSERT INTO language VALUES (185, 'de', 'sum licences', 'Gesamt');
INSERT INTO language VALUES (186, 'de', 'new sub_lic user', 'Neuer Benutzer');
INSERT INTO language VALUES (187, 'de', 'user', 'Benutzer');
INSERT INTO language VALUES (188, 'de', 'keys', 'Schluessel');
INSERT INTO language VALUES (189, 'de', 'used', 'Benutzt');
INSERT INTO language VALUES (190, 'de', 'unused', 'Nicht benutzt');
INSERT INTO language VALUES (191, 'de', 'element', 'Element');
INSERT INTO language VALUES (192, 'de', 'deleted items', 'Geloeschte Elemente');
INSERT INTO language VALUES (193, 'de', 'double click to add', 'Doppelklick zum Hinzufuegen');
INSERT INTO language VALUES (194, 'de', 'edit contract', 'Vertrag bearbeiten');
INSERT INTO language VALUES (195, 'de', 'double click to add', 'Doppelklick zum Hinzufuegen');
INSERT INTO language VALUES (196, 'de', 'edit contract', 'Vertrag bearbeiten');
INSERT INTO language VALUES (197, 'de', 'help title', 'Hilfe');
INSERT INTO language VALUES (198, 'de', 'save', 'Speichern');
INSERT INTO language VALUES (199, 'en', 'save', 'Save');
INSERT INTO language VALUES (200, 'de', 'username', 'Benutzername');
INSERT INTO language VALUES (201, 'en', 'username', 'Username');
INSERT INTO language VALUES (202, 'de', 'password', 'Passwort');
INSERT INTO language VALUES (203, 'en', 'password', 'Password');
INSERT INTO language VALUES (204, 'de', 'surname', 'Nachname');
INSERT INTO language VALUES (205, 'en', 'surname', 'Surname');
INSERT INTO language VALUES (206, 'de', 'givenname', 'Vorname');
INSERT INTO language VALUES (207, 'en', 'givenname', 'First name');
INSERT INTO language VALUES (208, 'de', 'emailadress', 'E-Mail Adresse');
INSERT INTO language VALUES (209, 'en', 'emailadress', 'Emailadress');
INSERT INTO language VALUES (210, 'de', 'userlist', 'Benutzerliste');
INSERT INTO language VALUES (211, 'en', 'userlist', 'Userlist');
INSERT INTO language VALUES (212, 'de', 'moduleright', 'Authentifikationsart');
INSERT INTO language VALUES (213, 'en', 'moduleright', 'Authentification type');
INSERT INTO language VALUES (214, 'de', 'lastlogin', 'Letzter Login');
INSERT INTO language VALUES (215, 'en', 'lastlogin', 'Last login');
INSERT INTO language VALUES (216, 'de', 'newuser', 'Neuer SQL Benutzer');
INSERT INTO language VALUES (217, 'en', 'newuser', 'New SQL user');
INSERT INTO language VALUES (218, 'de', 'last_login_date', 'Zuletzt eingeloggt am');
INSERT INTO language VALUES (219, 'en', 'last_login_date', 'Last login date');
INSERT INTO language VALUES (220, 'de', 'creation_user', 'Erstellt von');
INSERT INTO language VALUES (221, 'en', 'creation_user', 'Created by');
INSERT INTO language VALUES (222, 'de', 'isactive', 'Aktiv');
INSERT INTO language VALUES (223, 'en', 'isactive', 'Active');
INSERT INTO language VALUES (224, 'de', 'auth_name', 'Authentifikation');
INSERT INTO language VALUES (225, 'en', 'auth_name', 'Authentification');
INSERT INTO language VALUES (226, 'de', 'groupname', 'Gruppe');
INSERT INTO language VALUES (227, 'en', 'groupname', 'Group');
INSERT INTO language VALUES (228, 'de', 'groupdescription', 'Beschreibung der Gruppe');
INSERT INTO language VALUES (229, 'en', 'groupdescription', 'Group description');
INSERT INTO language VALUES (230, 'de', 'grouplist', 'Liste der Rechtegruppen');
INSERT INTO language VALUES (231, 'en', 'grouplist', 'List of rights-groups');
INSERT INTO language VALUES (232, 'de', 'newrightsgroup', 'Neue Gruppe anlegen');
INSERT INTO language VALUES (233, 'en', 'newrightsgroup', 'Add new group');
INSERT INTO language VALUES (234, 'de', 'rights_management', 'Rechteverwaltung');
INSERT INTO language VALUES (235, 'en', 'rights_management', 'Rightsmanagement');
INSERT INTO language VALUES (236, 'de', 'element', 'Element');
INSERT INTO language VALUES (237, 'en', 'element', 'Element');
INSERT INTO language VALUES (238, 'de', 'rights', 'Rechte');
INSERT INTO language VALUES (239, 'en', 'rights', 'Rights');
INSERT INTO language VALUES (240, 'de', 'change_date', 'Aenderungsdatum');
INSERT INTO language VALUES (241, 'en', 'change_date', 'Change date');
INSERT INTO language VALUES (242, 'de', 'change_user', 'Geaendert von');
INSERT INTO language VALUES (243, 'en', 'change_user', 'Changed by');
INSERT INTO language VALUES (244, 'de', 'delete_current_group', 'Diese Gruppe loeschen');
INSERT INTO language VALUES (245, 'en', 'delete_current_group', 'Delete this group');
INSERT INTO language VALUES (246, 'de', 'groupmember', 'Rechtegruppe(n)');
INSERT INTO language VALUES (247, 'en', 'groupmember', 'Rightsgroup(s)');
INSERT INTO language VALUES (248, 'de', 'browse', 'Browse');
INSERT INTO language VALUES (249, 'en', 'Browse', 'Browse');
INSERT INTO language VALUES (250, 'de', 'read', 'Lesen');
INSERT INTO language VALUES (251, 'en', 'read', 'Read');
INSERT INTO language VALUES (252, 'de', 'write', 'Schreiben');
INSERT INTO language VALUES (253, 'en', 'write', 'Write');
INSERT INTO language VALUES (254, 'de', 'new', 'Neu');
INSERT INTO language VALUES (255, 'en', 'new', 'New');
INSERT INTO language VALUES (256, 'de', 'kein_benutzer_gefunden', 'Es wurde kein Benutzer gefunden');
INSERT INTO language VALUES (257, 'en', 'kein_benutzer_gefunden', 'No user was found');
INSERT INTO language VALUES (258, 'de', 'input_error', 'Sie haben einen Fehler bei Ihrer Eingabe gemacht!');
INSERT INTO language VALUES (259, 'en', 'input_error', 'There is an error in your input!');
INSERT INTO language VALUES (260, 'de', 'user_created', 'Benutzer wurde angelegt.');
INSERT INTO language VALUES (261, 'en', 'user_created', 'User was created.');
INSERT INTO language VALUES (262, 'de', 'userdata_saved', 'Die Benutzerdaten wurden gespeichert.');
INSERT INTO language VALUES (263, 'en', 'userdata_saved', 'Userdata was saved.');
INSERT INTO language VALUES (264, 'de', 'userdata_save_error', 'Es ist ein Fehler beim Speichern der Benutzerdaten aufgetreten.');
INSERT INTO language VALUES (265, 'en', 'userdata_save_error', 'An error occurred in saving the user data.');
INSERT INTO language VALUES (266, 'de', 'no_sysop_delete', 'Der Systembenutzer kann nicht geloescht werden.');
INSERT INTO language VALUES (267, 'en', 'no_sysop_delete', 'The System Operator cannot be deleted.');
INSERT INTO language VALUES (268, 'de', 'no_delete_active_user', 'Der letzte, aktive Benutzer kann nicht geloescht werden.');
INSERT INTO language VALUES (269, 'en', 'no_delete_active_user', 'The last active user cannot be deleted.');
INSERT INTO language VALUES (270, 'de', 'user_deleted', 'Benutzer wurde geloescht.');
INSERT INTO language VALUES (271, 'en', 'user_deleted', 'User was deleted.');
INSERT INTO language VALUES (272, 'de', 'user_with_id_not_found', 'Ein Benutzer mit dieser ID wurde nicht gefunden.');
INSERT INTO language VALUES (273, 'en', 'user_with_id_not_found', 'A user with this ID was not found.');
INSERT INTO language VALUES (274, 'de', 'no_changename_sysop', 'Der Benutzername des System Operators kann nicht geaendert werden.');
INSERT INTO language VALUES (275, 'en', 'no_changename_sysop', 'The name of the system operator cannot be changed.');
INSERT INTO language VALUES (276, 'de', 'no_change_isactive_sysop', 'Der System Operator kann nicht auf Inaktiv gesetzt werden.');
INSERT INTO language VALUES (277, 'en', 'no_change_isactive_sysop', 'The system operator cannot be set to inactive.');
INSERT INTO language VALUES (278, 'de', 'create_new_user', 'Neuen Benutzer erstellen');
INSERT INTO language VALUES (279, 'en', 'create_new_user', 'Create new user');
INSERT INTO language VALUES (280, 'de', 'delete_marked_user', 'Markierten Benutzer loeschen');
INSERT INTO language VALUES (281, 'en', 'delete_marked_user', 'Delete marked user');
INSERT INTO language VALUES (282, 'de', 'show_marked_user', 'Zeige markierten Benutzer an');
INSERT INTO language VALUES (283, 'en', 'show_marked_user', 'Show marked user');
INSERT INTO language VALUES (284, 'de', 'edit_marked_user', 'Editiere markierten Benutzer');
INSERT INTO language VALUES (285, 'en', 'edit_marked_user', 'Edit marked user');
INSERT INTO language VALUES (286, 'de', 'delete_user', 'Benutzer loeschen');
INSERT INTO language VALUES (287, 'en', 'delete_user', 'Delete user');
INSERT INTO language VALUES (288, 'de', 'edit_user', 'Benutzer editieren');
INSERT INTO language VALUES (289, 'en', 'edit_user', 'Edit user');
INSERT INTO language VALUES (290, 'de', 'save_user', 'Benutzer speichern');
INSERT INTO language VALUES (291, 'en', 'save_user', 'Save user');
INSERT INTO language VALUES (292, 'de', 'show_user', 'Benutzer anzeigen');
INSERT INTO language VALUES (293, 'en', 'show_user', 'Show user');
INSERT INTO language VALUES (294, 'de', 'edit_group', 'Rechtegruppe bearbeiten');
INSERT INTO language VALUES (295, 'en', 'edit_group', 'Edit rightsgroup');
INSERT INTO language VALUES (296, 'de', 'edit_rights', 'Rechte bearbeiten');
INSERT INTO language VALUES (297, 'en', 'edit_rights', 'Edit rights');
INSERT INTO language VALUES (298, 'de', 'rightsgroup_deleted', 'Rechtegruppe wurde geloescht');
INSERT INTO language VALUES (299, 'en', 'rightsgroup_deleted', 'Rightsgroup was deleted');
INSERT INTO language VALUES (300, 'de', 'rightsgroup_not_found', 'Rechtegruppe wurde nicht gefunden');
INSERT INTO language VALUES (301, 'en', 'rightsgroup_not_found', 'Rightsgroup was not found');
INSERT INTO language VALUES (302, 'de', 'rightsgroup_no_delete_cause_user_connected', 'Rechtegruppe konnte nicht geloescht werden, da Benutzer mir ihr verbunden sind');
INSERT INTO language VALUES (303, 'en', 'rightsgroup_no_delete_cause_user_connected', 'Rightsgroup could not be deleted because users are connected to it');
INSERT INTO language VALUES (304, 'de', 'groupname_already_assigned', 'Diesen Gruppennamen gibt es schon, bitte waehlen Sie einen anderen');
INSERT INTO language VALUES (305, 'en', 'groupname_already_assigned', 'The groupname already exists, please choose another one');
INSERT INTO language VALUES (306, 'de', 'groupname_updated', 'Gruppenname und -beschreibung gespeichert');
INSERT INTO language VALUES (307, 'en', 'groupname_updated', 'Groupname and -description saved');
INSERT INTO language VALUES (308, 'de', 'no_modules_found', 'Keine Module gefunden');
INSERT INTO language VALUES (309, 'en', 'no_modules_found', 'No modules found');
INSERT INTO language VALUES (310, 'de', 'password_5chars', 'Das Passwort muss mindestens 5 Zeichen lang sein');
INSERT INTO language VALUES (311, 'en', 'password_5chars', 'The password has to have at least 5 characters');
INSERT INTO language VALUES (312, 'de', 'username_3chars', 'Der Benutzername muss mindestens 3 Zeichen lang sein');
INSERT INTO language VALUES (313, 'en', 'username_3chars', 'The username has to have at least 3 characters');
INSERT INTO language VALUES (314, 'de', 'user_management', 'Benutzerverwaltung');
INSERT INTO language VALUES (315, 'en', 'user_management', 'Usermanagement');
INSERT INTO language VALUES (316, 'de', 'new_user', 'Neuer Benutzer');
INSERT INTO language VALUES (317, 'en', 'new_user', 'New user');
INSERT INTO language VALUES (318, 'de', 'edit_group', 'Gruppe bearbeiten');
INSERT INTO language VALUES (319, 'en', 'edit_group', 'Edit group');
INSERT INTO language VALUES (320, 'de', 'delete_group', 'Gruppe loeschen');
INSERT INTO language VALUES (321, 'en', 'delete_group', 'Delete group');
INSERT INTO language VALUES (322, 'de', 'save_group', 'Gruppe speichern');
INSERT INTO language VALUES (323, 'en', 'save_group', 'Save group');
INSERT INTO language VALUES (324, 'de', 'show_group', 'Gruppen anzeigen');
INSERT INTO language VALUES (325, 'en', 'show_group', 'Show groups');
INSERT INTO language VALUES (326, 'de', 'new_group', 'Gruppe erstellen');
INSERT INTO language VALUES (327, 'en', 'new_group', 'Create group');
INSERT INTO language VALUES (328, 'de', 'edit sub_lic user', 'Benutzer bearbeiten');
INSERT INTO language VALUES (329, 'en', 'edit sub_lic user', 'Edit user');
INSERT INTO language VALUES (334, 'de', 'left', 'Verbleibend');
INSERT INTO language VALUES (335, 'de', 'licences', 'Lizenzen');
INSERT INTO language VALUES (332, 'de', 'start', 'Beginn');
INSERT INTO language VALUES (333, 'de', 'end', 'Ende');
INSERT INTO language VALUES (336, 'de', 'remark', 'Bemerkung');
INSERT INTO language VALUES (337, 'de', 'add user to sublicence', 'Neuer Benutzer');
INSERT INTO language VALUES (338, 'de', 'edit sublicence', 'Sublizenz bearbeiten');
INSERT INTO language VALUES (339, 'de', 'delete sublicence', 'Sublizenz loeschen');
INSERT INTO language VALUES (340, 'de', 'new_sublic', 'Neue Sublizenz');
INSERT INTO language VALUES (341, 'de', 'edit_lic', 'Lizenz bearbeiten');
INSERT INTO language VALUES (342, 'de', 'delete_lic', 'Lizenz loeschen');
INSERT INTO language VALUES (343, 'de', 'save user', 'Speichern');
INSERT INTO language VALUES (344, 'de', 'initials', 'Kuerzel');
INSERT INTO language VALUES (345, 'de', 'days', 'Tage');
INSERT INTO language VALUES (346, 'de', 'count', 'Anzahl');
INSERT INTO language VALUES (347, 'de', 'detail_view', 'Details');
INSERT INTO language VALUES (348, 'de', 'startdate', 'Startdatum');
INSERT INTO language VALUES (349, 'de', 'expiredate', 'Enddatum');
INSERT INTO language VALUES (350, 'de', 'edit sub_lic', 'Sublizenz bearbeiten');
INSERT INTO language VALUES (351, 'de', 'save sublicence', 'Speichern');
INSERT INTO language VALUES (352, 'de', 'save_licence', 'Speichern');

---

--
-- Tabellenstruktur für Tabelle mod_archive_deleted_items_modules

CREATE TABLE mod_archive_deleted_items_modules (
ID int(11) NOT NULL auto_increment,
ident varchar(32) collate latin1_general_ci NOT NULL default '',
sorting int(11) NOT NULL default '0',
template varchar(255) collate latin1_general_ci NOT NULL default '',
short varchar(8) collate latin1_general_ci NOT NULL default '',
color varchar(8) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

--
-- Daten für Tabelle mod_archive_deleted_items_modules

INSERT INTO mod_archive_deleted_items_modules VALUES (1, 'checklists', 0, 'checklists_archive_deleted_items_inner.inc.php', '', '');
INSERT INTO mod_archive_deleted_items_modules VALUES (2, 'docman', 1, 'docman_archive_deleted_items_inner.inc.php', '', '');

---

--
-- Tabellenstruktur für Tabelle mod_archive_modules

CREATE TABLE mod_archive_modules (
ID int(11) NOT NULL auto_increment,
ident varchar(32) collate latin1_general_ci NOT NULL default '',
sorting int(11) NOT NULL default '0',
template varchar(255) collate latin1_general_ci NOT NULL default '',
short varchar(8) collate latin1_general_ci NOT NULL default '',
color varchar(8) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

--
-- Daten für Tabelle mod_archive_modules

INSERT INTO mod_archive_modules VALUES (1, 'checklists', 1, 'checklists_archive_inner.inc.php', 'checklis', '#ff0000');
INSERT INTO mod_archive_modules VALUES (2, 'tasks', 1, 'tasks_archive_inner.inc.php', 'TASKS', '');

---

--
-- Tabellenstruktur für Tabelle mod_archive_updates_modules

CREATE TABLE mod_archive_updates_modules (
ID int(11) NOT NULL auto_increment,
ident varchar(32) collate latin1_general_ci NOT NULL default '',
sorting int(11) NOT NULL default '0',
template varchar(255) collate latin1_general_ci NOT NULL default '',
short varchar(8) collate latin1_general_ci NOT NULL default '',
color varchar(8) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle mod_archive_updates_modules

---

--
-- Tabellenstruktur für Tabelle mod_checklists_checks

CREATE TABLE mod_checklists_checks (
ID int(11) NOT NULL auto_increment,
description varchar(255) collate latin1_general_ci NOT NULL default '',
timeline varchar(255) collate latin1_general_ci NOT NULL default '',
receiver varchar(255) collate latin1_general_ci NOT NULL default '',
deleted tinyint(4) NOT NULL default '0',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle mod_checklists_checks

INSERT INTO mod_checklists_checks VALUES (1, 'test', 'Mon;', '', 0);

---

--
-- Tabellenstruktur für Tabelle mod_checklists_workflow

CREATE TABLE mod_checklists_workflow (
ID int(11) NOT NULL auto_increment,
receiver varchar(255) collate latin1_general_ci NOT NULL default '',
userID int(11) NOT NULL default '0',
parentID int(11) NOT NULL default '0',
date date NOT NULL default '0000-00-00',
status enum('open','done','failed') collate latin1_general_ci NOT NULL default 'open',
comment text collate latin1_general_ci,
err_problem text collate latin1_general_ci,
err_effect text collate latin1_general_ci,
err_measure text collate latin1_general_ci,
err_inform varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

--
-- Daten für Tabelle mod_checklists_workflow

INSERT INTO mod_checklists_workflow VALUES (1, 'u1;', 0, 2, 0x323030352d30332d3137, 'open', NULL, NULL, NULL, NULL, NULL);
INSERT INTO mod_checklists_workflow VALUES (2, 'u1;', 0, 10, 0x323030352d30332d3137, 'open', NULL, NULL, NULL, NULL, NULL);
INSERT INTO mod_checklists_workflow VALUES (3, 'u27;', 0, 11, 0x323030352d30332d3137, 'open', NULL, NULL, NULL, NULL, NULL);

---

--
-- Tabellenstruktur für Tabelle mod_documents

CREATE TABLE mod_documents (
ID int(10) unsigned NOT NULL auto_increment,
filename varchar(255) collate latin1_general_ci NOT NULL default '',
size int(11) NOT NULL default '0',
type varchar(255) collate latin1_general_ci NOT NULL default '',
checksum varchar(64) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle mod_documents

---

--
-- Tabellenstruktur für Tabelle mod_lic_basis

CREATE TABLE mod_lic_basis (
ID int(1) unsigned NOT NULL auto_increment,
name varchar(64) collate latin1_general_ci default NULL,
tablename varchar(32) collate latin1_general_ci default NULL,
tableID int(4) unsigned default NULL,
minlicences int(4) unsigned default NULL,
description text collate latin1_general_ci,
deleted tinyint(1) default '0',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle mod_lic_basis

---

--
-- Tabellenstruktur für Tabelle mod_lic_sub

CREATE TABLE mod_lic_sub (
ID int(1) unsigned NOT NULL auto_increment,
parentlicID int(4) NOT NULL default '0',
count int(4) NOT NULL default '0',
costs int(4) unsigned NOT NULL default '0',
startdate date NOT NULL default '2004-10-13',
expiredate date default NULL,
type varchar(255) collate latin1_general_ci default NULL,
version varchar(32) collate latin1_general_ci default NULL,
systemname varchar(255) collate latin1_general_ci default NULL,
status enum('running',' expired') collate latin1_general_ci default 'running',
minlicences int(4) unsigned NOT NULL default '0',
deleted tinyint(4) NOT NULL default '0',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle mod_lic_sub

---

--
-- Tabellenstruktur für Tabelle mod_lic_subtouser

CREATE TABLE mod_lic_subtouser (
ID int(1) unsigned NOT NULL auto_increment,
parentsublicID int(4) default NULL,
usercacheID int(4) default NULL,
initials varchar(6) collate latin1_general_ci default NULL,
bemerkung text collate latin1_general_ci,
keys text collate latin1_general_ci,
system int(4) default NULL,
status enum('used','unused') collate latin1_general_ci default 'used',
deleted tinyint(4) NOT NULL default '0',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle mod_lic_subtouser

---

--
-- Tabellenstruktur für Tabelle mod_mydocs_modules

CREATE TABLE mod_mydocs_modules (
ID int(11) NOT NULL auto_increment,
ident varchar(32) collate latin1_general_ci NOT NULL default '',
sorting int(11) NOT NULL default '0',
template varchar(255) collate latin1_general_ci NOT NULL default '',
short varchar(8) collate latin1_general_ci NOT NULL default '',
color varchar(8) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

--
-- Daten für Tabelle mod_mydocs_modules

INSERT INTO mod_mydocs_modules VALUES (2, 'tasks', 1, 'mytasks_inner.inc.php', 'TASKS', '#FF0000');
INSERT INTO mod_mydocs_modules VALUES (3, 'checklists', 0, 'mychecks_inner.inc.php', 'checks', '#00FF00');

---

--
-- Tabellenstruktur für Tabelle mod_nms_config

CREATE TABLE mod_nms_config (
ID int(11) NOT NULL auto_increment,
recordTable varchar(255) collate latin1_general_ci NOT NULL default '',
recordID int(11) NOT NULL default '0',
hostgroup varchar(255) collate latin1_general_ci NOT NULL default '',
services text collate latin1_general_ci NOT NULL,
IP varchar(20) collate latin1_general_ci NOT NULL default '127.0.0.1',
snmpVersion enum('1','2c','3') collate latin1_general_ci NOT NULL default '3',
checkMe tinyint(1) NOT NULL default '1',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle mod_nms_config

---

--
-- Tabellenstruktur für Tabelle mod_nms_snmp_records

CREATE TABLE mod_nms_snmp_records (
ID int(11) NOT NULL auto_increment,
table varchar(255) collate latin1_general_ci NOT NULL default '',
recordID int(11) NOT NULL default '0',
description varchar(255) collate latin1_general_ci NOT NULL default '',
oID text collate latin1_general_ci NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle mod_nms_snmp_records

---

--
-- Tabellenstruktur für Tabelle mod_tasks_list

CREATE TABLE mod_tasks_list (
ID int(10) unsigned NOT NULL auto_increment,
clientID int(11) NOT NULL default '0',
creation_date datetime NOT NULL default '0000-00-00 00:00:00',
task_description text collate latin1_general_ci NOT NULL,
priority enum('critical','time near','normal') collate latin1_general_ci NOT NULL default 'critical',
objID int(11) default NULL,
type enum('procurement','development','change','deletion') collate latin1_general_ci NOT NULL default 'procurement',
receiver varchar(255) collate latin1_general_ci NOT NULL default '',
end_date date NOT NULL default '0000-00-00',
description text collate latin1_general_ci,
element_typeID varchar(255) collate latin1_general_ci default NULL,
editorID int(11) NOT NULL default '0',
comment text collate latin1_general_ci NOT NULL,
finish_date date NOT NULL default '0000-00-00',
costs int(11) NOT NULL default '0',
expenditure int(11) NOT NULL default '0',
status enum('open','assumed','started','done','finished','expired') collate latin1_general_ci NOT NULL default 'open',
documentID int(11) default NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle mod_tasks_list

INSERT INTO mod_tasks_list VALUES (1, 28, '2005-04-13 14:55:47', 'Test', 'normal', -1, 'procurement', 'u28;', 0x323030352d30342d3133, NULL, 'strom', 0, '', 0x303030302d30302d3030, 0, 0, 'open', NULL);

---

--
-- Tabellenstruktur für Tabelle modules_main

CREATE TABLE modules_main (
ID int(11) NOT NULL auto_increment,
name varchar(64) collate latin1_general_ci NOT NULL default '',
ident varchar(32) collate latin1_general_ci NOT NULL default '',
file_icon varchar(255) collate latin1_general_ci default NULL,
description text collate latin1_general_ci,
usergroup varchar(32) collate latin1_general_ci default NULL,
sorting int(11) default NULL,
type enum('banner','tree') collate latin1_general_ci default 'tree',
template varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID),
UNIQUE KEY name (name),
UNIQUE KEY ident (ident),
UNIQUE KEY usergroup (usergroup)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=16 ;

--
-- Daten für Tabelle modules_main

INSERT INTO modules_main VALUES (3, 'IT-Elemente', 'docman', 'mod_docm.gif', NULL, NULL, 2, 'tree', 'inner_menu.inc.php');
INSERT INTO modules_main VALUES (4, 'Meine Dokumente', 'mydocs', 'mod_ttool.gif', NULL, NULL, 1, 'tree', NULL);
INSERT INTO modules_main VALUES (5, 'Arbeitsauftraege', 'tasks', 'modules/tasks/task_folder.gif', NULL, NULL, 4, 'tree', NULL);
INSERT INTO modules_main VALUES (7, 'Checkliste', 'checklists', NULL, 'Checkliste', NULL, 6, 'tree', NULL);
INSERT INTO modules_main VALUES (8, 'Dateiverwaltung', 'documents', NULL, 'Dateiverwaltung', NULL, 7, 'tree', NULL);
INSERT INTO modules_main VALUES (9, 'Archiv', 'archive', NULL, NULL, NULL, 7, 'tree', 'inner_menu.inc.php');
INSERT INTO modules_main VALUES (10, 'Konfiguration', 'config', 'config.gif', NULL, NULL, 50, 'banner', NULL);
INSERT INTO modules_main VALUES (12, 'Rechteverwaltung', 'userrights', NULL, 'Benutzerverwaltung und Auswahl der zugehoerigen Rechtegruppen.', NULL, 9, 'tree', 'inner_menu.inc.php');

---

--
-- Tabellenstruktur für Tabelle news_rss

CREATE TABLE news_rss (
ID int(11) NOT NULL auto_increment,
title varchar(255) collate latin1_general_ci NOT NULL default '',
url text collate latin1_general_ci NOT NULL,
sorting int(6) NOT NULL default '0',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

--
-- Daten für Tabelle news_rss

INSERT INTO news_rss VALUES (1, 'Novell Updates', 'http://www.novell.com/newsfeeds/rss/productupdates_rss091.xml', 1);
INSERT INTO news_rss VALUES (2, 'Heise Newsticker', 'http://www.heise.de/newsticker/heise.rdf', 2);
INSERT INTO news_rss VALUES (3, 'i-doit', 'http://www.i-doit.de/rss.php', 0);

---

--
-- Tabellenstruktur für Tabelle sessions

CREATE TABLE sessions (
ID int(11) NOT NULL auto_increment,
session_ID varchar(255) collate latin1_general_ci NOT NULL default '',
usercache_ID int(11) NOT NULL default '0',
username varchar(255) collate latin1_general_ci NOT NULL default '',
password varchar(255) collate latin1_general_ci NOT NULL default '',
IP varchar(16) collate latin1_general_ci NOT NULL default '',
timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID),
FULLTEXT KEY sessionID (session_ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=348 ;

--
-- Daten für Tabelle sessions

INSERT INTO sessions VALUES (347, 'cdc539274fd03593cd38667ffd7b5e56', 28, 'sysop', 'idoit', '127.0.0.1', 0x323030352d30342d31382031363a34393a3333);

---

--
-- Tabellenstruktur für Tabelle ur_element

CREATE TABLE ur_element (
id int(11) NOT NULL auto_increment,
moduleid int(11) default NULL,
max_rights smallint(6) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=19 ;

--
-- Daten für Tabelle ur_element

INSERT INTO ur_element VALUES (10, 3, 31);
INSERT INTO ur_element VALUES (11, 4, 31);
INSERT INTO ur_element VALUES (12, 5, 31);
INSERT INTO ur_element VALUES (13, 7, 31);
INSERT INTO ur_element VALUES (14, 8, 31);
INSERT INTO ur_element VALUES (15, 9, 31);
INSERT INTO ur_element VALUES (16, 10, 31);
INSERT INTO ur_element VALUES (17, 11, 31);
INSERT INTO ur_element VALUES (18, 12, 31);

---

--
-- Tabellenstruktur für Tabelle ur_group

CREATE TABLE ur_group (
id int(11) NOT NULL auto_increment,
name varchar(255) collate latin1_general_ci NOT NULL default '',
description varchar(255) collate latin1_general_ci default NULL,
creation_date datetime NOT NULL default '0000-00-00 00:00:00',
creation_userid int(11) default NULL,
change_date datetime default '0000-00-00 00:00:00',
change_userid int(11) default NULL,
l_word varchar(255) collate latin1_general_ci default NULL,
cannotbedeleted tinyint(1) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=16 ;

--
-- Daten für Tabelle ur_group

INSERT INTO ur_group VALUES (1, 'Administrator', 'Standardgruppe mit allen Rechten.', '2004-11-26 12:06:14', 6, '2005-01-24 13:09:10', 1, 'admin', 1);
INSERT INTO ur_group VALUES (11, 'Standardbenutzer', 'Standardbenutzer', '2004-12-06 03:29:05', NULL, '2004-12-06 12:53:33', 1, NULL, NULL);

---

--
-- Tabellenstruktur für Tabelle ur_groupright

CREATE TABLE ur_groupright (
groupid int(11) NOT NULL default '0',
rightid int(11) NOT NULL default '0',
PRIMARY KEY (groupid,rightid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Daten für Tabelle ur_groupright

INSERT INTO ur_groupright VALUES (1, 1);
INSERT INTO ur_groupright VALUES (1, 2);
INSERT INTO ur_groupright VALUES (1, 3);
INSERT INTO ur_groupright VALUES (1, 4);
INSERT INTO ur_groupright VALUES (1, 5);
INSERT INTO ur_groupright VALUES (1, 6);
INSERT INTO ur_groupright VALUES (1, 7);
INSERT INTO ur_groupright VALUES (1, 8);
INSERT INTO ur_groupright VALUES (1, 9);
INSERT INTO ur_groupright VALUES (11, 97);
INSERT INTO ur_groupright VALUES (11, 98);
INSERT INTO ur_groupright VALUES (11, 99);
INSERT INTO ur_groupright VALUES (11, 100);
INSERT INTO ur_groupright VALUES (11, 101);
INSERT INTO ur_groupright VALUES (11, 102);
INSERT INTO ur_groupright VALUES (11, 103);
INSERT INTO ur_groupright VALUES (11, 104);
INSERT INTO ur_groupright VALUES (11, 106);

---

--
-- Tabellenstruktur für Tabelle ur_interface

CREATE TABLE ur_interface (
id int(11) NOT NULL auto_increment,
auth_name varchar(10) collate latin1_general_ci NOT NULL default '',
table_name varchar(20) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY auth_name (auth_name),
UNIQUE KEY table_name (table_name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

--
-- Daten für Tabelle ur_interface

INSERT INTO ur_interface VALUES (1, 'sql', 'ur_sql_user');
INSERT INTO ur_interface VALUES (2, 'ldap', 'ur_ldap_user');

---

--
-- Tabellenstruktur für Tabelle ur_ldap_user

CREATE TABLE ur_ldap_user (
id int(11) NOT NULL auto_increment,
dn text collate latin1_general_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

--
-- Daten für Tabelle ur_ldap_user

INSERT INTO ur_ldap_user VALUES (5, 'cn=awoesten,ou=users,dc=naaina,dc=org');

---

--
-- Tabellenstruktur für Tabelle ur_right

CREATE TABLE ur_right (
id int(11) NOT NULL auto_increment,
right_bits smallint(6) default NULL,
elementid int(11) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=139 ;

--
-- Daten für Tabelle ur_right

INSERT INTO ur_right VALUES (1, 31, 10);
INSERT INTO ur_right VALUES (2, 31, 17);
INSERT INTO ur_right VALUES (3, 31, 16);
INSERT INTO ur_right VALUES (4, 31, 15);
INSERT INTO ur_right VALUES (5, 31, 14);
INSERT INTO ur_right VALUES (6, 31, 13);
INSERT INTO ur_right VALUES (7, 31, 12);
INSERT INTO ur_right VALUES (8, 31, 11);
INSERT INTO ur_right VALUES (103, NULL, 16);
INSERT INTO ur_right VALUES (106, NULL, 18);
INSERT INTO ur_right VALUES (102, 3, 15);
INSERT INTO ur_right VALUES (101, 19, 14);
INSERT INTO ur_right VALUES (100, 3, 13);
INSERT INTO ur_right VALUES (99, 3, 12);
INSERT INTO ur_right VALUES (98, 3, 11);
INSERT INTO ur_right VALUES (97, 3, 10);
INSERT INTO ur_right VALUES (104, 3, 17);
INSERT INTO ur_right VALUES (9, 31, 18);

---

--
-- Tabellenstruktur für Tabelle ur_rightdescriptor

CREATE TABLE ur_rightdescriptor (
id int(11) NOT NULL auto_increment,
bit_field smallint(6) default NULL,
l_word varchar(50) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

--
-- Daten für Tabelle ur_rightdescriptor

INSERT INTO ur_rightdescriptor VALUES (1, 1, 'browse');
INSERT INTO ur_rightdescriptor VALUES (2, 2, 'read');
INSERT INTO ur_rightdescriptor VALUES (3, 4, 'write');
INSERT INTO ur_rightdescriptor VALUES (4, 8, 'new');
INSERT INTO ur_rightdescriptor VALUES (5, 16, 'delete');

---

--
-- Tabellenstruktur für Tabelle ur_sql_user

CREATE TABLE ur_sql_user (
id int(11) NOT NULL auto_increment,
username varchar(255) collate latin1_general_ci default NULL,
password varchar(255) collate latin1_general_ci default NULL,
surname varchar(255) collate latin1_general_ci default NULL,
givenname varchar(255) collate latin1_general_ci default NULL,
email varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=21 ;

--
-- Daten für Tabelle ur_sql_user

INSERT INTO ur_sql_user VALUES (1, 'sysop', 'idoit', 'Operator', 'System', 'root@localhost');

---

--
-- Tabellenstruktur für Tabelle ur_usercache

CREATE TABLE ur_usercache (
id int(11) NOT NULL auto_increment,
interfaceid int(11) NOT NULL default '0',
userid int(11) NOT NULL default '0',
username varchar(255) collate latin1_general_ci NOT NULL default '',
password varchar(255) collate latin1_general_ci default NULL,
surname varchar(255) collate latin1_general_ci default NULL,
givenname varchar(255) collate latin1_general_ci default NULL,
email varchar(255) collate latin1_general_ci default NULL,
last_login_date datetime NOT NULL default '0000-00-00 00:00:00',
creation_date datetime NOT NULL default '0000-00-00 00:00:00',
creation_userid int(11) default NULL,
change_date datetime NOT NULL default '0000-00-00 00:00:00',
change_userid int(11) default NULL,
isactive tinyint(4) NOT NULL default '1',
isdeleted tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;

--
-- Daten für Tabelle ur_usercache

INSERT INTO ur_usercache VALUES (28, 1, 1, 'sysop', 'idoit', 'Operator', 'System', 'root@localhost', '2005-04-18 16:43:22', '2005-03-17 11:26:13', 1, '2005-03-17 11:26:13', 1, 1, 0);

---

--
-- Tabellenstruktur für Tabelle ur_usercachegroup

CREATE TABLE ur_usercachegroup (
usercacheid int(11) NOT NULL default '0',
groupid int(11) NOT NULL default '0',
PRIMARY KEY (usercacheid,groupid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Daten für Tabelle ur_usercachegroup

INSERT INTO ur_usercachegroup VALUES (1, 1);

[Guest]

Hi Folks!

Ein Kollege hat i-doit gerade installiert und der Fehler besteht immer noch.

Ursache ist das Fehlen der Tabelle "cdromserver" bzw. die Tatsache, dass dieses Fehlen nicht abgefangen wird. Wo die Tabelle hingekommen ist kann vielleicht jemand anderes beantworten, von mir gibt's nur folgenden Patch für modules/docman/inner_menu.inc.php:

Ersetze:
$howmany = db_num_rows(db_query("select ID from $tree_row2[0]"));

Durch:
// 20050916 enbiz GS - Fix
if ($tmp_res=db_query("select ID from $neu_row2[0]")) {
$howmany = db_num_rows($tmp_res);
} else $howmany="?";

HTH. Ansonsten macht das System schon einen ziemlich guten Eindruck!

CU,
Gerd

[cr]

was ist denn jetzt los mit dem fehler- den hab ich auch noch (unter debian mit xampp)

langsam aber sicher sollte das doch gefixt sein nicht ?

bitte um infos….