Ошибка сервера в приложении '/'.

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 'id,t_name FROM tegs where match(t_name)against(''sneha b-827\'') limit 10')' at line 1SELECT match(t_name)against('sneha b-827\'),id,t_name FROM tegs where match(t_name)against('sneha b-827\') limit 10

Описание: Необработанное исключение при выполнении текущего веб-запроса. Изучите трассировку стека для получения дополнительных сведений о данной ошибке и о вызвавшем ее фрагменте кода.

Сведения об исключении: System.Exception: 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 'id,t_name FROM tegs where match(t_name)against(''sneha b-827\'') limit 10')' at line 1SELECT match(t_name)against('sneha b-827\'),id,t_name FROM tegs where match(t_name)against('sneha b-827\') limit 10

Ошибка источника:


Строка 40:         //if (string.IsNullOrEmpty(SQL)) { SQL = string.Format("<p style=\"color:red\">{0}</p><p>{1}</p>", myError.Message, SQL); }
Строка 41:         //SQL = string.Format("{0}\r\n{1}", myError.Message, SQL);
Строка 42:         throw new Exception(myError.Message + SQL);
Строка 43: 
Строка 44:     }

Исходный файл: d:\WebSites\activeSites\by-hands3\App_Code\Connection.cs    Строка: 42

Трассировка стека:


[Exception: 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 'id,t_name FROM tegs where match(t_name)against(''sneha b-827\'') limit 10')' at line 1SELECT match(t_name)against('sneha b-827\'),id,t_name FROM tegs where match(t_name)against('sneha b-827\') limit 10]
   Connection.AddError(Exception myError, String SQL) in d:\WebSites\activeSites\by-hands3\App_Code\Connection.cs:42
   Connection.FillAdapter(String qwerty, String ConnectionName) in d:\WebSites\activeSites\by-hands3\App_Code\Connection.cs:179
   Connection.FillAdapter(String qwerty) in d:\WebSites\activeSites\by-hands3\App_Code\Connection.cs:62
   _Article.FillSameKeys(Object kName_) in d:\WebSites\activeSites\by-hands3\article.aspx.cs:170
   _Article.Page_Load(Object sender, EventArgs e) in d:\WebSites\activeSites\by-hands3\article.aspx.cs:302
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Информация о версии: Платформа Microsoft .NET Framework, версия:4.0.30319; ASP.NET, версия:4.8.4110.0