SQLSTATE[HY000]

[EndErr]

From this morning I started to get that error on model->save(): SQLSTATE[HY000]: General error: -104 Dynamic SQL Error SQL error code = -104 Unexpected end of command - line 1, column 1 From SQLSTATE Error Codes and Descriptions it says that it is a

CLI-specific condition Nothing was changed in the system (using CentOS 6.9, php 7.1, pdo-firebird).

After some testing I found that the problem is in Schema::insert method. Not having much time to dig dipper I reverted this method to a older and averything works, but not fixed.

[marcinmisiak]

PHP 8.0 Yii2 2.40 When use Firebird PROCEDURE i have the same error: SQLSTATE[HY000]: General error: -104 Dynamic SQL Error SQL error code = -104 Unexpected end of command - line 1

Did you test yii2-firebird + PHP8?

oh if name param is witch "_" there error eg.: :stud_id When change to: :studid work ok, so:

\Yii::$app->db->createCommand( "select wynik from cz_dajzaleglosc(:stud_id, :data_od, :data_do, 2)", [ "stud_id" => 56286, "data_od" => "$data_od", "data_do" => "$data_do" ] )->queryOne();

• give error: SQLSTATE[HY000]: General error: -104 Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 36 _id Failed to prepare SQL: select wynik from cz_dajzaleglosc(:stud_id, :dataod, :datado, 2)

CODE: \Yii::$app->db->createCommand( "select wynik from cz_dajzaleglosc(:studid, :dataod, :datado, 2)", [ "studid" => 56286, "dataod" => "$data_od", "datado" => "$data_do" ] )->queryOne(); Work ok!

[edgardmessias]

Sorry, but I haven't used Yii2 or firebird in a long time, but pull requests are welcome

[marcinmisiak]

BUG was in PHP8.0 , after upgrade PHP to PHP 8.0.2 parameters name with "_" work perfect