SmartCJ Support Forum

I've updated my site to SCJ 1.52 and am trying to update to TCMS. I successfully installed TCMS and ran scj_1to2_db_converter.php and get the following error:

Fatal error: Uncaught Exception: Mysql error:: 1054 (Unknown column 'start_time' in 'field list') (db_link) in query insert ignore into rot_search_queries (`search_query`, `hits`, `gal_id`, `items_found`, `date`, `start_time`) values ('Flora', '6', '4308', '12', '2025-04-17', '0'). () in /home/httpd/html/mydomain.com/public_html/scj2/includes/db_modules/mysql.php:160

Any advice is appreciated, thank you.

Hi!

I guess somebody modified rot_search_queries table as there's no `start_time` field in the original one

0. create backup
1. delete field start_time in rot_search_queries
3. rerun update