Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 01-24-2006, 01:05 PM
mccollin mccollin is offline
 
Join Date: Jul 2003
Location: North Carolina, USA
Posts: 160
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 2.3 to 3.5 Upgrade - Archive Issues with Google

I have a fairly active forum that has been a long time needing an upgrade from 2.3.0. I finally did the upgrade last night to 3.5.3. One of the issues I'm having is that the site was heavily indexed by the search engines... primarily into one of the old Archive hacks. Well now I'm getting a ton of database error messages coming from this because the search engines are feeding people to the old "search engine friendly" archive. Any ideas how I can either redirect these inbound folks to the correct location in the new archive, or just to the forum index page if that is possible. I'd like to avoid people getting an error message. I'm probably losing a ton of visitors because of this situation, and my email inbasket is loaded with error messages.

Here is the error you get when calling one of these archives...

Quote:
Fatal error: Call to undefined function: verifyid() in /home/pph/public_html/forums/showthread on line 17
Here is the email I receive...

Quote:
Database error in vBulletin 3.0.1:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass)
VALUES
('f743fdee75198116cd7a950c1f90c84f', 0, '70.156.244.89', '16a335ce10b30195952d77aef998c543', 1138066293, '/forums/showthread/t-5643.html', 0, 0, 0, 0, 0, 0, 2, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7', 0);

MySQL Error : Unknown column 'languageid' in 'field list' Error Number : 1054
Date : Monday, January 23rd 2006 @ 07:31:33 PM
Script : http://pdaphonehome.com/forums/showthread/t-5643.html
Referrer : http://www.google.com/search?hl=en&q...=Google+Search
IP Address : 70.156.244.89
Username : Unregistered
Classname : vb_database
Well it looks like the old hack used the following url for an archived thread...

The new 3.5.3 version uses this url for the same archived thread...

I tried inserting a redirect in CPanel for http://pdaphonehome.com/forums/showthread to http://pdaphonehome.com/forums/archives/index.php and it isn't working. It will work if I don't have there is no filename.html on the end, but not with it. Anyone know how to do the redirect to fix this?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:50 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03544 seconds
  • Memory Usage 2,160KB
  • 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
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete