Page 1 of 2
upgrade woes 5.1 -> 8-b2
Posted: Sat Mar 12, 2005 7:50 am
by Shanness
Hi,
I've finally decided to upgrade my S9 installation (busy, but getting sick of the insane amount of comment spam I've been getting and deleting).
Anyhow, I dropped the new version over the old one, wen't to the blog, and get this.
I take it that somehow S9 didn't notice that I'd upgraded and run the upgrade scripts.
NOTE : I'm running on my ISP's webserver, so only have FTP access (and PHP of course). Also, I'm not POSITIVE I'm running 5.1, could be 5.0?? Don't know how to check.
I have a (local) backup of both the S9 directory and the database (thank heavens for phpMyAdmin!)
Thanks,
Craig
Code: Select all
Query 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 <= '1110609466'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Table 'db0293650406.serendipity_entrycat' doesn't exist
Re: upgrade woes 5.1 -> 8-b2
Posted: Sun Mar 13, 2005 1:43 pm
by garvinhicking
How did you upgrade? Say your blog is
http://yourblog/serendipity/, did you call that URL straight after you uploaded the new s9y version?
It should then show you the upgrade panel immediately. You didn't manually modify any files, right?
Try to edit serendipity_config_local.inc.php and set the versionInstalled directive to "0.5".
Regards,
Garvin
Posted: Thu Mar 31, 2005 3:21 pm
by James
This is the biggest problem. I am pulling out my hair with a similar upgrade problem from 0.701 to the latest 0.8-beta4.
The serendipity_config_local.inc.php file is "locked" to me. That is, it is set to 605 (i think), and I can not therefore download it to view or modify its contents. I cannot chgmod with FlashFXP or download the file.
I have since deleted all the Serendipity install dir contents, but it seems there are files mysteriously staying behind as I cannot completely delete the directory itself (permission denied).
There is certainly some level of corruption occuring. I will have to contact my server host to delete the dir for me...
I have no idea how my blog is currently running since I have deleted all the files (none visible in FlashFXP). When I view the files in Cpanel there are a host of phantom files that refuse to go away...
Re: upgrade woes 5.1 -> 8-b2
Posted: Sun May 08, 2005 5:29 am
by Guest
Hi Garvin,
Sorry it took me so long to get back onto this.
I checked that directive, and it was set to 0.5-CVS. I changed it to 0.5, but it has made no difference. I still get the same error above.
I have logged in to phpMyAdmin, and I definately don't have that table ('db0293650406.serendipity_entrycat')
Is there some way to manually trigger the upgrade process, as it seems that something about my setup is making it not work. My blogs been down for a few months now, and I really should fix it.
Thanks,
Craig
garvinhicking wrote:How did you upgrade? Say your blog is
http://yourblog/serendipity/, did you call that URL straight after you uploaded the new s9y version?
It should then show you the upgrade panel immediately. You didn't manually modify any files, right?
Try to edit serendipity_config_local.inc.php and set the versionInstalled directive to "0.5".
Regards,
Garvin
Posted: Sun May 08, 2005 5:31 am
by Shanness
Oops, forgot to log in first, so can't edit my original post.
Anyhow, no, I didn't edit any files during or after the upgrade process.
Craig
Posted: Mon May 09, 2005 2:08 pm
by garvinhicking
It can be that you are running an older PHP 4.1 version, is that true?
You should really upgrade PHP to 4.3.x becaues many important PHP fixes have been made. There would be a workaround for forcing an upgrade in Serendipity, but I really do not suggest this way. It would leave your blog hackable because of the PHP errors...
Regards,
Garvin
Posted: Mon May 09, 2005 2:33 pm
by Shanness
Hiya Garvin,
PHP Version 4.1.2
It's on my ISP's webserver... Not much I can do about it unfortunately.
I assume my blog is still hackable anyhow? My blog doesn't work at all, but I'm still getting shitloads of comment spam (my main reason for upgrading in the first place)...
Anyhow, I think I'll just have to try the workaround if you wouldn't mind, I can't see any other way around it.
I'll also start hassling my ISP, but I'm probably jumping ship in a couple of months when ADSL2+ becomes available elsewhere.
Thanks,
Craig
Posted: Mon May 09, 2005 3:22 pm
by garvinhicking
You can temporarily edit your serendipity_config.inc.php and search for the define('ISUP2DATE'). Set this to define('ISUP2DATE', false) and then the s9y config will run. After you've applied the config you can set is2update to the original statement again.
But as I mentioned, PHP 4.1.2 will definitely be a pain in your ISPs back.
Best regards,
Garvin
Posted: Fri May 13, 2005 3:20 am
by Guest
Hi Garvin,
Thanks for the info.
Despite the lack of any errors or warning on the "are you sure" page, when I said to go ahead, I got the following problems, and now get 500:Internal Server Error back from my blog...
Any ideas?
I do have a backup of my database, and I THINK I must have a backup of the 0.5-CVS version of s9y.
Thanks,
Craig
-
CREATE INDEX date_idx ON serendipity_entries (timestamp);
/ Duplicate key name 'date_idx'
CREATE INDEX mod_idx ON serendipity_entries (last_modified);
/ Duplicate key name 'mod_idx'
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_layout.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_layout_table.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_entries_overview.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_rss_exchange.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_admin_category.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_admin_entries.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_admin_images.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_admin_installer.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_admin_interop.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_admin_overview.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_admin_plugins.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_admin_templates.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_functions_config.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_lang.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_plugin_api.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_db.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_db_mysql.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_db_postgres.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_db_sqlite.inc.php.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/serendipity_config_local.tpl.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/INSTALL.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/LICENSE.
Can't write to file /swiftdsl/0293650406/shanness/html/serendipity/templates/default/layout.php.
serendipity_config.inc.php,v 1.152 2005/03/05 11:42:25 garvinhickin
Posted: Fri May 13, 2005 12:21 pm
by garvinhicking
IF you get a 500 Server error, please paste your contents of your .htaccess file and/or temporarily remove it. Some settings inside there seem to fail on your server.
Regards,
Garvin
Posted: Sat May 14, 2005 1:48 pm
by Guest
Moving my .htaccess file out of the way temporariliy gave me this strange error :
Serendipity has detected that your configuration is currently installed with version 0.8-beta2, however serendipity itself is installed as version 0.8-beta2, you need to upgrade!
Is it safe to do as suggested, and upgrade again?
Of course, I'd chmod all the "can't write" files listed below first.
What do you think?
Craig
P.S. thanks for the help Garvin, and here's my .htaccess.
P.P.S. I've put .htaccess back for for the moment.
lftp xxxx@xxxx:serendipity> more .htaccess.bak
# BEGIN s9y
DirectoryIndex 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
Posted: Sat May 14, 2005 2:29 pm
by garvinhicking
If you get this upgrade message there is something serously wrong.
Did you make sure you installed the 0.8 final release? Because your serendipity_config.inc.php file is still the 0.8-beta2 one. Maybe by uploading the final release you did not overwrite all files?
Regarding the .htaccess file: remove the two php_value pairs in the htaccess file, then you should not get the internal error!
Regards,
Garvin
Posted: Sat May 14, 2005 6:26 pm
by Shanness
Hi Garvin,
No, I didn't install 0.8 final, as per the thread subject, it was 0.8b2 (on March 12th), coming from version 0.5-CVS
I'm at a bit of a loss with how to proceed now, and think I had better leave my 500 errors intact until I've completed the upgrade.
At the moment, I have the choice between 500 errors, and leaving upgrading to any visitor.
Should I click the upgrade link (from 0.8b2 to 0.8b2) after chmoding the files? Do you have any other suggestions?
Craig
<edit> Sorry about the delay with responses, even though I'm watching this thread, I'm not getting emailed when you respond... </edit>
Posted: Sun May 15, 2005 1:29 am
by garvinhicking
You should definitely install the 0.8 final release and then upgrade! Do not do anything with the 0.8-beta2 thingie.
It is suggested to create a .htaccess file like suggested on
http://www.s9y.org/37.html tokeep other users from upgrading your "in-between-state" s9y.
Regards,
Garvin
Posted: Sun May 15, 2005 12:50 pm
by Shanness
<edit> This post has been editted </edit>
Hey Garvin,
I uploaded 0.8 final over the top of the broken blog, and everything seems to be working!!
Thanks,
Craig
P.S. I had to comment out the follow bits of the root .htaccess to get rid of the 500. This shouldn't cause any problems I hope??
Thanks again Garvin, you rock! Oh, and your wish list is all in german, I'm not sure I can safely drive Amazon in german.
# DirectoryIndex index.php
# php_value session.use_trans_sid 0
# php_value register_globals off