"search posts by time" might be broken

For you to give feedback to the Heartland moderators. Wish lists, fault reports, etc. You may get an answer, you may not. As in all things, it largely depends on how nicely you ask the people in charge... You're welcome.
Post Reply
User avatar
Quiff Boy
Herr Administrator
Posts: 16827
Joined: 25 Jan 2002, 00:00
Location: Lurking and fixing
Contact:
Contact Quiff Boy

is it just me or has the "search for posts from the last X days" drop-down thingumy at the top of the forum homepage stopped working?

:urff:

can anyone else get it to work? try searching for posts withing the last few minutes/hours/days/weeks... :?:

just says there are no posts :eek:

i upgraded the forum to version phpBB 2.0.14 the other day - one of the code changes was to the search page, so i'm guessing that was when it broke :roll:
What’s the difference between a buffalo and a bison?
Top
User avatar
Quiff Boy
Herr Administrator
Posts: 16827
Joined: 25 Jan 2002, 00:00
Location: Lurking and fixing
Contact:
Contact Quiff Boy

ahhhh

http://www.phpbbhacks.com/forums/viewtopic.php?t=47872

a job for tonight methinks :roll:
What’s the difference between a buffalo and a bison?
Top
User avatar
Petseri
Overbomber
Posts: 4579
Joined: 15 Apr 2002, 01:00

Quiff Boy wrote:ahhhh

http://www.phpbbhacks.com/forums/viewtopic.php?t=47872

a job for tonight methinks :roll:
If it is a hassle to fix, you may wish to chack how many people actually use it or would miss it. I do not think that I have ever used it, but I may be in the minority on that. Time for a new poll? ;D
Top
User avatar
Quiff Boy
Herr Administrator
Posts: 16827
Joined: 25 Jan 2002, 00:00
Location: Lurking and fixing
Contact:
Contact Quiff Boy

nah, looks like a pretty straight simple & forward fix to be honest :)

probably take longer to do a poll about it than to fix it :lol:
What’s the difference between a buffalo and a bison?
Top
User avatar
Petseri
Overbomber
Posts: 4579
Joined: 15 Apr 2002, 01:00

Quiff Boy wrote:nah, looks like a pretty straight simple & forward fix to be honest :)

probably take longer to do a poll about it than to fix it :lol:
What would take longer, activating the SEARCH function again or starting a poll about its usefulness? :innocent:

(Just teasing. I have not needed it much lately. It does seem to pull up recent hits, though. Is only a portion of the database searchable?)

Martin
Top
User avatar
Quiff Boy
Herr Administrator
Posts: 16827
Joined: 25 Jan 2002, 00:00
Location: Lurking and fixing
Contact:
Contact Quiff Boy

activating the SEARCH function would definitely take longer ;)

its not actually decativated, its just that the search words were deleted...

when someone posts something the forum looks at all the words in it and stores them in a database table

as i'm sure you can imagine, the table gets quite large! :o

i emptied the search-related tables, but any posts made after that time will still be added, hence only recent posts are searchable.

there is a script that i could run to whizz through all the posts and recreate the search table, but it takes about 8 hours :urff:

and if anyone posts while its regenerating it gets screwed and you have to start again...

:roll:

not ideal design, i'm sure you wil agree.

what i did before was recreate the tables on a backed up version on my pc at home, then i just uploaded the table data directly to the database.

it does mean that there will be a few things "missed out" between me taking the shapshot and then uploading the final regenerated table, but n the general scheme of things it tends not to be that noticable.

the reason i havent restored it yet is because the table itself can often be as bug as every other table put together - imagine every word from every post, along with a reference to where mentions that word! its mahoosive! :lol:

and mik had a nasty incident with his wishville forum when his db reached 100mb in size. he uses teh same hosting company as me and it seems they have (or had) an unofficial cap on db size. its not mentioned in their t&c's and i'm sure if i emailed them about i they would have no idea what i was on about :evil:

but with a fully restored search function the db these days would be about 120mb

i'd move hosting comanies but i've got so much other stuff tied up with this package that it would be a nightmare... march violets & salvation websites, heartland email addresses, etc etc. it would be a logistical nightmare to move! :(

suppose it could be worth restoring the search stuff and then just letting the db grow and grow and see what happens :!: worst case scenario is that it stops accepting new posts until i empty the search tables again...

hmmm :?: :!:
What’s the difference between a buffalo and a bison?
Top
User avatar
Quiff Boy
Herr Administrator
Posts: 16827
Joined: 25 Jan 2002, 00:00
Location: Lurking and fixing
Contact:
Contact Quiff Boy

bloody hell. did that even make sense? :lol: :urff: :roll:
What’s the difference between a buffalo and a bison?
Top
User avatar
hallucienate
Overbomber
Posts: 4602
Joined: 17 Apr 2002, 01:00
Location: /\/¯¯¯¯¯\/\
Contact:
Contact hallucienate

Quiff Boy wrote:bloody hell. did that even make sense? :lol: :urff: :roll:
made perfect sense to me :oops:

Chances are the DB would go over quota on a Friday evening just after you've left for an "away" weekend :lol: :lol: :urff:
Top
User avatar
James Blast
Banned
Posts: 24699
Joined: 11 Jun 2003, 18:58
Location: back from some place else

first thing I thought of was "Geek!" :eek:
"And when you start to think about death, you start to think about what's after it. And then you start hoping there is a God. For me, it's a frightening thought to go nowhere".
~ Peter Steele
Top
User avatar
Quiff Boy
Herr Administrator
Posts: 16827
Joined: 25 Jan 2002, 00:00
Location: Lurking and fixing
Contact:
Contact Quiff Boy

James Blast wrote:first thing I thought of was "Geek!" :eek:
its a fair cop ;) :lol:
What’s the difference between a buffalo and a bison?
Top
User avatar
Quiff Boy
Herr Administrator
Posts: 16827
Joined: 25 Jan 2002, 00:00
Location: Lurking and fixing
Contact:
Contact Quiff Boy

thats fixed now 8)
What’s the difference between a buffalo and a bison?
Top
Post Reply

Return to “Feedback”