Geeklog Forums

when search on my site an SQL error has occurred.



error.log details:

Sal 13 Mar 2007 17:20:12 GMT-2 - 1037: Out of memory; restart server and try again (needed 65528 bytes). SQL in question: SELECT u.username,u.fullname,s.uid,sid,title,introtext,bodytext,hits,UNIX_TIMESTAMP(date) AS day,'story' AS type FROM gklg141_stories AS s,gklg141_users AS u WHERE (draft_flag = 0) AND (date <= NOW()) AND (u.uid = s.uid) AND (introtext LIKE '%gvjkggh%' OR bodytext LIKE '%gvjkggh%' OR title LIKE '%gvjkggh%' GROUP BY date, username, fullname, u.uid, s.uid, sid, title, hits , s.introtext, s.bodytext ORDER BY date DESC LIMIT 0,10

Well, sounds like a server setup problem. If it's your own server, do what it says (and check your MySQL configuration). Otherwise, contact your hosting service.

bye, Dirk

my site mySQUEL database using storage engine MyISAM

to solve that search problem, because it says memory problem, Should I change engine from MyISAM to InnoDB?