error with comment form

<oXygen/> general issues.
tomjohnson1492
Posts: 132
Joined: Thu Apr 17, 2014 1:55 am

error with comment form

Post by tomjohnson1492 » Thu Aug 28, 2014 9:53 am

With Oxygen's webhelp with feedback, somehow the comment form got messed up. It doesn't appear in the display, and I received this error:

Code: Select all

[10.246.126.56] - 2014-08-08 01:02:39: Error:[0] message:[r: Error:1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'adtruth-cpp'' AND version=''1.0''' at line 1] file:[/var/www/html/[my directory]/oxygen-webhelp/resources/php/classes/db/RecordSet.php] line:[143] 
Any idea how to fix this?

Tom

sorin_ristache
Posts: 4144
Joined: Fri Mar 28, 2003 2:12 pm

Re: error with comment form

Post by sorin_ristache » Thu Aug 28, 2014 12:14 pm

Hi Tom,

We need some more details because we don't know how to reproduce this error. What values did you set for the parameters webhelp.product.id and webhelp.product.version when you executed the Webhelp-Feedback transformation in the Oxygen application ? Did you use a " character or a ' character in any parameter of the transformation (in the Oxygen application) or in a text box displayed in the installation (in the browser, for the server deployment)? Did the installation in the browser report any error or warning?

What action did you do last time in the Webhelp page when you get this error: press the Submit button for adding a new comment, press the Log in button in the login dialog box, etc?

Please can you send us the following file from your Apache server installation: [Apache-dir]/mysql/data/mysql_error.log?


Thank you,
Sorin

tomjohnson1492
Posts: 132
Joined: Thu Apr 17, 2014 1:55 am

Re: error with comment form

Post by tomjohnson1492 » Thu Sep 04, 2014 9:08 pm

Sorry, I'm not sure what triggered the error. I didn't use any special characters. I'll be on the lookout the next time it happens to see if I can pinpoint the cause. I ended up repurposing the db for something else, so the error log won't be any help at this point.

sorin_ristache
Posts: 4144
Joined: Fri Mar 28, 2003 2:12 pm

Re: error with comment form

Post by sorin_ristache » Fri Sep 05, 2014 9:31 am

Hi Tom,

We will try to pinpoint the error cause if we have more details from you. If the comment form in the Webhelp pages gets messed up again please let us know and if possible send us the error log file and we will try to find the cause and fix it.


Thank you,
Sorin

Post Reply