[Request] Create a DB:: unprepared command

[antonioribeiro]

I was trying to create a trigger using migrations after trying everything I discovered that all DB:: commands are under a "prepare" condition and some MySQL commands cannot run, actually if you are using DB::exec you don't have to prepare at all if you don't have variables to resolve.

This is what I was trying to do: http://paste.laravel.com/fIa

This is the error MySQL gives: [PDOException] SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet

I think it would be great to have an unprepared statement on DB::

Using getPDO made it work fine for me: http://paste.laravel.com/fIh

[taylorotwell]

Done.

[n3tninj40]

Can you explain your solution? I'm getting the same error when installing OctoberCMS (based on Laravel) and using MemSQL on Ubuntu 14.04.2 latest with PHP5 and MySQL client driver after running the command: "php artisan october:up" mentioned here: http://octobercms.com/docs/help/console#console-install. The web gui install errors out too. I have everything installed including all the Apache caveats related to the install and errors as well.

The full error is: " [PDOException] SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet "