Maggie's Farm

We are a commune of inquiring, skeptical, politically centrist, capitalist, anglophile, traditionalist New England Yankee humans, humanoids, and animals with many interests beyond and above politics. Each of us has had a high-school education (or GED), but all had ADD so didn't pay attention very well, especially the dogs. Each one of us does "try my best to be just like I am," and none of us enjoys working for others, including for Maggie, from whom we receive neither a nickel nor a dime. Freedom from nags, cranks, government, do-gooders, control-freaks and idiots is all that we ask for.

Categories

Query failed:

SELECT  c.categoryid,
                           c.category_name,
                           c.category_icon,
                           c.category_description,
                           c.authorid,
                           c.category_left,
                           c.category_right,
                           c.parentid,

                           a.username,
                           a.username AS loginname,
                           a.realname
                      FROM csg_category AS c
           LEFT OUTER JOIN csg_authors AS a
                        ON c.authorid = a.authorid
           LEFT OUTER JOIN csg_authorgroups AS ag
                        ON ag.authorid = c.authorid
           LEFT OUTER JOIN csg_access AS acl
                        ON (ag.groupid = acl.groupid AND acl.artifact_id = c.categoryid)
                           
                           GROUP BY c.categoryid
 ORDER BY category_name ASC

/ Got error 28 from storage engine

All categories

Quicksearch

Blog Administration

Open login screen

RSS Readers

The search function did not work as expected. Notice for the administrator of this blog: This may happen because of missing index keys in your database. On MySQL systems your database user account needs to be privileged to execute this query:

CREATE FULLTEXT INDEX entry_idx on csg_entries (title,body,extended)

The specific error returned by the database was:

SELECT 
                            
                            e.id,
                            e.authorid,
                            a.realname AS author,
                            e.allow_comments,
                            e.moderate_comments,
                            a.email,
                            e.timestamp,
                            e.comments,
                            e.title,
                            e.body,
                            e.extended,
                            e.trackbacks,
                            e.exflag,
                            e.isdraft,
                            e.last_modified,
                            a.username AS loginname
                    
                      FROM
                            csg_entries e
                 LEFT JOIN  csg_authors a
                        ON  e.authorid = a.authorid
                 LEFT JOIN  csg_entrycat ec
                        ON  e.id = ec.entryid
                            
                     WHERE
                            (MATCH(title,body,extended) AGAINST('gramsci*' IN BOOLEAN MODE))
                             AND isdraft = 'false'  AND timestamp <= 1743506700
                    GROUP BY e.id
                    
                  ORDER BY  timestamp DESC
                     LIMIT 25
 / Got error 28 from storage engine

A Chris Southern Consulting website.

Maggie's Farm

Our Recent Essays Behind the Front Page

Categories

Quicksearch

Links

Blog Administration

RSS Readers