SQL for setting "Enable BBCode" to true?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
alecrust
Registered User
Posts: 348
Joined: Thu Mar 27, 2008 11:24 am
Location: London, UK
Contact:

Re: SQL for setting "Enable BBCode" to true?

Post by alecrust » Tue Sep 06, 2011 1:02 pm

Right, thanks for that.

Upon running that query there were 23935 rows affected (my whole user database basically) and the "Disable BBCode" in the "Edit signature" page is set to "false" as it should be.

Unfortunately, now the "Disable smilies" and "Do not automatically parse URLs" seem to have been set to "true" where they weren't before. This must be the same for every member of my site?
Attachments
Untitled-2.png
Untitled-2.png (17.28 KiB) Viewed 351 times

User avatar
alecrust
Registered User
Posts: 348
Joined: Thu Mar 27, 2008 11:24 am
Location: London, UK
Contact:

Re: SQL for setting "Enable BBCode" to true?

Post by alecrust » Tue Sep 06, 2011 2:19 pm

Unfortunately this also seems to have had an affect on normal posting. The "Disable smilies" is set to "true" for all users now.

Would this be the time to break out a database clean-up tool?

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51889
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: SQL for setting "Enable BBCode" to true?

Post by Brf » Tue Sep 06, 2011 2:34 pm

What exactly did you run?

User avatar
alecrust
Registered User
Posts: 348
Joined: Thu Mar 27, 2008 11:24 am
Location: London, UK
Contact:

Re: SQL for setting "Enable BBCode" to true?

Post by alecrust » Tue Sep 06, 2011 3:00 pm

In total, all I've done is run these two queries:

Code: Select all

update phpbb_users set user_options = 230271;

Code: Select all

update phpbb_users set user_options = 32768;

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51889
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: SQL for setting "Enable BBCode" to true?

Post by Brf » Tue Sep 06, 2011 3:03 pm

alecrust wrote:

Code: Select all

update phpbb_users set user_options = 32768;
This query sets all of the other options to false.

User avatar
alecrust
Registered User
Posts: 348
Joined: Thu Mar 27, 2008 11:24 am
Location: London, UK
Contact:

Re: SQL for setting "Enable BBCode" to true?

Post by alecrust » Tue Sep 06, 2011 5:46 pm

Oh God, what a nightmare!

Can you tell me what SQ query to run to resolve this?

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51889
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: SQL for setting "Enable BBCode" to true?

Post by Brf » Tue Sep 06, 2011 5:49 pm

This one will be fine:
alecrust wrote:

Code: Select all

update phpbb_users set user_options = 230271;

User avatar
alecrust
Registered User
Posts: 348
Joined: Thu Mar 27, 2008 11:24 am
Location: London, UK
Contact:

Re: SQL for setting "Enable BBCode" to true?

Post by alecrust » Tue Sep 06, 2011 10:34 pm

Thank you!!

Locked

Return to “[3.0.x] Support Forum”