Serendipity Forums

Code: Select all

Query failed:

SELECT 
                    

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.username AS loginname,
                    a.email
                     
                     
                FROM
                    serendipity_entries AS e
                    LEFT JOIN serendipity_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN serendipity_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN serendipity_category c
                        ON ec.categoryid = c.categoryid
                     LEFT JOIN serendipity_authorgroups AS acl_a
                                   ON acl_a.authorid = 3
                            LEFT JOIN serendipity_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read'
                                       AND acl_acc.artifact_type = 'category'
                                       AND acl_acc.artifact_id   = c.categoryid
                                      )
                    WHERE MATCH (title,body,extended) AGAINST ('finn') AND     (
                                 c.categoryid IS NULL
                                 OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL
                                      
                                    )
                               )
                     GROUP BY e.id
            ORDER BY timestamp DESC
                      LIMIT 0, 13

/ Can't find FULLTEXT index matching the column list

Code: Select all

Suche
Die Suche konnte nicht wie gewünscht ausgeführt werden. Hinweis für den Administrator dieses Blogs: Dieser Fehler kann durch fehlende Index-Schlüssel der Datenbank verursacht werden. Auf MySQL-Systemen muss der Datenbankbenutzer-Account in der Lage sein, Index-Schlüssel zu erstellen und folgende Abfrage auszuführen:

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

Die genaue Fehlermeldung der Datenbank bei der Suche lautete:

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
                    
                      FROM
                            serendipity_entries e
                 LEFT JOIN  serendipity_authors a
                        ON  e.authorid = a.authorid
                 LEFT JOIN  serendipity_entrycat ec
                        ON  e.id = ec.entryid
                             LEFT JOIN serendipity_category c
                                       ON ec.categoryid = c.categoryid LEFT JOIN serendipity_authorgroups AS acl_a
                                   ON acl_a.authorid = 3
                            LEFT JOIN serendipity_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read'
                                       AND acl_acc.artifact_type = 'category'
                                       AND acl_acc.artifact_id   = c.categoryid
                                      )
                     WHERE
                            (MATCH(title,body,extended) AGAINST('bilder'))
                             AND isdraft = 'false'  AND timestamp <= 1191096300 AND     (
                                 c.categoryid IS NULL
                                 OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL
                                      
                                    )
                               )
                    GROUP BY e.id
                  ORDER BY  timestamp DESC
                     LIMIT 4

 / Can't find FULLTEXT index matching the column list

Keine Einträge vorhanden
<pre>SELECT s.*, a.realname FROM serendipity_staticpages AS s LEFT OUTER JOIN serendipity_authors AS a ON a.authorid = s.authorid WHERE MATCH(headline,content) AGAINST('bilder') AND s.publishstatus = 1 AND s.pass = '' GROUP BY id ORDER BY timestamp DESC</pre> / Can't find FULLTEXT index matching the column list

Weitere 0 Seiten gefunden:

Code: Select all

 CREATE INDEX exits_idx ON serendipity_exits (entry_id,day,host); 
 Fehler

SQL-Befehl:

CREATE INDEX exits_idx ON serendipity_exits(
entry_id,
DAY ,
host
)

MySQL meldet: Dokumentation
#1146 - Table 'twioe_s9y.serendipity_exits' doesn't exist  


 CREATE INDEX plcomb_idx ON serendipity_permalinks (permalink, type); 
 Fehler

SQL-Befehl:

CREATE INDEX plcomb_idx ON serendipity_permalinks(
permalink,
TYPE
)

MySQL meldet: Dokumentation
#1071 - Specified key was too long; max key length is 1000 bytes  

 CREATE INDEX plugincat_idx ON serendipity_plugincategories(class_name, category); 
 Fehler

SQL-Befehl:

CREATE INDEX plugincat_idx ON serendipity_plugincategories(
class_name,
category
)

MySQL meldet: Dokumentation
#1071 - Specified key was too long; max key length is 1000 bytes 

Code: Select all

Die Wörter Ihrer Suchanfrage müssen länger als 3 Zeichen sein. Sie können versuchen, ein "*" an diese kurzen Wörter anzuhängen (z.B. s9y*) um die Beschränkung zu umgehen.
Keine Einträge vorhanden
<pre>SELECT s.*, a.realname FROM serendipity_staticpages AS s LEFT OUTER JOIN serendipity_authors AS a ON a.authorid = s.authorid WHERE MATCH(headline,content) AGAINST('s9y') AND s.publishstatus = 1 AND s.pass = '' GROUP BY id ORDER BY timestamp DESC</pre> / Can't find FULLTEXT index matching the column list

Code: Select all

(Seite 1 von 1, insgesamt 2 Einträge) <pre>SELECT s.*, a.realname FROM serendipity_staticpages AS s LEFT OUTER JOIN serendipity_authors AS a ON a.authorid = s.authorid WHERE MATCH(headline,content) AGAINST('mario barth') AND s.publishstatus = 1 AND s.pass = '' GROUP BY id ORDER BY timestamp DESC</pre> / Can't find FULLTEXT index matching the column list

Weitere 0 Seiten gefunden: