http://www.icyphoenix.com/viewtopic.php?f=24&t=1399 ----------------------------------- tomm Thu 22 Mar, 2007 03:00 NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- Hello ! I'm new with phpbb, and I just want to add FAP 1.4.1 to my forum. I'm pretty sure that I've followed every step to install FAP. When I click on album (button) it shows following message : [b]General Error Could not query Album config information DEBUG MODE SQL Error : 1146 Table 'salon-ma_p_bb1.phpbb_album_config' doesn't exist SELECT * FROM phpbb_album_config Line : 75 File : album_common.php [/b] then I was trying to find some other solution and then I've found answer on this site : http://www.mightygorgon.com/viewtopic.php?t=3434 so, I changed following code: [b]Code: [Download] [Hide] Code: [Download] [Show] # #-----[ OPEN ]------------------------------------------------ # includes/constants.php # #-----[ FIND ]------------------------------------------------ # if ( !defined('IN_PHPBB') ) { die("Hacking attempt"); } # #-----[ AFTER, ADD ]------------------------------------------ # // Mighty Gorgon - Full Album Pack - BEGIN include($phpbb_root_path . 'album_mod/album_constants.' . $phpEx); define('LOGIN_MG', 'login.' . $phpEx); // Mighty Gorgon - Full Album Pack - END # #-----[ FIND ]------------------------------------------------ # define('VOTE_USERS_TABLE', $table_prefix.'vote_voters'); # #-----[ AFTER, ADD ]------------------------------------------ # // Mighty Gorgon - Full Album Pack - BEGIN 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'); // Mighty Gorgon - Full Album Pack - END [/b] after that i got following message : [b]Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(): Failed opening './ALBUM_MOD_PATHalbum_common.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/salon-ma/public_html/phpBB/album.php on line 61 Fatal error: Call to undefined function: album_read_tree() in /home/salon-ma/public_html/phpBB/album.php on line 135[/b] Here is my link and you can check it : http://salon-marijana.com/phpBB/index.php , and then just click album (button) Is there a way that I can fix this? Thanks. ----------------------------------- Shaythong Thu 22 Mar, 2007 03:10 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- I get this: [code]Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(): Failed opening './ALBUM_MOD_PATHalbum_common.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/salon-ma/public_html/phpBB/album.php on line 61 Fatal error: Call to undefined function: album_read_tree() in /home/salon-ma/public_html/phpBB/album.php on line 135 [/code] On your page... because the files are missing or the path is wrong. Once you've done that code on the MG site that the user helped you : #-----[ OPEN ]------------------------------------------------ # includes/constants.php this one. Make sure you didn't do it twice or your album won't work. The first SQL error is that you don't have the SQL installed follow this: I persume you don't really know how to query a database (if you installed phpBB i persume you do)... but just run it the easy way. :mricy: Download FAP 1.4.1 and upload the fap_install.php to ./ root of your site. Then type it in your internet browser and install. Then delete it. Also make sure you CHMODDEd the dictionarys. ----------------------------------- tomm Thu 22 Mar, 2007 03:32 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- [quote user="Shaythong" post="10538"]I get this: [code]Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(): Failed opening './ALBUM_MOD_PATHalbum_common.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/salon-ma/public_html/phpBB/album.php on line 61 Fatal error: Call to undefined function: album_read_tree() in /home/salon-ma/public_html/phpBB/album.php on line 135 [/code] On your page... because the files are missing or the path is wrong. Once you've done that code on the MG site that the user helped you : #-----[ OPEN ]------------------------------------------------ # includes/constants.php this one. Make sure you didn't do it twice or your album won't work. The first SQL error is that you don't have the SQL installed follow this: I persume you don't really know how to query a database (if you installed phpBB i persume you do)... but just run it the easy way. :mricy: Download FAP 1.4.1 and upload the fap_install.php to ./ root of your site. Then type it in your internet browser and install. Then delete it. Also make sure you CHMODDEd the dictionarys.[/quote] Thanks, I don't really know how to query a database (I didn't install phpBB) phpbb was on web site (my web hosting provider) as aplicaion installer. I have no experience with SQL, anyway, I did download FAP 1.4.1 and upload all files to _root of my site aslo with fap_install.php. And I've tried to type in interent browser but then I got this message : [b]Only admins may run this script!!![/b] And I did CHMODDEd the dictionarys. ----------------------------------- Shaythong Thu 22 Mar, 2007 03:37 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- Login to your site, tick "Login me in next time", go to -removed link for privacy- do all it, then log out (unless you want login me next time) ----------------------------------- tomm Thu 22 Mar, 2007 03:43 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- [quote user="Shaythong" post="10541"]Login to your site, tick "Login me in next time", go to http://salon-marijana.com/phpBB/fap_install.php do all it, then log out (unless you want login me next time)[/quote] I did it, thanks, but I think I have some errors as : DROP TABLE `phpbb_album_sp_config` +++ Error: Unknown table 'phpbb_album_sp_config' 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_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval` +++ Error: Duplicate column name 'cat_parent' 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' ----------------------------------- tomm Thu 22 Mar, 2007 03:49 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- [quote user="tomm" post="10542"][quote user="Shaythong" post="10541"]Login to your site, tick "Login me in next time", go to http://salon-marijana.com/phpBB/fap_install.php do all it, then log out (unless you want login me next time)[/quote] I did it, thanks, but I think I have some errors as : DROP TABLE `phpbb_album_sp_config` +++ Error: Unknown table 'phpbb_album_sp_config' 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_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval` +++ Error: Duplicate column name 'cat_parent' 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'[/quote] but still when I click on album (button) it's the same messages : Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(): Failed opening './ALBUM_MOD_PATHalbum_common.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/salon-ma/public_html/phpBB/album.php on line 61 Fatal error: Call to undefined function: album_read_tree() in /home/salon-ma/public_html/phpBB/album.php on line 135 ----------------------------------- Shaythong Thu 22 Mar, 2007 04:18 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- You already installed the database, no need for fap_install.php now, remove that file. Reupload all album files (FAP package). Set admin setting > Admin ACP > General > General config > script path, make sure it's right. [code]/phpBB/[/code] for yours and Go to ACP > Album panel (Admin) > config > set all your settings, correct path.. Make sure you edited the files correctly and read the instructions, make sure you didn't put duplicate edits. ----------------------------------- tomm Thu 22 Mar, 2007 04:49 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- [quote user="Shaythong" post="10544"]You already installed the database, no need for fap_install.php now, remove that file. Reupload all album files (FAP package). Set admin setting > Admin ACP > General > General config > script path, make sure it's right. [code]/phpBB/[/code] for yours and Go to ACP > Album panel (Admin) > config > set all your settings, correct path.. Make sure you edited the files correctly and read the instructions, make sure you didn't put duplicate edits.[/quote] Thanks for HELP !!! I really appriciate that. I will start from the beginning tomorrow. I let you know if I make it. Thanks ! ----------------------------------- 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. ----------------------------------- Shaythong Fri 23 Mar, 2007 04:30 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- Do not do MG's fix, just install normally for now. You already ran FAP_install.php, so delete it, and those SQL errors, it's fine. with CGI-Bin Upload to your root. CHMOD as it says: CHMOD 777 cgi-bin/tmp/ CHMOD 755 cgi-bin/nuffload.cgi And the error in the View All pictures, make some Public categories. In CGI-Bin setup in ACP Album: Change "Path to cgi-in" input in Admin CP to the path from your phpBB root to your cgi-bin for example: /cgi-bin/ Make sure you have "cgi-bin/tmp/" uploaded. and chmodded, I don't have it currently in Icy phoenix, but I think that's right. ----------------------------------- tomm Fri 23 Mar, 2007 04:48 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- [quote user="Shaythong" post="10606"]Do not do MG's fix, just install normally for now. You already ran FAP_install.php, so delete it, and those SQL errors, it's fine. with CGI-Bin Upload to your root. CHMOD as it says: CHMOD 777 cgi-bin/tmp/ CHMOD 755 cgi-bin/nuffload.cgi And the error in the View All pictures, make some Public categories. In CGI-Bin setup in ACP Album: Change "Path to cgi-in" input in Admin CP to the path from your phpBB root to your cgi-bin for example: /cgi-bin/ Make sure you have "cgi-bin/tmp/" uploaded. and chmodded, I don't have it currently in Icy phoenix, but I think that's right.[/quote] Thanks a lot for HELP !!! I think it's gonna work ...... THANKS ----------------------------------- Shaythong Sat 24 Mar, 2007 19:27 Re: SOLVED - NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- It worked last night, glad you got it working! :D But I cannot see the "album" link in your overall header, and this again: [quote]Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(./ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/salon-ma/public_html/phpBB/album.php on line 61 Warning: main(): Failed opening './ALBUM_MOD_PATHalbum_common.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/salon-ma/public_html/phpBB/album.php on line 61 Fatal error: Call to undefined function: album_read_tree() in /home/salon-ma/public_html/phpBB/album.php on line 135[/quote] shows up at album.php. what are you up to? ----------------------------------- etrini Sun 23 Sep, 2007 21:29 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- quick question the cgi bin have to go to the root of the site or the root of the folder containing the forum? ----------------------------------- etrini Sun 23 Sep, 2007 21:52 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- I have been going through this post hoping that it would help but nothing i still keep getting Warning: main(../ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/content/e/w/r/ewrighttrini/html/community2/admin/admin_album_cat.php on line 46 Warning: main(../ALBUM_MOD_PATHalbum_common.php): failed to open stream: No such file or directory in /home/content/e/w/r/ewrighttrini/html/community2/admin/admin_album_cat.php on line 46 ----------------------------------- Artie Mon 24 Sep, 2007 03:04 Re: NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- Please don't ask same question in more than one post .... you could earn your very own yellow card. :x ----------------------------------- etrini Mon 24 Sep, 2007 22:28 Re: SOLVED - NEED HELP !!! SQL Error : 1146 Table......etc. ----------------------------------- sorry was not thinking . wont happen again