Mysql error

Post Reply
mad
Posts: 318
Joined: Fri Nov 30, 2012 4:01 pm

Mysql error

Post by mad »

При просмотре статистики спайдеров по урлу
admin/?operation=trade_stats&redir=true&td=spiders
а именно юзерагентов ботов по урлу
admin/?redir=true&operation=trade_stats&stat=stats_browser&td=spiders
при нажатии кнопки Reset Browsers

Возвращает ошибку
Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and trader = 'spiders'' at line 1) (db_link) in query delete from browsers and trader = 'spiders' . (domain.com) ' in /www/domain.com/public_html/scj/includes/db_modules/mysql.php:64 Stack trace: #0 /www/domain.com/public_html/scj/includes/db_modules/mysql.php(89): db_error('delete from bro...', 1064, 'You have an err...', 'db_link') #1 /www/domain.com/public_html/scj/admin/files/stats_browser.php(0): db_query('delete from bro...') #2 /www/domain.com/public_html/scj/admin/files/trade_stats.php(0): include('/www/d...') #3 /www/domain.com/public_html/scj/admin/index.php(0): include('/www/d...') #4 {main} thrown in /www/domain.com/public_html/scj/includes/db_modules/mysql.php on line 64

(c) SmartCJ Pro V 2.1 Build 201609171942 (Lastest build: 201701241940 )
PHP 5.6.29
5.5.52-MariaDB

Как починить?
Я обожаю SmartCJ :shock: :oops: :twisted:
duhless
Posts: 172
Joined: Thu Oct 30, 2014 4:47 pm

Re: Mysql error

Post by duhless »

Тоже подобное часто ловил
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql error

Post by admin »

Спасибо, поправлено в апе.
Don't forget to run script update
Post Reply