-
-
Notifications
You must be signed in to change notification settings - Fork 3.2k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Unable to Restore Backup #13561
Comments
[2023-09-02 10:28:02] production.ERROR: Array to string conversion {"userId":1,"exception":"[object] (ErrorException(code: 0): Array to string conversion at /home/fredons/public_html/asset/app/Console/Commands/RestoreFromBackup.php:221) Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fredons_asset.users' doesn't exist (SQL: select * from [previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fredons_asset.users' doesn't exist at /home/fredons/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368) |
I honestly have no idea what's going on here. The array to string conversion is confusing, but it's saying the users table is not found - which sort of makes sense, since it clears out the database of data and tables before it tries to restore, but I don't know what else is going on here. Is this only happening on GUI restore, or also command line? |
We have a problem with backup recovery too from about a week. Tooday I unzipped it and discoverd that all the core of SnipeIT is just SQL database (everything including settings etc.). Logically order schould bee completly inversely. |
@marcinBB8 in the SQL file, the order doesn't matter. mysqldump generally does it alphabetically. |
Debug mode
Describe the bug
Trying to restore a Backup causes 500.
Log in below post
Reproduction steps
...
Expected behavior
no error and restore
Screenshots
No response
Snipe-IT Version
v6.1.2 build 10938 (g32747cafd)
Operating System
ubuntu
Web Server
apache
PHP Version
8.1.22
Operating System
No response
Browser
No response
Version
No response
Device
No response
Operating System
No response
Browser
No response
Version
No response
Error messages
No response
Additional context
No response
The text was updated successfully, but these errors were encountered: