SOLVED FAP SUPPORT - NEED HELP !!! SQL Error : 1146 Table......etc.


Subject: FAP SUPPORT - 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 :

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.

Profile PM  
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
I get this:
Code: [Download] [Hide]
  1. 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  
  2.  
  3. 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  
  4.  
  5. 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  
  6.  
  7. Fatal error: Call to undefined function: album_read_tree() in /home/salon-ma/public_html/phpBB/album.php on line 135  
  8.  


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.

Profile PM  
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
Shaythong wrote: [View Post]
I get this:
Code: [Download] [Hide]
  1. 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  
  2.  
  3. 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  
  4.  
  5. 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  
  6.  
  7. Fatal error: Call to undefined function: album_read_tree() in /home/salon-ma/public_html/phpBB/album.php on line 135  
  8.  


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.


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.

Profile PM  
Subject: 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)

Last edited by Shaythong on Sat 24 Mar, 2007 19:17; edited 1 time in total
Profile PM  
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
Shaythong wrote: [View Post]
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)


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'

Profile PM  
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
tomm wrote: [View Post]
Shaythong wrote: [View Post]
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)


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'




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

Profile PM  
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.

Code: [Download] [Hide]
  1. /phpBB/ 


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.

Profile PM  
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
Shaythong wrote: [View Post]
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: [Download] [Hide]
  1. /phpBB/ 


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.



Thanks for HELP !!! I really appriciate that. I will start from the beginning tomorrow. I let you know if I make it. Thanks !

Profile PM  
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.

Profile PM  
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.

Profile PM  
Subject: Re: NEED HELP !!! SQL Error : 1146 Table......etc.
Shaythong wrote: [View Post]
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.



Thanks a lot for HELP !!! I think it's gonna work ...... THANKS

Profile PM  
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:
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

shows up at album.php.

what are you up to?

Profile PM  
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

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

Profile PM  

Page 1 of 2


  
You cannot post new topics
You 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