Upgrading from Photopost 5.62 in VB 4.1.11

[benstafford]

Hi,
I just renewed the license for Photopost and we are upgrading photopost from 5.62 to the latest version for our forum VB4.1.11 Version in our eng environment. I don't see any specific instructions on how to upgrade. I followed the instructions from the members area. when I called the upgrade.php first it said upgrade is complete, but now when I visit the forum photos site forum.eng.sitename.com/photos/ its shows a black screen the links and now the forum doesn't work it showing Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Here are my questions
1) How to upgrade from 5.62 (any specific instructions)
2) How to change the forum url as this is in a engineering environment so the photopost before and after upgrade has the correct forum url
3) what are the files changed by Photopost in VB forum root
4) Is there any db changes?

Any help is appreciated.

Thanks

[Chuck S]

Upgrade instructions are included in the documentations folder of the downloaded code.

For a functional site:

Basically what you would be doing is uploading all the files from 8.03 except the 2 config files and the install file. You would then run upgrade.php and run any upgrade from 5.62 forward.

If your getting mysql connect issues on your gallery I can only suspect you overwrote your config files. I would need more specific information like real urls to say more.

[benstafford]

Thanks for the reply Chuck. The environment is behind a firewall, I can only share screen shots. I believe the ugprade went well as per your post and documentation. I see the sitename.com/photos/ home page (See attached picture) I see empty category listing but with no photos. But when go to the VBulletin forum home page I still get the mysql connect issue? what is causing this? is photopost changing anything in the VB config or db ? Please note I didn't change anything conf or conf int file.I only changed the forum location paths. Mysql socket error only showing up for forum home page sitename.com/forum.php

Originally Posted by Chuck S

Upgrade instructions are included in the documentations folder of the downloaded code.

For a functional site:

Basically what you would be doing is uploading all the files from 8.03 except the 2 config files and the install file. You would then run upgrade.php and run any upgrade from 5.62 forward.

If your getting mysql connect issues on your gallery I can only suspect you overwrote your config files. I would need more specific information like real urls to say more.

[Chuck S]

The only way your going to get a mysql error on your forum is if your installing some vb plugin and have not properly installed any said plugin without the proper steps to define the mysql stuff.

Hard for me to say for sure not being able to see the site. That seriously negates the level of support.

Your picture should suggest on the gallery side you have not ran all applicable upgrades. Make sure to turn off category cache in global options in photopost admin and then if your using any vb plugins make sure to follow any directions to properly install them. Photopost 8 comes with plugins and EXPLICIT instructions on how to install them and if those directions are followed there should be no issue.

I can only assume those plugins are not installed correct or you have some other plugin you did not install correctly.

[benstafford]

Hi Chuck,
I was able to upgrade photopost successfully (as per the upgrade script) and I was able to display photos and category listing on the photos directory home page forum.sitename.com/photos/ But after upgrading I see two issues

1)The forum home page(forum.sitename.com/forum.php) doesn't work it gives a mysql socket error.

2)Also when I click on a indvidiual photo it takes to me this url forum.sitename.com/photos/showphoto.php?photo=1436&title=picture-095&cat=500

throws a error
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script:
Query: SELECT rating FROM ratings WHERE photo=1436 AND userid=1 LIMIT 1
Result: Table 'pp_digitalcamerareview.ratings' doesn't exist
Database handle: Resource id #44

Please note we doing this in our eng enviroment (VB 4.1.11) behind a firewall. Where are we going wrong here?

Thanks

[Chuck S]

1. Again this has to do with many a hack you have installed? If you properly install the vb4 plugins then things should be fine. Maybe you still have some vb3 hack installed or have not properly install the plugins. Please read the upgrade documentation in the documentation folder of the download.

2. This goes in line with above as well that error tells me you have not ran the 7.0 to 8.0 upgrade.

[benstafford]

1) We had old plugins we had removed them all here is the plugins installed

PhotoPost Pro 8.0
Skimlinks Plugin 4.1.11
Sphinx Search for vB4.X 1.0
vBSEO 3.6.0
vBulletin Blog 4.1.11 (Disabled)
vBulletin CMS (Disabled)

2) running upgrade 7.0x/8.0 fixed the # 2 problem.

[Chuck S]

1. I would suspect that you have not set the xml files to 777 permissions as noted in the upgrade script when generating any vb4 plugins. My suggestion is to read the documentation set permissions and reinstall the vb4 plugins make sure to either uninstall the old ones or select the OVERWRITE option when reinstalling the xml files you generate from photopost admin.

[benstafford]

I followed the instructions line by line as mentioned in the UPGRADE.txt no help , still see the socket error. what happens I install the plugin in manage products section , does the plugin change any VB templates. I tried installing and uninstalling product more than one time still have the same issue. what does it change in the forum home page? The socket issue is only happening in the forum.sitename.com/forum.php home page.

[Chuck S]

Like I said your database information can not be correct thats what that error says. So what is the database information under the plugin global variables for photopost in your plugin manager?

[benstafford]

Hi Chuck
So I see under VBulletin admin - > Plugin Manager -> global is this what you are asking about? db connection looks ok to me.

//Photopost Directory Name
$vbulletin->options['prodir'] = 'photos';

//Url to PhotoPost Install
$vbulletin->options['ppurl'] = 'http:forum.eng.sitename.com/photos';

//Server Path to PhotoPost Install
$vbulletin->options['pppath'] = '/app/apache/forum/digi/svntrunk/forum/photos';

//PhotoPost Database Name
$vbulletin->options['db1'] = 'pp_camerareview';

//vBulletin Database Name
$vbulletin->options['db2'] = 'camerareview';

//PhotoPost Mysql Host
$vbulletin->options['dbhost'] = 'tggt.db.eng.tggt.com';

//PhotoPost Mysql Username
$vbulletin->options['dbuser'] = 'forumuser';

//PhotoPost Mysql Password
$vbulletin->options['dbpass'] = '***';

function photourlsafe( $string )
{
$str1 = array('Ä', 'ä', 'Ü', 'ü', 'Ö', 'ö', 'ß', '(', ')', '[', ']');
$str2 = array('Ae', 'ae', 'Ue', 'ue', 'Oe', 'oe', 'ss', '', '', '', '');
$string = str_replace($str1, $str2, $string);
$string = urlencode( $string );
$string = strtolower( htmlspecialchars( $string ) );
$string = @ereg_replace('[^A-Za-z0-9]', '-', $string);

return( @eregi_replace('-{2,}', '', $string) );
}

function photo_get_ext( $filename )
{
return substr($filename, strrpos($filename,"."));
}

function photo_get_filename($filename)
{
return str_replace( photo_get_ext($filename), "", $filename );
}

function photo_is_image( $filename )
{
$mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
$ext = photo_get_ext( $filename );

if ( in_array(strtolower($ext), $mediatypes) )
{
return( true );
}

return( false );
}

function photo_is_multimedia( $filename )
{
$mediatypes = array( ".avi", ".mov", ".mpg", ".mpeg", ".swf", ".flv" );
$ext = photo_get_ext( $filename );

if ( in_array(strtolower($ext), $mediatypes) )
{
return( true );
}

return( false );
}

Thanks

[Chuck S]

is your photopost database name correct there?

[benstafford]

Yes double checked. It is Correct.

[Chuck S]

$vbulletin->options['db1'] = 'pp_camerareview';

Your telling me beyond any doubt your photopost database is pp_camerareview not camerareview?

Something is obviously wrong with your mysql info somewhere for some plugin you have. You sure it is the gallery plugin not some other plugin. Try turning off all plugins and then enable photopost. Recheck your plugin global mysql settings again the config settings in photopost.

[benstafford]

Yes photopost db name is correct. I disabled all other plugins and making the photopost plugin the active one its throwing mysql socket error. Now If I disable all the plugins its still showing the same error. This has happened after adding the products through the VBulletin admin. What are the changes done by Photopost in the templates and in VB db? Should I start again ? if I start again should delete any entries in VBulletin db related to photopost?

Thanks

[Chuck S]

well if you disable the photopost product in vb product manager and you still get your issue then your issue is not with photopost.

Photopost does not alter vbulletin in ANY WAY. The photopost program is outside your forum code. There are some plugins that you can install and should work fine if installed correctly. Those plugins are merely to show gallery content in your forum. Customers have been using them for several years now since there where a modification I created way back when we first supported vb4.

I do not see any other information to assist you. All I can do is respond to what you are posting.

What happens if you turn off the vb plugin system?

I would assume you have some plugin that is not correct but I am guessing here.

This clearly shows you things do work fine if properly installed

http://www.reeftalk.com/forums

So the issue is finding out what type of plugin you have installed that would be causing your issue. Like I said if your forum is still down after you disable the photopost product in your product manager then the issue is with another plugin.

[benstafford]

when I disable all plugins in config.php for VB the forum.php works it doesn't show the socket error. I enabled photopost plugin and forced php to display error. I see these errors (please see below) all related to photos/inc_features.php looks like it cannot execute the sql statement as their is no database connection.

1)
Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /apps/apache/forum/digi/svntrunk/forum/photos/inc_features.php on line 66 Warning: mysql_query(): A link to the server could not be established in /apps/apache/forum/digi/svntrunk/forum/photos/inc_features.php on line 66 Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /apps/apache/forum/digi/svntrunk/forum/photos/inc_features.php on line 69 Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /apps/apache/forum/digi/svntrunk/forum/photos/inc_features.php on line 139 Warning: mysql_query(): A link to the server could not be established in /apps/apache/forum/digi/svntrunk/forum/photos/inc_features.php on line 139 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

2) Other warnings I see (which is not related to socket error)

Notice: Use of undefined constant MOBILE_CAT - assumed 'MOBILE_CAT' in /apps/apache/forum/digi/svntrunk/forum/config-int.php on line 31 Notice: Use of undefined constant VB3_INTEGRATION - assumed 'VB3_INTEGRATION' in /apps/apache/forum/digi/svntrunk/forum/config-int.php on line 41 Notice: Use of undefined constant VB3_ENHANCEDINT - assumed 'VB3_ENHANCEDINT' in /apps/apache/forum/digi/svntrunk/forum/config-int.php on line 42 Notice: Use of undefined constant VB3_COMMWYSIWYG - assumed 'VB3_COMMWYSIWYG' in /apps/apache/forum/digi/svntrunk/forum/config-int.php on line 43 Notice: Use of undefined constant VB2_INTEGRATION - assumed 'VB2_INTEGRATION' in /apps/apache/forum/digi/svntrunk/forum/config-int.php on line 49 Notice: Use of undefined constant VBP2_INTEGRATION - assumed 'VBP2_INTEGRATION' in /apps/apache/forum/digi/svntrunk/forum/config-int.php on line 55

[Chuck S]

Ben there is your issue. You are including some old vb3 HACK. There is no issue with PhotoPost or our plugins for vb4. Not even an issue with your upgrades. Your trying to include that vb3 hack in vb4 which will not work. Your seeing an error because that file was probally updated when you upgraded so any database info you had when you where using that hack in vb3 you might have edited that file with proper mysql info.

inc_features is an old vb3 block and is not used for vb4 so whatever plugin you have created in vb using that block you must remove.

I would suggest you uninstall delete any PhotoPost plugins on your forum and verify they are all gone and then regenerate the vb4 plugins.

[benstafford]

Renaming the inc_features.php did the trick. I see the gallery in the forum home page. Will keep you posted if any issues.

[Chuck S]

Yeah you had a vb3 hack installed in vb4. Renaming the file may be solving your immediate issue but you will want to go into your vb plugin manager and remove whatever vb3 plugin that calls that file and remove the plugin to really solve your issue.