Go Back   vb.org Archive > vBulletin 5 Connect Discussion > vB5 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2022, 10:19 AM
StarBuG's Avatar
StarBuG StarBuG is offline
 
Join Date: Dec 2001
Location: Germany
Posts: 1,033
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default how to change url structure with db query?

Hello

I set up my forum and created a few test forums.
After I understood the structure of the forum system (Last used vBulletin on Version 4) I changed the Names of the Categorys and forums and started my forum.

After the the first 20 Posts or so I recognised that the old test forums are still in the URL Structure and I need to change that.

Can someone help me plz:

Which DB Query do I have to run to change my current URL links that look like this


http://www.domain.com/forum/forum/61-post-name#post63

to

www.domain.com/forum/xxx/yyy/61-post-name#post63

Thank you in advance and it is nice to be back after 10 years without vBulletin


Kind regards

StarBuG
Reply With Quote
  #2  
Old 11-17-2022, 08:23 PM
StarBuG's Avatar
StarBuG StarBuG is offline
 
Join Date: Dec 2001
Location: Germany
Posts: 1,033
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The solution came from Wayne Luke

For anyone with the same problem:


Code:
Wayne Luke
Hello,

It is not recommended to change URLs with a database query. This can cause problems including the lack of 301 redirects.

To change the URL of a channel (i.e. Forum), visit that forum in your browser. Then:

1. Turn on Site Builder, if necessary, by clicking the Edit Site toggle.
2. Edit the page.
3. Save the page.
4. In the Save Dialog, update the URL as you wish.
5. Finish saving the page.
6. Repeat for other channels.

When you save the page, the system will automatically create a 301 redirect record so links to your old URLs will continue to work.


All the best,
Wayne Luke
Technical Support Lead
MH Sub I, LLC dba vBulletin

http://www.vbulletin.com/
support@vbulletin.com

Translations provided by Google Translate.
--------------- Added [DATE]1668723888[/DATE] at [TIME]1668723888[/TIME] ---------------

My response was:

Code:
Michael Scheel
17th Nov 2022 05:21pm

Hey,

thanks for your help.
That was easy

Great to see how far your software has developed.
And nice to see that you are still on board :)
I remember your name from "the old days"

Just noticed that I am a member on vBulletin since 09.2001
That was 21 years ago
Shit I am old :)

Anyway thanks again for your help and it's nice to be back

Kind regards

Michael Scheel

(Reply Posted via Ticket System)
Reply With Quote
Благодарность от:
TheLastSuperman
Reply


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 01:47 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.05827 seconds
  • Memory Usage 2,174KB
  • 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
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (1)post_thanks_box_bit
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete