Backup: File could not be found!

Hi

There is a problem doing the restore in Settings / Maintenance / Backup / Restore. The message appears: "File could not be found!"

Both the platform that provided the backup file and the platform that will receive the backup file belong to version 3.0.3.8

I already checked the php.ini; System / Settings / Max File Size; and the database name is the same

Please, how to solve this?

Check both your OpenCart and PHP error logs. Check DIR_UPLOAD is correct in you config.php files and has the correct permissions.

Could also be an issue with your PHP settings.

Thank you, ADD Creative

This is the result of the log error: [Fri May 06 15:04:44.479332 2022] [php7:warn] [pid 14824] [client 127.0.0.1:55262] PHP Warning: POST Content-Length of 9609843 bytes exceeds the limit of 8388608 bytes in Unknown on line 0, referer: http://localhost/admin/index.php?route= ... qEVyGQZgSZ

Do you khow where is this configuration of the 8mb? I can not find it

I find it: .htaccess

Remove the #:
php_value upload_max_filesize 100M
php_value post_max_size 100M

Now I have the log message:

[Fri May 06 18:26:15.553654 2022] [php7:error] [pid 30182] [client 127.0.0.1:59608] PHP Fatal error: Uncaught Exception: Error: Table 'banco_dados_infousado.oc_affiliate' doesn't exist<br />Error No: 1146<br />TRUNCATE TABLE `oc_affiliate` in /var/www/html/system/library/db/mysqli.php:48\nStack trace:\n#0 /var/www/html/system/library/db.php(45): DB\\MySQLi->query('TRUNCATE TABLE ...')\n#1 /var/www/html/admin/controller/tool/backup.php(103): DB->query('TRUNCATE TABLE ...')\n#2 /var/www/html/system/engine/action.php(79): ControllerToolBackup->import()\n#3 /var/www/html/admin/controller/startup/router.php(26): Action->execute(Object(Registry), Array)\n#4 /var/www/html/system/engine/action.php(79): ControllerStartupRouter->index()\n#5 /var/www/html/system/engine/router.php(67): Action->execute(Object(Registry))\n#6 /var/www/html/system/engine/router.php(56): Router->execute(Object(Action))\n#7 /var/www/html/system/framework.php(169): Router->dispatch(Object(Action), Object(Action))\n#8 /var/www/html/system/startup.php(104): require_once('/var/www/html/s...')\n#9 /var/www/html/admin/index.php(19): start('admin')\n#10 {main}\n in /var/www/html/system/library/db/mysqli.php on line 48, referer: http://localhost/admin/index.php?route= ... nRFTsGdKDQ

There is no oc_affiliate table in 3.0.3.8. It looks like you are trying to restore an old version or it's left over from an upgrade.

The both are 3.0.3.8: VPN and localhost

The translation or friendly URL can make the system understand different versions?

No, you need to edit the backup SQL file to remove the tables that are no longer needed or add the missing tables to the database.

You could also try a different method of export and import, such as with phpMyAdmin or and extension.

ADD Creative,

I believe OpenCart native backup is not compatible with PHPMyADMIN. This message is the result.

Error
SQL query:
TRUNCATE TABLE `oc_address`
MySQL said: Documentation
#1046 - No database selected

On the OpenCart Brazil forum, admins recommend using PHPMyADMIN for the backup and not the OC native backup.

I have a white screen when accessing the site and I imagine the problem is "500". Apache settings were harmed for me in the trying to install Certbot.

If I delete the OC and install again, do I access the database again at screen 3/4? The directory of OC in Ubuntu 20.04 is /var/www/html

No it won't be compatible. You have to backup and restore using the same method. If you don't have access to the original database it won't help you.

Thank you very much. You helpd me a lot

This topic is finished because this specific subject has no way

Have you tried removing the oc_affiliate table from your backup (making a backup of the file first)? Have you tried adding the oc_affiliate table from version 2.x to your database?
https://github.com/opencart/opencart/bl ... ql#L40-L73

I didn't add or delete the tables because the backup is native OpenCart and PHPMyAdmin does not support OC backup file

The installation of PHPMyAdmin on the VPS server worked and read the database. Now it's time to try to import to localhost as a test. Then delete the VPS files and reinstall the OC