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 :
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
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:
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
after that i got following message :
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
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.
SOLVED FAP SUPPORT - NEED HELP !!! SQL Error : 1146 Table......etc.
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
I get this:
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.
- 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
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.
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
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 : Only admins may run this script!!!
And I did CHMODDEd the dictionarys.
Shaythong wrote: [View Post]
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 : Only admins may run this script!!!
And I did CHMODDEd the dictionarys.
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
Last edited by Shaythong on Sat 24 Mar, 2007 19:17; edited 1 time in total
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)
do all it, then log out (unless you want login me next time)
Last edited by Shaythong on Sat 24 Mar, 2007 19:17; edited 1 time in total
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
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'
Shaythong wrote: [View Post]
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'
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
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
tomm wrote: [View Post]
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
Subject: 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.
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.
Reupload all album files (FAP package).
Set admin setting > Admin ACP > General > General config > script path, make sure it's right.
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.
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
Thanks for HELP !!! I really appriciate that. I will start from the beginning tomorrow. I let you know if I make it. Thanks !
Shaythong wrote: [View Post]
Thanks for HELP !!! I really appriciate that. I will start from the beginning tomorrow. I let you know if I make it. Thanks !
Subject: 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.
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.
Subject: 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.
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.
Subject: 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:
shows up at album.php.
what are you up to?
But I cannot see the "album" link in your overall header, and this again:
Quote:
shows up at album.php.
what are you up to?
Subject: 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?
Subject: 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
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
Subject: 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
Page 1 of 2
You cannot post new topicsYou cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Powered by Icy Phoenix based on phpBB
Generation Time: 0.1317s (PHP: 16% SQL: 84%)
SQL queries: 10 - Debug Off - GZIP Enabled