Problem with searching threads

by **jszmiles** » Tue Apr 05, 2011 8:50 pm

Code: Select all: SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes INSERT INTO posts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (2940028, 'Problems with searching threads', 'dd6b43d1a6', '[code:1:dd6b43d1a6] Could not delete old search id sessions DEBUG MODE SQL Error : 1153 Got a packet bigger than ''max_allowed_packet'' bytes DELETE FROM search_results WHERE session_id NOT IN (''f979ca4f5f37704da73eb4229c8e6d2a'', ''baebc5941cc3514517405395c4c9c32d'', ''814c221b78a5cf362e75884bd35a2bc5'', ''df47a2d9f6c6b6e265d1c8fd0edba613'', ''23ad8a99919960b75a995145b6412210'', ''05430274a96b61ca95c5255b3d75ba81'',..... // removed like zillions of code lines. Line : 564 File : /home/ukmix/www/ukmix/forums-1.0.9/search.php

by **Charmbracelet** » Tue Apr 05, 2011 9:08 pm

I get this message aswell! I have got it 2 or 3 times over the last couple of months

by **Wayne** » Tue Apr 05, 2011 9:49 pm

I have a feeling that Lars will be either creating a backup of the site database [which is MASSIVE], he's definitely doing something involving the database, or there's a problem involving the database. At the moment, the database is having issues connecting to the server. Just needs a little redirection!

by **Plym** » Tue Apr 05, 2011 11:02 pm

I'm lost without the "View Your Posts" button, I can't navigate round the forum on my own! :lol:

by **JimJim** » Tue Apr 05, 2011 11:54 pm

Is this related to the search function?

I gave up on that a long time ago, for those who don't know, the secret is to go to google and type in:

site:ukmix.org [whatever you are looking for]

by **pollei** » Wed Apr 06, 2011 2:37 am

Charmbracelet wrote:I get this message aswell! I have got it 2 or 3 times over the last couple of months

by **irishguy28** » Wed Apr 06, 2011 6:25 am

That usually only happens when your search term returns too many results (though it doesn't always happen).

Try keeping extremely common words like "The", "A" etc out of your search terms; use the "Search for all terms" option instead of the default "Search for any terms or use query as entered"; limit the search to the particular part of the site you expect to find what you're lucking for, ie Chart Analysis, Pure Pop etc.

This will also lead to far better search results.

by **jszmiles** » Wed Apr 06, 2011 9:54 am

irishguy28 wrote:That usually only happens when your search term returns too many results (though it doesn't always happen).

I've tried not to duplicate possibly existing thread for Babylon Zoo's Spaceman... I think it won't return too many results. :wink:

Yeah, the number of duplicate threads is caused by this I suppose.

by **irishguy28** » Wed Apr 06, 2011 10:27 am

Oh...

"Babylon Zoo Spaceman" shouldn't have run into overflow issues as a result of the number of hits then so it must have been a genuine server/database error!

The search worked fine for me, just now :wink:

by **Thriller** » Wed Apr 06, 2011 3:43 pm

It didn't work for me last night is fine again now! I rarely have problems with it.

by **matthew_dixon** » Wed Apr 06, 2011 4:39 pm

Aye - I sometimes get this (as I always use the "View posts since last visit" page). Best bet is to work around it when it happens, and then next time you log in it's normally fine, and might remain fine for another few weeks.

by **Thriller** » Wed May 18, 2011 8:47 pm

It's broken for me now, spoke to soon

by **Star** » Wed May 18, 2011 8:50 pm

Me too!

by **skapunk** » Thu May 19, 2011 5:59 am

I think it happens to everyone like 2-3 times a month.

by **JimJim** » Thu May 19, 2011 6:08 am

I say this a million times...

JimJim wrote:For those who don't know, the secret is to go to google and type in:
site:ukmix.org [whatever you are looking for]

It works 100% of the time!

by **skapunk** » Thu May 19, 2011 6:09 am

Oh...found it. I was doing it wrong!

Thanks.

by **Star** » Thu May 19, 2011 12:43 pm

JimJim wrote:I say this a million times...

JimJim wrote:For those who don't know, the secret is to go to google and type in:
site:ukmix.org [whatever you are looking for]
It works 100% of the time!

But sometimes one would like to view all the possible topics for a particular word. i.e. I use it to search "albumclash" to make sure I don't repeat any albums.

by **JimJim** » Thu May 19, 2011 12:45 pm

That does work "site:ukmix.org albumclash" comes up with all the album clashes to date.

by **Graham76man** » Sun May 22, 2011 11:30 pm

Sorry but the UKMIX search is the worst I have ever encounted :-?

It would be nice to have an "precise word or phrase" option :wink:

Does the server crash if you search for Britney or Mairiah? :wink:

by **jpguy** » Mon May 23, 2011 5:04 pm

JimJim wrote:Is this related to the search function?

I gave up on that a long time ago, for those who don't know, the secret is to go to google and type in:
site:ukmix.org [whatever you are looking for]

Good advice

by **GetBack** » Wed May 25, 2011 6:48 am

by **Colin** » Wed May 25, 2011 10:29 am

As far as I'm aware, I think it is still difficult to specifically search one person's posts (i.e. not your own). That's the one thing that really bugged me about the searching difficulties here.

by **Graham76man** » Tue May 31, 2011 2:43 pm

I think this is why a lot of new posts are started when the subject is out there already. They then get locked. Is it not possibly to mearge them together rather than lock the up?

I think it just makes UKMIX look cluttered when these repeat threads appear all locked. Plus to an ousider it might put someone off joining the site if they think every new person gets the threads locked, for it does happen a lot to them :-?

We can't have people thinking crazy mods can we :wink:

by **irishguy28** » Tue May 31, 2011 3:10 pm

^ I think new users shouldn't be able to create new threads until they've made a certain number of posts and been a member for a certain period. By then they should hopefully have learned UKMix etiquette!

(It would also stop those spambots selling DVDs, shoes, games, jewellery, etc...)

by **Play** » Tue May 31, 2011 3:21 pm

irishguy28 wrote:^ I think new users shouldn't be able to create new threads until they've made a certain number of posts and been a member for a certain period. By then they should hopefully have learned UKMix etiquette!

(It would also stop those spambots selling DVDs, shoes, games, jewellery, etc...)

So true! I have seen lots of forums where you are not able to open a thread till you have 50/100 posts.