Integration with vB3

sjcctan · January 19th, 2006, 08:44 AM

Hello,

Please forgive my ignorance. I am trying to integrate Photopost Pro with vB3. May I know is the database prefix to be the same if I am sharing the database for the two programs. Thanks!

Chuck S · January 19th, 2006, 08:50 AM

Hello Photopost would have a separate table prefix like pp_

On the next to last step of install you will be asked for your vbulletin table prefix if you have one and you enter it where asked.

sjcctan · January 23rd, 2006, 08:25 AM

Hello,

I have moved my Photopost Pro to the same domain as vB3 Forum. After installation, I found out "Powered by: PhotoPost PHP, Copyright © 2005 All Enthusiast, Inc." was shown at the bottom of the screen. How can I remove or change the wording since I purchased the Branding free version. Thank you.

sjcctan · January 23rd, 2006, 09:30 AM

Hello,

After inserting the inc_features.php & inc_photopost.php file names into vBulletin index.php & tried run the forum, I received the following messages:

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_features.php on line 52

Warning: mysql_query(): A link to the server could not be established in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_features.php on line 52

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_features.php on line 54

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_features.php on line 115

Warning: mysql_query(): A link to the server could not be established in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_features.php on line 115

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_features.php on line 119

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_photopost.php on line 54

Warning: mysql_query(): A link to the server could not be established in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_photopost.php on line 54

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_photopost.php on line 57

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_photopost.php on line 71

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_photopost.php on line 106

Warning: mysql_query(): A link to the server could not be established in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_photopost.php on line 106

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_photopost.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in E:\User\forum.ipoh.com.my\httpdocs\forum\gallery\inc_photopost.php on line 118

What could be the problems? Thank you.

Chuck S · January 23rd, 2006, 10:16 AM

Please read this thread especially the paragraph in bold. It should solve your issue

PhotoPost Enhanced vB3 Index Integration

sjcctan · January 24th, 2006, 07:15 AM

Hello,

I added in all the required information. But now I get this error message "Could not select photopost databaseCould not select photopost database". What could be the problem?

The entry of the command is "mysql_select_db ("pp_klhost_ipoh_forum")or die("Could not select photopost database");". Is there anything wrong with the command line? Thank you.

Chuck S · January 24th, 2006, 11:24 AM

There are two mysql_select_db lines. The one you note above should be the photopost database name and the one at the bottom of the file should be the forum

If the username and password to access the databases is different between databases you will also need to uncomment the $link statement and fill in the proper variable to access Photopost database.

sjcctan · January 24th, 2006, 07:19 PM

Hello,

I already uncommented &link stament & filled in all the proper variables. Actually, database of Photopost is the same one as vBulletin & also with the same login user name & password. I am just wondering why there is such error message. Thank you.

Chuck S · January 24th, 2006, 08:12 PM

If the database name user is the same there should be no need to do this.

Make sure in your edit integration settings the table prefix for photopost is entered correctly.

sjcctan · January 25th, 2006, 08:08 AM

Hello,

I have checked through my settings. I didn't find anything wrong. The database prefix is pp_. It has been set correctly.

I have these command lines entered into vB3 index.php:
include(DIR . '/gallery/inc_features.php');
include(DIR . '/gallery/inc_photopost.php');

Are the entries correct, if all the Photopost files are at http://forum.ipoh.com.my/forum/gallery/? Thank you.

Chuck S · January 25th, 2006, 08:28 AM

Could not select photopost database

That is a very specific error. Try uploading a clean file from the distribution cause whatever has been edited in that file is incorrect. Your telling the file to select a database it can not select. Best to start over here since we have assertained your applications are in the same database.

sjcctan · January 26th, 2006, 08:24 AM

Hello,

I have done new installations both for Photopost Pro & vBulletin. Now I am facing with a problem. When I login as admin, the admin icon in Photopost doesn't show up. I can't enter Admin CP to set up the system. How? Thank you.

Chuck S · January 26th, 2006, 10:57 AM

Well you selected vb3 integration when installing right? You get no errors at all? Does the login authenticate? You might want to post url's here so we can assist.

I would check cookies and license number

Set photopost and the forum to match cookies like so. You will need to edit your photopost cookie settings in phpmyadmin settings 171-173

cookie path /

cookie prefix bb

cookie domain .domain.com

Now your config-inc.php file must have the correct vb license number entered on the $vblicense line. You can find this at the top of the vbulletin config.php file in the includes directory.

sjcctan · January 27th, 2006, 09:14 AM

Hello,

All problems solved. Thank you.

sjcctan · January 27th, 2006, 09:20 AM

Hello,

I have moved my Photopost Pro to the same domain as vB3 Forum. After installation, I found out "Powered by: PhotoPost PHP, Copyright © 2005 All Enthusiast, Inc." was shown at the bottom of the screen. How can I remove or change the wording since I purchased the Branding free version. Thank you.

Chuck S · January 27th, 2006, 09:29 AM

Hello you can email support@photopost.com for assistance in removing brand free. Please state your url and license number in the request.

sjcctan · February 3rd, 2006, 10:01 AM

Hello,

I have removed the bottom part by following your instruction. But I still find "Powered by PhotoPost" at the top of the screen in the "Window Title". How can I remove the wordings? Thank you.

Chuck S · February 3rd, 2006, 11:07 AM

Hello instructions for doing so where also included in that very support thread I responded to. I note to search 3 times for the phrase and remove it