• tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Topic: Big problem with my multiforum - "Unable to fetch search results"

Hi,

I've got multiforum server with PunBB. From few weeks I've got problem with MySQL:

File: /var/www/pun.pl_glowna/search.php
Line: 485

PunBB reported: Unable to fetch search results

Database reported: Got error 12 from storage engine (Errno: 1030)

Failed query: SELECT t.id AS tid, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.closed, t.forum_id FROM topics AS t WHERE t.id IN(665,905,906,903,904,901,101,603,890) GROUP BY t.id, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.closed, t.forum_id ORDER BY t.last_post DESC LIMIT 0, 30

I know that error 12 means not enough physical memory, so I changed my 512 MB ram to 2 GB last days ... but problem not disappear sad

Could you help me ?

Darmowe forum - Polish free forum hosting

tomekf's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Big problem with my multiforum - "Unable to fetch search results"

Talk to your host, MySQL might need to be configured to be given more RAM

3 Reply by tomekf (edited by tomekf 2007-01-14 16:01)

  • tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Re: Big problem with my multiforum - "Unable to fetch search results"

MySQL config is ready for more memory hmm

I've got very high Handler_read_rnd_next like 30M after 2 hours.

Darmowe forum - Polish free forum hosting

tomekf's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Big problem with my multiforum - "Unable to fetch search results"

http://www.skyblog.com/punbb-1.2.14_search.php.patch
Try using this

  • tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Re: Big problem with my multiforum - "Unable to fetch search results"

Smartys how should I use it ?

Darmowe forum - Polish free forum hosting

tomekf's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Big problem with my multiforum - "Unable to fetch search results"

http://en.wikipedia.org/wiki/Patch_%28Unix%29

  • tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Re: Big problem with my multiforum - "Unable to fetch search results"

It's done smile

Thanks for help.

Darmowe forum - Polish free forum hosting

tomekf's Website