https://www.icyphoenix.com/viewtopic.php?f=26&t=1399&p=10605#p10605
-----------------------------------
tomm
Fri 23 Mar, 2007 03:02

Re: NEED HELP !!! SQL Error : 1146 Table......etc.
-----------------------------------
I think I made it, just I'm not sure why do I have some errors

DROP TABLE `phpbb_album_sp_config`
+++ Error: Unknown table 'phpbb_album_sp_config'

ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`
+++ Error: Duplicate column name 'cat_parent'

ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`
+++ Error: Duplicate column name 'cat_user_id'

ALTER TABLE `phpbb_album_comment` ADD `comment_cat_id` int(11) NOT NULL default '0' AFTER `comment_pic_id`
+++ Error: Duplicate column name 'comment_cat_id'

but when I click album (button) it works.

Will those errors affect my photo album?

I'm not sure, when I download FAP 1.4.1 (zip file) and then I unzipped, and I have several folders - cgi-bin, contrib, phpbb_root, and 
fap_install.php FAP 1.4.1.txt. 
I upload only phpbb_root nad fap_install to my _root phpbb, what should I do with other folders (cgi-bin, contrib)?
I mean I followed instraction, and only what I didn't make is this :

Change "Path to cgi-in" in Admin CP to a relative path from phpBB root to your cgi-bin
Create folder: cgi-bin/tmp/
copy cgi-bin/nuffload.cgi to cgi-bin/nuffload.cgi
CHMOD 777 cgi-bin/tmp/
CHMOD 755 cgi-bin/nuffload.cgi

and I didn't create tables, "cause it says ... (You can manually execute "SQL_full_album_pack_1_4_0.txt" instead of run this portion of code
 Or you can copy "fap_install.php" to your phpBB root and execute it from your browser when you're logged in with admin rights)

I did with fap_install.php.

Other thing is : 

-----[ OPEN ]------------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------------
#
if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
}
#
#-----[ AFTER, ADD ]------------------------------------------
#
// Mighty Gorgon - Full Album Pack - BEGIN
define('ALBUM_MOD_PATH', 'album_mod/');
define('ALBUM_FILES_PATH', 'album_mod/upload/');
include($phpbb_root_path . ALBUM_MOD_PATH . 'album_constants.' . $phpEx);
// Mighty Gorgon - Full Album Pack - END

but if you check this site it's some different code : http://www.mightygorgon.com/viewtopic.php?t=3434.

thanks.