* Drupal 5.2
* PHP 5.1.6
* MySQL 5.0.27
* MySite 5.x-2.11

The user mysites on ElectricTeaParty.net refuse to show any content. You can add posts by type, by user, add user profiles, etc., but the mysite invariably states "You have no content saved." when viewed. Please feel free to ask for any more details you need, or to log into the site (using drupal ID, openID, facebook, or Windows Live ID) to test it out.

Many thanks for all your hard work on MySite,
Adrian

Comments

agentrickard’s picture

That's very, very weird. Hard to debug from here. I've never seen that behavior before.

A few questions:

1) Do you have Drupal's page cache turned on?

2) Do you have MySite's cache turned on?

3) As a user, what MySite permissions do I have?
http://electricteaparty.net/mysite/94/view

4) Do you have any default content set for users?

agentrickard’s picture

I think I figured this out by poking around.

I suspect that you need to run update.php. I just noticed that you upgraded from a previous version, so it is likely that your database tables are not up-to-date.

If you go here: http://electricteaparty.net/mysite/94/edit/style, you'll see that 'Red' and 'Blue' styles -- which were deprecated in the 5.x.2 series -- are still available.

This suggests that you updated the source files from 4.7.x to 5.x.2 but did not run the database upgrade script. If you didn't update the database, then the behavior we're seeing would make more sense.

I would also suspect that your logs are full of MySQL errors that say things like 'column does not exist'.

For more details, see section 2 of INSTALL.txt.

agentrickard’s picture

Status: Active » Postponed (maintainer needs more info)
canadrian’s picture

I have run update.php many times. :) I update my all my modules on a regular basis. However, I usually just un-tar the new version over top of the old version. Could this be causing the problems I'm seeing? Another explanation that I've asked about in a forum post is that it may be a question of access rights, possibly as a by-product of the OG modules. I am also having problems displaying forum posts in the forum listing, and displaying blog entries to anyone other than the creator. I'm wondering if nodes are refusing to display due to some sort of vestigial access control. (And yes, I did disable the access restrictions in the settings before I uninstalled the OG modules, but maybe it didn't do its job properly).

agentrickard’s picture

It very possibly could be access rights. MySite respects node access set by other modules.

That might explain some of the behavior. To fully reset your node_access table, you need the first row only.

 0 0 all 1 0 0
agentrickard’s picture

I didn't answer your other questions.

I don't think that untar-ing the new files should pose a problem (though red.css and blue.css should be deleted).

I think access_control is a definite possibility. I would reset node_access to the default state.

Otherwise, I can't really debug your specific problem without looking in your database.

canadrian’s picture

Hmm, odd. Anyway, I reset my node_access table as you described. It didn't fix the MySites, but maybe it will help with some of the other issues. I uninstalled and reinstalled the MySite module, and now it works. So I guess at some point there must have been an incomplete upgrade or something...

Thanks for your support! Keep up the great work on this outstanding module!

agentrickard’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)

Thanks. Note that I just rolled a minor patch, so there will be a new release pending.

http://drupal.org/files/issues/cols.patch

Thanks for hanging in on this. Sorry you had to delete data.