Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...After upgrade, all files are missing from databaseAfter upgrade, all files are missing from database
Previous
 
Next
New Post
12/13/2006 2:44 PM
 
I wanted to update this in case anyone stumbles across this in the future.

After upgrading, all my folders were jacked, and all my files were missing from my files table.  After manually fixing the folders table (removing duplicate entries, orphaned entries, and entries ending with double slashes), I managed to get my folders to show up in the file manager.  However, the file synchronization job was not adding in the files.

After digging through the source for a while, I figured out what I needed to do.  To fix this, I had to change the "lastupdated" field in the folders table to a date that would be further in the past than the timestamp of any of the files in the folder.  DNN checks the date of the folder in the database, and will only add files that have been added since that date.  I guess when the first file synch failed for whatever reason, it still changed the last updated date, so that every file synch after that just skipped all my files without adding them.

On the next file synch, all 3000+ files were added to the database with no problem.
 
New Post
12/15/2006 7:05 PM
 

This sounds really good, but I am afraid to try it. My file system and permissions for admins are still botched since I cleared out my folders and files tables and tried a re-synch with recursive after 4.3.5 messed things up. I had many instances of image modules, for example, displaying apparently randomly different images, and other doc links anchored to the incorrect files, and had to comb through portals looking for such instances and correcting them.

I'm afraid it will happen all over again!

It may be that my DNN (I'm now at 4.3.6) stepped on itself because I had auto-synch files checked while also doing a manual re-synch; I don't know. At this time I have re-synch in the scheduler turned off (it failed with "object not found" errors each time), and auto-synch turned off, and I have been migrating small portals manually to a new install. Couldn't use portal export to template because of the same file system errors.

However, I have a couple of portals that will be a huge and very difficult task to migrate/rebuild in this way. If I were confident that changing all the date in the folders table to be a year or two in the past, and re-synching, and if that would fix all my problems, I'd be a very happy camper.

It sounds like this is the fix - my folders table has recent dates in most instances. Yet I understandably (I think) am hesitant.

Could I hear some more thoughts on this?


pmgerholdt
 
New Post
12/16/2006 6:19 PM
 

Well, I bit the bullet ... backed up the db, and then updated the folders table so that LastUpdated date for each record was equal to the min(LastUpdated) date - sufficiently historical. Then resynched files recursive.

Looks like it did good - still haven't investigated thoroughly. I think that files for folders that were listed in the folders table are now all in the files table.

But there are a couple portals not represented in the folders table at all, and doing a recursive re-synch did not add them. <?>

Also if I go to the site settings for portals I am seeing that they do not have skins, containers or logos set anymore - it's all 'none selected' as with a new site.

Even though that is the case, the correct skins, containers and logos seem to be displaying on the portals in question. Rather boggling. Unless it's all just cached somewhere out in internet space and catch up later. But I did a ctl-F5 and the pages still look right.

Hmmm ... well, if I log into the default portal, and view portals from there, and look at settings for each portal, they all show to have the same skin as the default portal, once I re-selected the default portal skin. But if I log into the portal itself, and then view site settings, the correct skins, containers and logos are set there.

Something is still very much not right ...


pmgerholdt
 
New Post
12/18/2006 8:51 AM
 

Can someone tell me how to get folders into the folders table for portals whose folders are not represented at all?

Also - why would viewing site settings from Host | Portals make each portal look like it has the same settings as the host portal rather than show those that are correct for the portal (and correctly displayed when logged on to that portal and viewing from Admin | Site Settings)?

Thanks,

Mike


pmgerholdt
 
New Post
12/18/2006 7:41 PM
 

And admins on the portals are still getting the message "You are not allowed to see files" and are not able to upload files.

No answers to this?


pmgerholdt
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...After upgrade, all files are missing from databaseAfter upgrade, all files are missing from database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out