When a user enters our site through a Google search, and they use the '\' character in their search, the following error occurs:
COM Error #: -2147217900 (80040E14)
Category: Microsoft OLE DB Provider for ODBC Drivers
File: www.agf.nl/metatraffic2/clsLog.asp
Line, Column: 313, -1
Description: [MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-nt-log]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 ''agf\' AND k_site = 108' at line 1
At line 313, where the error occurs, a query is executed to load a recordset with matching keywords.
strSql = "SELECT k_id, k_value, k_site " &_
"FROM " & strTablePrefix & "Keywords " &_
"WHERE k_value = " & FormatDatabaseString(strKeywords, 255) & " " &_
"AND k_site = " & intSite
We're using the following configuration:
Windows 2003 Server
MySQL 5.0
VBScript
Can anyone help me out with resolving this error?
error in saving keywords
Can you please specify the version of the software you are using?
error in saving keywords
MetaTraffic 2.24 Pro
error in saving keywords
Hi,
Can you try applying this patch and see if it fixes the problem?
Download the following zipped file:
http://metasun.com/downloads/patch/mtpro_core_patch.zip
- Backup your existing core.asp file in your MetaTraffic installation folder in case you need to revert back to the original file.
- Overwrite the core.asp file with the version in the zip file.
Please let me know if that fixes the problem.
Regards,
~Chad
error in saving keywords
There is a bug in this patch when used with other databases so it will need to be reimplemented but it should work fine with MySQL. Did it fix your problem?
error in saving keywords
It has fixed the problem, thanks a lot!