Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi!

Today I edited the theme causing the website to have some errors, I reinstalled a whole VPS server with Cyberpanel. I had the file backed up from yesterday and Then I started to upload the SQL file through PhpAdmin but I am getting this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '

The dynamic response body size is over the limit, the response will be true...' at line 5

https://www.codeproject.com/KB/Articles/5329536/Working/ddddddd.PNG[^]

Any solution is appreciated. Thank you!

What I have tried:

I change the Max Dynamic Response Body Size configuration with web admin wich default port is :7080

Posted
Comments
Richard MacCutchan 11-Apr-22 12:17pm    
"Any solution is appreciated"
Without seeing the code and the generated SQL we cannot begin to guess what is wrong.
Lê Huy Tú 11-Apr-22 12:44pm    
how do i capture the SQL code?
Richard MacCutchan 11-Apr-22 12:47pm    
We cannot see your code so we have no idea. The obvious answer is to use the debugger, or some display statements.
Lê Huy Tú 11-Apr-22 12:49pm    
Can you show me how to get the code? Or I will send the whole SQL file to you.
Richard MacCutchan 11-Apr-22 12:53pm    
You do not seem to understand what we are asking for. We have no idea what your code is doing, or where (or why) the error occurs, so we cannot provide any suggestions to fix it. You need to provide all the information in your question:
1. The code of the part of the program where the error occurs.
2. The SQL data that causes the error.

If you really do not know how to extract that from your application then there is nothing we can do to help.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900