Comment #⁨5⁩

Just finished testing most features. I think it's really great, but I also think I might have discovered a few remaining bugs.

Global search does not work for me and neither does creating channels. Both functions search in the 'main' database of the laravel app instead of in the waterhole db. I think it's just a matter of using the wrong db connection in the codebase, or maybe some setting I forgot to make?

global search throws:

[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'maindb.comments' doesn't exist at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:416)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): PDO->prepare()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(809): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\\Database\\Connection->run()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2751): Illuminate\\Database\\Connection->select()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2739): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /var/www/html/vendor/waterhole/core/src/Search/MySqlEngine.php(121): Illuminate\\Database\\Query\\Builder->get()
#9 /var/www/html/vendor/waterhole/core/src/Search/Searcher.php(22): Waterhole\\Search\\MySqlEngine->search()
#10 /var/www/html/vendor/waterhole/core/src/Http/Controllers/Forum/SearchController.php(44): Waterhole\\Search\\Searcher->search()

creating a channel in the control panel throws:

[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'maindb.taxonomies' doesn't exist at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:416)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): PDO->prepare()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(809): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): Illuminate\\Database\\Connection->run()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2751): Illuminate\\Database\\Connection->select()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2739): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3221): Illuminate\\Database\\Query\\Builder->get()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3149): Illuminate\\Database\\Query\\Builder->aggregate()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Validation/DatabasePresenceVerifier.php(54): Illuminate\\Database\\Query\\Builder->count()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(903): Illuminate\\Validation\\DatabasePresenceVerifier->getCount()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Validation/Concerns/ValidatesAttributes.php(874): Illuminate\\Validation\\Validator->getExistCount()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(657): Illuminate\\Validation\\Validator->validateExists()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(457): Illuminate\\Validation\\Validator->validateAttribute()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(492): Illuminate\\Validation\\Validator->passes()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(534): Illuminate\\Validation\\Validator->fails()
#17 /var/www/html/vendor/waterhole/core/src/Forms/Form.php(45): Illuminate\\Validation\\Validator->validate()
#18 /var/www/html/vendor/waterhole/core/src/Forms/Form.php(25): Waterhole\\Forms\\Form->validate()
#19 /var/www/html/vendor/waterhole/core/src/Http/Controllers/Cp/ChannelController.php(26): Waterhole\\Forms\\Form->submit()
#20 /
  1. Answer
    Toby Toby Waterhole Founder Jan 31, 2024
    In reply to E Emmanuel71

    Glad to hear you got it working @Emmanuel71! I've created an issue to track Model::shouldBeStrict() compatibility. I've also released 0.4.5 which should hopefully fix these issues with using the incorrect database connection. Please try it out and let me know if there any further issues that persist!