#database issue
1 messages · Page 1 of 1 (latest)
It looks like you have some kind of problem. The jobs table is missing.
Is this a fresh installation?
from what i remember you needed to create one inside pterodactyl and then link this user inside the instalation of ctrlpanel
is there a user in ptero ?
Yeh they are
can you show your user ?
There is an error in the logs that the table is missing
(not showing emails but yeh)
Can you please fetch the error logs, so we can assist you better regarding this error.
tail -n 100 /var/www/controlpanel/public/install/logs/installer.log | nc pteropaste.com 99
ha meh
2024-05-14 22:32:49] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ctrlpanel.jobs' doesn't exist (SQL: select * from `jobs` where `queue` = default and ((`reserved_at` is null and `available_at` <= 1715725969) or (`reserved_at` <= 1715725879)) order by `id` asc limit 1 FOR UPDATE SKIP LOCKED) ```
How do I fix this?
I would recommend reinstalling cpgg, with deleting all existing tables. This will be the simplest and most reliable option.
How would one delete everything without reinstalling their dedi?
Is there an uninstall command?
Strangely, I see that all migrations were successful. Have you done anything with MySQL?
Nope, have done nothing
MariaDB is running fine, no errors too
Users, folders and filenames have been renamed from "dashboard" ⇒ "controlpanel". Be aware that the provided commands may not fit your installation. Please change the users, folder and filenames for the commands corresponding to your installation.
It works now, but I was trying to setup mailing and it won't work, so I tried on Pterodactyl to see why, usure how to fix this though
Can you please fetch the error logs, so we can assist you better regarding this error.
tail -n 100 /var/www/controlpanel/storage/logs/laravel.log | nc pteropaste.com 99
Please check if the password reset email sends.
If it does, check your queue workers - https://CtrlPanel.gg/docs/Installation/getting-started#queue-listeners
If it still doesnt work, check your php version is 8.1 - php -v
Make sure to clear the config cache and to restart the queue workers when making changes to the email details.
php artisan queue:restart```
It is recommended that you have some sort of Linux and MariaDB experience before installing this.
Nonono
Hm?
Roger is a bit dumb sometimes, you shouldn't listen to his every advice 😅
I don't see any errors in the logs that would relate to problems with email
check browser devtools console, likely and issue with datatable library not loading or erroring out
Everything is fixed, we good