Help please!
I have upgraded to 4.7.0 twice and reverted to 4.6.2 once so far due to this.
The site will run for a day or so, then the logo and any media files (gif, jpegs) disppear. (all users)
On the admin site settings page I can't access the 'icon' settings - ie to set the logo folder and media file.
The same happens trying to access any media module settings.
In red I see "You do not have permissions to see the files"
I have found that by going into filemanager I can set the 'view' access for all users to ticked for the root folder and contents, but they they get reset the next day.
In the mean time I have access to the site settings page and all media modules and can reset the logo and files. (I have to do this because the files default to the first in the list). The display is fine for about a day, then the whole thing locks out again.
I have not found a way to stabilise this other than reverting to 4.6.2. Thanks to Lee for his knowhow in backing up.
I have tried using SQL to study what is going on and took snapshots after upgrading the second time and after seeing the problem reappear. I notice a lot of renumbering of Ids going on.
Am I being a plonker
in using "Select * from vw_....." to look at views? (Does this in any way change the underlying tables or views used by the application, thereby making things worse
)
Any idea what is going on here, and how do I fix it?