PhotoPost Community - Server Move issues

PhotoPost Community (http://www.photopost.com/forum/)

- ReviewPost Installation & Upgrades (http://www.photopost.com/forum/reviewpost-installation-upgrades/)

- - Server Move issues (http://www.photopost.com/forum/reviewpost-installation-upgrades/147257-server-move-issues.html)

Server Move issues

I recently moved hosting providers. I'm having a few issues. I think they might be related to the config files, but the provider can't seem to find the issue.

I'd like to post the error messages and config files, but it won't let me because I haven't made 15 posts. Can you please allow me to post links?

Just need one more it seems so here it is

I am getting a couple errors. First, there is this one. It appears when I am logged in and try to access the forums ( http://www.carseatmoms.com/forum.php ). Disabling the reviewpost plugin eliminates this error. The forums are still under development and turned off to the public but I can provide an admin login for staff if needed.

Quote:

Warning: require(/hsphere/local/home/carseat/carseatmoms.com/reviewpost/config-intr.php) [function.require]: failed to open stream: No such file or directory in [path]/forum.php(643) : eval()'d code on line 1

Fatal error: require() [function.require]: Failed opening required '/hsphere/local/home/carseat/carseatmoms.com/reviewpost/config-intr.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/carmoms/public_html/forum.php(643) : eval()'d code on line 1

The unusual thing is that it refers to a path "/hsphere..." that is a path only on the old host, not the new one. I do not see any references to that path anywhere in either config file. Perhaps there is another path setting somewhere that needs to be changed?

Also, I get the following error when I try to go to anything in the reviewpost directory, whether or not the reviewpost plugin is enabled:

Quote:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [path]/reviewpost/forums/vb3.php on line 58

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in [path]/reviewpost/pp-inc.php on line 3820

For reference here are the config files:

Quote:

<?php
//-----------------------------------------------------------------------------------//
// Forum Integration Configuration File
//
// For users using our forum integration files, there are a few things
// we need to know - like the location of reviewpost and your forums; this
// prevents us from doing alot of extra processing in these scripts we otherwise
// would have to do.
//
// Follow the guides to set your paths and enable the integration options you
// want.
//-----------------------------------------------------------------------------------//

// We need to know the server paths to both your vB installation and your Reviewpost installation
$vbpath = "/home/carmoms/public_html";
$rppath = "/home/carmoms/public_html/reviewpost";

// We need the URL path to your Reviewpost and vb installation
$url_path = "http://www.carseatmoms.com/reviewpost";
$vb_urlpath = "http://www.carseatmoms.com";

// The URL of your photo dir where your images are stored (with / at end)
$rpdata_dir = "http://www.carseatmoms.com/reviewpost/data/";

// If your Reviewpost tables have a prefix, put it here
// Example:
// rp_ = "rp_";
$rp_db_prefix = "rp_";

//------------------------------------- vB3 -----------------------------------------//
// VB3_INTEGRATION is for using vB3 headers/footers and styles
// VB3_ENHANCEDINT is for Enhanced vB3 Integration (using vB3 elements in Reviewpost)
// requires that VB3_INTEGRATION also be set to 'on'
// VB3_COMMWYSIWYG is for turning on the WYSIWYG interface on the Post A Comment page
// if you set this to 'off' then only the standard input box will appear
//
// Set to 'on' to enable specific integrations
define(VB3_INTEGRATION, 'on');
define(VB3_ENHANCEDINT, 'on');
define(VB3_COMMWYSIWYG, 'on');
//-----------------------------------------------------------------------------------//

//------------------------------------- vB2 -----------------------------------------//
// VB2_INTEGRATION is if you are using vB2 and want to use the vB2 integration
define(VB2_INTEGRATION, 'off');
//-----------------------------------------------------------------------------------//

//---------------------------------- vB2 Portal -------------------------------------//
// To use set path and set flag to 'on'
define(VBP2_INTEGRATION, 'off');
$vbportal="/home/sites/yoursite/web/vbportal";
//-----------------------------------------------------------------------------------//

?>

Quote:

<?php
//**************** External Header Configuration ****************//
//
// the isset prevents vB headers from being sent during login/logout -
// do not remove this line as it may cause the vB headers to interfere with the login/logout process
//
// To include the file, edit the header-inc.php
//

if ( !isset($skip_exheader) ) {
include "header-inc.php";
}

// Reviewpost Pro Version Number
$VERSION = "3.2";

// Path to your Reviewpost installation - no end slashes
$RP_PATH = "/home/carmoms/public_html/reviewpost";

//**************** MySQL Database Configuration ****************//

// Reviewpost database host address, or leave as localhost
$host="localhost";

// Reviewpost's database name
$database="REMOVED";

// MySQL username and password to access Reviewpost's database
//
// These two variables are for the userid and password needed to access
// the Reviewpost database named above.
$mysql_user="REMOVED";
$mysql_password="REMOVED";

// User database host address, or leave as localhost
$host_bb="localhost";

// If you want to use a prefix for your database, enter it here.
// NOTE: This variable can only be set PRIOR to your first installation of Reviewpost;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation.
$rp_db_prefix = "rp_";

// User database MySQL database name
//
// This is the variable for the User Database; if you are using Internal
// as your registration system, then these variables are the same as the
// ones above. If you are linking to a message board system,
// thse variables should be set to the database, user and password for that
// database.
$database_bb="REMOVED";

// MySQL username and password to access user database
//
// These two variables are for the userid and password needed to access
// the Reviewpost or BB database.
$user_bb="REMOVED";
$password_bb="REMOVED";

//
// VB3 License Number required for VB3 integration
// You can find this number by checking your index.php file in your vB3 directory
// The 4th line in the file looks like:
// || # vBulletin 3.0.0 - Licence Number ########
// It is the ######## number you need to place below.
$vblicense = "REMOVED";

//
// Xenforo Globalsalt required for xenforo integration
// You can find this number in your xenforo librarynForo\Application.php file
// Around line 473 line in the file looks like:
// 'globalsalt' => '########################',
// It is the ######################## number you need to place below.
$globalsalt = "123456789abcdef";

//**************** Application Configuration ****************//

// Default Language
// This needs to be set to the name of the directory used inside of the languages directory
$rplang = "english";

//////////////////////// Application Configuration ////////////////////////////////
// These variables set the path to the MOGRIFY commands on your system
//
// This only needs to be set if you are allowing ZIP uploads. These are full paths,
// including the name of the executable (.exe extensions for windows)
// The -j option for Info-ZIP's UNZIP tells it to ignore paths in ZIP file
//
// This option is only used in the event the internal UNZIP does not work for you
//$zip_command = "/usr/bin/unzip -j";

// Path to MOGRIFY executable
// There should be no spaces in the directory names, use short names if necessary.
// Examples:
// $mogrify_command = "c:\progra~1\imagemagick\mogrify.exe";
// $mogrify_command = "c:\ImageMagick\mogrify.exe";
$mogrify_command = "/usr/bin/mogrify";

?>

Well try running the install script and install into the same database and tables that are currently there verifying all paths information is correct for the new server disregard any duplicate errors and you should be able to fix everything. rerunning the install into the same database does not delete anything.

Before I run an install script, would it be possible to look over the config files to make sure I don't ruin anything? I've checked the server settings again but I'd like to make sure all of my work doesn't get ruined somehow.

Does this mean that there are filepath settings within the database? I assume there is no other way to change them for a server move?

I went ahead and had the provider give it a try since we have a backup anyway from the move. It did resolve the mysql errors and the reviewpost section seems to be working now.

It did not resolve the error on the main forums http://www.carseatmoms.com/forum.php . I'm pretty sure this is still related to reviewpost because the errors go away when the plugin is disabled. Would uninstalling/reinstalling the plugin be worth a shot? Any harm in doing so or potential loss of data?

Warning: require(/hsphere/local/home/carseat/carseatmoms.com/reviewpost/config-intr.php) [function.require]: failed to open stream: No such file or directory in [path]/forum.php(643) : eval()'d code on line 1

Fatal error: require() [function.require]: Failed opening required '/hsphere/local/home/carseat/carseatmoms.com/reviewpost/config-intr.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/carmoms/public_html/forum.php(643) : eval()'d code on line 1

I have disabled the plugin. The forum works fine. I can manually go to the reviewpost folder and everything still seems to be working.

I'd like to re-install the plugin from scratch. I've re-uploaded and edited per instructions.

Now, I need to get into the reviewpost control panel to export the plugin file, but I can't get into the control panel. It won't accept any admin login from vbulletin like it used to do.

Any idea what's going on? I admit I am a newb with server side stuff, but even the provider is having trouble figuring out what is happening.

Still no luck. Gonna try to start from scratch with the old database I guess. Every time we try something a new error results.

Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /home/carmoms/public_html/reviewpost/header-inc.php on line 57

Warning: require(./global.php) [function.require]: failed to open stream: No such file or directory in /home/carmoms/public_html/reviewpost/header-inc.php on line 58

Warning: require(./global.php) [function.require]: failed to open stream: No such file or directory in /home/carmoms/public_html/reviewpost/header-inc.php on line 58

Fatal error: require() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/carmoms/public_html/reviewpost/header-inc.php on line 58

Running install is necessary to correct all paths as your config only hosts a master script path and database info. all urls and server paths are stored in the database settings which you could manually edit via a database viewer but I am always going to give you the easiest answer here.

If you correctly reran the install to integrate with vb you should be able to get into the admin panel if you provided all the proper info for your setup.

Your last error is a common installation mistake number 2 on this tutorial

http://www.photopost.com/forum/photo...solutions.html

Quote:

Originally Posted by Chuck S (Post 1295244)

I posted the contents of the two config files above. I just checked the paths and they are exactly as they were quoted above and appear to be correct. Assuming they don't need a trailing slash or something, I think it must be another issue.

I'm still waiting for a database restore in case all the attempts we've made have caused a database issue somewhere. Then we can start with the install on the database that was working at the old host.

If you are getting the issue about header-inc.php line 57 I would think your server path to the forums is incorrect.

Code:

Content visible to verified customers only.

Basically that is saying that we can not find your vbulletn global.php file in the server path you have provided in the $vbpath variable.

OK, well, there is progress with the restored database. I re-ran the install script and double checked all the paths to the best of my knowledge. It's possible I am just clueless enough to get one wrong of course. Anyway, mostly it seems to be working now.

The only current issue is that on the main forum page http://www.carseatmoms.com/forum.php at the top it gives this error:

Parse error: syntax error, unexpected '{' in /home/carmoms/public_html/forum.php(643) : eval()'d code on line 154

As before, the error goes away if I disable the plugin. This time, though, it just displays the error and everything else appears under it as normal.

Path issue?

You can discuss any issues with code mods you might be using in those threads if your application is working as what your talking about is outside the supported code you downloaded in the members area.

Maybe try redownloading and reapplying any code mod you have used for vb4.

I have no other mods or plugins. It's basically straight vb4.1 with reviewpost. Even the integrated vbulletin blog is currently disabled.

Turning off the plugin makes the error go away, so it must be related to the plugin?

Plus, it was working at the old server, so I would thinkg something in the server move related to review post caused these issues, whether file paths or otherwise.

I don't mean to be difficult. This is a very frustrating plugin to troubleshoot, even for tech support at the new provider, which is why I'm here of course.

Reviewpost shows nothing on the vbulletin forum unless your running a vb plugin or code mod as its called. That is not part of our supported code. I would suspect your using this plugin

http://www.photopost.com/forum/revie...tin-4-0-a.html

That is a code mod. Maybe try deleting the old plugin and reapplying it?

Quote:

Originally Posted by Chuck S (Post 1295281)

Well, yes, that is the plugin I've been talking about that removes the error when I disable it in the product manager. But it was working normally before the server move, as with the rest of reviewpost.

When I had the old database restored the plugin had been uninstalled. I started with the install.php and that worked fine. Then I exported the plugin module from the reviewpost admin panel as the instructions specifiy and imported it again. The integration seems to be working, except that it generates that error.

Should I uninstall it, re-upload files again and re-install it another time then?

You would probally need to reinstall any mod or plugin sure. I am merely saying that is outside the supported product code that we are discussing here. Your application that we support is fully functional correct?

Quote:

Originally Posted by Chuck S (Post 1295285)

I'll know in a few days. So far it isn't crashing like before, though.

Do you have any ideas regarding the plugin error? In that it was working before the move, perhaps there is something server related like a path issue in the plugin mod or something else that might have changed with the move?

Unfortunately, I can't have the error and the reviewpost addon isn't particularly useful to me without the plugin, as you know from our correspondence prior to my purchase.

I really can not say our company does not support plugins or code mods just our default supported code. That is why I said you could post in that mod thread but my suggest really is to reapply any code if you moved a server etc.

The mod itself works as I wrote it and use it.

Reeftalk Forums

There just is no photopost company support of code not released from the company much like vbulletin.

Quote:

Originally Posted by Chuck S (Post 1295281)

I'll post to the mod thread then, but it is a mod you developed, no?

I uninstalled and re-installed the mod, it's now showing a bit more information I will post there.