Icy Phoenix

     
 


This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 2
Goto page 1, 2  Next
 
Reply with quote Download Post 
Post 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.
 



 
tommSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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.  

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.
 



 
ShaythongSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.  

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.
 



 
tommSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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 
ShaythongSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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'
 



 
tommSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
tommSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
ShaythongSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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 !
 



 
tommSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
tommSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
ShaythongSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
tommSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: SOLVED - NEED HELP !!! SQL Error : 1146 Table......etc. 
 
It worked last night, glad you got it working!

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?
 



 
ShaythongSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?
 



 
etriniSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
etriniSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.  
 



 
ArtieSend private message  
Back to topPage bottom
This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies.  Page 1 of 2
Goto page 1, 2  Next


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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