Serendipity Forums

Posted: **Tue May 10, 2005 11:55 am**

Ok, last install to .7 was great, but this version isnt going as easy ..

i followed the directions Here

moved all the files made the necessary permission changes and when i go to the admin panel i see a new iface, but no welcome, hello or update script ..

the main page of the blog isnt functioning either.. all i see is the below

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 <= '1115717198'
                    GROUP BY e.id
                    ORDER BY timestamp DESC
                     LIMIT 15

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

I dont have my categories, images, archives or anything..

Any help Garvin?

Posted: **Tue May 10, 2005 12:23 pm**

Just to add, im running php-4.3.11, so it isnt the php version..

Posted: **Tue May 10, 2005 12:27 pm**

hmmm, now im locked out of the admin panel, eventhough im using the correct username and password..

Posted: **Tue May 10, 2005 1:15 pm**

Leonard - check your serendipity_config_local.inc.php and see which $serendipity['Versioninstalled'] is in there?

If you cannot access the file via PHP write a simple script:

Code: Select all

<?php
chmod('serendipity_config_local.inc.php', 0777);
?>

and then execute that PHP script and you'll be able to edit this local file.

Regards,
Garvin

Posted: **Tue May 10, 2005 1:47 pm**

garvinhicking wrote:Leonard - check your serendipity_config_local.inc.php and see which $serendipity['Versioninstalled'] is in there?

If you cannot access the file via PHP write a simple script:
Code: Select all
<?php
chmod('serendipity_config_local.inc.php', 0777);
?>
and then execute that PHP script and you'll be able to edit this local file.

Regards,
Garvin

Well, here is the result to your question..

Code: Select all

<?php
        /*
          Serendipity configuration file
          Written on Tue, 10 May 2005 05:20:54 -0400
        */

        $serendipity['versionInstalled']  = '0.8';
        $serendipity['dbName']            = 'serendipity';
        $serendipity['dbPrefix']          = 'serendipity_';
        $serendipity['dbHost']            = 'localhost';
        $serendipity['dbUser']            = 'Lenny';
        $serendipity['dbPass']            = 'pass';
        $serendipity['dbType']            = 'mysql';
        $serendipity['dbPersistent']      = false;

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

?>

Serendipity Forums

Upgrade to .8 Didnt Take Me To Hello Screen

Upgrade to .8 Didnt Take Me To Hello Screen