Laravel - Error when upload to server

Question

I upload a laravel project to server, create database, import database, change .env file and I am getting following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.contentTranslations' doesn't exist

The database was created and I have import all tables. In phpmyadmin if I did a select it works.

Full error:

in Connection.php line 332
at PDO->prepare('select `contentTranslations`.`image` from `content` inner join `contentTranslations` on `contentTranslations`.`id_content` = `content`.`id` where `contentTranslations`.`active` = ? and `contentTranslations`.`lang` = ? and `content`.`id_page` = ? and `content`.`id_pageZones` = ? order by `contentTranslations`.`id` asc') in Connection.php line 332
at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select `contentTranslations`.`image` from `content` inner join `contentTranslations` on `contentTranslations`.`id_content` = `content`.`id` where `contentTranslations`.`active` = ? and `contentTranslations`.`lang` = ? and `content`.`id_page` = ? and `content`.`id_pageZones` = ? order by `contentTranslations`.`id` asc', array('1', 'pt', '1', '1')) in Connection.php line 762
at Connection->runQueryCallback('select `contentTranslations`.`image` from `content` inner join `contentTranslations` on `contentTranslations`.`id_content` = `content`.`id` where `contentTranslations`.`active` = ? and `contentTranslations`.`lang` = ? and `content`.`id_page` = ? and `content`.`id_pageZones` = ? order by `contentTranslations`.`id` asc', array('1', 'pt', '1', '1'), object(Closure)) in Connection.php line 725
at Connection->run('select `contentTranslations`.`image` from `content` inner join `contentTranslations` on `contentTranslations`.`id_content` = `content`.`id` where `contentTranslations`.`active` = ? and `contentTranslations`.`lang` = ? and `content`.`id_page` = ? and `content`.`id_pageZones` = ? order by `contentTranslations`.`id` asc', array('1', 'pt', '1', '1'), object(Closure)) in Connection.php line 350
at Connection->select('select `contentTranslations`.`image` from `content` inner join `contentTranslations` on `contentTranslations`.`id_content` = `content`.`id` where `contentTranslations`.`active` = ? and `contentTranslations`.`lang` = ? and `content`.`id_page` = ? and `content`.`id_pageZones` = ? order by `contentTranslations`.`id` asc', array('1', 'pt', '1', '1'), true) in Builder.php line 1648
at Builder->runSelect() in Builder.php line 1634
at Builder->get(array('*')) in Builder.php line 632
at Builder->getModels(array('*')) in Builder.php line 327
at Builder->get() in FrontendController.php line 55
at FrontendController->home('pt')
at call_user_func_array(array(object(FrontendController), 'home'), array('locale' => 'pt')) in Controller.php line 55
at Controller->callAction('home', array('locale' => 'pt')) in ControllerDispatcher.php line 44
at ControllerDispatcher->dispatch(object(Route), object(FrontendController), 'home') in Route.php line 190
at Route->runController() in Route.php line 144
at Route->run(object(Request)) in Router.php line 642
at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
at Pipeline->then(object(Closure)) in Router.php line 644
at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 618
at Router->dispatchToRoute(object(Request)) in Router.php line 596
at Router->dispatch(object(Request)) in Kernel.php line 267
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
at Pipeline->then(object(Closure)) in Kernel.php line 149
at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 116
at Kernel->handle(object(Request)) in index.php line 54

Why? I have to solve this very soon.

What is the problem?

Thank you

Answer 1

I believe you have a problems with capital letters for table name. It's important, and for your server contenttranslations != contentTranslations. It's different tables.