CODEWITHSUNDEEP
phpmysqlyiimamp
mjmitche
mjmitche

Reputation: 2067

says table doesn't exist

I have been using Yii with MAMP for the last week without problem. However, today, I set up a new project, created a database and tried to use Gii to create a new model but it's giving me a message "table name doesn't exist."

I have confirmed many times that such a table exists in PHP MY Admin. I also did a reinstall on MAMP and have the same problem

Can anyone see what the problem might be

databse test1

This is my database

This is my configuration in the Yii config file

'db'=>array(
            'connectionString' => 'mysql:host=localhost;port:8889;dbname=test1',
            'emulatePrepare' => true,
            'username' => 'root',
            'password' => 'root',
            'charset' => 'utf8',
        ),

enter image description here

Upvotes: 0

Views: 2645

Answers (1)

James Skemp
James Skemp

Reputation: 8551

I'm a bit rusty, but ... case sensitivity? Are column and table name case sensitive in MySQL?

Screenshot also states that no tables were found in the test1 database.

Upvotes: 1

Related Questions