Which of the config?

ok

Because you may need to change many things in the both differently

Just make an API folder in controller for it

ok

Send the join query code for pagination

Hi, what could be the cause of this when the site was working fine for about a month on a shared hosting?

Hi
check db is exist !?
you may been hacked.
your mysql user : “worldma_antt” is not exist or no permission to mysql.

I removed the entire db created a new one will a single with all privileges yet nothing

Always set app_debug to false in production mode. Security issue!

you need to give permission for new db

had 500 error before changing it back to debug mode

after problem solved change debug to false.

No difference yet done that already

noted

Credential is crct in env? Also check database.php in config folder

did you check your .env file ?

All is corrected

downloaded the project and it’s still working fine on my dev server

Don’t know what could be the cause

Restarting apache may help!

it’s not a complex problem . it’s very simple and your config has an issue.

Yeah had that in mind contacted the hosting provider to do that cuz I don’t have SSH access

Which of the config? so I can check

let me … brb

I think .env in the database section is adjusted to the database on the user account in phpmyadmin

I think updating databse.php in config with crct credentials may fix…some times env may not load in the beginning

Also, in database.php

updating now

same error

create a new simple empty db
and try this script

<?php
try {
$dsn = “mysql:host=localhost;dbname=apidb”;
$user = “root4”;
$passwd = “”;
$pdo = new PDO($dsn, $user, $passwd);
}catch (exception $ex) {
echo $ex->getMessage();
}

change user,pass,db

after run this . if you get no message . then there is no problem across the server

trying now