AVideo icon indicating copy to clipboard operation
AVideo copied to clipboard

[BUG] MySQL ERROR Ai_transcribe_responses/list.json.php

Open gbrn opened this issue 1 year ago • 3 comments

@DanielnetoDotCom I still keep seeing errors about the AI Plugin... #8660

 [02-Dec-2023 22:45:30 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed again return false SCRIPT_NAME: /plugin/AI/View/Ai_transcribe_responses/list.json.php

 [02-Dec-2023 22:45:30 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":310,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/objects\/Object.php","line":104,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AI\/View\/Ai_transcribe_responses\/list.json.php","line":6,"function":"getAll","class":"ObjectYPT","type":"::"}] SCRIPT_NAME: /plugin/AI/View/Ai_transcribe_responses/list.json.php

 [02-Dec-2023 22:45:30 America/Sao_Paulo] AVideoLog::ERROR: [sqlDAL::readSql] (mysqlnd) Prepare failed: (1054) (Unknown column 'ai' in 'order clause')  preparedStatement = "SELECT * FROM  ai_transcribe_responses WHERE 1=1  ORDER BY  `ai` asc  LIMIT 0, 10 " formats = "" values = [] refreshCache = false SCRIPT_NAME: /plugin/AI/View/Ai_transcribe_responses/list.json.php

 [02-Dec-2023 22:45:30 America/Sao_Paulo] AVideoLog::ERROR: MySQL ERROR: [{"file":"\/var\/www\/html\/AVideo\/objects\/mysql_dal.php","line":298,"function":"log_error"},{"file":"\/var\/www\/html\/AVideo\/objects\/Object.php","line":104,"function":"readSql","class":"sqlDAL","type":"::"},{"file":"\/var\/www\/html\/AVideo\/plugin\/AI\/View\/Ai_transcribe_responses\/list.json.php","line":6,"function":"getAll","class":"ObjectYPT","type":"::"}] SCRIPT_NAME: /plugin/AI/View/Ai_transcribe_responses/list.json.php

gbrn avatar Dec 03 '23 01:12 gbrn

where page and where are you clicking to rise this error?

DanielnetoDotCom avatar Dec 04 '23 11:12 DanielnetoDotCom

This error appears in the LOG record after I activated the AI Plugin.

gbrn avatar Dec 04 '23 15:12 gbrn

it seems to be a table sorting, but I am not sure where it comes from. for now, nothing to worry

DanielnetoDotCom avatar Dec 04 '23 15:12 DanielnetoDotCom