Upgrading after a test forum

[donald1234]

Yes but it seems to me that you are having problems creating a subdomain test.yourforum.com, unless you have done it before you are much better putting it in a folder and forget the subdomain.

I will go through it again, if your live forums files are in the root (public_html) as they will be if your forum is accessable at www.yoursite.com then all you need to do is upload the "upload" folder to there with all the vb files still inside so you will end up with:

www.yoursite.com (live site)

and

www.yoursite.com/upload (or whatever you have named it) as the test site.

That is the easiest way and also less complicated than creating a subdomain. (doing which makes the live site more different than the test site if it is in a subdomain instead of a folder if you know what I mean.)

[jagtpf]

Thanks Donald, for your time and patience.

I am not sure exactly where my 'problem' lies with regard to access to the Test Forum.

I find that my Test Folder is, indeed, where you advise it to be, the 'only' difference is that cPanel recognises it as a sub-domain.

You're probably correct in that following the Host guide I may be complicating matters, but that's all I can do, follow a guide until I find something that works.
So far it hasn't worked, so back to another guide to see if that's more successful. (In answer to your first statement; no I haven't done this before, otherwise
I wouldn't be having these questions ! )

I don't know whether it's placement of the Test Forum, or the Database backup>restore to new, that I have done incorrectly.

So, back to the beginning and try again.

I notice, this morning, that my Live database is 680MB, whilst my Test database has increased in size to 810MB.

TestForum access is returning database errors...

Database error in vBulletin :

mysql_connect(): Access denied for user '*******'localhost' (using password: YES)
/home/*******/public_html/*****/includes/class_core.php on line 317

Thank you Sir....

[jagtpf]

Further :

Spent early hours with new folder under public_html as per suggestion.
Uploaded everything and ran install script.
at 86% - process aborted with a database error :weeps:


Tried, again, to logon under sub-domain; again failed with the usual error.

Had a sudden thought on passwords etc.


On the face of it, all are correct and compatible.


But, just as a last-ditch resort option, compared Live/Test config.php files.
Changed Username/Password in Test to those in Live.
(After all I used a backup to create a new database).
Access to admincp still failed ! :groan: BUT different error message.

Returned config.php (test site) entry back. Then ..... last attempt


SUCCEEDED ! ????

Access to adminCp - slightly messed up lefthand column of entries.

Obviously some database tables askew.

But WHY successful logon. Something got switched by changing config.php and then reversing that change?

[donald1234]

Best to download a copy of config.php from the live site if the credentials are the same and use that for the test site.

You don't need to run install.php it should work as is as its a replica of the live site, once in the admincp remember to update the URL in "site name URL contact details" before running the upgrade.

[jagtpf]

Is it possible to create a database backup that gives us just standard vB files etc.

Moving from vB3 to vB4 is daunting enough, but with plugins etc, just wondered if it would be easier to start
with a scratch database (But with Users/threads/posts intact) and build on that, rather than have to
work out what's wrong with the database as is because of these plugs.

Snapshot of first section in admin panel ...and there are similar down the menu....

Settings

Options
Search Type
*[navigation_manager]*
Human Verification Manager
Social Bookmarking Manager
*[run_upgrade]*

[donald1234]

Just download the live sites database, you want an exact replica. It doesn't matter if you run into problems, you can figure them out, thats the whole idea of doing the upgrade on the test forum first.

You can disable all your plugins by adding this line to config.php under <?php Most won't work on 4 anyway.

[COLOR=#000000][COLOR=#0000BB]define[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]'DISABLE_HOOKS'[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]true[/COLOR][COLOR=#007700]);[/COLOR][/COLOR]

Or just uninstall them from the test site before upgrading

[jagtpf]

Just download the live sites database, you want an exact replica. It doesn't matter if you run into problems, you can figure them out, thats the whole idea of doing the upgrade on the test forum first.

You can disable all your plugins by adding this line to config.php under <?php Most won't work on 4 anyway.

[COLOR=#000000][COLOR=#0000BB]define[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]'DISABLE_HOOKS'[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]true[/COLOR][COLOR=#007700]);[/COLOR][/COLOR]

Or just uninstall them from the test site before upgrading

config.php is already set for hooks and mail to be disabled.

We have access to the test site (or at least admincp) - 'just' need to work out why some of the database tables are skewed as per the example in the previous post.

Thanks for your guidance. Much appreciated.

[jagtpf]

Can anyone suggest a 'cure' for these control panel entries;
these and more besides further up the column ....
seemingly tables of entries got shifted?

Maintenance

*[clear_system_cache]*
*[clear_autosave]*
Repair / Optimize Tables
Update Counters
Diagnostics
Execute SQL
Query
View PHP Info

*[xml_sitemap]*

*[manage_content_priority]*
*[rebuild_sitemap]*

*[api]*

*[api_key]*
*[api_log]*
*[api_stats]*

[jagtpf]

Hey !

All Good Fun

[donald1234]

"just" need to work out why some of the database tables are skewed

Once in the admincp remember to update the URL in "site name URL contact details" before running the upgrade.

If you don't update to the test forums URL in there it will be skewed.

[jagtpf]

All have been done, was at stage 1 I believe, as per "creating a test site" instructions - just haven't had the nerve to investigate as yet .....

small steps.

[jagtpf]

Finally we have something that makes some sense.

Errors notified in the above, plus some others; were repaired using tools.php options.

and we're running on

http://www. test.blahblahblah.com/admincp - using the subdomain option

[jagtpf]

Thanks everyone who popped in for a look and to Donald for your support ....