V7 what has to be set-up to export to PDF ???

Hi Eric,

no. After (fresh) deploy with .3 the folder (linux-i386) has 755, the file 744 … I set the file to 755 and the pdf is generated.

OK, I will check that, but do not think this will effect at the end. I set the permission not only to 755 but 777. On my webserver, the file was set to 644, but I cannot do the deploy directly to the webserver, cause since .1, this is no longer working to me. I am not able to do the configuration after a fresh installation. I have to install it first to my testing server and after that I can put it file by file to the production webserver.

Eric,

Please let me know on any update regarding the issue.

regards,
Bernhard Bernsmann

Tested it with different permissions, up to 777 for file and folder. It is not working … we are back at the starting point, the files to prosuce the pdf were written into the tmp folder, but the pdf is NOT written, against the message given by the software, which is telling pdf is written. With the Version between, some parts of the pdf were written and shown, but now, there is nothing.

P.S.: To let the app make the first step, it was necessary to set the permission of the tmp-folder from 755 to 777. May be it is the problem, that the generated .css, .html and .log file in the tmp-folder only get 644 permission??? Just an idea …

I’m going to join in on this one. We can confirm all Eric’s findings. PDF is not working on SC7 generated production site where it was working on SC 6 generated production site. Nothing has changed on our production server. Web site has full permissions on the tmp directory, tmp was already at 777.

Mark Stopkey

Since today export to pdf is nearly working perfectly on production server. Was a mistake in webserver configuration of the webserver.
There is only one grid left which is not working. Cross table of two tables.
Testing server still not working. May be there is an idea, given by Reinhard, that it may concern to the way how PHP is associated to the webserver. CGI and/or module.
I am not sure, if I can test that on the testing server, but will try …

BR

Eric

Have you set 755 to _lib/prod/third/wkhtmltopdf/linux-amd64/wkhtmltopdf-amd64 and/or _lib/prod/third/wkhtmltopdf/linux-i386/wkhtmltopdf-i386?

Hello Mark,

As Reinhard stated, make sure that you have set 755 to “prod/third/wkhtmltopdf/[yourOperatingSystem]”.

If you are still unable to generate the PDF, go to /tmp and there should be a log file. Open the log file and you should see a line command regarding the PDF generation. Access “prod/third/wkhtmltopdf/[yourOperatingSystem]” via terminal run the command and let me know the error message (if possible, please take a screenshot).

regards,
Bernhard Bernsmann

OK, I think this thread can be moved to the section BUG. Further testing today shows a bug when using the Search before exporting to pdf.

  1. whole table shown in the grid -> Export2PDF works
  2. using the search, to show only a part of the grid, search works, Export2PDF returns a blank file.

BR

Eric

P.S.: Had the problem with the blank pdf in another form too. Even when the seach was not used, but here I changed the Select-statement in the OnScriptInit-event to show only a part of the table. So I think the problem is NOT the Seach, but the where-clause of the Select-statement. BTW, changing the sorting order of the grid is working, as long as the where clause is not touched.

Hi all,

I’ve tried also on 7.00.0004 and the problem is still present also there.

Also the export of XLS file need the ZIP extension enabled but most of hosting server has not it as default. If you like that option you have to shift up to custom server environment that has 10 times the cost of a standard. Why it’s necessary ?? Is it not possible to do the XLS export without using it ?? I’m not a tech guy but it seems me impossible do not fix it.
Bye

[QUOTE=giovannino;13079]Hi all,

I’ve tried also on 7.00.0004 and the problem is still present also there.

Also the export of XLS file need the ZIP extension enabled but most of hosting server has not it as default. If you like that option you have to shift up to custom server environment that has 10 times the cost of a standard. Why it’s necessary ?? Is it not possible to do the XLS export without using it ?? I’m not a tech guy but it seems me impossible do not fix it.
Bye[/QUOTE]

Hello,

1 - Were you unable to generate PDFs also?

2 - Was it on your development or production environment?

3 - Have you followed the tutorials described on this thread?

regards,
Bernhard Bernsmann

OK, I prayed not to write these lines, but with the switch to PHP 5.4 we have to come back to post #1 of this thread.

Files are stored in the tmp directory. CSS and the HTML files with the matching names and timestamps are stored in that directory.
The whole directory-tree of wkhtmltopdf is set to 777 permission (for testing issue) which I would set back to 755 if it would work.
But unfortunally it is again the message:

Fehler beim Erstellen der PDF-Datei. Kontaktieren Sie den Techischen Support.
(error while creating pdf-file. Please contact the technical support.)

pdf is killing me …

Best Regards

Eric

Send me a pm and we will look …

No more, we solve this problem (handing over of variables) yesterday … :slight_smile:

Yes, thanks to Reinhard for helping and giving some good ideas. Seems to me that PHP 5.4 is more restrictive than 5.3. So, to everyone, if there are some problems in 5.4, which were were not existing in 5.3, keep that in mind …

Happy X-mas to everone

Hi everyone,

I do have similar problem with pdf.
I saw in forum a lot of people with problems with pdf - and no definite solution -

Reinhard, could you please tell us how do you solve the issue ? I tried similar things you did (permissions, reinstallation, etc without results)

Regards and happy Xmats

Jose Miguel

Hi Jose,

These are all individual problems, so there is not the general solution for it. I can watch via remote maintenance with you, but can’t guarantee a solution. Write me a pm with your system details …

Hey Bernhard,

I know this is a bit old, but I just ran into the same problem. Just wanted to say thanks for this post…your last line on execution was my problem. +x to that file and works like a champ.

Thank you!..Mark

Hi Bernhard,

After struggling for two days, your post solved my issue. I had to install libxrender1.so on my Ubuntu server.

Regards,
Willem