Album Mod Adminstraions Problem

w.white · Beitrag von **w.white** » 10.04.2007 14:51

Ich hab ein Problem mit dem kürzlich instaliertem Album Mod und zwar wenn ich im Admin Menü auf die Einzelnen Verwaltungspunkte geh kommt folgendes

Categories:

Could not query Album Categories information

DEBUG MODE

SQL Error : 1146 Table 'sevents.ALBUM_CAT_TABLE' doesn't exist

SELECT * FROM ALBUM_CAT_TABLE ORDER BY cat_order ASC

Line : 100
File : admin_album_cat.php

KOfiguration

Code: Alles auswählen

phpBB : Kritischer Fehler

Could not query Album config information

DEBUG MODE

SQL Error : 1146 Table 'sevents.ALBUM_CONFIG_TABLE' doesn't exist

SELECT * FROM ALBUM_CONFIG_TABLE

Line : 46
File : admin_album_config.php

Befugnisse:

Code: Alles auswählen

Could not get Category list

DEBUG MODE

SQL Error : 1146 Table 'sevents.ALBUM_CAT_TABLE' doesn't exist

SELECT cat_id, cat_title, cat_order FROM ALBUM_CAT_TABLE ORDER BY cat_order ASC

Line : 48
File : admin_album_auth.php

Personal Galleries

Code: Alles auswählen

Couldn't get Album info

DEBUG MODE

SQL Error : 1146 Table 'sevents.ALBUM_CONFIG_TABLE' doesn't exist

SELECT * FROM ALBUM_CONFIG_TABLE WHERE config_name = 'personal_gallery_private'

Line : 67
File : admin_album_personal.php

Das Album Funktioniert aber soweit ich sehen kann optimal nur kann ich es im Admin Menü nicht verwalten

Weiß jemand was das für ein Problem ist ? [/code]

Michael Zacher · Beitrag von **Michael Zacher** » 10.04.2007 14:57

Ja, da wurden einige Tabellen nicht angelegt.

w.white · Beitrag von **w.white** » 10.04.2007 15:18

Michael Zacher hat geschrieben:Ja, da wurden einige Tabellen nicht angelegt.

Hab aber den SQL Befehl der dastand ausgeführt und der wurde defenetiv auch ausgeführt

Michael Zacher · Beitrag von **Michael Zacher** » 10.04.2007 15:22

w.white hat geschrieben:Hab aber den SQL Befehl der dastand ausgeführt und der wurde defenetiv auch ausgeführt

Das kann defenitiv nicht so sein.
Denn wie man definitiv lesen kann, existieren dort einige Tabellen definitiv nicht.
Schau bitte mal via PHPMyAdmin Deine Datenbank an und sieh selber, dass hiesige Tabellen nicht existent sind.

w.white · Beitrag von **w.white** » 10.04.2007 15:31

Michael Zacher hat geschrieben:
w.white hat geschrieben:Hab aber den SQL Befehl der dastand ausgeführt und der wurde defenetiv auch ausgeführt
Das kann defenitiv nicht so sein.
Denn wie man definitiv lesen kann, existieren dort einige Tabellen definitiv nicht.
Schau bitte mal via PHPMyAdmin Deine Datenbank an und sieh selber, dass hiesige Tabellen nicht existent sind.

Ich hab via phpmyadmin schon längst nachgeschaut da ich des lesens ya auch mächtig bin ... sonst würde ich das ganze hier ya nicht posten, oder?

Michael Zacher · Beitrag von **Michael Zacher** » 10.04.2007 15:39

Dann machen wir das ganze nochmal anhand der Dokumentation:

SQL Error : 1146 Table 'xxx' doesn't exist

easygo · Beitrag von **easygo** » 10.04.2007 15:44

w.white hat geschrieben:Could not query Album Categories information

DEBUG MODE

SQL Error : 1146 Table 'sevents.ALBUM_CAT_TABLE' doesn't exist

SELECT * FROM ALBUM_CAT_TABLE ORDER BY cat_order ASC

Line : 100
File : admin_album_cat.php

Fehler deutet darauf hin, dass die Konstante nicht zugeordnet werden kann.

Überprüf mal den Teil der Install (MOD Version: 2.0.55a)

Code: Alles auswählen

#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
}
#
#-----[ AFTER, ADD ]------------------------------------------
#
# No worries, this file is very lite.
// Album MOD
include($phpbb_root_path . 'album_mod/album_constants.' . $phpEx);

w.white · Beitrag von **w.white** » 10.04.2007 16:09

easygo hat geschrieben:
w.white hat geschrieben:Could not query Album Categories information

DEBUG MODE

SQL Error : 1146 Table 'sevents.ALBUM_CAT_TABLE' doesn't exist

SELECT * FROM ALBUM_CAT_TABLE ORDER BY cat_order ASC

Line : 100
File : admin_album_cat.php
Fehler deutet darauf hin, dass die Konstante nicht zugeordnet werden kann.

Überprüf mal den Teil der Install (MOD Version: 2.0.55a)
Code: Alles auswählen
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
}
#
#-----[ AFTER, ADD ]------------------------------------------
#
# No worries, this file is very lite.
// Album MOD
include($phpbb_root_path . 'album_mod/album_constants.' . $phpEx);

Hab ich überprüft stimmt aber.

Dazu muss ich noch sagen das ich ein anderes Prefix hab welches concert_ lautet ... hab ich natürlich im SQL Befehl umgeschrieben hier der Befehel der auszuführen war:

Code: Alles auswählen

CREATE TABLE phpbb_album (
	pic_id int(11) UNSIGNED NOT NULL auto_increment,
	pic_filename varchar(255) NOT NULL,
	pic_thumbnail varchar(255),
	pic_title varchar(255) NOT NULL,
	pic_desc text,
	pic_user_id mediumint(8) NOT NULL,
	pic_username varchar(32),
	pic_user_ip char(8) NOT NULL DEFAULT '0',
	pic_time int(11) UNSIGNED NOT NULL,
	pic_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1',
	pic_view_count int(11) UNSIGNED NOT NULL DEFAULT '0',
	pic_lock tinyint(3) NOT NULL DEFAULT '0',
	pic_approval tinyint(3) NOT NULL DEFAULT '1',
	PRIMARY KEY (pic_id),
	KEY pic_cat_id (pic_cat_id),
	KEY pic_user_id (pic_user_id),
	KEY pic_time (pic_time));

CREATE TABLE phpbb_album_rate (
	rate_pic_id int(11) UNSIGNED NOT NULL,
	rate_user_id mediumint(8) NOT NULL,
	rate_user_ip char(8) NOT NULL,
	rate_point tinyint(3) UNSIGNED NOT NULL,
	KEY rate_pic_id (rate_pic_id),
	KEY rate_user_id (rate_user_id),
	KEY rate_user_ip (rate_user_ip),
	KEY rate_point (rate_point));

CREATE TABLE phpbb_album_comment (
	comment_id int(11) UNSIGNED NOT NULL auto_increment,
	comment_pic_id int(11) UNSIGNED NOT NULL,
	comment_user_id mediumint(8) NOT NULL,
	comment_username varchar(32),
	comment_user_ip char(8) NOT NULL,
	comment_time int(11) UNSIGNED NOT NULL,
	comment_text TEXT,
	comment_edit_time int(11) UNSIGNED,
	comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0',
	comment_edit_user_id mediumint(8),
	PRIMARY KEY(comment_id),
	KEY comment_pic_id (comment_pic_id),
	KEY comment_user_id (comment_user_id),
	KEY comment_user_ip (comment_user_ip),
	KEY comment_time (comment_time));

CREATE TABLE phpbb_album_cat (
	cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	cat_title varchar(255) NOT NULL,
	cat_desc text,
	cat_order mediumint(8) NOT NULL,
	cat_view_level tinyint(3) NOT NULL DEFAULT '-1',
	cat_upload_level tinyint(3) NOT NULL DEFAULT '0',
	cat_rate_level tinyint(3) NOT NULL DEFAULT '0',
	cat_comment_level tinyint(3) NOT NULL DEFAULT '0',
	cat_edit_level tinyint(3) NOT NULL DEFAULT '0',
	cat_delete_level tinyint(3) NOT NULL DEFAULT '2',
	cat_view_groups varchar(255),
	cat_upload_groups varchar(255),
	cat_rate_groups varchar(255),
	cat_comment_groups varchar(255),
	cat_edit_groups varchar(255),
	cat_delete_groups varchar(255),
	cat_moderator_groups varchar(255),
	cat_approval tinyint(3) NOT NULL DEFAULT '0',
	PRIMARY KEY (cat_id),
	KEY cat_order (cat_order));

CREATE TABLE phpbb_album_config (
	config_name varchar(255) NOT NULL,
	config_value varchar(255) NOT NULL,
	PRIMARY KEY (config_name));

INSERT INTO phpbb_album_config VALUES ('max_pics', '1024');
INSERT INTO phpbb_album_config VALUES ('user_pics_limit', '50');
INSERT INTO phpbb_album_config VALUES ('mod_pics_limit', '250');
INSERT INTO phpbb_album_config VALUES ('max_file_size', '128000');
INSERT INTO phpbb_album_config VALUES ('max_width', '800');
INSERT INTO phpbb_album_config VALUES ('max_height', '600');
INSERT INTO phpbb_album_config VALUES ('rows_per_page', '3');
INSERT INTO phpbb_album_config VALUES ('cols_per_page', '4');
INSERT INTO phpbb_album_config VALUES ('fullpic_popup', '1');
INSERT INTO phpbb_album_config VALUES ('thumbnail_quality', '50');
INSERT INTO phpbb_album_config VALUES ('thumbnail_size', '125');
INSERT INTO phpbb_album_config VALUES ('thumbnail_cache', '1');
INSERT INTO phpbb_album_config VALUES ('sort_method', 'pic_time');
INSERT INTO phpbb_album_config VALUES ('sort_order', 'DESC');
INSERT INTO phpbb_album_config VALUES ('jpg_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('png_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('gif_allowed', '0');
INSERT INTO phpbb_album_config VALUES ('desc_length', '512');
INSERT INTO phpbb_album_config VALUES ('hotlink_prevent', '0');
INSERT INTO phpbb_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com');
INSERT INTO phpbb_album_config VALUES ('personal_gallery', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_private', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_limit', '10');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_view', '-1');
INSERT INTO phpbb_album_config VALUES ('rate', '1');
INSERT INTO phpbb_album_config VALUES ('rate_scale', '10');
INSERT INTO phpbb_album_config VALUES ('comment', '1');
INSERT INTO phpbb_album_config VALUES ('gd_version', '2');
INSERT INTO phpbb_album_config VALUES ('album_version', '.0.55');

und hier der den ich ausgeführt habe:

Code: Alles auswählen

CREATE TABLE concert_album (
	pic_id int(11) UNSIGNED NOT NULL auto_increment,
	pic_filename varchar(255) NOT NULL,
	pic_thumbnail varchar(255),
	pic_title varchar(255) NOT NULL,
	pic_desc text,
	pic_user_id mediumint(8) NOT NULL,
	pic_username varchar(32),
	pic_user_ip char(8) NOT NULL DEFAULT '0',
	pic_time int(11) UNSIGNED NOT NULL,
	pic_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1',
	pic_view_count int(11) UNSIGNED NOT NULL DEFAULT '0',
	pic_lock tinyint(3) NOT NULL DEFAULT '0',
	pic_approval tinyint(3) NOT NULL DEFAULT '1',
	PRIMARY KEY (pic_id),
	KEY pic_cat_id (pic_cat_id),
	KEY pic_user_id (pic_user_id),
	KEY pic_time (pic_time));

CREATE TABLE concert_album_rate (
	rate_pic_id int(11) UNSIGNED NOT NULL,
	rate_user_id mediumint(8) NOT NULL,
	rate_user_ip char(8) NOT NULL,
	rate_point tinyint(3) UNSIGNED NOT NULL,
	KEY rate_pic_id (rate_pic_id),
	KEY rate_user_id (rate_user_id),
	KEY rate_user_ip (rate_user_ip),
	KEY rate_point (rate_point));

CREATE TABLE concert_album_comment (
	comment_id int(11) UNSIGNED NOT NULL auto_increment,
	comment_pic_id int(11) UNSIGNED NOT NULL,
	comment_user_id mediumint(8) NOT NULL,
	comment_username varchar(32),
	comment_user_ip char(8) NOT NULL,
	comment_time int(11) UNSIGNED NOT NULL,
	comment_text TEXT,
	comment_edit_time int(11) UNSIGNED,
	comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0',
	comment_edit_user_id mediumint(8),
	PRIMARY KEY(comment_id),
	KEY comment_pic_id (comment_pic_id),
	KEY comment_user_id (comment_user_id),
	KEY comment_user_ip (comment_user_ip),
	KEY comment_time (comment_time));

CREATE TABLE concert_album_cat (
	cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	cat_title varchar(255) NOT NULL,
	cat_desc text,
	cat_order mediumint(8) NOT NULL,
	cat_view_level tinyint(3) NOT NULL DEFAULT '-1',
	cat_upload_level tinyint(3) NOT NULL DEFAULT '0',
	cat_rate_level tinyint(3) NOT NULL DEFAULT '0',
	cat_comment_level tinyint(3) NOT NULL DEFAULT '0',
	cat_edit_level tinyint(3) NOT NULL DEFAULT '0',
	cat_delete_level tinyint(3) NOT NULL DEFAULT '2',
	cat_view_groups varchar(255),
	cat_upload_groups varchar(255),
	cat_rate_groups varchar(255),
	cat_comment_groups varchar(255),
	cat_edit_groups varchar(255),
	cat_delete_groups varchar(255),
	cat_moderator_groups varchar(255),
	cat_approval tinyint(3) NOT NULL DEFAULT '0',
	PRIMARY KEY (cat_id),
	KEY cat_order (cat_order));

CREATE TABLE concert_album_config (
	config_name varchar(255) NOT NULL,
	config_value varchar(255) NOT NULL,
	PRIMARY KEY (config_name));

INSERT INTO concert_album_config VALUES ('max_pics', '1024');
INSERT INTO concert_album_config VALUES ('user_pics_limit', '50');
INSERT INTO concert_album_config VALUES ('mod_pics_limit', '250');
INSERT INTO concert_album_config VALUES ('max_file_size', '128000');
INSERT INTO concert_album_config VALUES ('max_width', '800');
INSERT INTO concert_album_config VALUES ('max_height', '600');
INSERT INTO concert_album_config VALUES ('rows_per_page', '3');
INSERT INTO concert_album_config VALUES ('cols_per_page', '4');
INSERT INTO concert_album_config VALUES ('fullpic_popup', '1');
INSERT INTO concert_album_config VALUES ('thumbnail_quality', '50');
INSERT INTO concert_album_config VALUES ('thumbnail_size', '125');
INSERT INTO concert_album_config VALUES ('thumbnail_cache', '1');
INSERT INTO concert_album_config VALUES ('sort_method', 'pic_time');
INSERT INTO concert_album_config VALUES ('sort_order', 'DESC');
INSERT INTO concert_album_config VALUES ('jpg_allowed', '1');
INSERT INTO concert_album_config VALUES ('png_allowed', '1');
INSERT INTO concert_album_config VALUES ('gif_allowed', '0');
INSERT INTO concert_album_config VALUES ('desc_length', '512');
INSERT INTO concert_album_config VALUES ('hotlink_prevent', '0');
INSERT INTO concert_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com');
INSERT INTO concert_album_config VALUES ('personal_gallery', '0');
INSERT INTO concert_album_config VALUES ('personal_gallery_private', '0');
INSERT INTO concert_album_config VALUES ('personal_gallery_limit', '10');
INSERT INTO concert_album_config VALUES ('personal_gallery_view', '-1');
INSERT INTO concert_album_config VALUES ('rate', '1');
INSERT INTO concert_album_config VALUES ('rate_scale', '10');
INSERT INTO concert_album_config VALUES ('comment', '1');
INSERT INTO concert_album_config VALUES ('gd_version', '2');
INSERT INTO concert_album_config VALUES ('album_version', '.0.55');

[/code]

easygo · Beitrag von **easygo** » 10.04.2007 16:20

w.white hat geschrieben:Hab ich überprüft stimmt aber.

Dann würde der SQL Error Datenbankname, Präfix und Tabellenname enthalten. easy

w.white · Beitrag von **w.white** » 10.04.2007 19:57

Keine ne Ahnung ? evtl. is ya was am SQL Befehl falsch den ich gepostet hab ?!

phpBB.de

Album Mod Adminstraions Problem

Album Mod Adminstraions Problem

Re: Album Mod Adminstraions Problem

Re: Album Mod Adminstraions Problem

Re: Album Mod Adminstraions Problem