Ask Question does not save my question

[icab]

When I call Ask Question with text that includes keywords used in previous questions, you enter a search dialogue that provides potential solutions for you to view. If non are suiatable you click the "No, there is still no adequte answer" button after which you are thanked for your question. However no question is saved to the database (for me at least!)

[Thorsten]

Hi,

I tested it... it works on my system... do you have any hints for me?

bye
Thorsten

[icab]

After I type in my question and hit the "Submit" button, I get the following DEBUG info:

DEBUG INFORMATION:

SELECT
config_name, config_value
FROM
hac_faqconfig

SELECT
sid
FROM
hac_faqsessions
WHERE
sid = 6
AND
ip = '82.68.173.158'
AND
time > 1249292727

UPDATE
hac_faqsessions
SET
time = 1249379127,
user_id = -1
WHERE
sid = 6
AND ip = '82.68.173.158'

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
hac_faqcategories fc
LEFT JOIN
hac_faqcategory_group fg
ON
fc.id = fg.category_id
LEFT JOIN
hac_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

SELECT
COUNT(record_id) AS n
FROM
hac_faqdata_tags

SELECT
count(sid) AS anonymous_users
FROM
hac_faqsessions
WHERE
user_id = -1
AND time > 1249378827

SELECT
count(session_id) AS registered_users
FROM
hac_faquser
WHERE
session_timestamp > 1249378827

SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS thema,
fcr.category_id AS category_id
FROM
hac_faqdata fd
LEFT JOIN
hac_faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
hac_faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
hac_faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.lang = 'en'
AND
fd.date_start <= '20090804114528'
AND
fd.date_end >= '20090804114528'
AND
fd.active = 'yes'
AND
fd.sticky = 1
AND
( fdu.user_id = -1 OR fdu.user_id = -1 )

When I then click the "No, this doesn't answer my question" button, then I get the following DEBUG output
DEBUG INFORMATION:

SELECT
config_name, config_value
FROM
hac_faqconfig

SELECT
sid
FROM
hac_faqsessions
WHERE
sid = 6
AND
ip = '82.68.173.158'
AND
time > 1249292829

UPDATE
hac_faqsessions
SET
time = 1249379229,
user_id = -1
WHERE
sid = 6
AND ip = '82.68.173.158'

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
hac_faqcategories fc
LEFT JOIN
hac_faqcategory_group fg
ON
fc.id = fg.category_id
LEFT JOIN
hac_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

SELECT
COUNT(record_id) AS n
FROM
hac_faqdata_tags

SELECT
count(sid) AS anonymous_users
FROM
hac_faqsessions
WHERE
user_id = -1
AND time > 1249378929

SELECT
count(session_id) AS registered_users
FROM
hac_faquser
WHERE
session_timestamp > 1249378929

SELECT
fd.id AS id,
fd.lang AS lang,
fd.thema AS thema,
fcr.category_id AS category_id
FROM
hac_faqdata fd
LEFT JOIN
hac_faqcategoryrelations fcr
ON
fd.id = fcr.record_id
AND
fd.lang = fcr.record_lang
LEFT JOIN
hac_faqdata_group AS fdg
ON
fd.id = fdg.record_id
LEFT JOIN
hac_faqdata_user AS fdu
ON
fd.id = fdu.record_id
WHERE
fd.lang = 'en'
AND
fd.date_start <= '20090804114710'
AND
fd.date_end >= '20090804114710'
AND
fd.active = 'yes'
AND
fd.sticky = 1
AND
( fdu.user_id = -1 OR fdu.user_id = -1 )

I then get the "Thanks" message, but nothing is stored in the database.Is there some other debug info that would be useful to help track this problem down? Thanks in advance, Ian.

[icab]

We've managed to track down the area where the feature is occuring my modifying savequestion.php to log some details into a file. Basically what appears to happen is that it enters savequestion.php with the username/mail/content set correctly. A search is then performed and the results displayed. If the [No, there is still no adequate answer (will send the mail)] button is clicked, savequestion.php is called again (presumably to actually send the question), but this time username/mai/content is now unset and an error message is output. Finally savequestion.php is called again to output the thanks for your question message.

The first point to note is that the error message as displayed below (Required fields) is not actually output, or rather it may be, but is then replaced immediately by the "thanks for your question" message. The seconds is that we guess the reason this fails when there is a positive search is that the required field are missing!


***
Before check
Username 'Paul Griffiths' 1
Usermail 1
Content 1
IPCheck 1
Banned 1

Entered main check ok
Got search result back
At end of savequestion

***
Before check
Username ''
Usermail
Content
IPCheck 1
Banned 1

error message
--> Required fields are <strong>your name</strong>, <strong>your email address</strong>, <strong>your question</strong> and, when requested, the <strong><a href="http://en.wikipedia.org/wiki/Ca
ptcha" title="Read more on Captcha at Wikipedia" target="_blank">Captcha</a> code</strong>.<br /><br /><a href="javascript:history.back();">one page back</a><br /><br />
At end of savequestion

***
Before check
Username ''
Usermail
Content
IPCheck 1
Banned 1

Writing block thanks for email
At end of savequestion

[Thorsten]

Hi,

We've managed to track down the area where the feature is occuring my modifying savequestion.php to log some details into a file. Basically what appears to happen is that it enters savequestion.php with the username/mail/content set correctly. A search is then performed and the results displayed. If the [No, there is still no adequate answer (will send the mail)] button is clicked, savequestion.php is called again (presumably to actually send the question), but this time username/mai/content is now unset and an error message is output. Finally savequestion.php is called again to output the thanks for your question message.

this should not happen. Can you show me your FAQ?

bye
Thorsten

[icab]

Hi Thorsten,

thanks for the speedy reply. Could you send me an email to faq@high-availability.com and I will email you back with full access details to our FAQ site.

Regards,

Ian.

[icab]

We have fixed the issue we were seeing (and also no characters in the captcha code image) by rebuilding our PHP with the following configuration items *removed*
--enable-gd-native-ttf
-with-ttf
--with-ttf

Our php version is 5.2.10

Strange, but true!

[Thorsten]

Hi,

so you don't use the captchas anymore?

bye
Thorsten

[icab]

Yes we do, you only need --with-gd when building php. Adding the other swithces:

--enable-gd-native-ttf
--with-ttf

breaks the captcha code display.

[Thorsten]

Hi,

interesting... could be a PHP bug, too.

bye
Thorsten

[p80joe]

Sorry, I posted the below message on the wrong discussion thread last week. I was meant to go here:

We are experiencing what sounds like the same, or a very similar problem:

When there are no matches for the Ask a Question form submission, the question is inserted appropriately into the DB (that is, it becomes visible on the Open Questions page in the admin section), and the email notification is sent to our admin email address. However, when there are matches for the Ask a Question submission, and the user cicks the 'No, there is still no adequate answer' button, then neither is the email sent to us, nor is the question visible in Open Questions.

We did not build our PHP instance: We are using the ISAPI version of the precompiled Windows binary (5.2.6) with IIS. Is there some PHP (or phpMyFAQ) configuration step we can take to overcome this issue? We do not want to launch the new FAQ without sorting this out, since users will have the false impression that their questions have been submitted when, in fact, we have no record of them.

Thanks in advance for whatever help you can provide.

[Thorsten]

Hi,

I'll check this on my Windows Server VM.

bye
Thorsten