1. 

   brad@foreverybody, Blocked

   we are having a problem storing reports in folders. The folders are regular folders, that is the "hidden from normal users" option is not ticked and indeed the normal users can see the folders. The problem is that they cannot access the folders; clicking on a folder makes the browser load the script but the view never advances to inside the folder. The bread crumbs on the top left always say myDBR and never anything else.

   In the meantime we are working around the issue by storing all reports in the root folder, obviously not ideal in the slightest.

   help?
   myDBR is 1.5 running on windows server 2000 with PHP 5.2.8
2. 

   myDBR Team, Key Master

   Brad,
   sounds like myDBR believes that the folder is a admin-only folder. This only happens with normal users? Can you repeat that also with a newly created folder?

   Could you show the folder structure using query:

   select * from mydbr_folders;
   --
   myDBR Team
3. 

   brad@foreverybody, Blocked

   output of select * from mydbr_folders

   1 NULL Home 0 1
   2 1 Admin reports 1 1
   3 2 Drill reports 0 1
   4 1 HR 0 1
   5 1 test 0 1

   test is the folder i just created and it behaves the exact same as other folders. normal users can see the folder but mydbr doesn't navigate into the folder when clicked. admin users can navigate any folder normally.

   here is more info on our setup:

   tested on both firefox 3.5.6 safari 4.0.4. same result.
   using mssql server 2005 as the DB
4. 

   myDBR Team, Key Master

   Brad,
   this is a problem with MS SQL Server's 1.5.0 version. You can download a fix here:

   MS SQLServer 1.5.0 folder fix

   The fix contains corrected stored procedure which you need replace in myDBR's database (default 'mydbr').

   Sorry for the time spent on this one.
   --
   myDBR Team
5. 

   brad@foreverybody, Blocked

   don't worry about it; in fact you guys are extremely quick and responsive. that patch worked like a champ!

   Overall fantastic software. great job.

Reply

You must log in to post.