Categories not working

[T]

Hello,

After an upgrade ( to the latest version) and server migration, my categories won't work properly. Whenever I click one, I get an empty page (no entries to print) and when I try to edit a category in the admin section, all fields are filled with "<" instead of category name etc.

What am I doing wrong?

Thanks in advance,

[garvinhicking]

Hi!

This happens when you have not properly executed the upgrade and have missed the database upgrade. Please have a look at the FAQ on www.s9y.org on how to upgrade and how to re-execute a failed upgrade.

Regards,
Garvin

[T]

Hmmm... I've done everything it says in there, but whenever I just move my installation (including config.local.inc) and migrate the database, I get a blank screen. The only thing to do than is to delete the config, than reinstall, after which I get another blank screen.

What worked was to make a fresh install (the latest version) and import the old database afterwards, but than I have the problem mentioned above: categories acting weird. The rest seems to work just fine.

[garvinhicking]

Hi!

What do you mean with "move your installation" and "migrate the database"?

Blank pages usually mean fatal PHP errors; check your Apache PHP/CGI -Errorlogs.

What worked was to make a fresh install (the latest version) and import the old database afterwards, but than I have the problem mentioned above: categories acting weird. The rest seems to work just fine.

Yeah, doing so is bad. Please read the FAQ on how to re-perform an upgrade.

You are not only having category problems; you will also face media management issues and several other category-related issues.

You cannot use s9y 1.3 with a 1.2 database layout; the layout changes from s9y version to version which is why you need to properly perform the upgrade procedure...

HTH,
Garvin

[gaw]

I'm also having the exact same problem- Empty page (no entries to print)

I'm sure I need to upgrade my DB, but I'm at a loss for how to do it. The FAQ just isn't getting it for me. The serendipity_config_local.inc.php file exists, but is blank- there is nothing there to modify.

I'm at http://unitelater.com if you need to look around.

Regards!

(By the way, how can I tell what version DB I am running?)

[garvinhicking]

Hi!

Try to use phpMyAdmin and execute this SQL:

Code: Select all

ALTER TABLE serendipity_category ADD COLUMN sort_order int(11);
ALTER TABLE serendipity_category ADD COLUMN hide_sub int(1);
CREATE INDEX categoryso_idx ON serendipity_category (sort_order);

[gaw]

You truly are a superhero!

By the way, I'm having a problem in the media library as well- when I click on the Library from w/in admin, the top of the screen is filled with;

Code: Select all

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 sdipity_images AS i
       LEFT OUTER JOIN sdipity_authors AS a
                    ON i.authorid = a.authorid
                        LEFT JOIN sdipity_authorgroups AS acl_a
                                   ON acl_a.authorid = 1
                            LEFT JOIN sdipity_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

/ Unknown column 'i.realname' in 'field list'

Did I hose something somewhere?

[garvinhicking]

Hi!

Ah, I thought you were upgrading from serendipity 1.2, where indeed it seems you are upgrading from an even earlier version.

The proper way to do it (like the FAQ mentions) would be to execute the upgrade (again) by editing the $serendipity['Version'] string in your serendipity_config_local.inc.php file. This file cannot be empty on your site, because else serendipity would not be able to access the database at all. It is more likely, that your FTP account does not have privileges to view this file. This can often be circumvented by the "fixperm.php" script that's also been mentioned in the FAQ:

If you tell me from which s9y version you upgraded exactly, I can try to collect the required SQL statements for you. It would make no sense if I now gather the ones from serendipity 1.1.3, if you upgraded from serendipity 0.9 for example.

Regards,
Garvin

[gaw]

I thought I had been upgraded to 1.2.1, apparently not. How do I determine what my DB version actually is?

[gaw]

I tried entering different versions in the 'versionInstalled' string. Nothing significant happened other than when I put 1.0 in, it said I had a host of sql queries to run. Apparently that's where my DB was stuck at. All is good now!