Opencart vqmod issue

Hi Guys,

I'm trying to move the openCart website one server to another and I get following error. I don't have much experience with Opencart but I'm sure, I'm copied all required file and folder and database. I also change all config files and delete inside of the /vqcache but when I tried to reach /admin or click add to cart button or search button I get following errors.

Warning: Packets out of order. Expected 0 received 80. Packet size=5526600 in /home/mydomain/public_html/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 7Warning: mysqli::__construct(): Error while reading greeting packet. PID=10778 in /home/mydomain/public_html/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 7Warning: mysqli::__construct(): (HY000/2006): MySQL server has gone away in /home/mydomain/public_html/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 7Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/mydomain/public_html/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 10Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/mydomain/public_html/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 10

Fatal error: Uncaught Exception: Error:
Error No: in /home/mydomain/public_html/vqmod/vqcache/vq2-system_library_db_mysqli.php:10 Stack trace: #0 /home/mydomain/public_html/storage/modification/system/library/db.php(36): DB\MySQLi->__construct('myserverIP', 'dbUser', 'passwd', 'spDb', 'port') #1 /home/mydomain/public_html/vqmod/vqcache/vq2-system_framework.php(80): DB->__construct('mysqli', 'myserverIP', 'dbUser', 'passwd', 'spDb', 'port') #2 /home/mydomain/public_html/vqmod/vqcache/vq2-system_startup.php(109): require_once('/home/mydom...') #3 /home/mydomain/public_html/index.php(23): start('catalog') #4 {main} thrown in /home/mydomain/public_html/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 10
How can I solve this issue?

Thanks in advance.

If you are after help, you will need to provide more information, such as the OpenCart version, PHP version, the extensions you are using.
viewtopic.php?t=200480

The errors suggests some issue connection to the database, so check your database credentials are all correct.

Follow these steps in order to solve your current issue:

Double-check that all files and folders from the old server have been copied over to the new one properly, including OpenCart installation configuration files which need updating for correct database credentials.
Clear any cached files by clearing out the contents of "/vqcache" folder on both servers to clear out cached files and ensure MySQL server runs normally; check that its settings match up on both.
Verify the database user credentials are correct and have enough privileges to access the database. If any modifications were performed using vQmod files, make sure they were copied over correctly to be compatible with the new server environment.
If the issue continues, attempt reinstalling or upgrading to the most up-to-date version of vQmod in order to resolve "Packets Out Of Order" and "MySQL Server Has Vanished" errors you are experiencing. By taking these steps you should be able to rectify them.

The Packets out of order bit is generally something of a red herring and it is the "MySQL server has gone away" bit that is a clue.

If you get the problem with the add to cart button then I guess the store front actually loads up, so likely a time out issue. Unfortunately, I don't think you will get an answer here as it will need to be looked into to find out where the problem is.

Rebuild modification cache.

The indication of packets being out of order is often misleading, while the real clue lies in the "MySQL server has gone away" aspect.

If you encounter issues specifically with the add to cart button, it suggests a potential timeout problem since the store front appears to load successfully. Unfortunately, finding the exact cause of the issue will require further investigation, and it may not be possible to obtain a definitive answer here. Identifying and resolving the problem will require a thorough examination to pinpoint the source.