excepInfo: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'length(us.spe_price)' in 'order clause'
excepFile: /www/wwwroot/www.jkouyu.com/core/think/db/Connection.php
excepLine: 342
excepCode: 42S22
excepTime: 2024-06-08 02:02:37
#0 COOLC_PATH/core/think/db/Connection.php(342): PDO->prepare(SELECT `mus`.*,`us`.`simple`,`us`.`spe_price`,`us`.`ads_price`,`us`.`matching` FROM music as mus LEFT JOIN `user` `us` ON `us`.`id`=`mus`.`user_id` WHERE  (  mus.is_del = 0 and us.commuting = 0 and find_in_set(178,mus.cat_id) and us.spe_price >= 80 and us.spe_price <= 120 ) ORDER BY `length(us.spe_price)` ASC,`us`.`spe_price` ASC LIMIT 0,25 )
#1 COOLC_PATH/core/think/db/Query.php(223): think\db\Connection->query(SELECT `mus`.*,`us`.`simple`,`us`.`spe_price`,`us`.`ads_price`,`us`.`matching` FROM music as mus LEFT JOIN `user` `us` ON `us`.`id`=`mus`.`user_id` WHERE  (  mus.is_del = 0 and us.commuting = 0 and find_in_set(178,mus.cat_id) and us.spe_price >= 80 and us.spe_price <= 120 ) ORDER BY `length(us.spe_price)` ASC,`us`.`spe_price` ASC LIMIT 0,25 )
#2 COOLC_PATH/core/think/db/Query.php(2338): think\db\Query->query(SELECT `mus`.*,`us`.`simple`,`us`.`spe_price`,`us`.`ads_price`,`us`.`matching` FROM music as mus LEFT JOIN `user` `us` ON `us`.`id`=`mus`.`user_id` WHERE  (  mus.is_del = 0 and us.commuting = 0 and find_in_set(178,mus.cat_id) and us.spe_price >= 80 and us.spe_price <= 120 ) ORDER BY `length(us.spe_price)` ASC,`us`.`spe_price` ASC LIMIT 0,25 )
#3 COOLC_PATH/core/think/db/Query.php(1390): think\db\Query->select()
#4 COOLC_PATH/core/IQuery.php(64): think\db\Query->paginate(25)
#5 COOLC_PATH/app/controllers/voice.php(149): IQuery->find()
#6 COOLC_PATH/core/IInlineAction.php(47): voice->list()
#7 COOLC_PATH/core/IController.php(216): IInlineAction->run()
#8 COOLC_PATH/core/App.php(135): IController->run(list)
#9 COOLC_PATH/core/App.php(41): App->execRequest()
#10 COOLC_PATH/index.php(9): App->run()