jacquestvanzuydam / laravel-firebird Goto Github PK

Hi.

I've been testing the branch 5.2-sup with the composer updated for laravel 5.3, and it seems to be working like it did on 5.2. I'll test extensively this week and report back. Should I PR the changes on the composer.json?

ErrorException in ConnectionFactory.php line 21:
Declaration of Firebird\ConnectionFactory::createConnection() should be compatible with Illuminate\Database\Connectors\ConnectionFactory::createConnection($driver, $connection, $database, $prefix = '', array $config = Array)

What can it be?

My config/app.php

<?php

return [

    /*
    |--------------------------------------------------------------------------
    | Application Name
    |--------------------------------------------------------------------------
    |
    | This value is the name of your application. This value is used when the
    | framework needs to place the application's name in a notification or
    | any other location as required by the application or its packages.
    |
    */

    'name' => env('APP_NAME', 'Laravel'),

    /*
    |--------------------------------------------------------------------------
    | Application Environment
    |--------------------------------------------------------------------------
    |
    | This value determines the "environment" your application is currently
    | running in. This may determine how you prefer to configure various
    | services your application utilizes. Set this in your ".env" file.
    |
    */

    'env' => env('APP_ENV', 'production'),

    /*
    |--------------------------------------------------------------------------
    | Application Debug Mode
    |--------------------------------------------------------------------------
    |
    | When your application is in debug mode, detailed error messages with
    | stack traces will be shown on every error that occurs within your
    | application. If disabled, a simple generic error page is shown.
    |
    */

    'debug' => env('APP_DEBUG', false),

    /*
    |--------------------------------------------------------------------------
    | Application URL
    |--------------------------------------------------------------------------
    |
    | This URL is used by the console to properly generate URLs when using
    | the Artisan command line tool. You should set this to the root of
    | your application so that it is used when running Artisan tasks.
    |
    */

    'url' => env('APP_URL', 'http://localhost'),

    /*
    |--------------------------------------------------------------------------
    | Application Timezone
    |--------------------------------------------------------------------------
    |
    | Here you may specify the default timezone for your application, which
    | will be used by the PHP date and date-time functions. We have gone
    | ahead and set this to a sensible default for you out of the box.
    |
    */

    'timezone' => 'UTC',

    /*
    |--------------------------------------------------------------------------
    | Application Locale Configuration
    |--------------------------------------------------------------------------
    |
    | The application locale determines the default locale that will be used
    | by the translation service provider. You are free to set this value
    | to any of the locales which will be supported by the application.
    |
    */

    'locale' => 'en',

    /*
    |--------------------------------------------------------------------------
    | Application Fallback Locale
    |--------------------------------------------------------------------------
    |
    | The fallback locale determines the locale to use when the current one
    | is not available. You may change the value to correspond to any of
    | the language folders that are provided through your application.
    |
    */

    'fallback_locale' => 'en',

    /*
    |--------------------------------------------------------------------------
    | Encryption Key
    |--------------------------------------------------------------------------
    |
    | This key is used by the Illuminate encrypter service and should be set
    | to a random, 32 character string, otherwise these encrypted strings
    | will not be safe. Please do this before deploying an application!
    |
    */

    'key' => env('APP_KEY'),

    'cipher' => 'AES-256-CBC',

    /*
    |--------------------------------------------------------------------------
    | Logging Configuration
    |--------------------------------------------------------------------------
    |
    | Here you may configure the log settings for your application. Out of
    | the box, Laravel uses the Monolog PHP logging library. This gives
    | you a variety of powerful log handlers / formatters to utilize.
    |
    | Available Settings: "single", "daily", "syslog", "errorlog"
    |
    */

    'log' => env('APP_LOG', 'single'),

    'log_level' => env('APP_LOG_LEVEL', 'debug'),

    /*
    |--------------------------------------------------------------------------
    | Autoloaded Service Providers
    |--------------------------------------------------------------------------
    |
    | The service providers listed here will be automatically loaded on the
    | request to your application. Feel free to add your own services to
    | this array to grant expanded functionality to your applications.
    |
    */

    'providers' => [

        /*
         * Laravel Framework Service Providers...
         */
        Illuminate\Auth\AuthServiceProvider::class,
        Illuminate\Broadcasting\BroadcastServiceProvider::class,
        Illuminate\Bus\BusServiceProvider::class,
        Illuminate\Cache\CacheServiceProvider::class,
        Illuminate\Foundation\Providers\ConsoleSupportServiceProvider::class,
        Illuminate\Cookie\CookieServiceProvider::class,
        Illuminate\Database\DatabaseServiceProvider::class,
        Illuminate\Encryption\EncryptionServiceProvider::class,
        Illuminate\Filesystem\FilesystemServiceProvider::class,
        Illuminate\Foundation\Providers\FoundationServiceProvider::class,
        Illuminate\Hashing\HashServiceProvider::class,
        Illuminate\Mail\MailServiceProvider::class,
        Illuminate\Notifications\NotificationServiceProvider::class,
        Illuminate\Pagination\PaginationServiceProvider::class,
        Illuminate\Pipeline\PipelineServiceProvider::class,
        Illuminate\Queue\QueueServiceProvider::class,
        Illuminate\Redis\RedisServiceProvider::class,
        Illuminate\Auth\Passwords\PasswordResetServiceProvider::class,
        Illuminate\Session\SessionServiceProvider::class,
        Illuminate\Translation\TranslationServiceProvider::class,
        Illuminate\Validation\ValidationServiceProvider::class,
        Illuminate\View\ViewServiceProvider::class,


        /*
         * Package Service Providers...
         */


        /*
         * Application Service Providers...
         */
        App\Providers\AppServiceProvider::class,
        App\Providers\AuthServiceProvider::class,
        // App\Providers\BroadcastServiceProvider::class,
        App\Providers\EventServiceProvider::class,
        App\Providers\RouteServiceProvider::class,

    ],

    /*
    |--------------------------------------------------------------------------
    | Class Aliases
    |--------------------------------------------------------------------------
    |
    | This array of class aliases will be registered when this application
    | is started. However, feel free to register as many as you wish as
    | the aliases are "lazy" loaded so they don't hinder performance.
    |
    */

    'aliases' => [

        'App' => Illuminate\Support\Facades\App::class,
        'Artisan' => Illuminate\Support\Facades\Artisan::class,
        'Auth' => Illuminate\Support\Facades\Auth::class,
        'Blade' => Illuminate\Support\Facades\Blade::class,
        'Broadcast' => Illuminate\Support\Facades\Broadcast::class,
        'Bus' => Illuminate\Support\Facades\Bus::class,
        'Cache' => Illuminate\Support\Facades\Cache::class,
        'Config' => Illuminate\Support\Facades\Config::class,
        'Cookie' => Illuminate\Support\Facades\Cookie::class,
        'Crypt' => Illuminate\Support\Facades\Crypt::class,
        'DB' => Illuminate\Support\Facades\DB::class,
        'Eloquent' => Illuminate\Database\Eloquent\Model::class,
        'Event' => Illuminate\Support\Facades\Event::class,
        'File' => Illuminate\Support\Facades\File::class,
        'Gate' => Illuminate\Support\Facades\Gate::class,
        'Hash' => Illuminate\Support\Facades\Hash::class,
        'Lang' => Illuminate\Support\Facades\Lang::class,
        'Log' => Illuminate\Support\Facades\Log::class,
        'Mail' => Illuminate\Support\Facades\Mail::class,
        'Notification' => Illuminate\Support\Facades\Notification::class,
        'Password' => Illuminate\Support\Facades\Password::class,
        'Queue' => Illuminate\Support\Facades\Queue::class,
        'Redirect' => Illuminate\Support\Facades\Redirect::class,
        'Redis' => Illuminate\Support\Facades\Redis::class,
        'Request' => Illuminate\Support\Facades\Request::class,
        'Response' => Illuminate\Support\Facades\Response::class,
        'Route' => Illuminate\Support\Facades\Route::class,
        'Schema' => Illuminate\Support\Facades\Schema::class,
        'Session' => Illuminate\Support\Facades\Session::class,
        'Storage' => Illuminate\Support\Facades\Storage::class,
        'URL' => Illuminate\Support\Facades\URL::class,
        'Validator' => Illuminate\Support\Facades\Validator::class,
        'View' => Illuminate\Support\Facades\View::class,

    ],

];

Hello people,

I’m having some troubles when inserting especial characters(á,é,í,ó,ú,ñ) into de database. The FB I’m working with is encoded with ‘WIN1254’ charset and I can read properly any register that has especial characters, but when it comes to insert the data, it gets saved with the wrong encoding.

Note: When saving the data with plain php pdo, it works just fine.

Anyone has had this problem?

5.4-Support - https://github.com/jacquestvanzuydam/laravel-firebird/tree/5.4-support#installation
5.5-Support - https://github.com/jacquestvanzuydam/laravel-firebird/tree/5.5-support#installation

so i got this error message

PDOException in Connection.php line 90:
SQLSTATE[HY000] [335544344] I/O error during "CreateFile (open)" operation for file "/storage/firebird/DBCUBIS_OPRS.FDB"

when i try to test it with

Route::get('firebird', function()
{
    $users = DB::connection('firebird')->table('user')->get();
    dd($users);
});

and in my connection

'firebird' => [
            'driver'   => 'firebird',
            'host'     => env('DB_HOST_Firebird', 'localhost'),
            'database' => env('DB_DATABASE_Firebird','/storage/firebird/DBCUBIS_OPRS.FDB'),
            'username' => env('DB_USERNAME_Firebird', 'SYSDBA'),
            'password' => env('DB_PASSWORD_Firebird', 'masterkey'),
            'charset'  => env('DB_CHARSET_Firebird', 'UTF8'),
        ],

and i already make sure i never changed any username or password....

note:
laravel version: 5.4
php version: 7.0
using XAMPP in windows 10 Pro 64bit

Detail

1. in Connector.php line 55
2. at PDO->__construct('firebird:dbname=localhost:/storage/firebird/name_database.FDB', 'sysdba', 'masterkey', array('0', '2', '0', false, false)) in Connector.php line 55

Somebody could help me?

I coded

composer require jacquestvanzuydam/laravel-firebird:dev-5.1-support

added to config/database.php

    'firebird' => [
        'driver'   => 'firebird',
        'host'     => env('DB_HOST', 'localhost'),
        'database' => '/storage/firebird/G_CHIOSCO.FDB',
        'username' => 'sysdba',
        'password' => 'masterkey',
        'charset'  => env('UTF8'),
    ],

added to config/app.php

Firebird\FirebirdServiceProvider::class,

added

DB_CHARSET=UTF8

I use in the same project also a mysql database, so in the model where i need this connection i coded

added to the stats.php model

protected $connection = 'firebird';

Thanks a lot look like great job and i would like try!

When using version 2.0.7 of Firebird, Laravel 5.0 shows error

PDOException in Connector.php line 47:could not find driver

Hello,

Thanks for this package.

Installing it via Composer prints this error.

Problem 1
- Installation request for jacquestvanzuydam/laravel-firebird dev-5.3-support -> satisfiable by jacquestvanzuydam/la
ravel-firebird[dev-5.3-support].
- Conclusion: remove laravel/framework v5.4.6
- Conclusion: don't install laravel/framework v5.4.6
- jacquestvanzuydam/laravel-firebird dev-5.3-support requires illuminate/events 5.3.* -> satisfiable by illuminate/e
vents[v5.3.0, v5.3.16, v5.3.23, v5.3.4].
- don't install illuminate/events v5.3.0|don't install laravel/framework v5.4.6
- don't install illuminate/events v5.3.16|don't install laravel/framework v5.4.6
- don't install illuminate/events v5.3.23|don't install laravel/framework v5.4.6
- don't install illuminate/events v5.3.4|don't install laravel/framework v5.4.6
- Installation request for laravel/framework (locked at v5.4.6, required as 5.4.*) -> satisfiable by laravel/framework[v5.4.6].

Will we be having support for Laravel 5.4.*?

Can i install it manually? Do i need to modify any files to make it work with Laravel 5.4.

Thanks.

Do you plan support it?

Thanks!

i'm using support 5.5.
when i want paginate results, laravel return this screens

any idea?

Hello, I have a problem with migration for adding a new column to the database.
When I try to add new column:

Schema::table('table_name', function (Blueprint $table) {
$table->integer('column_name');
});

migration executed, but the column missing in the database.
How can I resolve this?

I'm using Eloquent in a project outside of Laravel, I wonder how I register your provider to use adapter?

Is there any compatibility issue with Laravel 5.2.x that can cause malfunction with your package? I've been trying to install on it, but keeps me showing errors about laravel version.

Thanks in advance,

Firebird way for auto increments is using generators and trigger. Applications like Firebird Maestro and Flamerobin can create this automatically. I have been looking up Laravel 5.1 migration classes, but still have no idea how this could be created automatically when running the migration.

In requests driver works, but all commands dont works (ex: php artisan migrate, vendor/bin/phpunit).

1. BookTest::test_criar_book
   PDOException: could not find driver

D:\FONTES\Php\firebird\vendor\jacquestvanzuydam\laravel-firebird\src\Firebird\Connection.php:90
D:\FONTES\Php\firebird\vendor\jacquestvanzuydam\laravel-firebird\src\Firebird\Connection.php:46
D:\FONTES\Php\firebird\vendor\jacquestvanzuydam\laravel-firebird\src\Firebird\ConnectionFactory.php:98
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\Connectors\ConnectionFactory.php:64
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\Connectors\ConnectionFactory.php:50
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php:176
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php:68
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:3351
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:3317
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1861
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1834
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1450
D:\FONTES\Php\firebird\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:561
D:\FONTES\Php\firebird\tests\BookTest.php:15

please add license in package description

http://packalyst.com/packages/package/jacquestvanzuydam/laravel-firebird

my guess is mit :)

I had installed this package using:
composer require jacquestvanzuydam/laravel-firebird:dev-5.5-support
and i installed also php7.0-interbase tha enables firebird pdo
i enabled pdo-firebird php module with:
phpenmod pdo_firebird
when i run :
php -m
it shows me that pdo_firebird is compiled and loaded.

when i print :
print_r(PDO::getavailabledrivers());
it shows

[0] => 'firebird'

but when i run laravel thinker and try to execute:
App\EMPLOYEE::all();

it shows:

InvalidArgumentException with message: UnsupportedDriver[firebird]'

I'm using php 7 and firebird 2.5 superclassic under ubuntu 16.04 xenial

Hi! I'm working with the following stack and eventually i have the error: "Connection rejected by remote interface". Sometimes 15 seconds later it back to work

Laravel 5.2
PHP 7.0
Firebird 2.5 classic
Ubuntu 16.04

Thanks for any information

Hi Guys.

I'm working on an API which uses FB 1.5 database. For my surprise, this drivers works in a old version firebird database.

However I cant query stored procedure due a quotation marks on table name.

Laravel query
select * from "E_SP_PLANILHA_VENDA_LOJAS('', '', '', '')" order by "CODIGO_LOJA"

Supposed correct query
select * from E_SP_PLANILHA_VENDA_LOJAS('', '', '', '') order by "CODIGO_LOJA"

If has a way to force this driver to dont placle quotation marks? If dont, may I make a PR to add this functionality?

Thanks.

When attempting to create a field as $ table-> string ('email', 160), the tool always creates as varchar (255)

Hello, I'm having trouble inserting text inside a blob-type field. In some cases it inserts and others do not.
In both cases when I use the save method does not return error, but also does not return success.
I've done a test changing the field type to Varchar from 2000 and I have the same problem.
I was wondering if anyone had this problem and how it worked.

Hi.

I know this is probably not your package's issue, but I was hoping for some explanation, maybe solution.

Problem

I have a simple query:

Person::where('PATIENT_ID', 'LIKE', '770915%')->paginate(10);

It essentially executes two queries:

SELECT count(*) as aggregate FROM "PERSON" WHERE "PATIENT_ID" LIKE '770915%'

and

SELECT first 10 skip 0 * FROM "PERSON" WHERE "PATIENT_ID" LIKE '770915%'

Everything works perfectly, but the problem is execution time.
When I run these queries in IBExpert I get Execution time = 16ms(sometimes 32ms, sometimes 0).
However if ran with Laravel, Clockwork shows respectively 600ms and 350ms.

I dug a bit in the Laravel Eloquent core and found, that the eg. first query looks like this:

SELECT count(*) as aggregate FROM "PERSON" WHERE "PATIENT_ID" LIKE ?

Then, Laravel binds parameters to the prepared statement and after that fetches all rows.

I thought I'd fiddle with raw PHP PDO to replicate this and I found out that adding single quotes around the question mark speeds up the query from 600ms to 30ms.
Similar thing happens in IBExpert. If I type:

SELECT count(*) as aggregate FROM "PERSON" WHERE "PATIENT_ID" LIKE :patientID

and execute, there is a popup window for parameter input and after filling out the form the query executes for 600ms. If I however skip the parameter and pass the value explicitly into the query it goes back to 16ms.

Possible solution

When Laravel binds where clause parameters, it goes though Illuminate\Database\Grammar::parameter() method.
It looks like this:

public function parameter($value)
{
    return $this->isExpression($value) ? $this->getValue($value) : '?';
}

If I override that in FirebirdGrammar with following code:

public function parameter($value)
{
    if($this->isExpression($value)) {
        return $this->getValue($value);
    }

    if(is_string($value)) {
        return "'?'";
    }

    return "?";
}

I get a huge improvement in both queries. Clockwork now shows 90ms and 20ms respectively. It's slower than when ran with IBExpert probably because of the VPN connection and PDO overhead.

Conclusion

Can you check if

1. This issue also exists in your environment?
2. This change doesn't break any of your existing code?

Do you have any knowledge of Firebird or PHP's Firebird PDO that can explain this behaviour?

I'm using Laravel 5.3 with [email protected] and Firebird 2.5.3

Always whem im trying to get UTF8 characters like ñ, á, ó, é, ° etc i have this error, help me please i need fix this to have mi app in production.

UnexpectedValueException in Response.php line 403:
The Response content must be a string or object implementing __toString(), "boolean" given.

I'm working with the driver in an app that is ok. Now i need to extend this app and my first requirement is to install Laravel Passport package, so i follow every step and when i do "php artisan passport:install" i get the error:

In Processor.php line 34:

  SQLSTATE[IM001]: Driver does not support this function: driver does not support lastInsertId()

Following the stacktrace i see that the Processor.php file that is using is in vendor\laravel\framework\src\Illuminate\Database\Query\Processors\ and calls lastInsertId php function. I'm stuck in here and don't know what to do to fix this problem.

I create a new Model Object
$sale = new Sale();
Then, i updated its fields
$sale->amount=.... # and som other update

When i tried to insert t with $sale->save()
I got the following error:

SQLSTATE[IM001]: Driver does not support this function: driver does not support lastInsertId()

Hello,

I cannot connect to a Firebird DB that is on a non-default port.
If I connect to the default port (3050) all works fine.

In the PDO documentation under example 2 there is the possibility to add a port.
If I change the relevant part (in Connection.php, line 69) I still have the same issue.

Does anyone has a tip for me to get it running?

Thanks and kind regards,
Mario

This is the query returns:

0 => array:6 [▼
"CODCC" => "001"
"DSCCC" => b"INSCRIÇÃO IPSC - PISTOLA"
"VALOR" => "150.00"
"DT_ATZ" => null
"DT_INI_INS" => "2016-02-20"
"DT_FIM_INS" => "2016-02-29"
]

Note that in the "DSCCC" => b "INSCRIÇÃO IPSC - PISTOLA" there is a b before starting the registry value, every time the record has some special character that happens, so the laravel can not transform variable in information.

Can you help me please?

Support transactions?

Could not find the package

I'm having a problem when using Eloquent with blob fields... The execution stops...
What can I do?

Thanks

I have problem with generating helper with Laravel 5 IDE Helper Generator. I created second connection to Firebird database and model:

<?php

namespace App\Models\Firebird;

use Illuminate\Database\Eloquent\Model;

class ScEvents extends Model
{
    protected $connection = 'firebird';
    protected $table = 'SC_EVENTS';
}

Next when I run command php artisan ide-helper:models have this error:

  [Symfony\Component\Debug\Exception\FatalThrowableError]
  Call to undefined method Firebird\Connection::getDoctrineDriver()

Connection with Firebird database and model is OK.

Full log message:

[2017-03-14 10:16:40] local.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Call to undefined method Firebird\Connection::getDoctrineDriver() in ***\vendor\laravel\framework\src\Illuminate\Database\Connection.php:853
Stack trace:
#0 ***\vendor\barryvdh\laravel-ide-helper\src\Console\ModelsCommand.php(311): Illuminate\Database\Connection->getDoctrineSchemaManager('SC_ACTIONS')
#1 ***\vendor\barryvdh\laravel-ide-helper\src\Console\ModelsCommand.php(195): Barryvdh\LaravelIdeHelper\Console\ModelsCommand->getPropertiesFromTable(Object(App\Models\Firebird\ScActions))
#2 ***\vendor\barryvdh\laravel-ide-helper\src\Console\ModelsCommand.php(95): Barryvdh\LaravelIdeHelper\Console\ModelsCommand->generateDocs(Array, Array)
#3 [internal function]: Barryvdh\LaravelIdeHelper\Console\ModelsCommand->fire()
#4 ***\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(29): call_user_func_array(Array, Array)
#5 ***\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#6 ***\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))
#7 ***\vendor\laravel\framework\src\Illuminate\Container\Container.php(524): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)
#8 ***\vendor\laravel\framework\src\Illuminate\Console\Command.php(182): Illuminate\Container\Container->call(Array)
#9 ***\vendor\symfony\console\Command\Command.php(265): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#10 ***\vendor\laravel\framework\src\Illuminate\Console\Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#11 ***\vendor\symfony\console\Application.php(826): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 ***\vendor\symfony\console\Application.php(189): Symfony\Component\Console\Application->doRunCommand(Object(Barryvdh\LaravelIdeHelper\Console\ModelsCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 ***\vendor\symfony\console\Application.php(120): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 ***\vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php(123): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 ***\artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 {main}  

When I try run the migrations happens this:

Migration table created successfully.
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: -206 Dynamic SQL Error SQL error code = -206 Column unknown migration At line 1, column 20 (SQL: select "migration" from "migrations" order by "batch" asc, "migration" asc)

The problem is that in firebird I cant run select "migration" from "migrations" order by "batch" asc, "migration" asc it should be select migration from migrations order by batch asc, migration asc

About double quotes in other places like create table or alter table I resolved in file FirebirdGrammar.php but this query with double quotes seems be default in laravel, I just need to know where laravel build this query for remove the double quotes before run.

Using laravel 5.4, Firebird 2.5 and php 7.

hello jacquestvanzuydam, i have field price with type data numeric(15,2) and my raw query is

$data = DB::select("select * from DATA_MASTER('{$param1}','{$param2}')");

price in the procedure is 10000.00, but the result in php is 1563888.64 ,how to fix it

Hi.

I've upgrade Laravel to 5.4 but now I have problems with laravel-firebird. Will there be support for this version?

Does it have support?

Thanks!

Hello, I have a problem with the library since the version of laravel 5.8.5 onwards, even probe with a clean installation and gives the same error

Argument 1 passed to Illuminate\Database\Connection::setReconnector() must be callable, null given, called in ...\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php on line 179

public function index()
{
return DB::connection('firebird')->table('cliente')->get();
}
I'm get error for this code using laravel 5.3.
obs: the file DB_EX.GDB have 777 permission.

PDOException in Connection.php line 90:
SQLSTATE[HY000] [335544344] I/O error during "open" operation for file "/storage/DB_EX.GDB"

.env:
DB_CONNECTION=firebird
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=/storage/DB_EX.GDB
DB_USERNAME=ex
DB_PASSWORD=keyex
DB_CHARSET=UTF8

config/app:
'firebird' => [
'driver' => 'firebird',
'host' => env('DB_HOST', '127.0.0.1'),
'database' => env('DB_DATABASE', '/storage/firebird/APPLICATION.FDB'),
'username' => env('DB_USERNAME', 'sysdba'),
'password' => env('DB_PASSWORD', 'masterkey'),
'charset' => env('DB_CHARSET', 'UTF8'),
],

Anyone have any idea how to solve it?

composer require jacquestvanzuydam/laravel-firebird:dev-5.3-support fails on illuminate/events.
Maybe you have to update composer.json to include 5.3.* of Illuminate libraries instead of 5.0.*

Is there any plans to exted the compatibility for Laravel 5.2.x

php artisan migrate

[PDOException]
could not find driver

you can help me?

PDOException in Processor.php line 34:
SQLSTATE[IM001]: Driver does not support this function: driver does not support lastInsertId()

Hi everyone.

I don't know if is a Laravel's bug or a PDO bug. It's annoying me a lot, delaying my deploys and all.

First of all, let me introduce my scenario in production environment.

• Windows Server 2008 R2
• PHP 5.6 (planning upgrade to 7.3 soon)
• Firebird 1.5 (Doesn't depend on me to upgrade)
• Apache 2.4

I have a method that does a lot of inserts in 5 different tables (this case I'm processing a e-commerce order). Some of then does only one insert, others many inserts. When I will make a insert on 5th table, my PDO returns SQL error that table does not exist. (Yeah, It f*** exists!)

Even if I change order of inserts, fails always on 5th table. I dunno why and I don't have idea what is going on.

Anyone get a situation like this? My project is a legacy code, not a Laravel project.

Please, can anybody open a new Branch for the new Laravel 5.5?

I made a fork and made tests with the new version and I already have the pull request for it.

Thank you.

I have this erro The Response content must be a string or object implementing __toString(), "boolean" given. when i trying to get data with utf8 charsets like "Almacén"

When try insert using create or DB:insert(), the string values is not with double quotes.

QueryException in Connection.php line 662:
SQLSTATE[HY000]: General error: -204 Dynamic SQL Error SQL error code = -204 Table unknown USERS At line 1, column 13 (SQL: insert into users (name, email, password) values (teste, [email protected], asdasd))

php7, firebird 2.5.7, laravel 5.1

I'm try to use persistent connection an it's doesn't work.
Someone tried

Regards
Wiesiek

The tables created by artisan migrate in IBOConsole always appears with quotation marks, for use in IBOconsole: select * from "users". To use the pre-existing tables, created in IBOConsole, in laravel whenever I have to do it always with their names and fields in capital letters. I hope I have succeeded in explaining!

Laravel 5.1, Win7, Firebird 2.5

How to execute the migrations in firebird, if firebird does not accept autoincrement in the id of the migrations table.