I git cloned a repository for a project written in Laravel/PHP. I was able to get most things running locally and I was able to create the initial migrations folder but I'm stuck at the seeding and table creation point (?). I keep get the following errors:
In Connection.php line 664:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lara_dev.users' doesn't exist (SQL: alter table `users` add `avatar` varchar(255
) null default 'users/default.png' after `email`, add `role_id` int null after `id`)
In PDOStatement.php line 144:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lara_dev.users' doesn't exist
In PDOStatement.php line 142:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lara_dev.users' doesn't exist
*lara_dev is the local database's name. I created it directly in my MySQL local client terminal after git cloning the project, it was NOT created by any commands executed in the terminal.
Also:
The database folder has three folders inside: factories, migrations, and seeds. From what I see and understand, the files inside are configured correctly and the database should be created without issues and without having to edit these files.
I do NOT have a WAMP server, I'm simply using php's built in server through the command 'php artisan serve'.
Solutions I've tried so far that haven't worked:
php artisan cache:clear //Clears the cache but that's about it.
php artisan migrate:fresh --seed //Same errors but also drops any tables that were there before.
php artisan migrate:refresh --seed // Gives 'nothing to rollback' message.
php artisan db:seed //Same errors
I haven't been able to find any solutions here on Stack that work for my situation. Any help would be greatly appreciated.
Please take into account I am relatively new to PHP, but not to coding, and I've been able to get things running for the most part, I'm just stuck here. If I can provide additional information, please let me know. Thanks in advance!
Daniyal Javani gave me the right answer in the comments above. I added that exact file, https://github.com/laravel/laravel/blob/master/database/migrations/2014_10_12_000000_create_users_table.php, to my migrations folder. It created the users table I was missing and then running 'php artisan migrate' worked.