ERROR - 2026-01-23 06:18:13 --> ErrorException: pg_query(): Query failed: ERROR:  insert or update on table "vouchers" violates foreign key constraint "vouchers_category_id_foreign"
DETAIL:  Key (category_id)=(1) is not present in table "categories". in /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Database/Postgre/Connection.php:206
Stack trace:
#0 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler()
#1 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Database/Postgre/Connection.php(206): pg_query()
#2 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Database/BaseConnection.php(729): CodeIgniter\Database\Postgre\Connection->execute()
#3 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Database/BaseConnection.php(646): CodeIgniter\Database\BaseConnection->simpleQuery()
#4 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(2345): CodeIgniter\Database\BaseConnection->query()
#5 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Model.php(394): CodeIgniter\Database\BaseBuilder->insert()
#6 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/BaseModel.php(838): CodeIgniter\Model->doInsert()
#7 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Model.php(797): CodeIgniter\BaseModel->insert()
#8 /opt/bitnami/apache/htdocs/bb_api/app/Controllers/Api/Merchant.php(1706): CodeIgniter\Model->insert()
#9 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/CodeIgniter.php(933): App\Controllers\Api\Merchant->createVoucher()
#10 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/CodeIgniter.php(507): CodeIgniter\CodeIgniter->runController()
#11 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/CodeIgniter.php(354): CodeIgniter\CodeIgniter->handleRequest()
#12 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Boot.php(363): CodeIgniter\CodeIgniter->run()
#13 /opt/bitnami/apache/htdocs/bb_api/vendor/codeigniter4/framework/system/Boot.php(68): CodeIgniter\Boot::runCodeIgniter()
#14 /opt/bitnami/apache/htdocs/bb_api/public/index.php(59): CodeIgniter\Boot::bootWeb()
#15 {main}