I can't seem to upgrade

[Sarpy Sam]

I asked the question here

http://www.s9y.org/forums/viewtopic.php ... highlight=

on how to upgrade from a 0.8 version to a newrer 0.8 version.

I followed the instructions given here

http://www.s9y.org/63.html

followed the instructions up until

open the Admin panel of your blog, say hello to our update script and let it do its work.

Where is the update script? I have opened the admin panel (I think) but all that is there is normal admin stuff and nothing about upgrading. If I try to go to my blog I get the following.

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 <= '1109905801'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Unknown column 'a.realname' in 'field list'

I give, where am I going wrong? It doesn't seem very easy to me. This is my 5th attempt at this with no luck.

[garvinhicking]

It seems you grabbed a snapshot from an in-between buggy CVS timestamp. Because the snapshots are created daily on a fixed time it may happen that during that time the snapshot was not fully stable.

In your case you should upgrade to the latest -beta1 release. You may need to at the 'realname' column manually to your SQL tables. In MySQL you can create that via:

Code: Select all

ALTER TABLE serendipity_authors ADD realname VARCHAR(255) NOT NULL FIRST;
UPDATE serendipity_authors SET realname = username;

I am sorry for your confusion.

Regards,
Garvin

[kho]

Hi,

I tried to upgrade from 0.7.1 to 0.8 beta 1 as announced. Followed the instructions...

After login to my blog nothing happened. No update script in the admin panel.. I got no error mesages, the admin panel says, I am using the version 0.7.1...

Any suggestions, what to do??

Thanks and greetings form germany, kho

[garvinhicking]

What URL do you have? I think you haven't unpacked the 0.8 tarball correctly -. check if in your serendipity directories there is another serendipity subdirectory - if yes, that one should not be there, thus move its content to your serendipity root dir

Regards,
Garvin

[kho]

The Url is: http://kho-im-www.de/blog

It´s just a test installation for upgrading. My real blog is http://k-ho.de/blog

There is only one serendipity root dir. I copied all files after unpacking tar and zip direct into the rootdir of serendipity...

kho

[garvinhicking]

It really seems you are missing the files of Serendipity 0.8 - I could, for example, not request http://kho-im-www.de/blog/templates/def ... ground.jpg even though that file should exist!

Paste a directory listing of your files - or make sure you really extracted the files correctly! Maybe you had errors with write permissions?

Regards,
Garvin

[kho]

There is also no directory that you described in my local unpacked directories. I got the zip-file yesterday from the download site.

I unpacked it in a seperate directory and copied all files directly in the serendipity root in the web... I got no errors with write permissions...

Properties of the local unpacked update: 530 files, 93 directories...

Regards, kho

[garvinhicking]

There definitely is something wrong then. I have 748 files in 110 folders.

Please try and download the .tar.gz file bundle!

Regards,
Garvin

[garvinhicking]

There definitely is something wrong then. I have 748 files in 110 folders.

Please try and download the .tar.gz file bundle!

Here's a file listing: http://rafb.net/paste/results/eNZj0x91.html

Regards,
Garvin

[kho]

seems that I have to try the upgrade again... but I don´t know what was wrong exactly..

Anyway, thank´s for your support!

Regards, kho

[Sarpy Sam]

I'm back finally. I downloaded 0.8 beta1 and tried the upgrade again. (I see there is a beta 2 and will try it next) Having the same problems. I log into admin and there is no upgrade script like the instructions say. This time at least the admin screen says its 0.8 beta1 so that's progress. I get the same set of errors when trying to look at my blog.

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 <= '1110076746'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Unknown column 'a.realname' in 'field list'

Can somebody please help me. I would really like to upgrade.

[garvinhicking]

Sam, the best thing would be to edit your serendipity_config_local.inc.php, and set the $serendipity['versionInstalled'] variable to '0.8-alpha11' - then open up your http://yourblog/ again, and then the installer should create the missing references!

Regards,
Garvin

[Sarpy Sam]

That fixed it and upgrade is done. Thanks a lot. One quick thing, when doing things this way make sure serendipity_config_local.inc.php is writable since the upgrade changes it. I didn't and had to go in and edit it right when i was done. Thanks again.

[James]

I think I am stuck on the same problem. However, I cannot EDIT the serendipity_config_local.inc.php file, since it is set at 700 permission. I am unable to download the file from my server (via FTP), and I cannot CHGMOD the permissions via my FTP client or cpanel file manager.

I am stuck!

Any other suggestions on how to get around this?

If I am able to completed wipe all Serendipity files from the server, will the install script from the latest beta be able to work with my existing database setup?

Thanks for any guidance,
James

[garvinhicking]

James, you should talk to your hoster and kindly ask them to reset hte permissions for the file to set them to 777. Then you can remove or edit the file.

It's format is quite easy, you could create the file manually:

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']            = 'root';
	$serendipity['dbType']            = 'mysql';
	$serendipity['dbPersistent']      = false;

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

You just need to fill in your SQL userdata. As well, if you unpack the s9y.tgz file to a different directory, you can just place the serendipity_config_local.inc.php from above to your new directory and adjust the SQL account data. Then you'll be able to access your existing data WITHOUT actually installing the fresh s9y directory.

You'll need to modify/adjust the paths in s9y Configuration though for the new s9y path you copied the files to.

Regards,
Garvin