SQL Error 28

  • Resolved lonegamer

    (@lonegamer)


    17 years, 1 month 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?

Viewing 12 replies - 1 through 12 (of 12 total)
  • Jonathan Landrum

    (@jonlandrum)

    17 years, 1 month ago

    Same thing as here: http://wordpress.org/support/topic/109358

    Thread Starter lonegamer

    (@lonegamer)

    17 years, 1 month ago

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

    vkaryl

    (@vkaryl)

    17 years, 1 month 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.

    Thread Starter lonegamer

    (@lonegamer)

    17 years, 1 month 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.

    vkaryl

    (@vkaryl)

    17 years, 1 month 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.

    Thread Starter lonegamer

    (@lonegamer)

    17 years, 1 month 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…

    vkaryl

    (@vkaryl)

    17 years, 1 month 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.

    Jonathan Landrum

    (@jonlandrum)

    17 years, 1 month ago

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

    Thread Starter lonegamer

    (@lonegamer)

    17 years, 1 month 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…

    vkaryl

    (@vkaryl)

    17 years, 1 month 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….

    Thread Starter lonegamer

    (@lonegamer)

    17 years, 1 month 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.

    vkaryl

    (@vkaryl)

    17 years, 1 month ago

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

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘SQL Error 28’ is closed to new replies.