search

ctf0 / Laravel-Media-Manager

A "Vuejs & Laravel" Media Manager With Tons of Features
MIT License
829 stars 179 forks source link

Wrong DATABASE_CONNECTION Chosen [Question] #191

Closed jasperf closed 3 years ago

jasperf commented 3 years ago

Since added a DATABASE_CONNECTION per database (base, backup and published) I am getting errors dealing with locked files. The table locked is in base, but somehow mysql_backup is still picked. I tweaked mediaManager.php in config:

/*
* Database connection
*/
'database_connection' => env('DB_CONNECTION', 'mysql'),

and re-added ctf0\MediaManager\MediaManagerServiceProvider::class, to app.php . And did composer dump-autoload Still I am getting this error:

12:00:07.048 XHRPOST http://app-base.test/media/get-files
[HTTP/1.1 500 Internal Server Error 161ms]

message "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'backup_base.locked' doesn't exist (SQL: select `path` from `locked`)"
exception   "Illuminate\\Database\\QueryException"
file    "/app-base/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
line    678
trace   [ {…}, {…}, {…}, {…}, {…}, {…}, {…}, {…}, {…}, {…}, … ]
0   Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Database/Connection.php", line: 638, function: "runQueryCallback", … }
1   Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Database/Connection.php", line: 346, function: "run", … }
2   Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php", line: 2313, function: "select", … }
3   Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php", line: 2488, function: "runSelect", … }
4   Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php", line: 2796, function: "Illuminate\\Database\\Query\\{closure}", … }
5   Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php", line: 2490, function: "onceWithColumns", … }
6   Object { file: "/app-base/vendor/ctf0/media-manager/src/App/Controllers/Modules/Lock.php", line: 28, function: "pluck", … }
7   Object { file: "/app-base/vendor/ctf0/media-manager/src/App/Controllers/Modules/GetContent.php", line: 28, function: "lockList", … }
8   Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Controller.php", line: 54, function: "getFiles", … }
9   Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php", line: 45, function: "callAction", … }
10  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Route.php", line: 254, function: "dispatch", … }
11  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Route.php", line: 197, function: "runController", … }
12  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Router.php", line: 695, function: "run", … }
13  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 128, function: "Illuminate\\Routing\\{closure}", … }
14  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php", line: 50, function: "Illuminate\\Pipeline\\{closure}", … }
15  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
16  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php", line: 78, function: "Illuminate\\Pipeline\\{closure}", … }
17  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
18  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php", line: 49, function: "Illuminate\\Pipeline\\{closure}", … }
19  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
20  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php", line: 37, function: "Illuminate\\Pipeline\\{closure}", … }
21  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
22  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php", line: 67, function: "Illuminate\\Pipeline\\{closure}", … }
23  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
24  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 103, function: "Illuminate\\Pipeline\\{closure}", … }
25  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Router.php", line: 697, function: "then", … }
26  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Router.php", line: 672, function: "runRouteWithinStack", … }
27  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Router.php", line: 636, function: "runRoute", … }
28  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Routing/Router.php", line: 625, function: "dispatchToRoute", … }
29  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php", line: 166, function: "dispatch", … }
30  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 128, function: "Illuminate\\Foundation\\Http\\{closure}", … }
31  Object { file: "/app-base/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php", line: 67, function: "Illuminate\\Pipeline\\{closure}", … }
32  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
33  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php", line: 21, function: "Illuminate\\Pipeline\\{closure}", … }
34  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php", line: 31, function: "handle", … }
35  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
36  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php", line: 21, function: "Illuminate\\Pipeline\\{closure}", … }
37  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php", line: 40, function: "handle", … }
38  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
39  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php", line: 27, function: "Illuminate\\Pipeline\\{closure}", … }
40  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
41  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php", line: 121, function: "Illuminate\\Pipeline\\{closure}", … }
42  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php", line: 64, function: "handleStatefulRequest", … }
43  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
44  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php", line: 86, function: "Illuminate\\Pipeline\\{closure}", … }
45  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
46  Object { file: "/app-base/vendor/fruitcake/laravel-cors/src/HandleCors.php", line: 38, function: "Illuminate\\Pipeline\\{closure}", … }
47  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
48  Object { file: "/app-base/vendor/fideloper/proxy/src/TrustProxies.php", line: 57, function: "Illuminate\\Pipeline\\{closure}", … }
49  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 167, function: "handle", … }
50  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php", line: 103, function: "Illuminate\\Pipeline\\{closure}", … }
51  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php", line: 141, function: "then", … }
52  Object { file: "/app-base/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php", line: 110, function: "sendRequestThroughRouter", … }
53  Object { file: "/app-base/public/index.php", line: 52, function: "handle", … }
54  Object { file: "/Users/user/.composer/vendor/laravel/valet/server.php", line: 214, function: "require" }

Any ideas what I am missing here?

jasperf commented 3 years ago

Never mind. Had to stick to one DATABASE_CONNECTION=mysql