Suche Bildergallerie mit Vote-System

[wwwthomasbauerattf]

was?

ich hab ja schon alles geändert und aufn server raufgeladen.

nur, jetzt kommt die fehlermeldung

was muss ich da ändern?

[Martin Truckenbrodt]

Hallo,
in der install.txt steht alles drinnen.

Hast die SQL Anweisungen durchgeführt?

Deutsche Sprachdateien findet man eigentlich immer im contrib Ordner.

XS = Extreme Styles

Gruß Martin

[wwwthomasbauerattf]

´normal erstellt der eh automatisch die datenbanken im sql, oder?

steht ja sogar inder installanweisuntg:

You can manually execute "SQL_full_album_pack_1_2_0.txt" instead of run this portion of code
Or you can execute "full_album_pack_db_install.php" from your browser when you're logged in with admin rights

Was muss ich jetzt machen um den fehler wegzukriegen:

Allgemeiner Fehler
Couldn't access list of Album Categories

DEBUG MODE

SQL Error : 1054 Unknown column 'c.cat_user_id' in 'where clause'

SELECT c.*, COUNT(p.pic_id) AS count, '' AS username FROM tb_album_cat AS c LEFT JOIN tb_album AS p ON c.cat_id = p.pic_cat_id WHERE cat_id <> 0 AND c.cat_user_id = 0 GROUP BY cat_id ORDER BY cat_order ASC

Line : 135
File : album_hierarchy_sql.php

[darkon]

Or you can execute "full_album_pack_db_install.php" from your browser when you're logged in with admin rights

Das mußt du machen. Er hat die Datenbank nicht angelegt

Lade die full_album_pack_db_install.php ins Rootverzeichnis, logge dich als Admin ein und rufe sie im Browser auf.

[wwwthomasbauerattf]

ok, probiers einmal

[wwwthomasbauerattf]

das is kommen: am anfang a paar error-meldung und dann immer successfull:



Updating the database
CREATE TABLE `tb_album` ( `pic_id` int(11) unsigned NOT NULL auto_increment, `pic_filename` varchar(255) NOT NULL default '', `pic_thumbnail` varchar(255) default NULL, `pic_title` varchar(255) NOT NULL default '', `pic_desc` text, `pic_user_id` mediumint(8) NOT NULL default '0', `pic_username` varchar(32) default NULL, `pic_user_ip` varchar(8) NOT NULL default '0', `pic_time` int(11) unsigned NOT NULL default '0', `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`) )
+++ Error: Table 'tb_album' already exists

CREATE TABLE `tb_album_cat` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(255) NOT NULL default '', `cat_desc` text, `cat_order` mediumint(8) NOT NULL default '0', `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) default NULL, `cat_upload_groups` varchar(255) default NULL, `cat_rate_groups` varchar(255) default NULL, `cat_comment_groups` varchar(255) default NULL, `cat_edit_groups` varchar(255) default NULL, `cat_delete_groups` varchar(255) default NULL, `cat_moderator_groups` varchar(255) default NULL, `cat_approval` tinyint(3) NOT NULL default '0', `cat_parent` mediumint(8) unsigned default '0', `cat_user_id` mediumint(8) unsigned default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) )
+++ Error: Table 'tb_album_cat' already exists

CREATE TABLE `tb_album_comment` ( `comment_id` int(11) unsigned NOT NULL auto_increment, `comment_pic_id` int(11) unsigned NOT NULL default '0', `comment_cat_id` int(11) NOT NULL default '0', `comment_user_id` mediumint(8) NOT NULL default '0', `comment_username` varchar(32) default NULL, `comment_user_ip` varchar(8) NOT NULL default '', `comment_time` int(11) unsigned NOT NULL default '0', `comment_text` text, `comment_edit_time` int(11) unsigned default '0' NULL, `comment_edit_count` smallint(5) unsigned NOT NULL default '0', `comment_edit_user_id` mediumint(8) default '0' NULL, 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`) )
+++ Error: Table 'tb_album_comment' already exists

CREATE TABLE `tb_album_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )
+++ Error: Table 'tb_album_config' already exists

CREATE TABLE `tb_album_rate` ( `rate_pic_id` int(11) unsigned NOT NULL default '0', `rate_user_id` mediumint(8) NOT NULL default '0', `rate_user_ip` char(8) NOT NULL default '', `rate_point` tinyint(3) unsigned NOT NULL default '0', `rate_hon_point` tinyint(3) NOT NULL default '0', 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`) )
+++ Error: Table 'tb_album_rate' already exists

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_pics', '1024')
+++ Error: Duplicate entry 'max_pics' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('user_pics_limit', '-1')
+++ Error: Duplicate entry 'user_pics_limit' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('mod_pics_limit', '-1')
+++ Error: Duplicate entry 'mod_pics_limit' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_file_size', '128000')
+++ Error: Duplicate entry 'max_file_size' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_width', '1024')
+++ Error: Duplicate entry 'max_width' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_height', '768')
+++ Error: Duplicate entry 'max_height' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('rows_per_page', '5')
+++ Error: Duplicate entry 'rows_per_page' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('cols_per_page', '4')
+++ Error: Duplicate entry 'cols_per_page' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('fullpic_popup', '0')
+++ Error: Duplicate entry 'fullpic_popup' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('thumbnail_quality', '75')
+++ Error: Duplicate entry 'thumbnail_quality' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('thumbnail_size', '125')
+++ Error: Duplicate entry 'thumbnail_size' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('thumbnail_cache', '1')
+++ Error: Duplicate entry 'thumbnail_cache' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('sort_method', 'pic_time')
+++ Error: Duplicate entry 'sort_method' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('sort_order', 'DESC')
+++ Error: Duplicate entry 'sort_order' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('jpg_allowed', '1')
+++ Error: Duplicate entry 'jpg_allowed' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('png_allowed', '1')
+++ Error: Duplicate entry 'png_allowed' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('gif_allowed', '1')
+++ Error: Duplicate entry 'gif_allowed' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('desc_length', '512')
+++ Error: Duplicate entry 'desc_length' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('hotlink_prevent', '0')
+++ Error: Duplicate entry 'hotlink_prevent' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('hotlink_allowed', 'mightygorgon.com')
+++ Error: Duplicate entry 'hotlink_allowed' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_gallery', '0')
+++ Error: Duplicate entry 'personal_gallery' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_gallery_private', '0')
+++ Error: Duplicate entry 'personal_gallery_private' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_gallery_limit', '-1')
+++ Error: Duplicate entry 'personal_gallery_limit' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_gallery_view', '-1')
+++ Error: Duplicate entry 'personal_gallery_view' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('rate', '1')
+++ Error: Duplicate entry 'rate' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('rate_scale', '10')
+++ Error: Duplicate entry 'rate_scale' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('comment', '1')
+++ Error: Duplicate entry 'comment' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('gd_version', '2')
+++ Error: Duplicate entry 'gd_version' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('album_version', '.0.53')
+++ Error: Duplicate entry 'album_version' for key 1

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('fap_version', '1.2.1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_thumb', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_total_pics', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_total_comments', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_comments', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_last_comment', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_last_pic', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_pics', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_recent_in_subcats', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_recent_instead_of_nopics', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('line_break_subcats', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_subcats', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_allow_gallery_mod', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_allow_sub_categories', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_sub_category_limit', '-1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_show_subcats_in_index', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_show_recent_in_subcats', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_show_recent_instead_of_nopics', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_personal_gallery_link', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('album_category_sorting', 'cat_order')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('album_category_sorting_direction', 'ASC')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('album_debug_mode', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_all_in_personal_gallery', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('new_pic_check_interval', '1M')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('index_enable_supercells', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('email_notification', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_download', '2')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_slideshow', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_pic_size_on_thumb', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('rate_type', '2')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('disp_late', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('disp_mostv', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('disp_high', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('disp_rand', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('img_rows', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('img_cols', '4')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('use_watermark', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('wut_users', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('disp_watermark_at', '3')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('hon_rate_times', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('hon_rate_sep', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('hon_rate_where', '')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('hon_rate_users', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('midthumb_use', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('midthumb_height', '600')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('midthumb_width', '800')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('midthumb_cache', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_files_to_upload', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_pregenerated_fields', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('dynamic_fields', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('pregenerate_fields', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('propercase_pic_title', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_index_last_pic_lv', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_pics_approval', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_img_no_gd', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('dynamic_pic_resampling', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_file_size_resampling', '1024000')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('switch_nuffload', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('path_to_bin', './cgi-bin/')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('perl_uploader', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_progress_bar', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('close_on_finish', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_pause', '5')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('simple_format', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('multiple_uploads', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('max_uploads', '5')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('zip_uploads', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('resize_pic', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('resize_width', '600')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('resize_height', '600')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('resize_quality', '70')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_pics_nav', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_inline_copyright', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('enable_nuffimage', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('enable_sepia_bw', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('personal_allow_avatar_gallery', '0')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('show_gif_mid_thumb', '1')
+++ Successfull

INSERT INTO `tb_album_config` ( `config_name` , `config_value` ) VALUES ('slideshow_script', '0')
+++ Successfull

[wwwthomasbauerattf]

und wenn ich wieder auf album.php gehe kommt wieder die gleiche fehlermeldung wie vorher

[Martin Truckenbrodt]

Hallo,
Dein Forum ist mit der table prefix tb_ installiert?

Gruß Martin

[wwwthomasbauerattf]

ah, kann das sein dass ich vorher die tabelle album im sql löschen muss. weil die hat bei mir schon vorher existiert, weil ich schon vorher eine andere gallery oben gehabt hab?

Glaub schon, oder?

[wwwthomasbauerattf]

ja; tb_ ist vor der bezeichnung immer