Server 500 error - newbie installation

Thorin · Post by **Thorin** » Thu Mar 03, 2005 5:21 pm

whereis php

whereis php
php: /usr/bin/php /etc/php.ini /usr/lib/php /usr/share/php /usr/share/man/man1/php.1.gz

cat .htaccess for serendipity

Code: Select all

# BEGIN s9y
DirectoryIndex /[myusername]/serendipity/index.php
php_value session.use_trans_sid 0
php_value register_globals off
<Files *.tpl>
    deny from all
</Files>

<Files *.sql>
    deny from all
</Files>

<Files *.inc.php>
    deny from all
</Files>

<Files *.db>
    deny from all
</Files>

# END s9y

cat .htaccess for parent directory

Code: Select all

cat .htaccess
cat: .htaccess: No such file or directory

Here's the results from phpinfo http://carmelite.homedns.org/~thorin/version.html

oxygenws · Post by **oxygenws** » Fri Mar 04, 2005 12:38 am

Dear Thorin,

i can't find any bad configuration, the last solution is....
rename that .htaccess file (for testing) to something else.

regards

Post by **garvinhicking** » Fri Mar 04, 2005 12:08 pm

I think Thorin's problem is just that his Apache VirtualHost has set 'AllowOverride NONE' sett, but we require 'AllowOverride ALL' for the .htaccess directive "DirectoryIndex" to execute properly.

So the only fix is to either manually edit .htaccess (and re-edit if you change configuration setting), or to edit the Apache configuration for the VHost.

Regards,
Garvin

Thorin · Post by **Thorin** » Fri Mar 04, 2005 6:15 pm

garvinhicking wrote:I think Thorin's problem is just that his Apache VirtualHost has set 'AllowOverride NONE' sett, but we require 'AllowOverride ALL' for the .htaccess directive "DirectoryIndex" to execute properly.

So the only fix is to either manually edit .htaccess (and re-edit if you change configuration setting), or to edit the Apache configuration for the VHost.

Regards,
Garvin

Thanks for the help. Sorry to be so slow with this, but Apache configuration isn't really my forte. Could you tell me exactly what you want me to change, what to, and where it is please.

Thanks.

oxygenws · Post by **oxygenws** » Sat Mar 05, 2005 8:01 am

find "AllowOverride" in your httpd.conf file.
change the value in front of it to "ALL"
restart apache.

Thorin · Post by **Thorin** » Sat Mar 05, 2005 11:47 am

oxygenws wrote:find "AllowOverride" in your httpd.conf file.
change the value in front of it to "ALL"
restart apache.

That's what I thought garvin was suggesting I did. It's just when I tried it I still got the Server 500 error! I've just tried renaming my .htaccess file in the serendipity directory to something else to see what happened, and I got this error:

Code: Select all

SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_orderQuery failed:

SELECT 
                    

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.author,
                    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 <= '1110018919'
                    GROUP BY e.id
                    ORDER BY timestamp DESC
                     LIMIT 15

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

Does that give any further clues?

Post by **garvinhicking** » Sat Mar 05, 2005 1:26 pm

Now you're heading in the right direction. Sadly the last Serendipity snapshot you fetched was a bad one, thus you are missing a column update now.

I suggest you to download the -beta2 release (which will be available in a few minutes), unpack that, then edit your serendipity_config_local.inc.php and set your versionInstalled to '0.8-alpha11' - then the proper upgrade will be run again to add the missing 'Realname' column to your database!

Regards,
Garvin

Thorin · Post by **Thorin** » Sat Mar 05, 2005 4:35 pm

IT WORKS!!!!

Thanks all for your help.

Garvin's last bit of advice fixed it!

Post by **garvinhicking** » Sat Mar 05, 2005 4:50 pm

Thorin: Great. I'm really glad that it finally works out and you had the will to fix it. Now I hope you'll enjoy Serendipity!

Have a nice weekend,
Garvin.