使用Oracle将数据导入laravel中的Elasticsearch的问题

有人可以帮助我吗?当我尝试将数据导入elasticsearch时,出现以下错误。使用的数据库是Oracle。

当我这样做时:

php artisan scout:import "Amp\XIP\Linesearch

我在下面收到此错误:

Illuminate\Database\QueryException : ORA-01741: illegal zero-length identifier (SQL: select t2.* from ( select rownum AS "rn",t1.* from (select * from "SA"."TABLE_X_SEARCH_CUSTOMER" order by "" asc) t1 ) t2 where t2."rn" between 1 and 500)

at /Users/amp/Sites/amp3/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
660| // If an exception occurs when attempting to run a query,we'll format the error
661| // message to include the bindings with SQL,which will make this exception a
662| // lot more helpful to the developer instead of just the database's errors.
663| catch (Exception $e) {

664| throw new QueryException(
665| $query,$this->prepareBindings($bindings),$e
666| );
667| }
668|

Exception trace:

1 Yajra\Pdo\Oci8\Exceptions\Oci8Exception::("ORA-01741: illegal zero-length identifier")
/Users/amp/Sites/amp3/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:122

2 Yajra\Pdo\Oci8::prepare("select t2.* from ( select rownum AS "rn",t1.* from (select * from "SA"."TABLE_X_SEARCH_CUSTOMER" order by "" asc) t1 ) t2 where t2."rn" between 1 and 500")
/Users/amp/Sites/amp3/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326

我正在使用此软件包https://github.com/babenkoivan/scout-elasticsearch-driver

a9413164 回答:使用Oracle将数据导入laravel中的Elasticsearch的问题

您不能像这样使用订单:通过“”订购

而不是使用按空排序

本文链接:https://www.f2er.com/3159614.html

大家都在问