vBulletin URL Issue (Urgent)

[seadoonet]

I have been trying to reconnect my vBulletin to a different URL and have been having a lot of problems. It is hosted by nexcess and they are currently assisting with the problem. Right now this is what my vBulletin looks like - http://bit.ly/2c2DCWy

This is what I was messaged by the nexcess team
"Sorry, I'm having trouble getting the URL changed from there. It looks like I have limited access. It doesn't look like I can change this directly from the database either. When you installed vBulletin, you should have received a "do_not_upload" folder that contains a tools.php file. This file can be used to change the URL. Can you try to track this down and get it uploaded somewhere on the server so we can fix the URL?"

Where can I find this file? I am pretty sure I do not have it. Help !

Thank you
- Jim

[dbrooke]

Like the team said, when you downloaded your vBulletin forum, there is a do_not_upload folder in that download. You can re-download in the member services area.

The issue looks like a .htaccess issue to me.

Donovan

[glennrocksvb]

The base URL configured in AdminCP is http://www.sea-doo.net/forums and now you are trying to change it to http://www.perryperformancegroup.com/sea-doo-forums

You should have changed the URLs in AdminCP before the move to a different domain/URL. But since you already moved without changing it, it's too late to do it in AdminCP. What you need to do is to update the database directly by executing this SQL query. Add the table prefix if you are using it.

update setting set value = 'http://www.perryperformancegroup.com/sea-doo-forums' where varname='frontendurl';
update setting set value = 'http://www.perryperformancegroup.com/sea-doo-forums' where varname='frontendurl_login';
update setting set value = 'http://www.perryperformancegroup.com/sea-doo-forums/core' where varname='bburl';
delete from datastore where title in ('options', 'publicoptions', 'miscoptions');

NOTE: It is highly recommended to backup the database first before doing this.

[seadoonet]

Okay I am on the next issue. This is what the team sent me.
"We're still researching but it appears from the notes that tools.php may be able to be used to update the bitfields, or we'll need to manually edit the datastore table (varname=options, or so we think) and change it there also. It's serialized there, so we can't just do a query, but will need to really look at the data and change it correctly which may be easier said than done.

This is from info provided in the links below. If you approve of this attempt please let us know and we'll give it a shot. Of course you can always defer to your developer if they have some familiarity with this issue."

"When trying to run the tools.php file I'm getting the following:

PHP Warning: require_once(./install/includes/class_upgrade.php): failed to open stream: No such file or directory in /chroot/home/seadoone/perryperformancegroup.com/html/sea-doo-forums/core/admincp/tools.php on line 57
PHP Fatal error: require_once(): Failed opening required './install/includes/class_upgrade.php' (include_path='.:/usr/share/pear:/usr/share/php') in /chroot/home/seadoone/perryperformancegroup.com/html/sea-doo-forums/core/admincp/tools.php on line 57

You may want to ahve your VB developers attempt to update the URLs as they may be more familiar with setup and the internal working of the site they built. Let us know if the developers still need us to attempt this and if you can provide the required files from the error.
"

What can I do?

[glennrocksvb]

You also need to upload the "install" directory to the core directory. But did you try my suggestion to run the SQL queries I provided in post #3?

[Wayne Luke]

tools.php just provides an interface to do what the queries above do. If you're comfortable running queries, that is faster.