HOME | DOWNLOAD | SUPPORT | INSTALLATION | FAQ | SUPPORT FORUM | DEMO
 ° Forums ° Statistics ° Registration ° Search ° Manual °
SkaLinks Forum / Technical Support / version 1_3_2: SQL error
Author Message
bug


Posted: 22 Aug 2005 10:14:53


On the "Settings" page when You save changes You get error:

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 't place reciprocal link(s) to yet, please use

skalinks
Admin

Posted: 22 Aug 2005 22:25:43


Did you modify letter templates or code in functional module? This error can be, if the checking for ' is disabled. Please, whould you show the templates of letters, which you tried to use, and this error appeared.
Thank's

bug


Posted: 23 Aug 2005 02:34:45


Please, add to .htaccess the string:

php_value magic_quotes_runtime 1

You should explicitly describe this option in the installation manual: either to set magic_quotes_runtime = On in the php.ini, or escape all quotation marks with back slash.

skalinks
Admin

Posted: 23 Aug 2005 03:38:24


bug, I know about this directive in php.ini file. There is a magic_quotes_gpc directive, which inserts backslashes before ', ", and as I remember, this directive usuall turned On in most hostings in php.ini file. And if it is, is it necessry to include this option in php.ini file?

bug


Posted: 23 Aug 2005 05:46:32


This is common question. You shouldn't keep in mind such words as "usual" or "most"
Instead, there should be all server options necessary for Your software to get working in the installation manual described explicitly. At this time are found these options:

AllowOverride All
RewriteEngine On
php_value magic_quotes_runtime 1

All options are not supported by all servers.

As for magic_quotes_gpc, in some applications You might get something like this \\\"xxxxx\\\"
after few posting of data.

skalinks
Admin

Posted: 24 Aug 2005 01:27:29


Ok, we will include this option in .htaccess file.
Thank you.