Open jayavman opened 1 year ago
[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) [stacktrace]
"} [2023-09-02 10:28:16] production.ERROR: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fredons_asset.users' doesn't exist in /home/fredons/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368 Stack trace:
Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fredons_asset.users' doesn't exist (SQL: select * from users
where id
= 1 and users
.deleted_at
is null limit 1) in /home/fredons/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712
Stack trace:
[2023-09-02 10:28:16] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fredons_asset.users' doesn't exist (SQL: select from users
where id
= 1 and users
.deleted_at
is null limit 1) {"exception":"[object] (Illuminate\Database\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fredons_asset.users' doesn't exist (SQL: select from users
where id
= 1 and users
.deleted_at
is null limit 1) at /home/fredons/public_html/asset/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712)
[stacktrace]
[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) [stacktrace]
"}
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.). looking in code of backup i see that propably the problem is that it start recreating DB from Assets, licences, , later are fieldsets, companies, users and almost at the end are settings.
Logically order schould bee completly inversely. e.g. the importer requier models, fieldsets etc are created before importong assets, licences or consumables
@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