python /home/admin/mtr/script_for_cron.py -j default -m 30 -a 'python3 ~/workarea/git/Velours/python/mtr/utils/prepare_link_perlen_to_consolidate.py --dashboard angers_montee_convoyeur --date_debut 2025-10-01 --date_fin 2025-10-31 --matiere emr' -s prepare_link -M 0 -S 0 -U 90,80,95
 import MySQLdb succeeded 
Import error (python version)
warning , we can't find thcl infos in json_data
warning , we can't find pdt infos in json_data
select dr.mtr_portfolio_id,dr.date_debut,dr.hashtag,dr.qualite,count(mpp.mtr_photo_id),dr.completion_json 
            from MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp where
            dr.hashtag like "%emr" and dr.qualite>0 and dr.dashboard_run_id in (
            select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=36 and date in ('2025-10-01','2025-10-02','2025-10-03','2025-10-04','2025-10-05','2025-10-06','2025-10-07','2025-10-08','2025-10-09','2025-10-10','2025-10-11','2025-10-12','2025-10-13','2025-10-14','2025-10-15','2025-10-16','2025-10-17','2025-10-18','2025-10-19','2025-10-20','2025-10-21','2025-10-22','2025-10-23','2025-10-24','2025-10-25','2025-10-26','2025-10-27','2025-10-28','2025-10-29','2025-10-30','2025-10-31')
            and mpp.mtr_portfolio_id=dr.mtr_portfolio_id group by dr.mtr_portfolio_id order by 
            qualite desc, count(mpp.mtr_photo_id) desc limit 9;
Catched exception !
Connect or reconnect !
Traceback (most recent call last):
  File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 106, in select
    cursor.execute(query, args)
  File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 179, in execute
    res = self._query(mogrified_query)
  File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 330, in _query
    db.query(q)
  File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/connections.py", line 280, in query
    _mysql.connection.query(self, query)
MySQLdb.ProgrammingError: (1064, "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 '' at line 6")

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/admin/workarea/git/Velours/python/mtr/utils/prepare_link_perlen_to_consolidate.py", line 169, in <module>
    data_velours=get_portfolios_of_the_day(context,liste_date_csv,dashboard_id,options.matiere,options.limit, options.order, options.score)
  File "/home/admin/workarea/git/Velours/python/mtr/utils/prepare_link_perlen_to_consolidate.py", line 81, in get_portfolios_of_the_day
    res=context.gq.select(query)
  File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 117, in select
    cursor.execute(query, args)
  File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 179, in execute
    res = self._query(mogrified_query)
  File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 330, in _query
    db.query(q)
  File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/connections.py", line 280, in query
    _mysql.connection.query(self, query)
MySQLdb.ProgrammingError: (1064, "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 '' at line 6")
Command exited with non-zero status 1
0.97user 0.70system 0:01.20elapsed 139%CPU (0avgtext+0avgdata 101572maxresident)k
0inputs+0outputs (0major+24435minor)pagefaults 0swaps