04/11/07 02:55pm  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Hello everybody,

Sometimes I got this sql error message with a Geeklog 1.4.1

Text Formatted Code
1030: Got error -1 from storage engine. SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1  ORDER BY featured DESC, date DESC LIMIT 0, 6


Does someone have the same problem?

::Ben

I'm available to customise your themes or plugins for your Geeklog CMS
 04/15/07 04:24am  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
If you google (sorry: search Google) for that message you'll find a few references to a bug in MySQL at around MySQL 4.1.17. Not sure if that's really the cause of the problem, though, as that bug has to do with subqueries, which Geeklog doesn't use.

So upgrading MySQL may or may not help. Or try talking to your hosting service if they have any other ideas.

bye, Dirk
 04/17/07 04:27pm  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Thank you for your reply Dirk.

My MySQL version is 4.1.21-standard and this problem only happen with Geeklog 1.4.1SR on the index.php page.

I 'm still investigating and help is welcome.

Thanks.

::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
 04/23/07 06:09am  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
:banghead: Now sometimes it's error 28 on www.slirl.com/secondlife

Text Formatted Code
1030: Got error 28 from storage engine. SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1  ORDER BY featured DESC, date DESC LIMIT 0, 6


Maybe a problem with my hosting Co?

:helpme: ::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
 04/23/07 01:57pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Quote by: cordiste

1030: Got error 28 from storage engine.


You've heard of Google, haven't you? Neutral

You're out of space on the drive the database is on.

bye, Dirk
 03/10/11 09:54am  

er1c

Anonymous
Dirk,

I found this page via Google. How amusing that a high ranking result is a snarky "go Google it" post. Just wanted you to know that people actually searching for the answer on Google are presented with your nonsense posts that aren't helpful and make you look like a fool. Maybe if you don't have anything helpful to add you could ignore the posts?