Caused by PDOException: SQLSTATE[42000] - php unit test in Laravel

Question

I am new to laravel and php unit testing. I am trying to run a very basic test in laravel and getting the error below while running phpunit through command line:

Caused by PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'after impressions, clicks int not null, clicks_change float(4, 2) not null' at line 1

class ExampleTest extends TestCase {

    /**
     * A basic functional test example.
     *
     * @return void
     */
    public function testStats()
    {
        $result = true;
        $this->assertEquals(true, $result);
    }
}

Where is the query that you are are trying to do assertion ? — Abhik Chakraborty, Commented Mar 25, 2015 at 8:01
There is not any, I need to test apis, but I am assuming assertEquals to be success first. I think I am missing something very basic. — Fahad Khan, Commented Mar 25, 2015 at 8:02
Anything I am doing inside testStats() giving the same error. @AbhikChakraborty — Fahad Khan, Commented Mar 25, 2015 at 8:13
The error states its a mysql error perhaps see if you are calling a class constuctor which is casing the issue. — Abhik Chakraborty, Commented Mar 25, 2015 at 8:20
I guess the error is caused by TestCase::setUp(). Maybe it is making an application and somewhere there a query is executing. Have you set app/database configs correctly? — Hamid Alaei, Commented Mar 25, 2015 at 15:04

User123456 · Accepted Answer · 2017-03-06 10:57:30Z

1

Please check the query you have written. Or comment out DB related part from your phpunit.xml to run the tests without no db interaction

    <!--<env name="DB_CONNECTION" value="mysql"/>-->
    <!--<env name="DB_DATABASE" value="event_test_db"/>-->

answered Mar 6, 2017 at 10:57

User123456

2,7483 gold badges31 silver badges46 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Caused by PDOException: SQLSTATE[42000] - php unit test in Laravel

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related