Sqlstate hy000 general error 1 no such table

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

<?php

namespace TestsBrowser;

use IlluminateFoundationTestingDatabaseMigrations;
use LaravelDuskBrowser;
use TestsBrowserPagesCartPage;
use TestsBrowserPagesProductShowPage;
use TestsDuskTestCase;
use VaniloFrameworkModelsProduct;
use VaniloProductModelsProductState;

class CartTest extends DuskTestCase
{
    use DatabaseMigrations;

    private $productA;

    private $productB;

    public function setUp() :void
    {
        parent::setUp();

        $this->productA = Product::create([
            'name'  => 'Fiat Punto',
            'sku'   => 'FTA-PUNTO',
            'state' => ProductState::ACTIVE(),
            'price' => 4500
        ]);

        $this->productB = Product::create([
            'name'  => 'Dacia Sandero',
            'sku'   => 'DCA-SANDERO',
            'state' => ProductState::ACTIVE(),
            'price' => 7900
        ]);
    }

    /** @test */
    public function it_can_open_cart()
    {
        $this->browse(function (Browser $browser) {
            $browser
                ->visit(new CartPage())
                ->assertSee('Your cart is empty');
        });
    }

    /** @test */
    public function it_can_use_cart_properly()
    {
        $this->browse(function (Browser $browser) {
            $browser
                ->visit(new ProductShowPage($this->productA))
                ->addToCart()
                ->visit(new ProductShowPage($this->productA))
                ->addToCart()
                ->visit(new ProductShowPage($this->productB))
                ->addToCart()
                ->visit(new CartPage())
                ->assertSourceHas('name="qty" value="1"')
                ->assertSourceHas('name="qty" value="2"')
                ->assertSee($this->productA->name)
                ->assertSee($this->productB->name)
                ->assertSee(format_price($this->productA->price * 2))
                ->assertSee(format_price($this->productB->price))
                ->assertSee(format_price($this->productA->price * 2 + $this->productB->price))
                ->deleteFromCart($this->productA)
                ->assertDontSee($this->productA->name);
        });
    }
}

<?php

namespace TestsBrowserPages;

use LaravelDuskBrowser;
use LaravelDuskPage;
use VaniloFrameworkModelsProduct;

class ProductShowPage extends Page
{
    /** @var Product */
    private $product;

    /**
     * ProductShowPage constructor.
     *
     * @param Product $product
     */
    public function __construct(Product $product)
    {
        $this->product = $product;
    }

    /**
     * Get the URL for the page.
     *
     * @return string
     */
    public function url()
    {
        return route('product.show', $this->product);
    }

    /**
     * Assert that the browser is on the page.
     *
     * @param  Browser $browser
     *
     * @return void
     */
    public function assert(Browser $browser)
    {
        $browser->assertSee($this->product->name);
    }

    public function addToCart(Browser $browser)
    {
        $browser->press("Add to cart");
    }
}

611 votes

1 answers

I have created the following unit test:

    <?php

    namespace TestsUnit;

    use TestsTestCase;
    use AppUser;
    use AppOrganization;

    class UserTest extends TestCase
    {
        public function testUserHasOwnedOrganization()
        {
            $user = factory(User::class)->create();
            $organization = factory(Organization::class)->create([
                'organizer_id' => $user->id,
            ]);

            $this->assertContains($organization, $user->owned_organizations);
        }
    }

When I run it, I get:

SQLSTATE[HY000]: General error: 1 no such table: users

However, when I open upphp artisan tinker:

>>> factory(AppUser::class)->create()
=> AppUser {#3048
     name: "Margret Armstrong",
     email: "[email protected]",
     email_verified_at: "2020-05-18 01:22:30",
     updated_at: "2020-05-18 01:22:30",
     created_at: "2020-05-18 01:22:30",
     id: 1,
   }

So clearly the factory works and the table exists.

What’s going on here?

Thanks,

Didn’t find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.