phpBB • Free and Open Source Forum Software

by **thetobster** » Tue Dec 13, 2011 8:36 am

Hello,

When I originally set up my board I had the "Remove my posts" filter set to YES which was, in retrospect, a mistake based on how we use our forum and the Digests mod. I am getting a lot of concerned emails from posters that there is something wrong with the forum and their posts aren't going out over the digests.

Is there a way (probably a SQL script run right on the DB) that I could go back and change this option for all users on the forum?

Thanks for your help everyone!

by **thetobster** » Tue Dec 13, 2011 9:14 am

Apparently necessity is indeed the mother of innovation. I was able to simply fix this by going into the database and running the following SQL:

Code: Select all: UPDATE `phpbb_users` SET `user_digest_show_mine` =1

Note that in the UCP it's worded as "Remove my posts" but in the DB it's "Show my posts" meaning that a value of 1 will in fact show posts for everyone.

If anybody can see that I've done something horrible to my database please let me know....

by **MarkDHamill** » Tue Dec 13, 2011 5:18 pm

No, you did fine and I would have given the same solution.

	What:	Where:	Country:
vacatures php arbeit php jobs php lavoro php emploi php trabajo php jobs php arbeit php

phpBB Digests

Retroactive change post filter - phpBB Digests

Advertisements