janus_zonstraal wrote: ↑Mon Jan 16, 2023 8:17 amAfter running the query you will get a message, can you post the message here?copy and paste the code run the query
janus_zonstraal wrote: ↑Mon Jan 16, 2023 8:17 amAfter running the query you will get a message, can you post the message here?copy and paste the code run the query
phpbb_posts is the table
so do I have an error or is it not the case to change all the links in the subjects which point to my new domain name?
Code: Select all
UPDATE `phpbb_posts` SET `post_text` = REPLACE (post_text, 'something', 'something_else');
`
and '
I'm not sure what you mean with that: subjects?
http://
and you want to replace that with https://
.http://
only as there might be other links using that (and you don't want to replace those)http://mydomainname
in different forms (with and without the www.
)www.mydomainename1.com
by www.mydomainename2.com
on my topic and subjects of the new forum www.mydomaibename2.com
Assuming you want to change the content of the posts (that's what you're trying with your SQL), then the SQL I posted should work.
Code: Select all
Erreur lors du démarrage de la session ; veuillez vérifier votre fichier journal PHP et/ou votre serveur Web et configurer correctement votre installation PHP. Assurez-vous également que les cookies sont activés dans votre navigateur.
session_start() : échec de l'ouverture (SESSION_FILE, O_RDWR) : quota de disque dépassé (122)
session_start() : échec de la lecture des données de session : fichiers (chemin : /home/powers76/tmp)
That's something you'll have to take up with your webhost.hamidouki wrote: ↑Tue Jan 17, 2023 11:12 pmI have erreur when I open my phpadminCode: Select all
Erreur lors du démarrage de la session ; veuillez vérifier votre fichier journal PHP et/ou votre serveur Web et configurer correctement votre installation PHP. Assurez-vous également que les cookies sont activés dans votre navigateur. session_start() : échec de l'ouverture (SESSION_FILE, O_RDWR) : quota de disque dépassé (122) session_start() : échec de la lecture des données de session : fichiers (chemin : /home/powers76/tmp)
By SSLUPDATE phpbb_posts SET post_text = REPLACE(post_text, 'www.yourdomaine1.com', 'www.yourdomaine2.com') WHERE post_text LIKE '%www.yourdomaine1.com%';