Serendipity Forums

Code: Select all

SELECT  i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
                     a.realname AS authorname
                     FROM serendipity_images AS i
       LEFT OUTER JOIN serendipity_authors AS a
                    ON i.authorid = a.authorid
                        LEFT JOIN serendipity_authorgroups AS acl_a
                                   ON acl_a.authorid = 1
                            LEFT JOIN serendipity_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read'
                                       AND acl_acc.artifact_type = 'directory'
                                       AND acl_acc.artifact_index = i.path
                                      )

                       WHERE 1=1  AND     (
                                 i.path IS NULL OR
                                        acl_acc.groupid IS NULL
                                 OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL
                                      
                                    )
                               )
                     GROUP BY i.id
            ORDER BY i.date DESC  LIMIT 0, 8

/ Unknown column 'i.realname' in 'field list' 

Code: Select all

ALTER TABLE serendipity_category ADD COLUMN sort_order int(11);

/ Duplicate column name 'sort_order'

ALTER TABLE serendipity_category ADD COLUMN hide_sub int(1);

/ Duplicate column name 'hide_sub'

CREATE INDEX categoryso_idx ON serendipity_category (sort_order);

/ Duplicate key name 'categoryso_idx'

ALTER TABLE serendipity_suppress CHANGE ip ip VARCHAR(65) NOT NULL;

/ Table 'serendipity.serendipity_suppress' doesn't exist