Hi there,
I updated the system to carry on working on it and now I can’t login to the backend.
Illuminate\Database\QueryException thrown with message "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'gorsispi_db.ti_staff_roles' doesn't exist (SQL: select * fromti_staff_roles` where 0 = 1)"
Stacktrace:
#92 Illuminate\Database\QueryException in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
#91 Doctrine\DBAL\Driver\PDOException in /home/gorsispi/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79
#90 PDOException in /home/gorsispi/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77
#89 PDO:prepare in /home/gorsispi/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:77
#88 Doctrine\DBAL\Driver\PDOConnection:prepare in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326
#87 Illuminate\Database\Connection:Illuminate\Database{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:657
#86 Illuminate\Database\Connection:runQueryCallback in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624
#85 Illuminate\Database\Connection:run in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:333
#84 Illuminate\Database\Connection:select in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2130
#83 Illuminate\Database\Query\Builder:runSelect in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2118
#82 Illuminate\Database\Query\Builder:Illuminate\Database\Query{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2604
#81 Illuminate\Database\Query\Builder:onceWithColumns in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2119
#80 Illuminate\Database\Query\Builder:get in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:521
#79 Illuminate\Database\Eloquent\Builder:getModels in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:505
#78 Illuminate\Database\Eloquent\Builder:get in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php:155
#77 Illuminate\Database\Eloquent\Relations\Relation:get in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php:144
#76 Illuminate\Database\Eloquent\Relations\Relation:getEager in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:569
#75 Illuminate\Database\Eloquent\Builder:eagerLoadRelation in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:538
#74 Illuminate\Database\Eloquent\Builder:eagerLoadRelations in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:506
#73 Illuminate\Database\Eloquent\Builder:get in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php:155
#72 Illuminate\Database\Eloquent\Relations\Relation:get in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php:144
#71 Illuminate\Database\Eloquent\Relations\Relation:getEager in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:569
#70 Illuminate\Database\Eloquent\Builder:eagerLoadRelation in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:538
#69 Illuminate\Database\Eloquent\Builder:eagerLoadRelations in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:506
#68 Illuminate\Database\Eloquent\Builder:get in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:77
#67 Illuminate\Database\Eloquent\Builder:first in /home/gorsispi/public_html/vendor/tastyigniter/flame/src/Auth/Manager.php:342
#66 Igniter\Flame\Auth\Manager:getByCredentials in /home/gorsispi/public_html/vendor/tastyigniter/flame/src/Auth/Manager.php:150
#65 Igniter\Flame\Auth\Manager:authenticate in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
#64 Illuminate\Support\Facades\Facade:__callStatic in /home/gorsispi/public_html/app/admin/controllers/Login.php:31
#63 Admin\Controllers\Login:index in /home/gorsispi/public_html/app/admin/classes/AdminController.php:206
#62 call_user_func_array in /home/gorsispi/public_html/app/admin/classes/AdminController.php:206
#61 Admin\Classes\AdminController:execPageAction in /home/gorsispi/public_html/app/admin/classes/AdminController.php:168
#60 Admin\Classes\AdminController:remap in /home/gorsispi/public_html/app/system/classes/Controller.php:105
#59 System\Classes\Controller:runAdmin in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#58 call_user_func_array in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#57 Illuminate\Routing\Controller:callAction in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
#56 Illuminate\Routing\ControllerDispatcher:dispatch in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
#55 Illuminate\Routing\Route:runController in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
#54 Illuminate\Routing\Route:run in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
#53 Illuminate\Routing\Router:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#52 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/tastyigniter/flame/src/Currency/Middleware/CurrencyMiddleware.php:33
#51 Igniter\Flame\Currency\Middleware\CurrencyMiddleware:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#50 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#49 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/app/admin/middleware/LogUserLastSeen.php:26
#48 Admin\Middleware\LogUserLastSeen:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#47 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#46 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/tastyigniter/flame/src/Translation/Middleware/Localization.php:23
#45 Igniter\Flame\Translation\Middleware\Localization:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#44 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#43 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41
#42 Illuminate\Routing\Middleware\SubstituteBindings:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#41 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#40 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
#39 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#37 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
#36 Illuminate\Session\Middleware\StartSession:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#35 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#34 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
#33 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#32 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#31 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
#30 Illuminate\Cookie\Middleware\EncryptCookies:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#29 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#28 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
#27 Illuminate\Pipeline\Pipeline:then in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
#26 Illuminate\Routing\Router:runRouteWithinStack in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:657
#25 Illuminate\Routing\Router:runRoute in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623
#24 Illuminate\Routing\Router:dispatchToRoute in /home/gorsispi/public_html/vendor/october/rain/src/Router/CoreRouter.php:20
#23 October\Rain\Router\CoreRouter:dispatch in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
#22 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#21 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/extensions/igniter/cart/middleware/CartMiddleware.php:10
#20 Igniter\Cart\Middleware\CartMiddleware:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#19 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#18 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/tastyigniter/flame/src/Setting/Middleware/SaveSetting.php:25
#17 Igniter\Flame\Setting\Middleware\SaveSetting:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#16 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#15 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/fideloper/proxy/src/TrustProxies.php:57
#14 Fideloper\Proxy\TrustProxies:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#12 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
#11 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#10 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#9 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
#8 Illuminate\Foundation\Http\Middleware\ValidatePostSize:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#6 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62
#5 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
#4 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#3 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
#2 Illuminate\Pipeline\Pipeline:then in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /home/gorsispi/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116
#0 Illuminate\Foundation\Http\Kernel:handle in /home/gorsispi/public_html/index.php:53
`
Also this:
I did not backup unfortunately =/ Had a lot of data in there as well.
