SELECT p.* FROM prompt_category t left join prompt_category_map pt on pt.tagID=t.id left join prompts p on pt.promptID = p.id where t.id=10 and p.id is not null and p.status=99 group by p.id order by p.status desc, p.orders desc
( ! ) Fatal error: Uncaught Exception: Unknown column 'pt.tagID' in 'on clause' in /mnt/webroot/ai_gpt_v2/services/common.php on line 119
( ! ) Exception: Unknown column 'pt.tagID' in 'on clause' in /mnt/webroot/ai_gpt_v2/services/common.php on line 119
Call Stack
#TimeMemoryFunctionLocation
10.0000357888{main}( ).../tag.php:0
20.0057568928Prompt::get_prompt_by_tag( $tagID = '10', $sorted = TRUE, $status = 99, $limit = ??? ).../tag.php:33
30.0057569856mbp_cache_remember( $key = 'get_prompt_by_tag_v1_10_', $callback = class Closure { virtual $closure = "$this->{closure}" }, $ttl = ??? ).../prompt.php:340
40.0057569856Prompt::{closure:/mnt/webroot/ai_gpt_v2/services/prompt.php:312-340}( ).../common.php:2170
50.0058570608DB->fetch_all( $sql = 'SELECT p.* FROM prompt_category t \n left join prompt_category_map pt on pt.tagID=t.id\n left join prompts p on pt.promptID = p.id\n where t.id=10 and p.id is not null and p.status=99 group by p.id\n order by p.status desc, p.orders desc ' ).../prompt.php:324
60.0058570608DB->query( $sql = 'SELECT p.* FROM prompt_category t \n left join prompt_category_map pt on pt.tagID=t.id\n left join prompts p on pt.promptID = p.id\n where t.id=10 and p.id is not null and p.status=99 group by p.id\n order by p.status desc, p.orders desc ' ).../common.php:133