Base table not found error

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!

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.

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

Yes, I’d suggest using a fresh install.

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!

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.

Awesome, thanks, I understand now. :slight_smile: