The Arcive of Official vBulletin Modifications Site.

Nat47 · #1 08-08-2013, 12:02 AM

Here is my situation:
I have a database from my site that used to work correctly. I was in the process of upgrading to a different server, and the import won't work. So, I have made a local test server. I was able to install vB and everything fine. However, when I imported the database, the links (such as seen on the right hand side) always link to wrong threads. Secondly, some threads have a user that posted the original thread, and the thread is viewable from the forum page, however when you click the link you get directed to the post reply page. When you click post, nothing happens and it states an error. Additionally, when you click the user's name that started one of these threads, it gives an error saying that the user isn't registered, although the user does exist in the database and does appear in the members list when viewed in vB.

Is this an error in database formatting or what? Should this be fixed through SQL or is there a way to fix it through impex/admincp?

Secondly, I have an error with the theme. The color scheme shows up fine, and the layout is fine, however none of the images are present you only get the broken image placeholder. The image file exists and is in the correct directory. What is likely the problem here?

Zachery · #2 08-08-2013, 01:01 AM

You should never be installing vBulletin to restore the database. You just restore the database to a clean database.

Lynne · #3 08-08-2013, 01:10 AM

Additionally to what Zachery said, you shouldn't be importing to upgrade or all your links WILL break. You need to move your database and then run the upgrade.php script on that database.

Nat47 · #4 08-08-2013, 03:56 PM

Technically we were just moving servers, and not really upgrading, but now that I looked, we're going from 4.2.0 to 4.2.1. Is that going to make a big difference and cause those problems I mentioned in the OP?

EDIT: Actually, the old Administration of the site had attempted to restore this database onto the site, which is currently 4.2.0. So, the version shouldn't be the issue here. What else can cause this problem?

Zachery · #5 08-08-2013, 04:16 PM

If you're just moving servers: http://www.vbulletin.com/docs/html/m...rsion=40200603

Nat47 · #6 08-08-2013, 05:54 PM

Quote:

Originally Posted by Zachery

If you're just moving servers: http://www.vbulletin.com/docs/html/m...rsion=40200603

Here's the story. There was a vBulletin forum. The VPS it was running on was accidentally wiped, and the Previous administration had only one local (not on the vps) backup of the site. They didn't seem to want to invest the time to figure out how to get the old Database back, and so they sold the site. However, before selling the site, they started a completely new version of the site. There are a couple thousand posts on the site now. I bought the site, and I want to get the old DB to merge into the new one (that's currently running live).

The live data on the site is completely new, although the forums are the same .

In order to fix it, I've got a (Local) test site set up. I installed vBulletin, and then used ImpEx to merge a dump of the live site. It worked fine. Then I tried to merge the OLD DB (with the live site dump), and it didn't work.

Lynne · #7 08-08-2013, 08:14 PM

What happened when you tried to ImpEx the old database into the test site?

Nat47 · #8 08-09-2013, 12:35 AM

Quote:

Originally Posted by Lynne

What happened when you tried to ImpEx the old database into the test site?

It imported. It worked fine from the ImpEx standpoint, no errors really.. Just took forever (obviously)... however, all of the links are broken on finished site.

Lynne · #9 08-09-2013, 01:02 AM

Links to what? If they are links to threads or users or anything like that, then yes, they will be broken. Or, if they are links to the old site, then yes, that will be broken also. Did you use the cleaner script after you ran ImpEx?

Nat47 · #10 08-09-2013, 01:27 AM

Quote:

Originally Posted by Lynne

Links to what? If they are links to threads or users or anything like that, then yes, they will be broken. Or, if they are links to the old site, then yes, that will be broken also. Did you use the cleaner script after you ran ImpEx?

Really? All the links are supposed to be broken? How come?

Here's the way that they are broken: When you click, say, the announcements forum and enter into /announcements, all of the threads you see look correct. However, once you click the thread you're sent to a completely different thread with the wrong url title.

We did run the maintenance > rebuild thread info.

How would I go about fixing links?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04342 seconds Memory Usage 2,248KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!