Jump to content

Excel export files won't open in Excel & security warning


PeteSE4

Recommended Posts

Hi all,

I've just installed a fresh download of Revive on a dedicated server. So it's Revive 5.3.0 running on Ubuntu 18.04 (x86_64) running PHP 7.4. Everything seems to be working apart from two things. Firstly, downloaded Excel reports won't open in Excel... well, it 'opens' it, but it doesn't display (and if I try in Apple Numbers it says 'unsupported version of Excel'). Opening the file in a pure text editor shows about a page of what could be XLS format, followed by what appears to be the HTML for Revive's homepage. Not an Excel expert, but pretty sure that shouldn't be there.

Is there a way to export in CSV or XLSX? Or just get XLS working? I'm pretty familiar with PHP so if anyone with knowledge of the inner workings of the export routine could point me in the right place I may have a stab at writing that myself.

Second problem is more of a niggle, but I know once I let this server loose on the user he's going to complain about it. Default page after login takes me to the security maintenance page complaining the browser can fetch files it shouldn't, for example var/cache/README.txt. I've tried using .htaccess and even deleted the README.txt file, yet the warning still keeps popping up. Any ideas?

Cheers,

Pete

Link to comment
Share on other sites

  • 3 weeks later...
On 10/12/2021 at 6:57 AM, PeteSE4 said:

Default page after login takes me to the security maintenance page complaining the browser can fetch files it shouldn't, for example var/cache/README.txt. I've tried using .htaccess and even deleted the README.txt file, yet the warning still keeps popping up. Any ideas?

I am seeing the same error messages. My Apache server allows .htaccess files, so I shouldn't have needed to do anything, according to this page:

* https://www.revive-adserver.com/how-to/secure-your-installation/

But, upon receiving the error messages within Revive, I added the "AllowOverride AuthConfig Limit" language to each of the .htaccess files. This causes loads of server errors immediately to be generated, so I removed the language. Revive's security notice then returned.

Given the choice between (a) the server being unhappy and (b) Revive having quibbles, I'll chose the server every time.

Since the files' non-existence (after you made your deletions) is not sufficient to "fix" the Security check within Revive, and since nobody here seems to have an answer, you may just have to tell your user that it's a known error, you hope it'll be fixed soon, and he can ignore it.

Good luck!

Eliz.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...