[Solved]Smartor Photo Album 2.0.53 -> IM141 Problems

[ScottDaMan]

Your phpBB Version: 2.0.22
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: [url]http://[/url]

PHP Version:
MySQL Version:


What was done before the problem appeared?
Searched. Couldn't find anything releated to this. Perhaps I'm not using the right keywords here.


What was done to try to solve the problem?
Not sure where to start.



De.scription and Message

I did a test upgrade from PHPBB 2.0.17 to IM141.

My 2.0.17 install had Photo Album 2.0.53 installed. After the upgrade to this new forum, I am getting errors when I attempt to view the forum.

[code]  Couldn't access list of Album Categories  DEBUG MODE  SQL Error ]

I know IM141 uses Smartor's photo album but it also has been upgraded since 2.0.53 to 2.0.55a. 2.0.54 came with a PHP file to run to upgrade from 53 to 54 but when I attempt to run it, it says it cannot find the database.

So, is there any suggestions? I'd hate to restart the album. Lots of photos in there.

[Teelk]

IntegraMOD uses Full Album Pack, which is Smartor's Photo Album plus a bunch of addons. There is an update package somewhere for it, I'll take a look and see if I can find it.

[ScottDaMan]

Wow, I was not expecting such a quick reply. You guys are awesome for helping others. Totally impressed.

Thanks greatly for your assistance.

[ScottDaMan]

Thanks for the lead. I fixed it with your help. For those having this issue:
Visit: http://www.mightygorgon.com/index.php
Download FAP 1.4.0a (or later when you read this)
Grab the file fap_install.php from within this file. Upload that to your forum root.
Run the file.
Click "Install/Upgrade FAP to latest version"
You'll see a bunch or errors for existing tables but you'll also see it add new tables.

For me, this fixed it and works awesome. You don't have to do anything else since by installing IM141, you have the MOD fully installed.

By posting this followup, I'm doing my part to help others.

[Teelk]

Run the following SQL in phpmyadmin...

Code: Select all

ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`;ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`;  INSERT INTO `phpbb_album_config` VALUES ('show_index_thumb', '0');INSERT INTO `phpbb_album_config` VALUES ('show_index_total_pics', '1');INSERT INTO `phpbb_album_config` VALUES ('show_index_total_comments', '1');INSERT INTO `phpbb_album_config` VALUES ('show_index_comments', '0');INSERT INTO `phpbb_album_config` VALUES ('show_index_last_comment', '1');INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic', '1');INSERT INTO `phpbb_album_config` VALUES ('show_index_pics', '0');INSERT INTO `phpbb_album_config` VALUES ('show_recent_in_subcats', '1');INSERT INTO `phpbb_album_config` VALUES ('show_recent_instead_of_nopics', '1');INSERT INTO `phpbb_album_config` VALUES ('line_break_subcats', '1');INSERT INTO `phpbb_album_config` VALUES ('show_index_subcats', '1');INSERT INTO `phpbb_album_config` VALUES ('personal_allow_gallery_mod', '0');INSERT INTO `phpbb_album_config` VALUES ('personal_allow_sub_categories', '0');INSERT INTO `phpbb_album_config` VALUES ('personal_sub_category_limit', '-1');INSERT INTO `phpbb_album_config` VALUES ('personal_show_subcats_in_index', '0');INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_in_subcats', '0');INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_instead_of_nopics', '0');INSERT INTO `phpbb_album_config` VALUES ('show_personal_gallery_link', '1');INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting', 'cat_order');INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting_direction', 'ASC');INSERT INTO `phpbb_album_config` VALUES ('album_debug_mode', '0');INSERT INTO `phpbb_album_config` VALUES ('show_all_in_personal_gallery', '1');INSERT INTO `phpbb_album_config` VALUES ('new_pic_check_interval', '1M');INSERT INTO `phpbb_album_config` VALUES ('index_enable_supercells', '0');INSERT INTO `phpbb_album_config` VALUES ('email_notification', '0');INSERT INTO `phpbb_album_config` VALUES ('show_download', '2');INSERT INTO `phpbb_album_config` VALUES ('show_slideshow', '1');INSERT INTO `phpbb_album_config` VALUES ('show_pic_size_on_thumb', '1');INSERT INTO `phpbb_album_config` VALUES ('fap_version', '1.2.3');INSERT INTO `phpbb_album_config` VALUES ('hon_rate_users', '0');INSERT INTO `phpbb_album_config` VALUES ('hon_rate_where', '');INSERT INTO `phpbb_album_config` VALUES ('hon_rate_sep', '1');INSERT INTO `phpbb_album_config` VALUES ('hon_rate_times', '1');INSERT INTO `phpbb_album_config` VALUES ('disp_watermark_at', '3');INSERT INTO `phpbb_album_config` VALUES ('wut_users', '0');INSERT INTO `phpbb_album_config` VALUES ('use_watermark', '0');INSERT INTO `phpbb_album_config` VALUES ('rate_type', '2');INSERT INTO `phpbb_album_config` VALUES ('disp_rand', '1');INSERT INTO `phpbb_album_config` VALUES ('disp_mostv', '1');INSERT INTO `phpbb_album_config` VALUES ('disp_high', '1');INSERT INTO `phpbb_album_config` VALUES ('disp_late', '1');INSERT INTO `phpbb_album_config` VALUES ('img_cols', '4');INSERT INTO `phpbb_album_config` VALUES ('img_rows', '1');INSERT INTO `phpbb_album_config` VALUES ('midthumb_use', '1');INSERT INTO `phpbb_album_config` VALUES ('midthumb_height', '600');INSERT INTO `phpbb_album_config` VALUES ('midthumb_width', '800');INSERT INTO `phpbb_album_config` VALUES ('midthumb_cache', '1');INSERT INTO `phpbb_album_config` VALUES ('max_files_to_upload', '1');INSERT INTO `phpbb_album_config` VALUES ('max_pregenerated_fields', '1');INSERT INTO `phpbb_album_config` VALUES ('dynamic_fields', '1');INSERT INTO `phpbb_album_config` VALUES ('pregenerate_fields', '0');INSERT INTO `phpbb_album_config` VALUES ('propercase_pic_title', '1');INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic_lv', '0');INSERT INTO `phpbb_album_config` VALUES ('personal_pics_approval', '0');INSERT INTO `phpbb_album_config` VALUES ('show_img_no_gd', '0');INSERT INTO `phpbb_album_config` VALUES ('dynamic_pic_resampling', '1');INSERT INTO `phpbb_album_config` VALUES ('max_file_size_resampling', '1024000');INSERT INTO `phpbb_album_config` VALUES ('switch_nuffload', '0');INSERT INTO `phpbb_album_config` VALUES ('path_to_bin', './cgi-bin/');INSERT INTO `phpbb_album_config` VALUES ('perl_uploader', '1');INSERT INTO `phpbb_album_config` VALUES ('show_progress_bar', '1');INSERT INTO `phpbb_album_config` VALUES ('close_on_finish', '1');INSERT INTO `phpbb_album_config` VALUES ('max_pause', '5');INSERT INTO `phpbb_album_config` VALUES ('simple_format', '0');INSERT INTO `phpbb_album_config` VALUES ('multiple_uploads', '1');INSERT INTO `phpbb_album_config` VALUES ('max_uploads', '5');INSERT INTO `phpbb_album_config` VALUES ('zip_uploads', '1');INSERT INTO `phpbb_album_config` VALUES ('resize_pic', '1');INSERT INTO `phpbb_album_config` VALUES ('resize_width', '600');INSERT INTO `phpbb_album_config` VALUES ('resize_height', '600');INSERT INTO `phpbb_album_config` VALUES ('resize_quality', '70');INSERT INTO `phpbb_album_config` VALUES ('show_pics_nav', '1');INSERT INTO `phpbb_album_config` VALUES ('show_inline_copyright', '0');INSERT INTO `phpbb_album_config` VALUES ('enable_nuffimage', '1');INSERT INTO `phpbb_album_config` VALUES ('enable_sepia_bw', '0');INSERT INTO `phpbb_album_config` VALUES ('personal_allow_avatar_gallery', '0');INSERT INTO `phpbb_album_config` VALUES ('show_gif_mid_thumb', '1');INSERT INTO `phpbb_album_config` VALUES ('slideshow_.script', '0');INSERT INTO `phpbb_album_config` VALUES ('show_exif', '0');INSERT INTO `phpbb_album_config` VALUES ('album_bbcode', '1');

If you also had Clown SP installed then run this as well...

Code: Select all

DROP TABLE `phpbb_album_sp_config`;

Don't forget to change phpbb_ to your table prefix if you chose something different.

Then upload the attached php file to your forum root and run it by visiting it with your browser, it'll migrate personal galleries into the proper locations.

[Teelk]

You posted as I was writing...

We have version 1.2.3 installed with IM1.4.1, but I think there are only additions to the db so you should be fine.

I would, however, user that migration tool to get your personal albums back as they've most likely disappeared.

[ScottDaMan]

Update, that migrate file worked like a dream too. Thanks for pointing this out. I would have found this out much later and got frustrated.

AWESOME!

[ScottDaMan]

Here's the 1.4.0a update .script if anyone wants it. It worked fine for me, even if it added a few extra tables.

[ScottDaMan]

I just noticed, after using album_hierarchy_pg_migrate.zip, all the images no longer load. Weird. Any ideas?

It just shows a box with text. When I click on the link, it says "Not Authorized." I tried clearing the cache to no avail.

[ScottDaMan]

Something to do with subdomains and hotlink protection. Fixed by temporarily disabling. Won't worry about allowing the subdomain, its a temporary test install.

[Master Dwarf]

I just upgraded from 1.40 to 1.41 and have some problems noted above. I get the following error when trying to access 'album'...

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 phpbb_album_cat AS c LEFT JOIN phpbb_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

I get the following error when I try to access my KB...

Failed obtaining forum access control lists

DEBUG MODE

SQL Error : 1054 Unknown column 'a.auth_view' in 'field list'

SELECT a.category_id, a.auth_view, a.auth_post, a.auth_rate, a.auth_comment, a.auth_edit, a.auth_delete, a.auth_approval, a.auth_approval_edit FROM phpbb_kb_categories a

Line : 114
File : functions_kb_auth.php

I try inserting this code into phpmyadmin:

ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`;
ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`;

INSERT INTO `phpbb_album_config` VALUES ('show_index_thumb', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_index_total_pics', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_total_comments', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_comments', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_comment', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_pics', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_recent_in_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_recent_instead_of_nopics', '1');
INSERT INTO `phpbb_album_config` VALUES ('line_break_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_gallery_mod', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_sub_categories', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_sub_category_limit', '-1');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_subcats_in_index', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_in_subcats', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_instead_of_nopics', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_personal_gallery_link', '1');
INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting', 'cat_order');
INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting_direction', 'ASC');
INSERT INTO `phpbb_album_config` VALUES ('album_debug_mode', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_all_in_personal_gallery', '1');
INSERT INTO `phpbb_album_config` VALUES ('new_pic_check_interval', '1M');
INSERT INTO `phpbb_album_config` VALUES ('index_enable_supercells', '0');
INSERT INTO `phpbb_album_config` VALUES ('email_notification', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_download', '2');
INSERT INTO `phpbb_album_config` VALUES ('show_slideshow', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_pic_size_on_thumb', '1');
INSERT INTO `phpbb_album_config` VALUES ('fap_version', '1.2.3');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_users', '0');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_where', '');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_sep', '1');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_times', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_watermark_at', '3');
INSERT INTO `phpbb_album_config` VALUES ('wut_users', '0');
INSERT INTO `phpbb_album_config` VALUES ('use_watermark', '0');
INSERT INTO `phpbb_album_config` VALUES ('rate_type', '2');
INSERT INTO `phpbb_album_config` VALUES ('disp_rand', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_mostv', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_high', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_late', '1');
INSERT INTO `phpbb_album_config` VALUES ('img_cols', '4');
INSERT INTO `phpbb_album_config` VALUES ('img_rows', '1');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_use', '1');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_height', '600');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_width', '800');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_cache', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_files_to_upload', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_pregenerated_fields', '1');
INSERT INTO `phpbb_album_config` VALUES ('dynamic_fields', '1');
INSERT INTO `phpbb_album_config` VALUES ('pregenerate_fields', '0');
INSERT INTO `phpbb_album_config` VALUES ('propercase_pic_title', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic_lv', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_pics_approval', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_img_no_gd', '0');
INSERT INTO `phpbb_album_config` VALUES ('dynamic_pic_resampling', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_file_size_resampling', '1024000');
INSERT INTO `phpbb_album_config` VALUES ('switch_nuffload', '0');
INSERT INTO `phpbb_album_config` VALUES ('path_to_bin', './cgi-bin/');
INSERT INTO `phpbb_album_config` VALUES ('perl_uploader', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_progress_bar', '1');
INSERT INTO `phpbb_album_config` VALUES ('close_on_finish', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_pause', '5');
INSERT INTO `phpbb_album_config` VALUES ('simple_format', '0');
INSERT INTO `phpbb_album_config` VALUES ('multiple_uploads', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_uploads', '5');
INSERT INTO `phpbb_album_config` VALUES ('zip_uploads', '1');
INSERT INTO `phpbb_album_config` VALUES ('resize_pic', '1');
INSERT INTO `phpbb_album_config` VALUES ('resize_width', '600');
INSERT INTO `phpbb_album_config` VALUES ('resize_height', '600');
INSERT INTO `phpbb_album_config` VALUES ('resize_quality', '70');
INSERT INTO `phpbb_album_config` VALUES ('show_pics_nav', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_inline_copyright', '0');
INSERT INTO `phpbb_album_config` VALUES ('enable_nuffimage', '1');
INSERT INTO `phpbb_album_config` VALUES ('enable_sepia_bw', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_avatar_gallery', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_gif_mid_thumb', '1');
INSERT INTO `phpbb_album_config` VALUES ('slideshow_.script', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_exif', '0');
INSERT INTO `phpbb_album_config` VALUES ('album_bbcode', '1');

and it returns the following error:

SQL query:

ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval` ;

MySQL said: Documentation
#1060 - Duplicate column name 'cat_parent'

I upload def_themes.php and try to run it and get the following error:

HACKING ATTEMPT

So I am not sure what ScottDaMan did to get his stuff to work, but its kicking my ase well and good.

You can check my site...www.grumblingdwarf.com

I have checked all my file permissions and ran the update .script a few times.

Help? Thanks in advance. <img>

[Frost]

You tried to run def_themes.php from your browser? Shame on you lol

Also...

I try inserting this code into phpmyadmin:

ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`;
ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`;

INSERT INTO `phpbb_album_config` VALUES ('show_index_thumb', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_index_total_pics', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_total_comments', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_comments', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_comment', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_pics', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_recent_in_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_recent_instead_of_nopics', '1');
INSERT INTO `phpbb_album_config` VALUES ('line_break_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_subcats', '1');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_gallery_mod', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_sub_categories', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_sub_category_limit', '-1');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_subcats_in_index', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_in_subcats', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_instead_of_nopics', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_personal_gallery_link', '1');
INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting', 'cat_order');
INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting_direction', 'ASC');
INSERT INTO `phpbb_album_config` VALUES ('album_debug_mode', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_all_in_personal_gallery', '1');
INSERT INTO `phpbb_album_config` VALUES ('new_pic_check_interval', '1M');
INSERT INTO `phpbb_album_config` VALUES ('index_enable_supercells', '0');
INSERT INTO `phpbb_album_config` VALUES ('email_notification', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_download', '2');
INSERT INTO `phpbb_album_config` VALUES ('show_slideshow', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_pic_size_on_thumb', '1');
INSERT INTO `phpbb_album_config` VALUES ('fap_version', '1.2.3');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_users', '0');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_where', '');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_sep', '1');
INSERT INTO `phpbb_album_config` VALUES ('hon_rate_times', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_watermark_at', '3');
INSERT INTO `phpbb_album_config` VALUES ('wut_users', '0');
INSERT INTO `phpbb_album_config` VALUES ('use_watermark', '0');
INSERT INTO `phpbb_album_config` VALUES ('rate_type', '2');
INSERT INTO `phpbb_album_config` VALUES ('disp_rand', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_mostv', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_high', '1');
INSERT INTO `phpbb_album_config` VALUES ('disp_late', '1');
INSERT INTO `phpbb_album_config` VALUES ('img_cols', '4');
INSERT INTO `phpbb_album_config` VALUES ('img_rows', '1');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_use', '1');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_height', '600');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_width', '800');
INSERT INTO `phpbb_album_config` VALUES ('midthumb_cache', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_files_to_upload', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_pregenerated_fields', '1');
INSERT INTO `phpbb_album_config` VALUES ('dynamic_fields', '1');
INSERT INTO `phpbb_album_config` VALUES ('pregenerate_fields', '0');
INSERT INTO `phpbb_album_config` VALUES ('propercase_pic_title', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic_lv', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_pics_approval', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_img_no_gd', '0');
INSERT INTO `phpbb_album_config` VALUES ('dynamic_pic_resampling', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_file_size_resampling', '1024000');
INSERT INTO `phpbb_album_config` VALUES ('switch_nuffload', '0');
INSERT INTO `phpbb_album_config` VALUES ('path_to_bin', './cgi-bin/');
INSERT INTO `phpbb_album_config` VALUES ('perl_uploader', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_progress_bar', '1');
INSERT INTO `phpbb_album_config` VALUES ('close_on_finish', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_pause', '5');
INSERT INTO `phpbb_album_config` VALUES ('simple_format', '0');
INSERT INTO `phpbb_album_config` VALUES ('multiple_uploads', '1');
INSERT INTO `phpbb_album_config` VALUES ('max_uploads', '5');
INSERT INTO `phpbb_album_config` VALUES ('zip_uploads', '1');
INSERT INTO `phpbb_album_config` VALUES ('resize_pic', '1');
INSERT INTO `phpbb_album_config` VALUES ('resize_width', '600');
INSERT INTO `phpbb_album_config` VALUES ('resize_height', '600');
INSERT INTO `phpbb_album_config` VALUES ('resize_quality', '70');
INSERT INTO `phpbb_album_config` VALUES ('show_pics_nav', '1');
INSERT INTO `phpbb_album_config` VALUES ('show_inline_copyright', '0');
INSERT INTO `phpbb_album_config` VALUES ('enable_nuffimage', '1');
INSERT INTO `phpbb_album_config` VALUES ('enable_sepia_bw', '0');
INSERT INTO `phpbb_album_config` VALUES ('personal_allow_avatar_gallery', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_gif_mid_thumb', '1');
INSERT INTO `phpbb_album_config` VALUES ('slideshow_..script', '0');
INSERT INTO `phpbb_album_config` VALUES ('show_exif', '0');
INSERT INTO `phpbb_album_config` VALUES ('album_bbcode', '1');

and it returns the following error:

SQL query:

ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval` ;

MySQL said: Documentation
#1060 - Duplicate column name 'cat_parent'

You could try removing that line from the sql and try it again

I mean the

Code: Select all

ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval` ;

Do this is at spits out the errors

Or if you know what you are doing you can drop the tables or manually remove the entries from your db then run the sql again

[Master Dwarf]

Thanks Frost!! I got my 'Album' to work, but how do I get the KB to work? Should I start a new thread? Is there one I can reference?

[Frost]

You should start a new thread, as this one has been marked [Solved] previously and most likely will get overlooked.

As for the KB, I will wait until you make the new thread <img>