Search
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Search

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    i get this error when trying to search for stuff.

    An Error Occured
    --------------------------------------------------------------------------------
    phpBB was unable to query the forums database
    The table 'SQL39b9b1_0' is full
    SELECT u.user_id,f.forum_id, p.topic_id, u.username, p.post_time,t.topic_title,f.forum_name FROM posts p, posts_text pt, users u, forums f,topics t WHERE ( (t.topic_title LIKE '%for%' OR t.topic_title LIKE '%...%' OR t.topic_title LIKE '%%' OR t.topic_title LIKE '%each%') OR (pt.post_text LIKE '%for%' OR pt.post_text LIKE '%...%' OR pt.post_text LIKE '%%' OR pt.post_text LIKE '%each%') ) AND p.post_id = pt.post_id AND p.topic_id = t.topic_id AND p.forum_id = f.forum_id AND p.poster_id = u.user_id AND f.forum_type != 1 ORDER BY p.post_time desc LIMIT 200

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i get a similar error
    When i use the word "cell" i get the problem
    SO i guess i won't use the word "cell" in my search


    phpBB was unable to query the forums database
    The table 'SQL6c30c6_0' is full
    SELECT u.user_id,f.forum_id, p.topic_id, u.username, p.post_time,t.topic_title,f.forum_name FROM posts p, posts_text pt, users u, forums f,topics t WHERE ( (t.topic_title LIKE '%cell%') OR (pt.post_text LIKE '%cell%') ) AND p.post_id = pt.post_id AND p.topic_id = t.topic_id AND p.forum_id = f.forum_id AND p.poster_id = u.user_id AND f.forum_type != 1 ORDER BY p.post_time desc LIMIT 200

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I would imagine just about 90% of topics include the word "cell" in them somewhere....

    that's a lot of results for your query...

    it's basically just maxed out...

    try narrowing it down to something specifics like "cell formatting" or "cell width" using ALL rather than ANY
    :: Pharma Z - Family drugstore ::

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com