Serendipity Forums

Code: Select all

<?php
	/*
	  Serendipity configuration file
	  Written on Thu, 07 Apr 2005 16:03:58 +0200
	*/

	$serendipity['versionInstalled']  = '0.8-beta6';
	$serendipity['dbName']            = 'serendipity';
	$serendipity['dbPrefix']          = 'serendipity_MERGE_';
	$serendipity['dbHost']            = 'localhost';
	$serendipity['dbUser']            = 'root';
	$serendipity['dbPass']            = 'password';
	$serendipity['dbType']            = 'mysql';
	$serendipity['dbPersistent']      = false;

	// End of Serendipity configuration file
	// You can place your own special variables after here:
?>

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.email

                    , e.body, e.extended
                    
                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
                    
                    WHERE isdraft = 'false' AND e.timestamp <= '1115350525'
                    GROUP BY e.id
                    ORDER BY timestamp DESC
                     LIMIT 10

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