Server 500 error - newbie installation

Having trouble installing serendipity?
Thorin
Regular
Posts: 8
Joined: Wed Mar 02, 2005 6:40 pm
Location: Coventry, UK

Post by Thorin »

whereis php

Code: Select all

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
Regular
Posts: 148
Joined: Thu Jan 20, 2005 11:20 am
Location: Iran
Contact:

Post by oxygenws »

Dear Thorin,

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

regards
My Blog, powered by s9y is http://oxygenws.com/blog/
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Thorin
Regular
Posts: 8
Joined: Wed Mar 02, 2005 6:40 pm
Location: Coventry, UK

Post by Thorin »

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
Regular
Posts: 148
Joined: Thu Jan 20, 2005 11:20 am
Location: Iran
Contact:

Post by oxygenws »

find "AllowOverride" in your httpd.conf file.
change the value in front of it to "ALL"
restart apache.
My Blog, powered by s9y is http://oxygenws.com/blog/
Thorin
Regular
Posts: 8
Joined: Wed Mar 02, 2005 6:40 pm
Location: Coventry, UK

Post by Thorin »

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?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Thorin
Regular
Posts: 8
Joined: Wed Mar 02, 2005 6:40 pm
Location: Coventry, UK

Post by Thorin »

IT WORKS!!!! :shock: :D

Thanks all for your help.

Garvin's last bit of advice fixed it!
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

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.
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply