Home Forums Support Base table not found error

This topic contains 6 replies, has 2 voices, and was last updated by  Anonymous 3 years, 5 months ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #2237

    Anonymous

    Hi,
    I have IN on a windows pc running bitnami wampstack (not the dedicated IN one). So i had to reinstall bitnami to a new folder..updated all my settings accordingly in bitnami and when i run IN i get an error in laravel.log as follows:

    production.ERROR: exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ninja.users' doesn't exist' in C:\Bitnami\wampstack-5.5.29-1\apps\invoicenj\htdocs\vendor\laravel\framework\src\Illuminate\Database\Connection.php

    Somehow the database is out of date, and i’m missing tables.How do I update?
    Thanks!

    #2241

    Hillel Coren
    Keymaster

    First check that the database still exists/is populated from the previous installation.

    Then review the .env file in the root folder of the project to make sure the database settings are correct.

    #2242

    Anonymous

    Hi, you were right, the db shows my data is missing.

    Image at http://imgur.com/OX56eRY

    I did not have alot of data in it yet, but I certainly don’t want this to happen again. I don’t know …apparently the setup routine that started again blanked my tables? if my data is gone, so be it, but hopefully this wont happen again. I’ll keep a backup next time. So, do i need to start fresh with a new install? what is best way to fix this?
    Thanks

    #2247

    Hillel Coren
    Keymaster

    Yes, I’d suggest using a fresh install.

    #2373

    Anonymous

    Hey Hillel,

    No problem, I did fresh install and I did not download the self host zip, instead i chose to clone the repo, then run composer install, and bower install. Then i went through the setup again. Just curious, does it matter which mysql charset I use for the db? I used utf8_unicode_ci.

    so to keep my program up to date, I can do just git pull, and then what else do i need to do? Sorry for newbie questions. I don’t want to get database corruption again!

    Thanks!

    #2374

    Hillel Coren
    Keymaster

    You should just need to do a git pull. We track the version in version.txt, if the app sees it change it should call /update to run the database migrations and clear the cache.

    I believe utf8_unicode_ci is the default.

    #2376

    Anonymous

    Awesome, thanks, I understand now. 🙂

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

Posted in: