Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. error 28 from table handler(Errno=1030)

error 28 from table handler(Errno=1030)

1 Aug 01, 2005 01:32    

when I go to the first page
http://northerniraq.info/news/
it says :

MySQL error!

Got error 28 from table handler(Errno=1030)

Your query:
SELECT DISTINCT ID, post_author, post_issue_date, post_mod_date, post_status, post_locale, post_content, post_title, post_urltitle, post_url, post_category, post_autobr, post_flags, post_wordcount, post_comments, post_renderers, post_karma FROM (evo_posts INNER JOIN evo_postcats ON ID = postcat_post_ID) INNER JOIN evo_categories ON postcat_cat_ID = cat_ID WHERE cat_blog_ID = 7 AND ( ( post_status = 'private' AND post_author = 1 ) OR post_status IN ('published','protected') ) AND post_issue_date <= '2005-07-31 18:00:55' ORDER BY post_issue_date DESC LIMIT 17

but I checked some of the news that I had its permannet link, it works for them.
like this one
http://northerniraq.info/news/index.php?title=a_tourists_report_from_kurdistan&more=1&c=1&tb=1&pb=1,http://northerniraq.info/news/xmlsrv/rss2.php?blog=7
that works fine..

whe I click on Edit for that post...I can edit it..when I click on Edit Tab to edit other posts...I see this

MySQL error!

Got error 28 from table handler(Errno=1030)

Your query:
SELECT DISTINCT ID, post_author, post_issue_date, post_mod_date, post_status, post_locale, post_content, post_title, post_urltitle, post_url, post_category, post_autobr, post_flags, post_wordcount, post_comments, post_renderers, post_karma FROM (evo_posts INNER JOIN evo_postcats ON ID = postcat_post_ID) INNER JOIN evo_categories ON postcat_cat_ID = cat_ID WHERE cat_blog_ID = 7 AND ( ( post_status = 'private' AND post_author = 1 ) OR post_status IN ('published','protected','draft','deprecated') ) ORDER BY post_issue_date DESC LIMIT 0,17

what has happend to my news site... I swear to god i didnt even Touch it....it happend suddenly..

please please please help me to fix it...many ppl visit that news site :-/

plz help

Back to top

2 Aug 01, 2005 01:34

I should say , these news site been up for 4 mont , we posted 10 news a day...
do you think, it is bedcause we posted too much ?and b2evo doenst suppor it?

well let me say something else that may be usefull .

I used to get that RED ERRROR , in using search .

like SOMTIMES when I entered a Search word , it gave me small MYSQL error...but i didnt pay attention to it ..it was just sometimes...

Back to top

3 Aug 01, 2005 04:47

seems fine to me. did you fix it? what did you do?

Back to top

4 Aug 01, 2005 13:50

oh thank god I have a good hosting, they have full support 24 hours / 7 day..

I e-mailed them and they fixed it for me , I dont know how ;)

by the way, i really recommend this hosting, they are great
https://secure.hostgator.com/cgi-bin/affiliates/clickthru.cgi?id=medya
(yes I do recive comission if you buy it as well, but belive me this is the best hosting i have ever had, I have changed many hostings...this one has been my hosting for 6 months and it has been Fast - Reliable and with full support)

Back to top

5 Aug 01, 2005 13:53

but I still have error when I do "search" by B2's Serach Box.

go to my news site http://northerniraq.info/news/
and try to search for a word, (if that word doenst exist in my site at all it will give this RED ERROR)


MySQL error!

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY comment_post_ID, comment_type' at line 3(Errno=1064)

Your query:
SELECT comment_post_ID, comment_type, COUNT(*) AS type_count FROM evo_comments WHERE comment_post_ID IN () GROUP BY comment_post_ID, comment_type

for example go to here http://northerniraq.info/news/
and search for "dsfdsa" and you see that Red Error.

Back to top

6 Aug 01, 2005 13:58

By the way : error 28 means : there is not enough room on the server.
Your host has was decent enough to make room !

Back to top


Form is loading...