Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
How to generate model from existing tables
I used oil to generate the ormauth tables. Am successfully authenticating using the Ormauth driver (no more serialize stuff - yippie).
I would like to use Model_User for some of my operations. I have tried using the command " oil refine fromdb:model users" to auto generate Model_User but I get the error below;
Database method Fuel\Core\Database_PDO_Connection::list_indexes is not supported by Fuel\Core\Database_PDO_Connection
I tried searching through existing posts but did not get a solution. Kindly help.
Don't use the generic PDO driver if a native driver exists, as functions like that are RDBMS specific, and therefore not implemented in the generic driver.
What database do you use?
If you use MySQL / MariaDB, use the mysql driver instead. It extends the PDO driver and adds those platform specific functions.
MySQL / MariaDB. Within my controllers, all db operations are working as expected. oil migrations work fine too.
In which config file should I specify the mysql driver?
In your db.php config file. Use "mysql" instead of "pdo".
As long as you are using ANSI SQL, the PDO driver works fine, because it is generic SQL. But commands like list columns are RDBMS specific, they can't be implemented generically for all platforms the PHP PDO driver supports.
So there are specific PDO extensions tor MySQL, MSSQL, Oracle, etc.
Add a Comment
It looks like you're new here. If you want to get involved, click one of these buttons!
Apply for Membership
↳ Job Board
↳ Installation & Setup
↳ Tips and Tutorials
↳ Code share
In this Discussion