D
Dokploy6mo ago
leggero

database error

Help me, I refresh page and now it is not working
No description
80 Replies
Xeglion
Xeglion6mo ago
We need more context for your request. Where does this message appear and when did it happen? Did you do anything before this happened?
leggero
leggeroOP6mo ago
know it came just 30 minutes ago
Xeglion
Xeglion6mo ago
local or cloud ?
leggero
leggeroOP6mo ago
I use cloud before that, I was still using it normally
Xeglion
Xeglion6mo ago
Don't hesitate to answer the other questions, the more context we have the easier it will be to understand where the error could come from.
leggero
leggeroOP6mo ago
yeah I used it, and took a break, so when I came back and opened my laptop, connected Wifi again, and refreshing the website and it said like that I think, maybe it happens after a while Dokploy released new update
Xeglion
Xeglion6mo ago
Yes it is it was updated a few hours ago and new features are available Was your application made with a template? Can you specify what you used?
leggero
leggeroOP6mo ago
I deploy Wordpress i use it for my business with woocommerce
Xeglion
Xeglion6mo ago
Is this happening when you log in or do you get this message directly? From your image, I have the impression that it cannot connect to your user.
leggero
leggeroOP6mo ago
it happens when I F5 before that, I have been creating products
Xeglion
Xeglion6mo ago
front or admin or two ?
leggero
leggeroOP6mo ago
admin now this is one page
leggero
leggeroOP6mo ago
No description
leggero
leggeroOP6mo ago
If I F5 it will be like the img i post above
Xeglion
Xeglion6mo ago
Ah ok I understand better, thank you
leggero
leggeroOP6mo ago
Hopfully You can help me solve it soon, I am running ads, so the customers can't not visit the website if they click the link
Xeglion
Xeglion6mo ago
Send me the logs from the database in dokploy, you go to your app>logs>select logs database
leggero
leggeroOP6mo ago
No description
Xeglion
Xeglion6mo ago
yes that's it show me this log
leggero
leggeroOP6mo ago
now, Do you me scree all the text in the box
Xeglion
Xeglion6mo ago
yep please Press F5 to make the problem appear and send a screen of your log This is to see what happens in the logs during the problem
leggero
leggeroOP6mo ago
No description
leggero
leggeroOP6mo ago
Xeglion
Xeglion6mo ago
And what does the other log give?
leggero
leggeroOP6mo ago
I dont understand you, sorry
leggero
leggeroOP6mo ago
No description
No description
Xeglion
Xeglion6mo ago
I wanted to have the other log "wordpress-1"
leggero
leggeroOP6mo ago
No description
leggero
leggeroOP6mo ago
Maybe, to be easier, Can I send you my account of Dokploy
Xeglion
Xeglion6mo ago
No, don't worry, it's better this way because if there are other people who see a problem they can participate in the solution.
leggero
leggeroOP6mo ago
No description
Xeglion
Xeglion6mo ago
That's good, there's enough information I think. Here you clearly have a communication problem with the database, we see that all requests fail with a "500 (Internal Server Error)" code for two reasons: - An overload of REST API requests by a third-party plugin (too many requests quickly) - Either your tables are corrupted In both cases these could be resolved, but several procedures are required For the possible cause of the dokploy update, I don't think so because your database is not affected since it is in a container, that's the advantage of docker, everything is isolated. What is affected is the dokploy interface but not your apps. Here the problem is rather a problem of your configuration. Do you have a third party cache extension for woocomerce?
leggero
leggeroOP6mo ago
I use some extension for woocomerce plugin
Xeglion
Xeglion6mo ago
It's what ? Try disabling this third-party application and let me know if the problem occurs again.
leggero
leggeroOP6mo ago
Agora oke, let's me do it I did delete it
Xeglion
Xeglion6mo ago
No, a simple deactivation would have been enough, but it doesn't matter. so ?
leggero
leggeroOP6mo ago
Now I refresh it, and it also has the same problem
leggero
leggeroOP6mo ago
No description
Xeglion
Xeglion6mo ago
OK at least we removed one possibility. Now, do you have access to your server via FTP? to access the wp-config.php file
leggero
leggeroOP6mo ago
No, I can't
Xeglion
Xeglion6mo ago
go env. config in your dokploy and send me info in message private.
leggero
leggeroOP6mo ago
Can you help me, how to go "env. config"
Xeglion
Xeglion6mo ago
No description
leggero
leggeroOP6mo ago
i have sent you in messege private
Xeglion
Xeglion6mo ago
ok thanks, I received, ideally you should increase the limits in the root file "wp-config.php": memory_limit: Increase to 512M. max_execution_time: Set to 300. upload_max_filesize: Increase to 128M. post_max_size: Increase to 128M. That's why I asked if you had access in SFTP port 22. since I have never done wordpress under dokploy cloud, I don't really know how to do this, normally if you are at hetzner you can download filezilla put your IP and port 22 and point to the server to see the files but you must have permissions in your server you can try @Siumauricio need your help : - Do you help him access and configure his "wp-config.php" file? - Does the "deploy" and "rebuild" command erase this data ? I don't dare tell him because I'm not sure that it erases this data.
leggero
leggeroOP6mo ago
I remmember when I loged in wordpress before, i installed a plugin and increase the limits
Xeglion
Xeglion6mo ago
I think that must be it, there are too many requests at once and therefore it does not have time to do the process, otherwise the data is corrupted. But I am limited to help you more. So I called someone else.
leggero
leggeroOP6mo ago
I just go hetzner
No description
leggero
leggeroOP6mo ago
and they send me this notice
Xeglion
Xeglion6mo ago
Yes, so that's it for me, too many requests from the API.
leggero
leggeroOP6mo ago
Thank you, so now, i did deactive that API, It seems, can i visit my website tomorrow?
Xeglion
Xeglion6mo ago
What do you mean by visiting your site tomorrow? You said it was already accessible. Are you talking about your article creation admin?
leggero
leggeroOP6mo ago
now, i haven't visited my admin
leggero
leggeroOP6mo ago
it still happens
No description
leggero
leggeroOP6mo ago
although hetzner noticed
No description
Xeglion
Xeglion6mo ago
You have to restart the app but I don't know if when you do a Deploy it erases the data, that's why I asked the creator the question above in order to avoid problems. The creator in Latin America so we will have to wait for him to get up, he has different schedules Unless there is someone who will answer you before. For my part, I cannot go any further. It's just an overload problem. and if after restarting your app it continues it means that it can't access your database so it's corrupted. it can be solved by a "table repair" on the db and other solutions.
leggero
leggeroOP6mo ago
Thank you very much @Siumauricio Could you help me solve it? @Xeglion almost 1 day don’t get any respond from Him. Do you think I should rebuild the app?
Siumauricio
Siumauricio6mo ago
I don't really know what happened in your application, I am not an expert in all the templates even I have never used wordpress, I honestly don't know what happened can you share your docker compose file to see if I can help you? Did you touched something on the template or it was a fresh creation?
Siumauricio
Siumauricio6mo ago
I recently created a fresh template and it works fine
No description
Siumauricio
Siumauricio6mo ago
Or did you create a custom wordpress template?
leggero
leggeroOP6mo ago
Hello I dìdn’t touch anything
leggero
leggeroOP6mo ago
if I rebuid
No description
leggero
leggeroOP6mo ago
my dada is deleted right @Siumauricio
Siumauricio
Siumauricio6mo ago
please share the docker compose file also just out of curiosity do you have another databases created?
leggero
leggeroOP6mo ago
no i dont I just sent you in private messengers
Xeglion
Xeglion6mo ago
@leggero Were you able to solve the problem?
leggero
leggeroOP6mo ago
Yes, thank you. I touch re-build button, and it worked
Xeglion
Xeglion6mo ago
You see, that's what I told you but I didn't know if it erased the data. Now we know that for the WordPress template, it keeps the data, can you confirm?
leggero
leggeroOP6mo ago
You mean the reason for that is template of theme? I am considering a plugin. I think that app keeps the data
Xeglion
Xeglion6mo ago
that it was necessary to do a simple rebuild
leggero
leggeroOP6mo ago
The fact is yesterday, it happned one more time
Xeglion
Xeglion6mo ago
And you, are you going to rebuild again?
leggero
leggeroOP6mo ago
Yes
Xeglion
Xeglion6mo ago
mmmhhh...
leggero
leggeroOP6mo ago
And it still works now Have not that problem again
Xeglion
Xeglion6mo ago
Yes, that's the main thing.
leggero
leggeroOP6mo ago
Btw, thank you very much
Xeglion
Xeglion6mo ago
So we will have to wait
leggero
leggeroOP6mo ago
Yep sur
Xeglion
Xeglion6mo ago
Normally I think you can mark as solved for your chat.

Did you find this page helpful?