The secure CMS.

Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 12:28 pm EST

Geeklog Forums

Got error -1 from storage engine

 New Topic  Post Reply
 04/11/07 02:55pm (Read 10,995 times)  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
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
 Quote
 04/15/07 04:24am  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote
 04/17/07 04:27pm  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
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
 Quote
 04/23/07 06:09am  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
: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
 Quote
 04/23/07 01:57pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote
 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?
 Quote
 New Topic  Post Reply
All times are EST. The time is now 12:28 pm.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content