Serendipity Forums

My installation said it went OK and now I get this error...

Query failed:
SELECT


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


what can i do to fix it?

It seems you performed an upgrade frmo a previous version without executing the upgrading SQL files.

Those should get automatically detected and installed, but your User SQL account needs to have ALTER TABLE (and basically all other) Privileges to perform upgrades.

Either look at sql/db_update_0.8*.sql from your previous version and execute queries manually (by repolacing {...} placeholders) or you edit your serendipity_config_local.inc.php file, insert your old version number and then try the automatic upgrade again. It should show up as soon as you access serendipity_admin.php via browser.

Regards,
Garvin

I need some help too. I've got the same error. My old version was 0.7.1.

I tried to change the version number in the file "serendipity_config_local.inc.php" (I had to chmod the file with a script first - o.O). I tried the automatic upgrade again after that. But serendipity showed me the "Welcome back"-Screen with the version number 0.7.1 - no automatic upgrade.

I can't find a sql/db_update_0.7.1_0.8.sql file, too?

Please help me! I think I am not a n00b, but I can't upgrade my s9y...

--
mfG Björn

Björn,

if you get a welcome screen with 0.7.1 message, you did not extract the 0.8 release files in your serendipity directory. Please check if you overwrote all files frm the 0.8 release bundle; you can check if the files sql/db_update_0.8* exist.

There is no db_update_0.7.1 sql file, because DB upgrade have only been made starting from 0.8-alpha2 or so. Those files should exist!

Regards,
Garvin

So if the MySql database is hosted on the provider's site (in my case aplus.net) then I can't upgrade to the .8 release? I'm a newbie (*hides*) but have spent hours on this forum trying to get my version upgraded because I love all of the new features?

Guest,

you can only upgrade your Serendipity version if you have FTP access to the server where your Serendipity installation is in, and you have a working Serendipity setup which can access the MySQL database.

In this case follow our upgrade guideline at http://www.s9y.org/63.html

Regards,
Garvin

Thank you Garvin!

Robyn wrote:My installation said it went OK and now I get this error...

Query failed:
SELECT
(...)
/ Unknown column 'a.realname' in 'field list'

what can i do to fix it?

By any chance: is your PHP version 4.1.x?

Hello,

Is there a posiblity to write a patch?

i have the same problem.

greetings Me

mini me wrote: Is there a posiblity to write a patch?
i have the same problem.

As long as Garvin does not ACK the brokeness of the upgrader on PHP 4.1 (as this is only my uneducated quess) and provides a fix, you will have to upgrade your PHP to 4.3, which is of course a good idea nevertheless.

Grüße,
Sven.

We are not going to provide a patch for this, as it is a PHP issue. This also forces users to upgrade to PHP 4.3, which is a VERY good thing in many other issues, so we encourage this upgrade.

I'm realy sorry for the inconvenience, but I think this is the best possible way. I updated the NEWS on www.s9y.org to tell about this issue.

Thanks a lot for your feedback,
Garvin

I will upgrade mysql

first thank you for your help

greetings Me

Mini me: In fact you should upgrade PHP and not MySQL!

Best regards,
Garvin

Patch:

update table: weblog_tabelauthors

Add field type: Varchar(128) -> realname


It works for now, have not tested it for the entire site......

Mini Me

Mini me, by doing this you are patching the most obvious issue. But there are MANY many other database upgrade from 0.7.1 to 0.8 which you are now missing and which will create other woes.

The only real solution is to upgrade PHP to at least 4.2 (I think) and then do the serendipity upgrade again; or patch the ISUP2DATE definition like posted earlier in this topic.

Regards,
Garvin