phpBB Studio - No Re:

Could not get it to work on a test phpBB forum - phpBB Studio - No Re:

Could not get it to work on a test phpBB forum

by IoHL-be » Thu Mar 19, 2020 10:57 am

I'm not an expert when it comes to using CLI so I hope someone can help me with what I'm doing wrong here.

I wanted to try out the No Re: extension on the local test version of my forum with xampp.

I could go as far as logging into the MySQL database, but when I type the command:

Code: Select all

php bin/phpbbcli.php phpbbstudio:nore posts
Nothing happens. No message prompting me to confirm, and no error.

Can someone tell me what I'm doing wrong here please? :)
IoHL-be
Registered User
Posts: 46
Joined: Tue Oct 09, 2018 3:50 pm

Re: Could not get it to work on a test phpBB forum

by 3Di » Thu Mar 19, 2020 11:02 am

BlackPandaBear wrote:...
I could go as far as logging into the MySQL database, but when I type the command:

Code: Select all

php bin/phpbbcli.php phpbbstudio:nore posts
Nothing happens. No message prompting me to confirm, and no error.
CLI has nothing to do with database.

See: https://area51.phpbb.com/docs/dev/3.2.x ... arted.html
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco

Re: Could not get it to work on a test phpBB forum

by IoHL-be » Thu Mar 19, 2020 1:39 pm

Thanks for your help but I still couldn't figure it out, at least for my local xampp installation which doesn't have SSH. I didn't want to risk screwing something up by trying it immediately on my live FTP for which SSH is activated.

I used those SQL queries instead:

Code: Select all

Update tablename_posts set post_subject = replace (post_subject, 'Re: ', '') where post_subject like 'Re:%'

Code: Select all

Update tablename_topics set topic_last_post_subject = replace (topic_last_post_subject, 'Re: ', '') where topic_last_post_subject like 'Re:%'
And it worked like a charm. I'm still going to use your extension to prevent the 'Re:' from reappearing since it's the latest one and it's officially compatible with phpBB 3.3.

Wouldn't it be possible for you to create a button inside the ACP to execute that command line?

Have a nice day!
Last edited by IoHL-be on Sun Sep 05, 2021 4:57 pm
IoHL-be
Registered User
Posts: 46
Joined: Tue Oct 09, 2018 3:50 pm

Re: Could not get it to work on a test phpBB forum

by 3Di » Thu Mar 19, 2020 1:52 pm

Wouldn't it be possible for you to create a button inside the ACP to execute that command line?
That's simply impossible.

Into a local installation (your PC) like xammp or wamp or the likes, you should use the "command line" of your Operating System (or install https://gitforwindows.org/ ) which is the same as the CLI (Command Line Interpreter) on remote servers. In any case, support for this kind of stuffs is not within the scope of the extension itself.
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco

Re: Could not get it to work on a test phpBB forum

by philmusic39 » Mon Jun 22, 2020 1:49 pm

Je n'ai pas trop saisi , le fonctionnement.
comment puis je me rendre sur mon FTP et faire ce nettoyage de re-
Sur mon forum phpbb 3.0.0 , cela n'a pas fonctionné et je n'ai pas saisi la technique.
merci pour votre réponse.
philmusic39
Registered User
Posts: 14
Joined: Mon Dec 17, 2018 5:11 pm

Re: Could not get it to work on a test phpBB forum

by 3Di » Mon Jun 22, 2020 3:56 pm

🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco