Branding 500 Error

[juluru06]

Can any one help me how to edit admin- Branding?

I am getting Server Error 500| Server Error

[welcome]

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

[sklycorp]

Can any one help me how to edit admin- Branding?

I am getting Server Error 500| Server Error

i got same error like this, i try to install/enable FileInfo extentions on my WHM cpanel, go to whm->Software->EasyApache4->php extentions and then search "fileinfo". enable it-preview-provision. done.
refreshing my browser and that issue its gone.
maybe if you use localhost, u can try to install fileinfo extentions, try this way https://www.php.net/manual/en/install.pecl.windows.php
hope helping, sorry if i wrong, thnks goodluck.

PHP: Installing a PHP extension on Windows - Manual

[efgait]

Got the same issue, every time when saving a branding change I get a 500 Error.
Version v5.3.7 - build 6587

Have you tried executing:

php artisan migrate

For me it fails with the following issue:

Migrating: 2019_04_06_060145_add_user_skin_setting

Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs (SQL: alter table users add skin varchar(191) null)

at /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
665| // If an exception occurs when attempting to run a query, we'll format the error
666| // message to include the bindings with SQL, which will make this exception a
667| // lot more helpful to the developer instead of just the database's errors.
668| catch (Exception $e) {

669| throw new QueryException(
670| $query, $this->prepareBindings($bindings), $e
671| );
672| }
673|

Exception trace:

1 Doctrine\DBAL\Driver\PDO\Exception::("SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs")
/var/www/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

2 Doctrine\DBAL\Driver\PDO\Exception::new()
/var/www/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:114

3 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs")
/var/www/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112

[efgait]

With debugging turned on I get the following additional details:

Illuminate\Database\QueryException thrown with message "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'allow_user_skin' in 'field list' (SQL: update settings set site_name = mySite, brand = 1, skin = blue, allow_user_skin = ?, settings.updated_at = 2022-01-22 12:05:51 where id = 1)"

Stacktrace:
#73 Illuminate\Database\QueryException in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
#72 Doctrine\DBAL\Driver\PDO\Exception in /var/www/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
#71 Doctrine\DBAL\Driver\PDO\Exception:new in /var/www/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:84
#70 PDOException in /var/www/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79
#69 PDO:prepare in /var/www/snipeit/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79
#68 Doctrine\DBAL\Driver\PDOConnection:prepare in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:484
#67 Illuminate\Database\Connection:Illuminate\Database{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:662
#66 Illuminate\Database\Connection:runQueryCallback in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:629
#65 Illuminate\Database\Connection:run in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:495
#64 Illuminate\Database\Connection:affectingStatement in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:428
#63 Illuminate\Database\Connection:update in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2736
#62 Illuminate\Database\Query\Builder:update in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:799
#61 Illuminate\Database\Eloquent\Builder:update in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:746
#60 Illuminate\Database\Eloquent\Model:performUpdate in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:661
#59 Illuminate\Database\Eloquent\Model:save in /var/www/snipeit/app/Http/Controllers/SettingsController.php:475
#58 App\Http\Controllers\SettingsController:postBranding in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#57 Illuminate\Routing\Controller:callAction in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
#56 Illuminate\Routing\ControllerDispatcher:dispatch in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
#55 Illuminate\Routing\Route:runController in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
#54 Illuminate\Routing\Route:run in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:681
#53 Illuminate\Routing\Router:Illuminate\Routing{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
#52 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckPermissions.php:26
#51 App\Http\Middleware\CheckPermissions:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#50 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php:43
#49 Illuminate\Auth\Middleware\Authenticate:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#48 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/AssetCountForSidebar.php:56
#47 App\Http\Middleware\AssetCountForSidebar:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#46 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/passport/src/Http/Middleware/CreateFreshApiToken.php:50
#45 Laravel\Passport\Http\Middleware\CreateFreshApiToken:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#44 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckForTwoFactor.php:53
#43 App\Http\Middleware\CheckForTwoFactor:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#42 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckLocale.php:37
#41 App\Http\Middleware\CheckLocale:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#40 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78
#39 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
#37 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#36 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67
#35 Illuminate\Cookie\Middleware\EncryptCookies:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#34 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
#33 Illuminate\Pipeline\Pipeline:then in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:683
#32 Illuminate\Routing\Router:runRouteWithinStack in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
#31 Illuminate\Routing\Router:runRoute in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:624
#30 Illuminate\Routing\Router:dispatchToRoute in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Routing/Router.php:613
#29 Illuminate\Routing\Router:dispatch in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:170
#28 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130
#27 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:67
#26 Barryvdh\Debugbar\Middleware\InjectDebugbar:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#25 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/PreventBackHistory.php:23
#24 App\Http\Middleware\PreventBackHistory:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#23 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/SecurityHeaders.php:26
#22 App\Http\Middleware\SecurityHeaders:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#21 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21
#20 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#19 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckForDebug.php:25
#18 App\Http\Middleware\CheckForDebug:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#17 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/CheckForSetup.php:26
#16 App\Http\Middleware\CheckForSetup:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#15 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/fideloper/proxy/src/TrustProxies.php:57
#14 Fideloper\Proxy\TrustProxies:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
#12 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#11 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
#10 Illuminate\Session\Middleware\StartSession:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#9 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:63
#8 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/app/Http/Middleware/NoSessionStore.php:27
#6 App\Http\Middleware\NoSessionStore:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#5 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/barryvdh/laravel-cors/src/HandlePreflight.php:29
#4 Barryvdh\Cors\HandlePreflight:handle in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171
#3 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105
#2 Illuminate\Pipeline\Pipeline:then in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:145
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /var/www/snipeit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:110
#0 Illuminate\Foundation\Http\Kernel:handle in /var/www/snipeit/public/index.php:58

[snipe]

This issue has been discussed several times here. It's a database configuration issue.

https://github.com/snipe/snipe-it/search?q=row+size+too+large&type=issues

#9974 (comment)
#9504 (comment)
https://snipe-it.readme.io/docs/installation-issues#sqlstate42000-syntax-error-or-access-violation-1118-row-size-too-large

[uberbrady]

For the 'row size too large' error, a fix might work for you here: https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/#converting-the-table-to-the-dynamic-row-format - specifically, run ALTER TABLE settings ROW_FORMAT=dynamic - then try and re-run migrations.

MariaDB KnowledgeBase

Troubleshooting Row Size Too Large Errors with InnoDB

Fixing "Row size too large (> 8126). Changing some columns to TEXT or BLOB may help."

[efgait]

Thanks @snipe and @uberbrady for your speedy response and input, I have been able to complete the migration successfully after changing the row format for a couple of tables as suggest ALTER TABLE settings ROW_FORMAT=dynamic;. Flowing which I am able again to save branding changes; no more 500 Error. 😃

@juluru06 sorry for hijacking your post, hope you too will be able to resolve your problem soon.