I can't seem to upgrade
I can't seem to upgrade
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.
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.
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: I can't seem to upgrade
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:
I am sorry for your confusion. ![Sad :(](./images/smilies/icon_sad.gif)
Regards,
Garvin
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;
![Sad :(](./images/smilies/icon_sad.gif)
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/
# 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/
where to say hello to update script??
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
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
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: where to say hello to update script??
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 ![Smile :)](./images/smilies/icon_smile.gif)
Regards,
Garvin
![Smile :)](./images/smilies/icon_smile.gif)
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/
# 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/
..
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
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
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: ..
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
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
# 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/
# 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/
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
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
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
There definitely is something wrong then. I have 748 files in 110 folders.
Please try and download the .tar.gz file bundle!
Regards,
Garvin
Please try and download the .tar.gz file bundle!
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/
# 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/
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
garvinhicking wrote: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
# 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/
# 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/
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.
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.
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
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
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/
# 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/
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
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
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
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:
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
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'll need to modify/adjust the paths in s9y Configuration though for the new s9y path you copied the files to.
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/
# 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/