Search code examples
phpmysqlpdoidiorm

dbname PDO issue

I am having a weird issue setting up a site with SlimPHP and Idiorm/Paris.

Basically none of the generated queries are working because MySQL is still requiring a database identifier.

For example: SELECT * FROM table fails , but SELECT * FROM dbname.table works.

ORM::configure('mysql:host=myhostname;dbname=mydbname;');
ORM::configure('username', $username);
ORM::configure('password', $password);

I set the dbname properly in the connection many times over using both a built string and manually. It connects find and appears to be using that schema.

I really don't want to hack together a forced "using" into the Idiorm module but if that is the only answer so be it.

Notes:

  1. GoDaddy Hosting (I suspect this is the issue) LAMP stack
  2. The dbname and username are the same
Solution

  • It was a godaddy issue like I suspected.. apparently they default non-direct connections which I missed somehow.

    Hopefully this can prevent someone else's misery in the future!