Page 1 of 1
TDS mysql error
Posted: Mon Apr 13, 2020 6:52 pm
by alexscj
Hello, after migrating the database to TCMS from v1, getting a mysql error related to TDS:
2020-04-13 21:49:27 :: 1054 :: Unknown column 'hr21' in 'field list' :: SELECT hr21 as row, hu21 as uni FROM day WHERE trader = '16.smartcj.tds'
Tried updating, repairing the mysql db.
*Build 202004130658
Re: TDS mysql error
Posted: Mon Apr 13, 2020 7:23 pm
by admin
where exactly?
Re: TDS mysql error
Posted: Mon Apr 13, 2020 7:35 pm
by alexscj
In ?operation=traffic_rules&sub=tds
Re: TDS mysql error
Posted: Mon Apr 13, 2020 7:35 pm
by alexscj
The error above is from mysql_error log.
Re: TDS mysql error
Posted: Tue Apr 14, 2020 6:30 am
by admin
I see
run update plz
Re: TDS mysql error
Posted: Tue Apr 14, 2020 4:42 pm
by alexscj
Updated (Build 202004140925), slightly different error in Traffic Rules - TDS:
Fatal error: Uncaught Exception: Mysql error:: 1054 (Unknown column 'hour' in 'where clause') (db_link) in query SELECT SUM(raw) as row, SUM(uni) as uni FROM day_last_hour WHERE trader = '16.smartcj.tds' and hour = '440800' . (domain_removed.com) in /.../includes/db_modules/mysql.php:129 Stack trace: #0 /.../includes/db_modules/mysql.php(182): db_error('SELECT SUM(raw)...', 1054, 'Unknown column ...', 'db_link') #1 /.../includes/db_modules/mysql.php(326): db_query('SELECT SUM(raw)...', 'db_link') #2 /.../admin/files/tds.php(305): db_get_row('SELECT SUM(raw)...') #3 /.../admin/index.php(309): unknown() #4 {main} thrown in /.../includes/db_modules/mysql.php on line 129
In Script messages:
2020-04-14 19:40:13 : Mysql error 1054: Unknown column 'hour' in 'where clause' (Please, run update. If it doesnt help - contact script support)
Re: TDS mysql error
Posted: Tue Apr 14, 2020 6:12 pm
by admin
run update one more time plz
Re: TDS mysql error
Posted: Tue Apr 14, 2020 6:28 pm
by alexscj
Worked! Thanks!
Re: TDS mysql error
Posted: Wed Apr 15, 2020 3:50 am
by admin
Thanks for the report )