Error when trying to update SCJ 1.52 to TCMS

Post Reply
chymp
Posts: 44
Joined: Tue Feb 12, 2013 11:00 pm

Error when trying to update SCJ 1.52 to TCMS

Post by chymp »

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.
admin
Site Admin
Posts: 37994
Joined: Wed Sep 10, 2008 11:43 am

Re: Error when trying to update SCJ 1.52 to TCMS

Post by admin »

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
Don't forget to run script update
Post Reply