Album Smator

Roza · Bericht door **Roza** » 09 sep 2006, 15:22

Hallo allen

Ik snap er niks van.

Ik blijf deze foutmelding krijgen. Wat doe ik niet goed?

Failed to update Album configuration for ('max_pics', '1024');

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max_pics', '1024');'' at line 3

UPDATE comm_album_config SET config_value = '' WHERE config_name = '('max_pics', '1024');'

Line : 65
File : admin_album_config.php

Vriendelijke groet, Roza

Roza · Bericht door **Roza** » 09 sep 2006, 17:00

Anyone?

Heb album er weer opnieuw opgezet. Krijg weer hetzelfde!

Wat o wat zie ik over het hoofd of doe ik niet goed?

Queen_Butterfly · Bericht door **Queen_Butterfly** » 09 sep 2006, 17:02

Roza schreef:Anyone?

De mods kunnen niet haasten,

Heb je update uitgevoerd?

Roza · Bericht door **Roza** » 09 sep 2006, 17:07

Queen_Butterfly schreef:
Roza schreef:Anyone?

De mods kunnen niet haasten,

Heb je update uitgevoerd?

Nee mods kunnen niet haasten. Groot gelijk dat je me daar aan herinnert.

Ik werd er inderdaad beetje kriegelig van dat het niet lukt.

Ben al 2 dagen bezig met het album. Steeds eraf en er weer op zetten van de Album Mod. Solly ....

Je vraagt: "Heb je update uitgevoerd". Welke update?

Queen_Butterfly · Bericht door **Queen_Butterfly** » 09 sep 2006, 17:10

Welke mod is het eigenlijk precies, maar er zit geen update voor database bij?

Roza · Bericht door **Roza** » 09 sep 2006, 18:50

Hallo Queen

Het is:
Title: Photo Album
Author: Smartor
MOD Version: 2.0.54a

Nee er zit geen update voor database bij.

Roza

Raimon · Bericht door **Raimon** » 09 sep 2006, 18:55

Die zit er wel bij, meen dat ze in de files root staan (van de gezipte file), het bestand heet meen ik full_album_db_install.
Dat staat ook aangegegeven in de install.txt van jou MOD, maar die zit er zeker bij hoor :thumb:

Roza · Bericht door **Roza** » 09 sep 2006, 19:01

Hallo Raimon

Dit staat in install.text.

Code: Selecteer alles

## 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 :)
## MOD Version: 2.0.54a
## 
## Installation Level: Moderate
## Installation Time: 13 minutes
## Files To Edit: includes/constants.php
##                includes/page_header.php
##                viewonline.php
##                admin/index.php
##                templates/subSilver/overall_header.tpl
##                templates/subSilver/subSilver.cfg
##                includes/usercp_viewprofile.php
##                templates/subSilver/profile_view_body.tpl
##                language/lang_english/lang_main.php
## Included Files: phpbb_root/album.php
##                 phpbb_root/album_cat.php
##                 phpbb_root/album_comment.php
##                 phpbb_root/album_comment_edit.php
##                 phpbb_root/album_comment_delete.php
##                 phpbb_root/album_delete.php
##                 phpbb_root/album_edit.php
##                 phpbb_root/album_modcp.php
##                 phpbb_root/album_personal.php
##                 phpbb_root/album_personal_index.php
##                 phpbb_root/album_page.php
##                 phpbb_root/album_pic.php
##                 phpbb_root/album_rate.php
##                 phpbb_root/album_thumbnail.php
##                 phpbb_root/album_upload.php
##                 phpbb_root/admin/admin_album_auth.php
##                 phpbb_root/admin/admin_album_cat.php
##                 phpbb_root/admin/admin_clearcache.php
##                 phpbb_root/admin/admin_album_config.php
##                 phpbb_root/admin/admin_albim_personal.php
##                 phpbb_root/album_mod/album_common.php
##                 phpbb_root/album_mod/album_constants.php
##                 phpbb_root/album_mod/album_functions.php
##                 phpbb_root/language/lang_english/lang_admin_album.php
##                 phpbb_root/language/lang_english/lang_main_album.php
##                 phpbb_root/templates/subSilver/album_cat_body.tpl
##                 phpbb_root/templates/subSilver/album_comment_body.tpl
##                 phpbb_root/templates/subSilver/album_edit_body.tpl
##                 phpbb_root/templates/subSilver/album_index_body.tpl
##                 phpbb_root/templates/subSilver/album_modcp_body.tpl
##                 phpbb_root/templates/subSilver/album_move_body.tpl
##                 phpbb_root/templates/subSilver/album_page_body.tpl
##                 phpbb_root/templates/subSilver/album_personal_body.tpl
##                 phpbb_root/templates/subSilver/album_personal_index_body.tpl
##                 phpbb_root/templates/subSilver/album_rate_body.tpl
##                 phpbb_root/templates/subSilver/album_upload_body.tpl
##                 phpbb_root/templates/subSilver/admin/album_auth_body.tpl
##                 phpbb_root/templates/subSilver/admin/album_cat_body.tpl
##                 phpbb_root/templates/subSilver/admin/album_cat_delete_body.tpl
##                 phpbb_root/templates/subSilver/admin/album_cat_new_body.tpl
##                 phpbb_root/templates/subSilver/admin/album_cat_select_body.tpl
##                 phpbb_root/templates/subSilver/admin/album_config_body.tpl
##                 phpbb_root/templates/subSilver/admin/album_personal_body.tpl
##                 phpbb_root/templates/subSilver/images/icon_mini_album.gif
##                 phpbb_root/templates/subSilver/images/nothumbnail.jpg
##                 phpbb_root/templates/subSilver/images/lang_english/upload_pic.gif
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
## Generator: MOD Studio [ ModTemplateTools 1.0.2108.38030 ]

Zal ergens anders Smartor photo album downloaden. Kijken of het er dan bij zit!

...............................

Raimon · Bericht door **Raimon** » 09 sep 2006, 19:05

Hoi Roza,

Hmm dat is vreemd, probeer hem eens Hier te downloaden,

Zodra je dat hebt gedaan, pak je de MOD uit, en zoek je script, daar staat het volgende bestand: album_db_install.php, die zet je in jou root van je ftp.
Dus waar het bestand config.php bevindt, en vervolgens roep je dat bestand aan via jou webbrowser.
Dus zo : domeinnaam.nl/album_db_install.php

Succes ermee

Roza · Bericht door **Roza** » 09 sep 2006, 19:13

Dank je wel Raimon

Jaaa .. daar zit het mapje script bij. Met de album_db_install.php

:thumb:

Roza

Roza · Bericht door **Roza** » 12 sep 2006, 13:02

Beste allen

Het album op het forum (phpBB 2.0.21) werkt goed nu. Echter als ik nu in het ACP in de configuratie van het forum iets wil aanpassen krijg ik de volgende error.

Code: Selecteer alles

Failed to update general configuration for ('max_pics', '1024');

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max_pics', '1024');'' at line 3

UPDATE comm_config SET config_value = '' WHERE config_name = '('max_pics', '1024');'

Line : 69
File : admin_board.php

...............................................................

Dit was/is de database install die ik gebruikt heb voor het fotoalbum.

Code: Selecteer alles

<?php
/***************************************************************************
 *                               db_update.php
 *                            -------------------
 *
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey
 *   project              : http://sourceforge.net/projects/dbgenerator
 *   Website              : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "CREATE TABLE comm_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))";
$sql[] = "CREATE TABLE comm_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))";
$sql[] = "CREATE TABLE comm_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))";
$sql[] = "CREATE TABLE comm_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))";
$sql[] = "CREATE TABLE comm_album_config (
	config_name varchar(255) NOT NULL,
	config_value varchar(255) NOT NULL,
	PRIMARY KEY (config_name))";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('max_pics', '1024')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('user_pics_limit', '50')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('mod_pics_limit', '250')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('max_file_size', '128000')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('max_width', '800')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('max_height', '600')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('rows_per_page', '3')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('cols_per_page', '4')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('fullpic_popup', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('thumbnail_quality', '50')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('thumbnail_size', '125')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('thumbnail_cache', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('sort_method', 'pic_time')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('sort_order', 'DESC')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('jpg_allowed', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('png_allowed', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('gif_allowed', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('desc_length', '512')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('hotlink_prevent', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('hotlink_allowed', 'smartor.is-root.com')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('personal_gallery', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('personal_gallery_private', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('personal_gallery_limit', '10')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('personal_gallery_view', '-1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('rate', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('rate_scale', '10')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('comment', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('gd_version', '2')";
$sql[] = "INSERT INTO " . $table_prefix . "album_config VALUES ('album_version', '.0.54')";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		$error = $db->sql_error();

		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
	}
	else
	{
		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successful</b></font></li><br />';
	}
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';

echo '<tr><th>Installation Complete</th></tr><tr><td><span class="genmed">Please be sure to delete this file now.<br />If you require any further assistance, please visit the <a href="http://www.phpbbhacks.com/forums">phpBBHacks.com Support Forums</a>.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Go back to your index page</a>.</span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>

Ik denk toch dat het daar ergens in moet zitten. Want voor dat de Mod album_v2054 erop stond kreeg ik geen foutmeldingen in configuratie van het forum in het ACP.

Roza

Luuk · Bericht door **Luuk** » 12 sep 2006, 15:23

UPDATE comm_config SET config_value = '' WHERE config_name = '('max_pics', '1024');'

Je tabelnaam klopt niet helemaal, ik weet niet wat je aangepast hebt maar daar zou moeten staan

Code: Selecteer alles

UPDATE comm_album_config SET config_value = '' WHERE config_name = '('max_pics', '1024');'

Roza · Bericht door **Roza** » 12 sep 2006, 15:40

Dank je Luuk

Ik heb aangepast:

Code: Selecteer alles

$sql[] = "CREATE TABLE phpbb_album_config (

in:

Code: Selecteer alles

$sql[] = "CREATE TABLE comm_album_config (

In de database staat dus de tabel comm_album_config.

En de tabel van het forum comm_config.

Groet, Roza