AMIA ARCHIVE
https://www.amiaworld.net/phpBB3/

Forum Search
https://www.amiaworld.net/phpBB3/viewtopic.php?f=2&t=45517
Page 1 of 1

Author:  Merrien [ Sun, Feb 21 2010, 14:47 PM ]
Post subject:  Forum Search

Getting this error message when I try to do a forum search today:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 16 bytes) in D:\Web\phpBB2\db\mysql4.php on line 214

Author:  Sylfwe [ Sun, Feb 21 2010, 16:10 PM ]
Post subject: 

The search function just doesn't work probably due to database size, don't think it's fixable unless older topics would be deleted.

Author:  Nekhy [ Sun, Feb 21 2010, 16:20 PM ]
Post subject: 

It works and then again doesn't work at times.

Author:  Terra_777 [ Sun, Feb 21 2010, 17:31 PM ]
Post subject: 

The database must be huge though, 5 year old forum and Disco knows what else is in there.

Author:  Dev Disco [ Sun, Feb 21 2010, 17:40 PM ]
Post subject: 

Yeah, lotsa stuff. I can't even prune it properly anymore.

Author:  Yurell [ Sun, Feb 21 2010, 20:10 PM ]
Post subject: 

Happens occasionally ... I find it helps to use less words.

Author:  Dwagin [ Mon, Feb 22 2010, 0:26 AM ]
Post subject: 

Terra_777 wrote:
The database must be huge though, 5 year old forum and Disco knows what else is in there.


Of course he knows, Between him, Tormy and Nekhy, they have made 1 out of every 5 posts on the forums :P

Author:  TormakSaber [ Mon, Feb 22 2010, 0:27 AM ]
Post subject: 

Technically it's 17.81% but yeah, it's a lot.

Author:  Yurell [ Mon, Feb 22 2010, 0:39 AM ]
Post subject: 

The top four people make one fifth of the total posts :P

Author:  MoshingChris [ Mon, Feb 22 2010, 2:43 AM ]
Post subject: 

Why not just kill offtopic.

People don't even use Search there, they just make a new topic.

You could eliminate thousands upon thousands of posts just the last deleting 50 - 100 threads :D

Author:  TormakSaber [ Mon, Feb 22 2010, 2:50 AM ]
Post subject: 

Because people need/want a place to dscuss things wit their friends that aren't related to Amia.

Author:  Garnith [ Mon, Feb 22 2010, 11:34 AM ]
Post subject: 

TormakSaber wrote:
Because people need/want a place to dscuss things wit their friends that aren't related to Amia.


I think he means just delete a few of the old, unused threads, but keep Off-topic, along with the newer threads. Unless I'm reading it wrong. >.>

Author:  Yurell [ Mon, Feb 22 2010, 11:40 AM ]
Post subject: 

Garnith wrote:
TormakSaber wrote:
Because people need/want a place to dscuss things wit their friends that aren't related to Amia.


I think he means just delete a few of the old, unused threads, but keep Off-topic, along with the newer threads. Unless I'm reading it wrong. >.>


I believe Tormak was addressing:
MoshingChris wrote:
Why not just kill offtopic.

Although Tormak certainly doesn't need me to speak for him.

That said, deleting the last few pages of Off Topic should clear up a lot of room, unless they are to be saved for 'historic' reasons?

Author:  Selmak [ Mon, Feb 22 2010, 18:55 PM ]
Post subject: 

http://www.phpbb.com/mods/db/index.php? ... rib_id=427

This MOD provides some advanced options in pruning, for example choosing to leave sticky posts (even if they are outdated) unpruned, prune also the active votes (although they are outdated) or to prune outdated active votes and announcements.


Might be worth a look.

Author:  Yurell [ Mon, Feb 22 2010, 22:15 PM ]
Post subject: 

Another suggestion - would it be possible to create a separate 'Archived Threads' section, that wouldn't be checked by the forum search?

Author:  Dwagin [ Mon, Feb 22 2010, 23:59 PM ]
Post subject: 

I have a feeling the largest amount of posts are on places unable to be see by us groundlings.

Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/