Thanks for reply - this one had us tearing out our hair for some time as it turned out that not only were files missing (ghost of file exists in users file area including KB footprint but no image in database). Then we discover that the feedback facility on a published page no longer works and no-one can upload a comment or an attached file to personal pages (although group pages not affected). All of this seemed to be connected to our recent move of server. Arghhhh!
In the end, with much digging around and some timely help from Dirk Meyer of iCampus, we discover that, in the words of Adolfo, our systems admin: - All the trouble was caused by changing the mysql user account to access the db. It happens that once mahara in installed, it generates hardwired code associated with a trigger, which includes the original mysql user name. So in case you change the mysql user account (either due to migration or site cloning...) you should mind about that detail, probably hand editing the db dump where you see something like 'trigger'. This might be something that would be useful general knowledge as changing servers is not uncommon … We're still testing that we have all functionality back but, so far it's looking good. Thanks Andrew Langford On Mar 2, 2014, at 7:35 AM, Kristina Hoeppner <1282...@bugs.launchpad.net> wrote: > This sounds like a permission issue. Was the portfolio copied or the > site upgraded? > > Could you please check in the database who the owner of the artefacts in > question is? > > -- > You received this bug notification because you are subscribed to the bug > report. > https://bugs.launchpad.net/bugs/1282831 > > Title: > files (mostly images, attached spreadsheets) yield "access denied" > > Status in Mahara ePortfolio: > New > > Bug description: > Apparently at random in one portfolio many images are missing from a > Collection of Pages. When maquerading as user clicking these files > in their file repository yields 'access denied'. There is a generic > 'image' icon there and a KB value for the file. > > In another portfolio the file is a spreadsheet and the same 'access > denied' issue occurs both when attempting to download it from the > Collection and also when trying direct access in the file area . But > not with all spreadsheets ... > > These Collections have all been submitted as secret urls to a Moodle > Assignment and yet, even when I delete the secret urls's in Mahara so > that there is nothing to link to, I still get 'access denied' > > The same effect does NOT show up in half a dozen other Collections > that other users have submitted. > > I am at a loss - is this a bug or some obscure misuse that I have not > yet detected. > > Thanks for your attention > > Mahara 1.8.1 > PHP Version 5.3.3-7+squeeze17 > mysql Client API version 5.1.72 > mysql Server version: 5.1.72-2 > > To manage notifications about this bug go to: > https://bugs.launchpad.net/mahara/+bug/1282831/+subscriptions > -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1282831 Title: files (mostly images, attached spreadsheets) yield "access denied" Status in Mahara ePortfolio: New Bug description: Apparently at random in one portfolio many images are missing from a Collection of Pages. When maquerading as user clicking these files in their file repository yields 'access denied'. There is a generic 'image' icon there and a KB value for the file. In another portfolio the file is a spreadsheet and the same 'access denied' issue occurs both when attempting to download it from the Collection and also when trying direct access in the file area . But not with all spreadsheets ... These Collections have all been submitted as secret urls to a Moodle Assignment and yet, even when I delete the secret urls's in Mahara so that there is nothing to link to, I still get 'access denied' The same effect does NOT show up in half a dozen other Collections that other users have submitted. I am at a loss - is this a bug or some obscure misuse that I have not yet detected. Thanks for your attention Mahara 1.8.1 PHP Version 5.3.3-7+squeeze17 mysql Client API version 5.1.72 mysql Server version: 5.1.72-2 To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1282831/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
