Add Question Hangs

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
camel_Trophy
Posts: 41
Joined: Fri Feb 17, 2017 5:03 pm

Add Question Hangs

Post by camel_Trophy »

Greetings all,

Fresh Install.

The Add Question form hangs with "Saving" after hitting the submit button, this happens whether I am logged in or not. I tried it with SMTP enabled and disabled, and still the same behavior. Our SMTP server is anonymous and doesn;t require authentication. Add new FAQ works fine with SMTP and without SMTP, only the Add Question is not working.

Any ideas?

Thank you,

Gibran
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Add Question Hangs

Post by Thorsten »

Hi,

please enable the debug mode in inc/Bootstrap.php and try it again to see if any errors occur.

Thanks in advance!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
camel_Trophy
Posts: 41
Joined: Fri Feb 17, 2017 5:03 pm

Re: Add Question Hangs

Post by camel_Trophy »

Hello Thorsten,

I enabled debug, but the behavior is the same and I am not getting any errors on the page. Is there a log file I should be looking at or do the error post on the same page I am on? I noticed the errors were posted on the same page for another problem I am having, the System information section, but nothing for Add Question.

Just an FYI, I changed the menu name from Add Question to Ask Question, I am not sure if this has something to do with it. However, on my phymyfaq dev server this change did not have any impact.

Thank you,

Gibran
camel_Trophy
Posts: 41
Joined: Fri Feb 17, 2017 5:03 pm

Re: Add Question Hangs

Post by camel_Trophy »

nevermind, I noticed the errors on the bottom of the page :)

I will review and get back for more help.

Thanks,

Gibran
camel_Trophy
Posts: 41
Joined: Fri Feb 17, 2017 5:03 pm

Re: Add Question Hangs

Post by camel_Trophy »

Hello Thorsten,

I tried to make sense of this debug with no luck, I would appreciate your help.

Thanks,

Gibran

!
!

DATABASE QUERIES

/var/www/html/faq/inc/Bootstrap.php:
PMF_Configuration->getAll() in line 149:
SELECT
config_name, config_value
FROM
faqconfig

/var/www/html/faq/index.php:
PMF_Session->checkSessionId() in line 212:
SELECT
sid
FROM
faqsessions
WHERE
sid = 10
AND
ip = '10.61.27.69'
AND
time > 1490186898

/var/www/html/faq/index.php:
PMF_Session->checkSessionId() in line 212:
UPDATE
faqsessions
SET
time = 1490273298,
user_id = -1
WHERE
sid = 10
AND ip = '10.61.27.69'

/var/www/html/faq/inc/PMF/Category.php:
PMF_Category->getOrderedCategories() in line 156:
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,
fc.group_id AS group_id,
fc.active AS active
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, fc.group_id, fc.active
ORDER BY
fc.parent_id, fc.id

/var/www/html/faq/index.php:
PMF_Tags->existTagRelations() in line 406:
SELECT
COUNT(record_id) AS n
FROM
faqdata_tags

/var/www/html/faq/index.php:
PMF_Session->getUsersOnline() in line 457:
SELECT
count(sid) AS anonymous_users
FROM
faqsessions
WHERE
user_id = -1
AND
time > 1490272998

/var/www/html/faq/index.php:
PMF_Session->getUsersOnline() in line 457:
SELECT
count(session_id) AS registered_users
FROM
faquser
WHERE
session_timestamp > 1490272998

/var/www/html/faq/inc/PMF/Helper/Category.php:
PMF_Category->getNumberOfRecordsOfCategory() in line 53:
SELECT
fcr.category_id AS category_id,
COUNT(fcr.record_id) AS number
FROM
faqcategoryrelations fcr, faqdata fd
WHERE
fcr.record_id = fd.id
AND
fcr.record_lang = fd.lang
GROUP BY fcr.category_id

/var/www/html/faq/inc/PMF/User.php:
PMF_User_UserData->get() in line 912:
SELECT
display_name
FROM
faquserdata
WHERE
user_id = 0

/var/www/html/faq/inc/PMF/Helper/Category.php:
PMF_Category->getNumberOfRecordsOfCategory() in line 53:
SELECT
fcr.category_id AS category_id,
COUNT(fcr.record_id) AS number
FROM
faqcategoryrelations fcr, faqdata fd
WHERE
fcr.record_id = fd.id
AND
fcr.record_lang = fd.lang
GROUP BY fcr.category_id

/var/www/html/faq/inc/PMF/Faq.php:
PMF_Faq->getStickyRecordsData() in line 3254:
SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS thema,
fcr.category_id AS category_id
FROM
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.lang = 'en'
AND
fd.date_start <= '20170323134818'
AND
fd.date_end >= '20170323134818'
AND
fd.active = 'yes'
AND
fd.sticky = 1
AND fdg.group_id IN (-1)

/var/www/html/faq/inc/PMF/Faq.php:
PMF_Faq->getTopTenData() in line 1814:
SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS question,
fd.updated AS updated,
fcr.category_id AS category_id,
fv.visits AS visits,
fv.last_visit AS last_visit,
fdg.group_id AS group_id,
fdu.user_id AS user_id
FROM
faqvisits fv,
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.date_start <= '20170323134818'
AND fd.date_end >= '20170323134818'
AND fd.id = fv.id
AND fd.lang = fv.lang
AND fd.active = 'yes'
AND
fd.lang = 'en'
AND fdg.group_id IN (-1)
GROUP BY
fd.id,fd.lang,fcr.category_id,fv.visits,fv.last_visit,fdg.group_id,fdu.user_id
ORDER BY
fv.visits DESC

/var/www/html/faq/inc/PMF/Faq.php:
PMF_Faq->getLatestData() in line 1854:
SELECT
fd.id AS id,
fd.lang AS lang,
fcr.category_id AS category_id,
fd.thema AS question,
fd.content AS content,
fd.updated AS updated,
fv.visits AS visits,
fdg.group_id AS group_id,
fdu.user_id AS user_id
FROM
faqvisits fv,
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.date_start <= '20170323134818'
AND fd.date_end >= '20170323134818'
AND fd.id = fv.id
AND fd.lang = fv.lang
AND fd.active = 'yes'
AND
fd.lang = 'en'
AND fdg.group_id IN (-1)
GROUP BY
fd.id,fd.lang,fcr.category_id,fv.visits,fdg.group_id,fdu.user_id
ORDER BY
fd.updated DESC

/var/www/html/faq/inc/PMF/Tags.php:
PMF_Tags->getAllTags() in line 490:
SELECT
MIN(t.tagging_id) AS tagging_id, t.tagging_name AS tagging_name
FROM
faqtags t
LEFT JOIN
faqdata_tags dt
ON
dt.tagging_id = t.tagging_id
LEFT JOIN
faqdata d
ON
d.id = dt.record_id
WHERE
1=1
AND d.active = 'yes'

GROUP BY
tagging_name
ORDER BY
tagging_name ASC

/var/www/html/faq/inc/PMF/Tags.php:
PMF_Tags->getRecordsByTagName() in line 493:
SELECT
dt.record_id AS record_id
FROM
faqtags t, faqdata_tags dt
LEFT JOIN
faqdata d
ON
d.id = dt.record_id
WHERE
t.tagging_id = dt.tagging_id
AND
t.tagging_name = '9.0'

/var/www/html/faq/inc/PMF/Tags.php:
PMF_Tags->getRecordsByTagName() in line 493:
SELECT
dt.record_id AS record_id
FROM
faqtags t, faqdata_tags dt
LEFT JOIN
faqdata d
ON
d.id = dt.record_id
WHERE
t.tagging_id = dt.tagging_id
AND
t.tagging_name = '9.1'

/var/www/html/faq/inc/PMF/Tags.php:
PMF_Tags->getRecordsByTagName() in line 493:
SELECT
dt.record_id AS record_id
FROM
faqtags t, faqdata_tags dt
LEFT JOIN
faqdata d
ON
d.id = dt.record_id
WHERE
t.tagging_id = dt.tagging_id
AND
t.tagging_name = 'New'

/var/www/html/faq/index.php:
PMF_Faq->showAllRecordsWoPaging() in line 749:
SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS thema,
fcr.category_id AS category_id,
fv.visits AS visits
FROM
faqdata fd
LEFT JOIN
faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
faqvisits fv
ON
fd.id = fv.id
AND
fv.lang = fd.lang
LEFT JOIN
faqdata_group fdg
ON
fd.id = fdg.record_id
LEFT JOIN
faqdata_user fdu
ON
fd.id = fdu.record_id
WHERE
fd.date_start <= '20170323134818'
AND
fd.date_end >= '20170323134818'
AND
fd.active = 'yes'
AND
fcr.category_id = 0
AND
fd.lang = 'en'
GROUP BY
fd.id,fd.lang,fcr.category_id,fv.visits
ORDER BY
id DESC
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Add Question Hangs

Post by Thorsten »

Hi,

there are just the normal queries. Is it possible to get access to your FAQ to see the issue in action?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
camel_Trophy
Posts: 41
Joined: Fri Feb 17, 2017 5:03 pm

Re: Add Question Hangs

Post by camel_Trophy »

Hello Thorsten,

Unfortunately, it's deployed on our intranet network and there is no external access.

If you have the time I can do a webex meeting with you, you can monitor it and get access via my remote session. While on the phone you can help me with the CSS question, I can do some donation to your site ;)

Thanks,

Gibran
camel_Trophy
Posts: 41
Joined: Fri Feb 17, 2017 5:03 pm

Re: Add Question Hangs

Post by camel_Trophy »

Hello Thorsten,

After disabling Elasticsearch because of the bug I decided to try the Add Question again, now it works :)


It appears Elasticsearch was causing couple of my problems.

Thanks,

Gibran
Thorsten
Posts: 15559
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Add Question Hangs

Post by Thorsten »

Hi,

yes, Elasticsearch v5 is not supported yet. Sorry.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply