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.0000 | 356000 | {main}( ) | .../index.php:0 |
| 2 | 0.1066 | 678608 | Prompt::get_prompt_by_tag( $tagID = '10', $sorted = TRUE, $status = 99, $limit = ??? ) | .../index.php:258 |
| 3 | 0.1066 | 679536 | mbp_cache_remember( $key = 'get_prompt_by_tag_v1_10_', $callback = class Closure { virtual $closure = "$this->{closure}" }, $ttl = ??? ) | .../prompt.php:340 |
| 4 | 0.1066 | 679536 | Prompt::{closure:/mnt/webroot/ai_gpt_v2/services/prompt.php:312-340}( ) | .../common.php:2170 |
| 5 | 0.1066 | 680288 | 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.1066 | 680288 | 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 |