PDF export is not working

[tshrinivasan]

When clicked the PDf icon, it shows an empty page.

How to diagnosis this?

Thanks.

[Thorsten]

Hi,

do you see any errors in your webserver's error log?

bye
Thorsten

[camilo.mendez]

Hello, Thanks for this great software.

I have the same problem I was working in version 2.6.13 and recently updated to 2.6.17, and continued with the problem. In reviewing the apache log can only see the following message:

"GET /faq/pdf.php?cat=15&id=29&artlang=es HTTP/1.1" 200 10130 "http://82.250.60.60/faq/content/15/29/e ... nacar.html" "Mozilla/5.0 (X11; Linux x86_64; rv:2.0.1) Gecko/20100101 Firefox/4.0.1"

Someone could help me solve this incident? thanks

[jason102178]

Just to let you know i was able to reproduce this same issue.

Cheers,

Jason

[jason102178]

I do know that the PDF Export Will be fixed in the 2.7 Version I just tested to make sure it was working in the 2.7 Version and it does.

[Thorsten]

Hi,

could you please turn on the debug mode in inc/Init.php?

Thanks!

bye
Thorsten

[jason102178]

Just to let you know that the export to xml and export to xhtml both work just not the pdf, i have listed the debug information below.


DEBUG INFORMATION:
/home/content/j/a/s/jason102178/html/faq/inc/Init.php:
PMF_Configuration->getAll() in line 106:

Code: Select all

 SELECT
                config_name, config_value
            FROM
                faqconfig

/home/content/j/a/s/jason102178/html/faq/inc/PMF_User/CurrentUser.php:
PMF_User->getUserById() in line 415:

Code: Select all

           SELECT
                user_id,
                login,
                account_status
            FROM
                faquser
            WHERE
                user_id = 1

/home/content/j/a/s/jason102178/html/faq/inc/PMF_User/CurrentUser.php:
PMF_User->getUserById() in line 415:

Code: Select all

                SELECT
                    pass
                FROM
                    faquserlogin
                WHERE
                    login = 'admin'

/home/content/j/a/s/jason102178/html/faq/inc/User.php:
PMF_User_UserData->load() in line 315:

Code: Select all

           SELECT
                last_modified, 
                display_name, 
                email
            FROM
                faquserdata
            WHERE
                user_id = 1

/home/content/j/a/s/jason102178/html/faq/inc/PMF_User/CurrentUser.php:
PMF_User_CurrentUser->getSessionInfo() in line 422:

Code: Select all

            SELECT
                session_id,
                session_timestamp,
                ip
            FROM
                faquser
            WHERE
                user_id = 1

/home/content/j/a/s/jason102178/html/faq/inc/PMF_User/CurrentUser.php:
PMF_User_CurrentUser->updateSessionId() in line 433:

Code: Select all

            UPDATE
                faquser
            SET
                session_id = '6e9e88c2a07edcfef349d1cbca88c63f',
                session_timestamp = 1308717574,
                
                ip = '184.57.107.238'
            WHERE
                user_id = 1

/home/content/j/a/s/jason102178/html/faq/admin/index.php:
PMF_Perm_PermBasic->getAllRightsData() in line 144

Code: Select all

            SELECT
                right_id,
                name,
                description,
                for_users,
                for_groups
            FROM
                faqright
            ORDER BY
                right_id ASC

/home/content/j/a/s/jason102178/html/faq/inc/PMF_Perm/PermMedium.php:
PMF_Perm_PermBasic->getUserRights() in line 720:

Code: Select all

            SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faquser_right fur,
                faquser fu
            WHERE
                fr.right_id = fur.right_id AND
                fu.user_id  = 1 AND
                fu.user_id  = fur.user_id

/home/content/j/a/s/jason102178/html/faq/inc/PMF_Perm/PermMedium.php:
PMF_Perm_PermMedium->getUserGroupRights() in line 721:

Code: Select all

            SELECT
                fr.right_id AS right_id
            FROM
                faqright fr,
                faqgroup_right fgr,
                faqgroup fg,
                faquser_group fug,
                faquser fu
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id AND
                fg.group_id = fgr.group_id AND
                fr.right_id = fgr.right_id

/home/content/j/a/s/jason102178/html/faq/admin/index.php:
PMF_Perm_PermMedium->getUserGroups() in line 169:

Code: Select all

            SELECT
                fg.group_id AS group_id
            FROM
                faquser fu,
                faquser_group fug,
                faqgroup fg
            WHERE
                fu.user_id  = 1 AND
                fu.user_id  = fug.user_id AND
                fg.group_id = fug.group_id

/home/content/j/a/s/jason102178/html/faq/inc/User.php:
PMF_User_UserData->get() in line 750:

Code: Select all

            SELECT
                display_name
            FROM
                faquserdata
            WHERE
                user_id = 1

/home/content/j/a/s/jason102178/html/faq/admin/export.main.php:
PMF_Db->checkOnEmptyTable() in line 38:

Code: Select all

SELECT * FROM faqdata

/home/content/j/a/s/jason102178/html/faq/admin/export.main.php:
PMF_Db->checkOnEmptyTable() in line 40:

Code: Select all

SELECT * FROM faqcategories

/home/content/j/a/s/jason102178/html/faq/inc/Category.php:
PMF_Category->getOrderedCategories() in line 160:

Code: Select all

            SELECT
                fc.id AS id,
                fc.lang AS lang,
                fc.parent_id AS parent_id,
                fc.name AS name,
                fc.description AS description,
                fc.user_id AS user_id
            FROM
                faqcategories fc
            LEFT JOIN
                faqcategory_group fg
            ON
                fc.id = fg.category_id
            LEFT JOIN
                faqcategory_user fu
            ON
                fc.id = fu.category_id
            WHERE
                ( fg.group_id IN (-1)
            OR
                (fu.user_id = 1 AND fg.group_id IN (-1)))
            AND
                fc.lang = 'en'
            GROUP BY
                fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id
            ORDER BY
                fc.id

[Thorsten]

Hi,

no entries in the error log?

bye
Thorsten

[camilo.mendez]

Hi,

In my server error log is not generated any input. Only input is generated previously published in the access log

Thank you.

[Thorsten]

Hi,

could you please post you phpinfo information. I think your PHP has too few memory and it'll crash with out of memory during the execution of the PDF export.

bye
Thorsten

[camilo.mendez]

Hi,

Here I post my phpinfo. thanks

[Thorsten]

Hi,

your memory limit is at 128 MB, that's enough. Is it possible to get access to your FAQ? This link doesn't work for me: http://82.250.60.60/faq/content/15/29/e ... nacar.html

bye
Thorsten

[camilo.mendez]

Hi,

Unfortunately I can not enable you to access the page because the tool is posted on the intranet and the security department does not allow me access request.

But if you want to test, I the I can do. What tests need to do?

[Thorsten]

Hi,

okay, no problem about this. Do you know a little bit about PHP?

bye
Thorsten

[camilo.mendez]

Hi,

A little, what tests need to make? I can support me in my coworkers.