1 Reply by hansenb88

(4 replies, posted in Reporting)

Janusz, I provided the information you gave me to the server support team, can you please advise on any steps I can now do to troubleshoot based on the following response from them:

"I reviewed the script and I noticed that the fopen and fwrite PHP function are used.

I created a test script in the same location which is working properly. You can check it bellow:

http://freedombrew.us/frontaccounting/reporting/includes/test/test.php

The information is added in the file bellow:

http://freedombrew.us/frontaccounting/reporting/includes/test/data.txt

You can also go to the URL below, delete the content in the data.txt file then visit the script and it will be added again.

https://cp.freehostia.com/filemanager/#/www/freedombrew.us/frontaccounting/reporting/includes/test

As I was able to understand the script is trying to access a file named "doc.pdf" which doesn't exit in the directory where the script is located, however this information might not be accurate because we are not familiar with this script and your developers is supposed to troubleshoot it.

I'm afraid that we can not proceed troubleshooting the case because the used function are working properly as you can see which indicates the the problem is not caused by the directory permission or any other server configuration."


I can provide you access to my server if you need to see anything directly for more clarity but this is beginning to frustrate me as I can't figure out for the life of me why it is not making these reports.

Go to forum: Reporting

2 Topic by hansenb88

(4 replies, posted in Reporting)

Please someone tell me additional information that I can provide to my server support. None of the reports are printing, all result in a 404 error. This is on a fresh install of 2.3.21 with all diagnostics OK. After 2 full days of troubleshooting with the server people they have resorted to this:
"In this case what would suggest is to consult with the application developers at frontaccounting application as they are most familiar with the application functionality, over which file of the application creates this .pdf file, what function they are using or if possible to provide us with more details over the script requirements so we can review them once again and test from our end additionally."

I do not know what to tell them.
Rep107.php prints invoices I know. When I click display on the software, does it call this page directly? And then this function calls pdf_report.inc? What function actually saves the pdf file to the server? Because the pdf is not saving to my server?

Go to forum: Reporting

3 Reply by hansenb88

(14 replies, posted in Installation)

Can anyone tell me if they resolved this?

apmuthu I would be happy to give you my server login details if you think you can figure this out. Same error, all acceptable version numbers. Was working for 3 months since this happened the last time and I cannot get it resolved. Have posted in reporting and bugs forum with 0 replies. Server tech support cannot find any incorrect configuration on my server, but the exact same zip file extracted to a free server on 000webhost works and on my paid server doesn't. Even after fresh install. There must be something not clearing from a cache is all I can figure but I have done it locally and on server I have deleted the ENTIRE directory, waited overnight, then reinstalled. This is a very weird problem and I don't have the knowledge to solve it myself. Looking for anyone's help. Please.

MySQL version >=4.1    Required    5.5.11    Ok
PHP version >=4.3.3    Required    5.2.17    Ok
Http server type    Info    Apache mod_fcgid/2.3.7 mod_auth_pgsql/2.0.3    Ok

Go to forum: Installation

4 Reply by hansenb88

(4 replies, posted in Reporting)

Need to bump this again. Any admin support would be greatly appreciated. I got the error above fixed by manually deleting the entire install and then re-installing and copying back my backups of language files and then reconfiguring the config files manually. Then repeating it a second time as the first re-install had the same issue.

Here is the bigger problem, every single file on the server after the reinstall has the same modified date as the broken setup except the files in the js_cache folder. I assume this must have something to do with the problem but I cannot figure anything further out. I've deleted those files manually the past 2 days to see if it could reset my setup to no avail. I had this working for exactly 3 months and now the error is back, the exact same problem and I have confirmed with the webhost that no server side changes have been made in the last 3 months. I can't delete and reinstall the entire package every 3 months on the hopes that that fixes it. Has no one else experienced this issue? Does anyone have something I can try so that I don't have to take this software off the server and reinstall the same version tomorrow?

Go to forum: Reporting

5 Reply by hansenb88

(1 replies, posted in Report Bugs here)

In case you didn't see the system diagnostics I posted in the reporting section when looking for help there, I am using FA 2.3.20 and all diagnostics report Ok:

MySQL version >=4.1    Required    5.5.11    Ok
PHP version >=4.3.3    Required    5.2.17    Ok
Http server type    Info    Apache mod_fcgid/2.3.7 mod_auth_pgsql/2.0.3    Ok
Server system    Info    Linux    Ok

Go to forum: Report Bugs here

6 Topic by hansenb88

(1 replies, posted in Report Bugs here)

Admins please help. I don't know where to locate the file which causes this to happen but have been trying to troubleshoot this report error for several days.

I went into the server from the hosting file manager and added a file 'testpdf.pdf' to the /company/0/pdf_files/ directory manually. I called the pdf file successfully from the browser by navigating to the url. The file was successfully added to the directory and was displayed properly.

I then went back into FA and tried to execute a sales report (but this problem happens with all reports). The pop-up to display the report shows a 404 error (which I have written about in the reporting section of this forum). I then looked at the /pdf_files/ directory again and there is no file called testpdf.pdf any longer. It appears that FA is wiping files from that directory when it tries to make a report. The only file which does not get deleted is the index.php in the directory which was written by the installation.

How can I disable the program from deleting files in that directory?? I would rather have to go into the server manually each week and delete the old reports than not be able to use the reports feature at all.

Please any advice would be appreciated. I am certain there must be someone here who knows of a line of code which cleans that /pdf_files/ directory out and I need to remove it asap.

Go to forum: Report Bugs here

7 Reply by hansenb88

(1 replies, posted in Report Bugs here)

When I had that problem I saw a very similar error in the log but not exactly the same. The solution was to deactivate Mod_security which my web host had just activated for all sites on the server. I expect it might be blocking the outgoing IP request which is what just recently happened to me. Hope that helps.

Go to forum: Report Bugs here

8 Reply by hansenb88

(4 replies, posted in Reporting)

Do any of the admins have a suggestion of something I can look at to resolve this? It's been several days I've tried troubleshooting on my own and I haven't found out what is causing this problem. I have no reports working whatsoever but every other piece of this software is acting normal.

Is there a way to debug this and check if the report file is actually ever being written or if it is disappearing before the next command where it opens the pop-up and looks for the report? Can someone explain to me any differences the software takes between writing a pdf and reporting in excel? Both types of reports are resulting in nothing (excel opens a blank file, pdf says 404 error). If I could understand what is common between the two then I can look more specifically at that section.

Current diagnostics:
MySQL version >=4.1    Required    5.5.11    Ok
PHP version >=4.3.3    Required    5.2.17    Ok
Http server type    Info    Apache mod_fcgid/2.3.7 mod_auth_pgsql/2.0.3    Ok

I'd appreciate anyone's advice. Thank you.
FrontAccounting 2.3.20 fresh installation.

Go to forum: Reporting

9 Reply by hansenb88

(3 replies, posted in Report Bugs here)

I'm not a programmer so don't be insulted if this doesn't help you but you simply have a rounding issue. 1.1102230246252E-16 is technically 0.00000000000000001102230246252 which for anyone's purpose is 0.

I'm not sure if you have something in the logger function that could be doing it but could you just add an operation to truncate some decimal places before the final result? Sorry if that doesn't help.

Go to forum: Report Bugs here

10 Reply by hansenb88

(4 replies, posted in Reporting)

Some more information:

After digging deeper I found that our server host added some features after recent attacks. In the process the IP 91.227.122.4 was blocked as an outgoing connection. After further investigation I discovered that was in fact the server I needed to access causing the original error and was why themes/languages etc would not work either recently.

Before discovering this however, I backed up my database and installed a fresh copy of FA to my subdomain. After all that my reports still will not work. I now get an entirely unrelated (I think) error in my log. The errors alternate between the two below:

[11-Apr-2014 03:31:47 UTC] 0:admin:JsHttpRequest.php:470: mb_convert_encoding(): Illegal character encoding specified
[11-Apr-2014 03:31:53 UTC] 0:admin:prn_redirect.php:40: file_get_contents(../company/0/pdf_files/53476225283fe.xls): failed to open stream: No such file or directory

I am almost certain this is a permissions issue now but can't seem to find what I have set wrong. I understand programming but almost never work with apache or php so I don't know where to go from here. I'd be happy to try anyone's advice. I've got a recent backup of everything so the worst case is I end up right where I am now. Thanks.

Go to forum: Reporting

11 Topic by hansenb88

(4 replies, posted in Reporting)

I don't believe we have changed any settings on our web server in several months but for the past 24 hours I have not been able to generate any reports or print any invoices no matter what I try or which module I am in. It doesn't work with pdf nor with excel. I have been trying to check logs/diagnostics but haven't figured out what some errors mean.

The system diagnostics in my frontaccounting system reads OK for every item in the list. I have php 5.2.17, mysql 5.5.11 and have tried accessing from IE and Chrome on windows 7. Every report shows up with Object Not Found 404 error.

My web server error log reports only this: "[10-Apr-2014 12:37:17] 0:admin:remote_url.inc:48: fsockopen() [<a href='function.fsockopen'>function.fsockopen</a>]: unable to connect to repo.frontaccounting.eu:80 (Permission denied)"

I don't know what permission I could have changed. Where can I fix this? Am I overlooking something simple? Please help.

Go to forum: Reporting