Upgrade Attempt Works after copying config file (resolved)

[richlew]

Close as I could come to the upgrade instructions leaves most everything working but none of the good signs and a couple of bad indicators:

The warning "Be sure not to delete or modify the .htaccess or serendipity_config_local.inc.php files" was misinterpreted badly and I did not copy the upgrade package "serendipity_config.inc.php file. Once I copied that file, everything went smooth as silk and no error were reported. Everything worked!

Trying to Manage Users results in:

Warning: Invalid argument supplied for foreach() in /var/www/html/serendipity/include/admin/users.inc.php on line 188

Trying to Manage Media results in this message:

SELECT i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
a.realname AS authorname
FROM serendipity_images AS i
LEFT OUTER JOIN serendipity_authors AS a
ON i.authorid = a.authorid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 2
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'directory'
AND acl_acc.artifact_index = i.path
)

WHERE 1=1 AND (
i.path IS NULL OR
acl_acc.groupid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY i.id
ORDER BY i.date DESC LIMIT 0, 8

It looks like some MySQL issue to me.

The administration panel never has the "click here to complete upgrade" message I expected and the version in the config file was left alone - should I have changed that?

Probably the most important piece of information: I ended up copying directly over the files in the directories. I expected that an upgrade system would be available when the Administrative Panel was opened. It was not. Users don't see a problem, I believe. I've detailed the effiects above.

Thanks in advance for what seems to be database update related.

[garvinhicking]

Hi!

How exactly did you try to do the update? Maybe you can explain it in full steps from the beginning to the end?

Did you go like outlined in the FAQ on www.s9y.org? There also stands an information on how you can re-execute the upgrade.

When you login to the backend, which version number do you see of s9y at the bottom of the screen? IT should tell you the upgraded version number, not the old version number. If it displays the old number, you didn't properly upload the new files completely.

Best regards,
Garvin

[richlew]

The warning "Be sure not to delete or modify the .htaccess or serendipity_config_local.inc.php files" was misread and misinterpreted badly and I did not copy the upgrade package "serendipity_config.inc.php file. Once I copied that file, everything went smooth as silk and no errors were reported. The upgrade script asked for permission to run SQL scripts and following the single click everything worked.