AI写作
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 | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0017 | 357976 | {main}( ) | .../index.php:0 |
| 2 | 0.2998 | 682096 | Prompt::get_prompt_by_tag( $tagID = '10', $sorted = TRUE, $status = 99, $limit = ??? ) | .../index.php:258 |
| 3 | 0.2999 | 683024 | mbp_cache_remember( $key = 'get_prompt_by_tag_v1_10_', $callback = class Closure { virtual $closure = "$this->{closure}" }, $ttl = ??? ) | .../prompt.php:340 |
| 4 | 0.2999 | 683024 | Prompt::{closure:/mnt/webroot/ai_gpt_v2/services/prompt.php:312-340}( ) | .../common.php:2170 |
| 5 | 0.3002 | 683776 | DB->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 |
| 6 | 0.3002 | 683776 | DB->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 |