WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] SQL Error 28 (13 posts)

  1. LoneGamer
    Member
    Posted 7 years ago #

    I made a post on my WordPress-powered blog today and got SQL error 28. My host insisted nothing is wrong with the database and had me reinstall WordPress. I went from 2.0.x to 2.1.2. Now, I get the following error where the Blogroll should be:

    WordPress database error: [Got error 28 from table handler]
    SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM wp_links LEFT JOIN wp_link2cat ON (wp_links.link_id = wp_link2cat.link_id) WHERE 1=1 AND link_visible = 'Y' AND ( category_id = 14 ) ORDER BY link_name ASC

    A different tech support staff member spent an hour and a half looking at the database and says nothing is wrong. What is possibly the problem?

  2. Jonathan Landrum
    Member
    Posted 7 years ago #

  3. LoneGamer
    Member
    Posted 7 years ago #

    I've had two different tech support people say there is no DB problem, though.

  4. vkaryl
    Member
    Posted 7 years ago #

    They both "shade the truth". Really. Error 28 from table handler IS a host-side problem. Who's your host?

    You can try repairing the db yourself using the mysql/phpmyadmin interface, but it's less than a 2second job for your host provider.

  5. LoneGamer
    Member
    Posted 7 years ago #

    I tried table repairs using phpMyAdmin. My host is Fuitadnet: http://www.fuitadnet.com/

    They can offer me no explanation and no suggestions on what to do.

  6. vkaryl
    Member
    Posted 7 years ago #

    *sigh* Well, gee. Not much of a host then....

    It refers to the amount of storage available on (generally) your shared space with your host. It means that that space is full - and your host doesn't know this?

    So you email your support back, and you tell them that you KNOW the storage has a space problem, and you EXPECT them to fix it NOW, since you are paying them.... etc. etc. ad infinitum ad nauseam.

    And before you pay them for another month or whatever, find a decent host.

  7. LoneGamer
    Member
    Posted 7 years ago #

    Yeah, from reading other support requests I got the feeling FNET was just ignorant. It took them an hour just to acknowledge my issue on IRC live support... before the ownership change they were so good, any problem I had was addressed and fixed within five minutes.

    Not really sure if I need my own domain any more though, I could just use Blogger or wordpress.com or something...

  8. vkaryl
    Member
    Posted 7 years ago #

    You could, certainly, if you have no compelling reason to run your own domain.

    Alternatively, if you go with wordpress.com, you can pay them something (not sure how much, don't do that myself - drmike where are you when you're needed?) to use your own domain name for your wordpress.com blog, which may be an option to look into.

    I don't know what you're paying currently, but there are various places (NOT godaddy or dreamhost!) which are less than $100 US a year for good hosting.

  9. Jonathan Landrum
    Member
    Posted 7 years ago #

    If you go with TextDrive you get free *.textdriven.com domains. But then again, wordpress.com is free altogether.

  10. LoneGamer
    Member
    Posted 7 years ago #

    All I'm using my hosting for at this point is blog, e-mail separate from my academic e-mail account, and some limited file hosting. I can move the files over to my academic file space, and get on gmail...

  11. vkaryl
    Member
    Posted 7 years ago #

    You need to do what's best for your situation, but it does sound as if wordpress.com would be a good option. There are a lot of nice themes there, and some fun sidebar widgety things....

  12. LoneGamer
    Member
    Posted 7 years ago #

    WordPress.com blog it is. New e-mail should be set up soon, once I get the nameservers to my domain released. Thanks for the advice.

  13. vkaryl
    Member
    Posted 7 years ago #

    There you go! Sometimes a new beginning is very validating all on its own! Have fun....

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags