vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB5 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=263)
-   -   UPDATE link in SQL (https://vborg.vbsupport.ru/showthread.php?t=328370)

TeckTP 11-26-2020 07:15 AM
UPDATE link in SQL
 
Hi,
We recently changed our forums url from www.olddomain.com to www.newsub.olddomain.com
We are using olddomain.com for more then 4 years and there are lots of posts with guide in posts with Photos IMG link to www.olddomain.com, but now we are change to www.newsub.olddomain.com and many posts have wrong IMG link.

Is there a way to replace this from entire database ?

Greet Tom

yilmaz 11-26-2020 07:36 AM
It should be if you run this in SQL query
PHP Code:

UPDATE  `text` SET  `rawtext` = REPLACE(`rawtext`, 'www.olddomain.com', 'www.newsub.olddomain.com') WHERE  `rawtext` LIKE '%www.olddomain.com%'; 

TeckTP 11-26-2020 07:48 AM
Sometings is wrong.

MySQL meldet: Dokumentation

1146 - table doesn’t exist’ error

--------------- Added [DATE]1606385697[/DATE] at [TIME]1606385697[/TIME] ---------------

OK correct:
UPDATE `vbtext` SET `rawtext...
now everything is OK.

Thank You


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00922 seconds
  • Memory Usage 1,713KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete