[Resolved] Fixed issues with composer and fixed large database problems.(This should be a tutorial)

[ocean path]

give more details please

what command you execute, why

[hasty atlas]

i was running

COMPOSER_ALLOW_SUPERUSER=1 composer install --no-dev --optimize-autoloader

i have followed all the steps with no problem

the php-redis extension is installed

@ocean path
OK crisis averted

The redis server was not running

suggestion : put in the documentation to check if redis-server is running and if not to start it with sudo service redis-server start

[ocean path]

yep known issue

sorry :)

@past marsh

[hasty atlas]

ok so new problem

it failed on migrating the users table

[ocean path]

i dont really know what is the problem

i'm not really a support person

at least if there is a support person they should have enought information to help

i hope that sapphireservers are not down ?

[hasty atlas]

existing customers have full access to their servers

[ocean path]

Mmmh because they are on ptero

but here its the store

your store is down so ?

ho yep it is

[hasty atlas]

i have backup if i do not find the solution soon

[ocean path]

maybe you would like to have a test and a production environement in the futur

so you can update and prepare on the test one

and wen ready just replace the production one by the test one :)

it would enable you tu have a better uptime

[hasty atlas]

i have upgraded the test environment with success

but i had an older version of the db

hmmm

[ocean path]

The error shows that you're trying to modify the 'pterodactyl_id' column in the users table, setting it as varchar(191) not null

The error SQLSTATE[01000]: Warning: 1265 Data truncated indicates that the data you're trying to store is too long for the column's defined length

its a strange error

since you are a company i would tell you to avoid updating

let a few month or time to cpgg to fix all issues on v1

[hasty atlas]

it seams that existing data in at least one row (specifically row 138) is longer than 191 characters

in pterodactyl_id ?

tf ?

[ocean path]

i have seen multiple issues whit username being swaped whit ptero ID

[hasty atlas]

ok i will check the db manually

[ocean path]

would be nice that you report the bugs and that we fix the issue, but in the current state of cpgg and your uptime obligation i would not try to update this early

even if all the features looks really cool :)

[ocean path]

yup could be nice

[hasty atlas]

lmao

[ocean path]

use >=

and not >

[hasty atlas]

ok

still

[ocean path]

try less ?

[hasty atlas]

wait

[ocean path]

or just try to get the problematic row :
SELECT id, pterodactyl_id, CHAR_LENGTH(pterodactyl_id) as length
FROM users
WHERE id = 138;

[hasty atlas]

that is what i am doing

now i am getting confused

[ocean path]

me too

i'm not very good whit SQL query

but i dont see the problem here

do you have tools such as php my admin ?

[hasty atlas]

ok i just saw the user

[hasty atlas]

the account is a complete zombie

i cant find his email in the pterodactyl dash

the account was logged in for 0 seconds lmao

[ocean path]

i guess... if the account is inactive and causing problem delete it

[hasty atlas]

and all the NULLS should be his pterodactyl id and other info

how did this happened lmao

[ocean path]

strange

[hasty atlas]

is it safe to delete him/her

or does cpgg rely on anything here ?

[ocean path]

i dont known xD

[hasty atlas]

1 way to find out

[ocean path]

you have a backup of the database before ?

[hasty atlas]

and i also have a backup

[ocean path]

okay

[hasty atlas]

i also have a snapshot of the server incase something goes super wrong

[ocean path]

okay

[hasty atlas]

wow there are more than one

time for a cleanup

[ocean path]

maybe check the user 502 also

just to see what is going on

[hasty atlas]

i will see all users that have ptero id NULL

SELECT id, name, email, pterodactyl_id
FROM users
WHERE pterodactyl_id IS NULL;

i mean... 35k users

[ocean path]

avoid posting picture here even if you hide important info since some software can bypass censor on picture

and everyting is public

anyway

[ocean path]

thats strange

[hasty atlas]

even a black picture ?

[ocean path]

yeah

[hasty atlas]

ok

[ocean path]

wen your sensoring, some software only tint it and do not fully replace the pixel

anyway

i dont really have a solution to your problem
what i would recommand is to wait for a more advanced member
and wait that cpgg fix all issues :)

it might take some month to find and fix everything

[hasty atlas]

this is probably my issue with user managment

[ocean path]

your issue ?

[hasty atlas]

ye

i did not notice these users sooner

but cpgg should have a check

[ocean path]

i dont known how that work

[hasty atlas]

i guess it is similar to how the panel gets the server id from ptero

and i have encountered times when a "zombie" server with no id is made

it existed in cpgg but not in ptero

lmao that was totally the issue

[ocean path]

the users where the issues ?

[hasty atlas]

yes

zombie

users

ok now it is fixed

and my db is in a normal state again

2 in 1

gg

[ocean path]

i would like to known how they apeared in the first place

[hasty atlas]

i will try to find out

[agile latch]

💎 Want Premium Support and a Shiny Role in Discord? Join our supporters on ctrlpanel.gg and enjoy unique perks! 🙌 Patreon | Ko-fi | GitHub Sponsors

[hasty atlas]

i am

lol [i know it is a bot (i am stupid) ]

[ocean path]

thanks :D we will also look into it

[hasty atlas]

[Resolved] Fixed issues with composer and fixed large database problems.(This should be a tutorial)

[ocean path]

happy that we found a solutions :)

[hasty atlas]

https://tenor.com/view/friday-happydance-seinfeld-gif-11537457160907667463

[past marsh]

I have already realized that CtrlPanel does not work without Redis. I knew it, even though everyone was trying to convince me otherwise, lol

And I understood why everything worked in my tests

In Ubuntu Desktop 24.04, Redis Server is installed by default

That's why, even though I didn't install it, everything worked for me

[proven crystal]

TLDR ?

[past marsh]

Redis server is required

[hasty atlas]

Also my DB had Problems

[wicked grove]

My control panel is literally running without Redis right now

And updating it worked, besides the broken migration stuff, find

[wicked grove]

It's not.