Welcome to Geeklog, Anonymous Friday, October 18 2024 @ 02:41 am EDT
Geeklog Forums
SQL Problem
I tried to install the filemgmt plugin and it didn't quite work 100% so I uninstalled it. After uninstall I got this error when I tried to load the index page.
An SQL error has occured. Please see error.log for details.
When I checked the error.log this is the error that it generates.
1030: Got error 28 from table handler. 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, 4
This only happens when I try to view the index page. If I try and go to the admin dircetory or even the different news topics it works. Reloading the database previous to the filemgmt plugin didn't help either.
Any ideas? Thanks.
An SQL error has occured. Please see error.log for details.
When I checked the error.log this is the error that it generates.
Text Formatted Code
Wed Aug 3 19:31:18 2005 - 1030: Got error 28 from table handler. 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, 4
This only happens when I try to view the index page. If I try and go to the admin dircetory or even the different news topics it works. Reloading the database previous to the filemgmt plugin didn't help either.
Any ideas? Thanks.
1
2
Quote
All times are EDT. The time is now 02:41 am.
- 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