phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Post Reply
User avatar
ouiouiphoto
Registered User
Posts: 80
Joined: Mon Jun 15, 2015 5:30 am
Contact:

phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by ouiouiphoto » Mon Apr 16, 2018 1:55 pm

Dear All

I have to free space in my dabase that reach my provider limit. I have see a table phpbb_notifications with 30000 Rows and a total size of 10Mb. I assume this is the notification send to users. In ACP i have limit this to 10 Days but the size does not change. Any idea tu reduce this table is welcome ;)

Thanks

User avatar
david63
Jr. Extension Validator
Posts: 14070
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by david63 » Mon Apr 16, 2018 2:12 pm

I am guessing that you (or at least your users) have a lot of unread notifications. If that is the case then there is nothing within the core to mark them read (sounds like the need for an extension to do that).

All I can think of is to run an sql query to mark them read (probably using a date so that new ones are not marked) and then they should roll out.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
ouiouiphoto
Registered User
Posts: 80
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by ouiouiphoto » Mon Apr 16, 2018 2:24 pm

Thanks for this idea. I have 25514 lignes unread for a total of 27 492 lignes. I can probably pass the oldest ones to read

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49021
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by stevemaury » Mon Apr 16, 2018 3:48 pm

If 10 MB of database space is critical, you need a new host.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
ouiouiphoto
Registered User
Posts: 80
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by ouiouiphoto » Mon Apr 16, 2018 4:25 pm

You are right. I need a bigger database but in the meanwhile i just need some free space to be able to change my database not in a rush ;)

janus_zonstraal
Registered User
Posts: 2269
Joined: Sat Aug 30, 2014 1:30 pm

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by janus_zonstraal » Mon Apr 16, 2018 5:00 pm

What search index are you using?
Sorry! My English is bat ;) !!!

User avatar
ouiouiphoto
Registered User
Posts: 80
Joined: Mon Jun 15, 2015 5:30 am
Contact:

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by ouiouiphoto » Mon Apr 16, 2018 5:30 pm

janus_zonstraal wrote:
Mon Apr 16, 2018 5:00 pm
What search index are you using?
"Mysql full text" as far as i understand your question ;)

janus_zonstraal
Registered User
Posts: 2269
Joined: Sat Aug 30, 2014 1:30 pm

Re: phpbb_notifications is 10Mb and 30000 Rows. How to clean ?

Post by janus_zonstraal » Mon Apr 16, 2018 6:06 pm

Ok that will not help you much to free some space.
Sorry! My English is bat ;) !!!

Post Reply

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: Bing [Bot] and 19 guests