Photo Album v2

Junior-BS · Beitrag von **Junior-BS** » 12.06.2005 22:23

Hallo!

Habe soeben versucht den Mod Photo Album v2 zu integrieren. Soweit lief alles perfekt - dachte ich. Im Admin-Menü erhalte ich beim Klick auf eines der Auswahlmenüs für das Album jedoch Fehlermeldungen.

Beim Klick auf "Categories" z.B.

Code: Alles auswählen

Template->make_filename(): Error - file admin/album_cat_body.tpl does not exist

Könnte es sein, dass es mit folgendem Befehl lt. Anleitung zusammenhängt, den ich wegen Unwissenheit nicht ausgeführt habe?

Code: Alles auswählen

#-----[ ACTION ]--------------------------------------
# Require for Unix-like host (you can use your FTP client to do this)
#
# CHMOD 777 album_mod/upload
# CHMOD 777 album_mod/upload/cache

Was sagt mir das? Was muss ich machen???

Vielen Dank für eure Hilfe!!!

Beitrag von **Markus67** » 12.06.2005 22:57

Hi ...

lade mal die Datei hier hoch ... die fehlt

Error - file admin/album_cat_body.tpl does not exist

Markus

Junior-BS · Beitrag von **Junior-BS** » 13.06.2005 20:48

Hallo!

Vielen Dank für den Tip. Habe ich so ausgeführt.

Anschließend habe ich die Installation neu durchgeführt. Das Protokoll schaut so aus:

Code: Alles auswählen

Running :: CREATE TABLE CT24album ( 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)) -> FAILED ---> Table 'CT24album' already exists

Running :: CREATE TABLE CT24album_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)) -> FAILED ---> Table 'CT24album_rate' already exists

Running :: CREATE TABLE CT24album_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)) -> FAILED ---> Table 'CT24album_comment' already exists

Running :: CREATE TABLE CT24album_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)) -> FAILED ---> Table 'CT24album_cat' already exists

Running :: CREATE TABLE CT24album_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name)) -> FAILED ---> Table 'CT24album_config' already exists

Running :: INSERT INTO CT24album_config VALUES ('max_pics', '1024') -> FAILED ---> Duplicate entry 'max_pics' for key 1

Running :: INSERT INTO CT24album_config VALUES ('user_pics_limit', '50') -> FAILED ---> Duplicate entry 'user_pics_limit' for key 1

Running :: INSERT INTO CT24album_config VALUES ('mod_pics_limit', '250') -> FAILED ---> Duplicate entry 'mod_pics_limit' for key 1

Running :: INSERT INTO CT24album_config VALUES ('max_file_size', '128000') -> FAILED ---> Duplicate entry 'max_file_size' for key 1

Running :: INSERT INTO CT24album_config VALUES ('max_width', '800') -> FAILED ---> Duplicate entry 'max_width' for key 1

Running :: INSERT INTO CT24album_config VALUES ('max_height', '600') -> FAILED ---> Duplicate entry 'max_height' for key 1

Running :: INSERT INTO CT24album_config VALUES ('rows_per_page', '3') -> FAILED ---> Duplicate entry 'rows_per_page' for key 1

Running :: INSERT INTO CT24album_config VALUES ('cols_per_page', '4') -> FAILED ---> Duplicate entry 'cols_per_page' for key 1

Running :: INSERT INTO CT24album_config VALUES ('fullpic_popup', '1') -> FAILED ---> Duplicate entry 'fullpic_popup' for key 1

Running :: INSERT INTO CT24album_config VALUES ('thumbnail_quality', '50') -> FAILED ---> Duplicate entry 'thumbnail_quality' for key 1

Running :: INSERT INTO CT24album_config VALUES ('thumbnail_size', '125') -> FAILED ---> Duplicate entry 'thumbnail_size' for key 1

Running :: INSERT INTO CT24album_config VALUES ('thumbnail_cache', '1') -> FAILED ---> Duplicate entry 'thumbnail_cache' for key 1

Running :: INSERT INTO CT24album_config VALUES ('sort_method', 'pic_time') -> FAILED ---> Duplicate entry 'sort_method' for key 1

Running :: INSERT INTO CT24album_config VALUES ('sort_order', 'DESC') -> FAILED ---> Duplicate entry 'sort_order' for key 1

Running :: INSERT INTO CT24album_config VALUES ('jpg_allowed', '1') -> FAILED ---> Duplicate entry 'jpg_allowed' for key 1

Running :: INSERT INTO CT24album_config VALUES ('png_allowed', '1') -> FAILED ---> Duplicate entry 'png_allowed' for key 1

Running :: INSERT INTO CT24album_config VALUES ('gif_allowed', '0') -> FAILED ---> Duplicate entry 'gif_allowed' for key 1

Running :: INSERT INTO CT24album_config VALUES ('desc_length', '512') -> FAILED ---> Duplicate entry 'desc_length' for key 1

Running :: INSERT INTO CT24album_config VALUES ('hotlink_prevent', '0') -> FAILED ---> Duplicate entry 'hotlink_prevent' for key 1

Running :: INSERT INTO CT24album_config VALUES ('hotlink_allowed', 'smartor.is-root.com') -> FAILED ---> Duplicate entry 'hotlink_allowed' for key 1

Running :: INSERT INTO CT24album_config VALUES ('personal_gallery', '0') -> FAILED ---> Duplicate entry 'personal_gallery' for key 1

Running :: INSERT INTO CT24album_config VALUES ('personal_gallery_private', '0') -> FAILED ---> Duplicate entry 'personal_gallery_private' for key 1

Running :: INSERT INTO CT24album_config VALUES ('personal_gallery_limit', '10') -> FAILED ---> Duplicate entry 'personal_gallery_limit' for key 1

Running :: INSERT INTO CT24album_config VALUES ('personal_gallery_view', '-1') -> FAILED ---> Duplicate entry 'personal_gallery_view' for key 1

Running :: INSERT INTO CT24album_config VALUES ('rate', '1') -> FAILED ---> Duplicate entry 'rate' for key 1

Running :: INSERT INTO CT24album_config VALUES ('rate_scale', '10') -> FAILED ---> Duplicate entry 'rate_scale' for key 1

Running :: INSERT INTO CT24album_config VALUES ('comment', '1') -> FAILED ---> Duplicate entry 'comment' for key 1

Running :: INSERT INTO CT24album_config VALUES ('gd_version', '1') -> FAILED ---> Duplicate entry 'gd_version' for key 1

Running :: INSERT INTO CT24album_config VALUES ('album_version', '.0.53') -> FAILED ---> Duplicate entry 'album_version' for key 1


COMPLETE!

Some queries failed. Please contact me at http://smartor.is-root.com we may solve your problems...
To Undo the changes to your database please execute album_db_uninstall.php.

NOW DELETE THIS FILE

Die Installationsanleitung schaut wie folgt aus:

Code: Alles auswählen

##############################################################
## MOD Title: Photo Album v2 for phpBB2
## MOD Author: Smartor < smartor_xp@hotmail.com > (Hoang Ngoc Tu) http://smartor.is-root.com
## MOD Description:
##	This is a phpBB-based photo album/gallery management system.
##	It is really powerful, stable, efficient, rich features and highly customizable.
##	The version 2 was written from the scratch for more security, performance, etc.
##	It is not really a MOD/hack, it is rather a phpBB-based system :)
##
##	Features:
##		- Fully integrated with phpBB2 backend (DB, session, template, multi languages, etc.)
##		- Powerful and handy AdminCP
##		- Auto-generated thumbnail (require GD)
##		- Manual-uploaded thumbnail (for someone cannot install GD)
##		- Thumbnail cache (for better performance)
##		- Multi-categories
##		- Powerfull and phpBB-like permissions system
##		- ModeratorCP
##		- Upload Quota
##		- Pic Description
##		- Recent pics
##		- Personal galleries (for member-oriented boards)
##		- Rate system
##		- Comment system
##		- Hotlink prevention (can set allowed domains)
##		- Auto optimization for different GD versions
##		- Pic view counter
##		- Admin/Moderator pic approval
##		- Probably uploadable in PHP Safe Mode
##		- The rest is for your exploring ;)
##
##	Requirements:
##		A running phpBB 2.0.x (of course - recommend the lastest version)
##		GD 1.8.x - 2.0 or higher (require for auto-thumbnail - more detail at http://www.boutell.com/gd)
##		HTTP File Upload Enabled (this MOD can work with PHP Safe-Mode in some cases)
##		MySQL 3.23.x
##		A basic ability to follow my instructions (read this file carefully by letter and follow step-by-step)
##
##	Tested with:	phpBB 2.0.4 - PHP4 (I recommend the up-to-date version) - MySQL 3.23.x
##
## MOD Version: 2.0.53
##
## Installation Level: medium
## Installation Time: 15 minutes
##
## Files To Edit: 9
##	viewonline.php
##	admin/index.php
##	includes/constants.php
##	includes/page_header.php
##	includes/usercp_viewprofile.php
##	language/lang_english/lang_main.php
##	templates/subSilver/profile_view_body.tpl
##	templates/subSilver/overall_header.tpl
##	templates/subSilver/subSilver.cfg
##
## Included Files: 56
##	album.php
##	album_cat.php
##	album_comment.php
##	album_comment_edit.php
##	album_comment_delete.php
##	album_delete.php
##	album_edit.php
##	album_modcp.php
##	album_personal.php
##	album_personal_index.php
##	album_page.php
##	album_pic.php
##	album_rate.php
##	album_thumbnail.php
##	album_upload.php
##	admin/admin_album_auth.php
##	admin/admin_album_cat.php
##	admin/admin_clearcache.php
##	admin/admin_album_config.php
##	admin/admin_albim_personal.php
##	album_mod/album_common.php
##	album_mod/album_constants.php
##	album_mod/album_functions.php
##	language/lang_english/lang_admin_album.php
##	language/lang_english/lang_main_album.php
##	templates/subSilver/album_cat_body.tpl
##	templates/subSilver/album_comment_body.tpl
##	templates/subSilver/album_edit_body.tpl
##	templates/subSilver/album_index_body.tpl
##	templates/subSilver/album_modcp_body.tpl
##	templates/subSilver/album_move_body.tpl
##	templates/subSilver/album_page_body.tpl
##	templates/subSilver/album_personal_body.tpl
##	templates/subSilver/album_personal_index_body.tpl
##	templates/subSilver/album_rate_body.tpl
##	templates/subSilver/album_upload_body.tpl
##	templates/subSilver/admin/album_auth_body.tpl
##	templates/subSilver/admin/album_cat_body.tpl
##	templates/subSilver/admin/album_cat_delete_body.tpl
##	templates/subSilver/admin/album_cat_new_body.tpl
##	templates/subSilver/admin/album_cat_select_body.tpl
##	templates/subSilver/admin/album_config_body.tpl
##	templates/subSilver/admin/album_personal_body.tpl
##	templates/subSilver/images/icon_mini_album.gif
##	templates/subSilver/images/nothumbnail.jpg
##	templates/subSilver/images/lang_english/upload_pic.gif
##
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/
##############################################################
## Author Notes:
##
##	Special thanks to all my testers, translators and users :)
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################


# NOTE: (for upgrade from older versions)
#
# If you are using a version 1.5.x/1.6.x of Album you must read file update_v1_to_lastest.txt
#
# If you are using Album v1.0.x or older, sorry I have no guide to upgrade
#
# If you are using a older version of Album v2 you must read appropriate files in "update" directory


#
#-----[ OPEN ]-------------------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]----------------------------------------
#
if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
}


#
#-----[ AFTER, ADD ]----------------------------------
# Don't worried! This file is very *lite*
// Album MOD
include($phpbb_root_path . 'album_mod/album_constants.' . $phpEx);


#
#-----[ OPEN ]-------------------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]----------------------------------------
#
	'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),

#
#-----[ AFTER, ADD ]----------------------------------
#
	// Album MOD
	'L_ALBUM' => $lang['Album'],
	'U_ALBUM' => append_sid('album.'.$phpEx),


#
#-----[ OPEN ]-------------------------------------------------------
#
viewonline.php

#
#-----[ FIND ]----------------------------------------
#
				case PAGE_FAQ:
					$location = $lang['Viewing_FAQ'];
					$location_url = "faq.$phpEx";
					break;

#
#-----[ AFTER, ADD ]----------------------------------
#
				case PAGE_ALBUM:
					$location = $lang['Album'];
					$location_url = "album.$phpEx";
					break;


#
#-----[ OPEN ]-------------------------------------------------------
#
admin/index.php

#
#-----[ FIND ]----------------------------------------
#
						case PAGE_FAQ:
							$location = $lang['Viewing_FAQ'];
							$location_url = "index.$phpEx?pane=right";
							break;

#
#-----[ AFTER, ADD ]----------------------------------
#
						case PAGE_ALBUM:
							$location = $lang['Album'];
							$location_url = "index.$phpEx?pane=right";
							break;


#
#-----[ OPEN ]-------------------------------------------------------
# also for other templates
templates/subSilver/overall_header.tpl

#
#-----[ FIND ]----------------------------------------
#
<td align="center" width="100%" valign="middle"><span class="maintitle">{SITENAME}</span><br /><span class="gen">{SITE_DESCRIPTION}<br />&nbsp; </span>
				<table cellspacing="0" cellpadding="2" border="0">
					<tr>
						<td align="center" valign="top" nowrap="nowrap"><span class="mainmenu">

#
#-----[ AFTER, ADD ]----------------------------------
# this step will add a link into your header menu

<a href="{U_ALBUM}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_album.gif" width="12" height="13" border="0" alt="{L_ALBUM}" hspace="3" />{L_ALBUM}</a>&nbsp;



#
#-----[ OPEN ]-------------------------------------------------------
# also for other templates
templates/subSilver/subSilver.cfg

#
#-----[ FIND ]----------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]---------------------------------
#
// Album MOD
$images['upload_pic'] = "$current_template_images/{LANG}/upload_pic.gif";
$images['no_thumbnail'] = "$current_template_images/nothumbnail.jpg";


#
#-----[ OPEN ]-------------------------------------------------------
#
includes/usercp_viewprofile.php

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

#
#-----[ AFTER, ADD ]----------------------------------
#
	// Photo Album Addon v2.x.x by Smartor
	'U_PERSONAL_GALLERY' => append_sid("album_personal.$phpEx?user_id=" . $profiledata['user_id']),
	'L_PERSONAL_GALLERY' => sprintf($lang['Personal_Gallery_Of_User'], $profiledata['username']),


#
#-----[ OPEN ]-------------------------------------------------------
# also for all other templates
templates/subSilver/profile_view_body.tpl

#
#-----[ FIND ]----------------------------------------
#
<a href="{U_SEARCH_USER}" class="genmed">{L_SEARCH_USER_POSTS}</a>

#
#-----[ IN-LINE AFTER, ADD ]--------------------------
#
<br /><a href="{U_PERSONAL_GALLERY}" class="genmed">{L_PERSONAL_GALLERY}</a>


#
#-----[ OPEN ]-------------------------------------------------------
# also for all other language packs
language/lang_english/lang_main.php

#
#-----[ FIND ]----------------------------------------
#
//
// Errors (not related to a
// specific failure on a page)
//
$lang['Information'] = 'Information';
$lang['Critical_Information'] = 'Critical Information';

#
#-----[ BEFORE, ADD ]---------------------------------
#
//
// Photo Album Addon v2.x.x by Smartor
//
$lang['Album'] = 'Album';
$lang['Personal_Gallery_Of_User'] = 'Personal Gallery of %s';


#
#-----[ COPY ]-------------------------------------------------------
# These following instructions mean...
# Upload all files in directory "phpbb_root" with their structure to your phpBB root directory
#
# Remember to upload all the language files and template files to all your
# language packs and template directories
#
# If you use FTP please remember to use ASCII mode for text files (*.php, *.tpl)
# and BINARY mode for image files (*.jpg, *.gif)
# Fortunately good FTP clients today can auto-detect the mode for your files

copy phpbb_root/*.php to *.php
copy phpbb_root/admin/*.php to admin/
copy phpbb_root/album_mod/*.* to album_mod/
copy phpbb_root/language/lang_english/*.php to language/lang_english/
copy phpbb_root/templates/subSilver/*.* to templates/subSilver/
copy phpbb_root/templates/subSilver/admin/*.* to templates/subSilver/admin/
copy phpbb_root/templates/subSilver/images/*.* to templates/subSilver/images/
copy phpbb_root/templates/subSilver/images/lang_english/*.* to templates/subSilver/images/lang_english/


#
#-----[ ACTION ]--------------------------------------
# Create folder: album_mod/upload
# Create folder: album_mod/upload/cache


#
[color=red]#-----[ ACTION ]--------------------------------------
# Require for Unix-like host (you can use your FTP client to do this)
#
# CHMOD 777 album_mod/upload
# CHMOD 777 album_mod/upload/cache[/color]

#
#-----[ SQL ]--------------------------------------------------------
# For FRESH Install Only!!! If you *upgrade* from Album v1.x.x you
# must *skip* this step to go to the *next* step!
#
# [color=red]This Photo Album must add 5 tables into your database.
# Fortunately it will not alter any existed tables :)[/color]#
# Upload album_db_install.php and album_mysql.sql to your phpBB root
# directory then run album_db_install.php by typing on the browser
# After that, delete both files immediately
#
# If you do not want to run album_db_install.php you can run the SQL
# queries manually in album_mysql.sql
#
##########

Die roten Passagen habe ich nicht ausgeführt, da ich nicht weiß was gemeint ist

Wäre sehr nett, wenn mir jemand sagen und erklären würde, was ich zu tun habe...

Vielen dank vom hilflosen
Junior-BS

Junior-BS · Beitrag von **Junior-BS** » 13.06.2005 20:50

Nachtrag:

Rote Passagen gibt es nicht

Also folgende meinte ich:

#-----[ ACTION ]--------------------------------------
# Require for Unix-like host (you can use your FTP client to do this)
#
# CHMOD 777 album_mod/upload
# CHMOD 777 album_mod/upload/cache

und

# This Photo Album must add 5 tables into your database.
# Fortunately it will not alter any existed tables

Milan Baroš · Beitrag von **Milan Baroš** » 13.06.2005 21:14

Hi,

du brauchst die Installation jetzt nicht nocheinmal durchzuführen.
Es müsste jetzt klappen, probiers mal aus.

Gruß

Beitrag von **Markus67** » 13.06.2005 23:02

Hi ...

die beiden Verzeichnisse (die hast du mit dem MOD auf den Webspace hochgeladen) brauchen die entsprechenden Rechte ...

Code: Alles auswählen

# CHMOD 777 album_mod/upload 
# CHMOD 777 album_mod/upload/cache

KB:chmod

Markus

Junior-BS · Beitrag von **Junior-BS** » 25.06.2005 22:00

Hallo!

Leider etwas verspätet, aber ich habe so ziemlich alles ausprobiert. Es kappt nicht. Werde das Gefühl nicht los, dass irgendwas falsch installiert wurde von mir. Nunja... Trotzdem vielen herzlichen Dank für eure Hilfestellungen!!! Werde mir wohl etwas anderes einfallen lassen und es später noch mal von Anfang an probieren.

Hat jemand von euch eventuell eine Idee, was es bedeutte, wenn ich Tabellen erstellen soll??? Das wird in der Anleitung soweit ich das verstanden habe auch gefordert?!

Nach wie vor ratlose Grüße
Junior-BS