"Галерия за PHPBB. Автор: Access" ПОМОЩ!!

Stifi

Registered
Ае помогнете ми бе :cry: :cry:...
Цял ден неможах да пусна тоя мод:x

SQL Error : 1146 Table 'mu_forum.album_config_table' doesn't exist

SELECT * FROM ALBUM_CONFIG_TABLE

http://web-tourist.net/login/login/view.php?st=684

Там е работата че само требе да си разпознае таблицата и базата данни ... а неще :x

// Table names
define('ALBUM_TABLE', $table_prefix.'album');
define('ALBUM_CAT_TABLE', $table_prefix.'album_cat');
define('ALBUM_CONFIG_TABLE', $table_prefix.'album_config');
define('ALBUM_COMMENT_TABLE', $table_prefix.'album_comment');
define('ALBUM_RATE_TABLE', $table_prefix.'album_rate');

ми показва само SQL Error : 1146 Table 'mu_forum.album_config_table' doesn't exis

+1 който каже как да го оправя
 
sql
Код:
 CREATE TABLE mu_forum_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 mu_forum_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 mu_forum_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 mu_forum_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 mu_forum_album_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name));

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

Така?
 
Код:
CREATE TABLE mu_forum.album_table (
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 mu_forum.album_rate_table (
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 mu_forum.album_comment_table (
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 mu_forum.album_cat_table (
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 mu_forum.album_config_table (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name));

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

Така стана :?:

Поне ми помогна и ще ти дам +1 :wink:
 
Имам още 1 проблем... моля ако знаеш помогни :cry:
Защо и от каде ми прави това.. В главната папка на форума...
ALBUM_CACHE_PATHb09eb380252a914f76d82ddf520c74be.jpg
ALBUM_UPLOAD_PATHb09eb380252a914f76d82ddf520c74be.jpg
не требе ли да е

Голяма-
/forum/album_mod/upload/
ALBUM_UPLOAD_PATHb09eb380252a914f76d82ddf520c74be.jpg

Малка-
/forum/album_mod/upload/cache/
ALBUM_CACHE_PATHb09eb380252a914f76d82ddf520c74be.jpg
 
http://4storing.com/mo2xi/ccf3f121c5bc5478344ed2edc5a097e7.html

Не знам дали работи, няма как да тествам :)
 
Код:
Warning: copy(/album_mod/upload/417bb23bbcc050544bdb9e176a177a47.jpg) [function.copy]: failed to open stream: No such file or directory in \forum\album_upload.php on line 490

Warning: getimagesize(/album_mod/upload/417bb23bbcc050544bdb9e176a177a47.jpg) [function.getimagesize]: failed to open stream: No such file or directory in \forum\album_upload.php on line 506

Warning: Cannot modify header information - headers already sent by (output started at D:\xampp\xampp\htdocs\forum\album_upload.php:490) in \forum\includes\page_header.php on line 690

Warning: Cannot modify header information - headers already sent by (output started at D:\xampp\xampp\htdocs\forum\album_upload.php:490) in \forum\includes\page_header.php on line 692

Warning: Cannot modify header information - headers already sent by (output started at D:\xampp\xampp\htdocs\forum\album_upload.php:490) in \forum\includes\page_header.php on line 693

Нестава.... :cry:

Ето грешките които ми дава в page_header.php
Код:
690-header ('Cache-Control: private, pre-check=0, post-check=0, max-age=0');
}
692-header ('Expires: 0');
693-header ('Pragma: no-cache');
 
devent каза:
http://4storing.com/0ih6t/351a7a5d0120f48635069fd335e8e3c7.html

Сега?

Качваги там но не ги показва... в forum/album.php които ако сикаш да ти дам скайп ... :roll:
 
devent каза:
http://4storing.com/mo4xi/d54781759d3c2467c5dd8aa98266d203.html

Сега ги показва но като дам да го оголеми ми дава "This pic does not exis"
forum/album_pic.php?pic_id=4
 
За да не търся и променям всеки един файл, ще ти кажа какво да направиш:
отваряш всеки файл в phpbb_root, от галерията и където имаш:
include($album_root_path . 'album_common.'.$phpEx);
под него слагаш:
include($album_root_path . 'album_constants.'.$phpEx);

Това е :?:
 

Back
Горе