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,
Categories not working
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Categories not working
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
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
# 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/
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.
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.
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
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.
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
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.
Yeah, doing so is bad. Please read the FAQ on how to re-perform an upgrade.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.
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
# 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/
Same problem...
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?)
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?)
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Same problem...
Hi!
Try to use phpMyAdmin and execute this SQL:
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);
# 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/
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;
Did I hose something somewhere?
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'
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
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
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
# 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/