Code: Select all
http://www.old_domain.com
Code: Select all
http://www.old_domain.com
Code: Select all
update phpbb_posts set post_text = replace(post_text, 'postimage.org', 'postimage.cc');
update phpbb_posts set post_text = replace(post_text, 'postimage.org', 'postimage.cc');
[phpbb_
replace appropriately.Code: Select all
UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg.org', 'postimg.cc');
UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg.org', 'postimg.cc');
That was the least helpful post and it's also wrong in the majority of cases.
postimage wrote: ↑Thu Apr 12, 2018 5:49 pm Correct query to fix image URLs
Code: Select all
UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg.org', 'postimg.cc'); UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg.org', 'postimg.cc');
Code: Select all
UPDATE `phpbb_posts` SET `post_text` = replace(post_text, 'postimg.org', 'postimg.cc');
#1064 - There is something wrong with the used syntax ''postimg.)' in line 1
On the left hand bottom side of the window for the query is setting for the delimiter, change to something other than a semicolon that is not used in the query. ! should work, at the end of the query change the semicolon to a !Froddelaar wrote: ↑Mon May 07, 2018 8:35 pm This one is not working.
#1064 - There is something wrong with the used syntax ''postimg.)' in line 1
And that works! Thank youthecoalman wrote: ↑Mon May 07, 2018 11:25 pmOn the left hand bottom side of the window for the query is setting for the delimiter, change to something other than a semicolon that is not used in the query. ! should work, at the end of the query change the semicolon to a !Froddelaar wrote: ↑Mon May 07, 2018 8:35 pm This one is not working.
#1064 - There is something wrong with the used syntax ''postimg.)' in line 1
phpbb_users
& field is user_sig
]
Code: Select all
UPDATE `phpbb_users` SET `user_sig` = replace(user_sig, 'postimg.org', 'postimg.cc');
UPDATE `phpbb_users` SET `user_sig` = replace(user_sig, 'postimg.org', 'postimg.cc');