Photo Album v2.0.53

[SpiderZLS]

ist der nu EM kompatibel mit dem phpbb 2.0.19 oder nicht ???

[SpiderZLS]

Please Help

[Gulaschk@none]

also bei mir gings

[SpiderZLS]

habe es gerade probier und bekomme

Code: Alles auswählen

Critical Error

FIND FAILED: In file [includes/usercp_viewprofile.php] could not find:

'U_SEARCH_USER' => append_sid("search.$phpEx?search_author=" . urlencode($profiledata['username'])), 

MOD script line #257 :: FAQ :: Report

[SemiX]

Japp, weil zwischen Veröffentlichung des Album Mods 2.0.53 und phpBB 2.0.19 mittlerweile 1,5Jahre liegen. phpBB wurde immer weiterentwickelt, der Mod nicht. Und unter diesen Umständen kann es passieren, dass solche EM-Versuche scheitern. Dir bleibt also keine andere Wahl als den MOD manuell einzubauen oder die Install-Anleitung dem geänderten phpBB anzupassen...

[SpiderZLS]

habe glaube ich den Fehler gefunden muss mal testen.

[Gulaschk@none]

bei mir ging das ohne umgeschreibe habe auch die 2.0.19

[SpiderZLS]

Ich bekomme im ACP folgendes Angezeigt

Code: Alles auswählen

Allgemeiner Fehler 
Could not query Album Categories information

DEBUG MODE

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

SELECT * FROM ALBUM_CAT_TABLE ORDER BY cat_order ASC

Line : 100
File : admin_album_cat.php 

 

ich habe aus dem Script Verzeichniss schon die.sql Datei via PhpMyAdmin integriert leider ohne erfolg !

[Gulaschk@none]

welche von den dateien fürst du aus ?

album_db_install
album_db_uninstall
album_update_v1_to_v2
album_quote_fix
album_update
album_mysql.txt

bei mir liegen diese 6 dateien im script ordner

ich kopier die album_mysql.txt im mein root ordner

und dann führe ich die album_db_install aus und alles hat gefunzt bei mir

[SpiderZLS]

also ich rufe die album_db_install.php aus dem root auf dann kommt

Code: Alles auswählen

Installing Photo Album Addon for phpBB2 
 

Running :: 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)) -> COMPLETED

Running :: 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)) -> COMPLETED

Running :: 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)) -> COMPLETED

Running :: 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)) -> COMPLETED

Running :: CREATE TABLE phpbb_album_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name)) -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('max_pics', '1024') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('user_pics_limit', '50') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('mod_pics_limit', '250') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('max_file_size', '128000') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('max_width', '800') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('max_height', '600') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('rows_per_page', '3') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('cols_per_page', '4') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('fullpic_popup', '1') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('thumbnail_quality', '50') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('thumbnail_size', '125') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('thumbnail_cache', '1') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('sort_method', 'pic_time') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('sort_order', 'DESC') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('jpg_allowed', '1') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('png_allowed', '1') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('gif_allowed', '0') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('desc_length', '512') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('hotlink_prevent', '0') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('personal_gallery', '0') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('personal_gallery_private', '0') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('personal_gallery_limit', '10') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('personal_gallery_view', '-1') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('rate', '1') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('rate_scale', '10') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('comment', '1') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('gd_version', '1') -> COMPLETED

Running :: INSERT INTO phpbb_album_config VALUES ('album_version', '.0.53') -> COMPLETED


COMPLETE!

Photo Album Tables generated successfully. To Undo the changes to your database please execute album_db_uninstall.php

NOW DELETE THIS FILE

wenn ich jetzt in das ACP gehe und dort auf z.b.
Categories klicke kommt

Code: Alles auswählen

Allgemeiner Fehler 
Could not query Album Categories information

DEBUG MODE

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

SELECT * FROM ALBUM_CAT_TABLE ORDER BY cat_order ASC

Line : 100
File : admin_album_cat.php 

Ich peil das nicht !!
Warum versucht der auch auf eine Tabelle mit dem Namen ALBUM_CAT_TABLE zuzugreifen die wird doch garnicht erzeugt !!
ich habe mir mal die album_mysql.sql angesehen da steht nix von dieser ALBUM_CAT_TABLE drinn... ich kapier es nicht !
Es werden bei mir folgende Tabellen erzeugt

phpbb_album
phpbb_album_cat
phpbb_album_comment
phpbb_album_config
phpbb_album_rate