Upgrade to 3.3 issue

[mattgann]

Upgrade to 3.3 issue Laravel log error Whoops, looks like something went wrong.

[2016-08-24 09:18:32] production.ERROR: exception 'Symfony\Component\Debug\Exception\FatalErrorException' with message 'Class 'MisterPhilip\MaintenanceMode\MaintenanceModeServiceProvider' not found' in C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\ProviderRepository.php:146 Stack trace:

0 {main}

[2016-08-24 09:18:35] production.ERROR: exception 'Symfony\Component\Debug\Exception\FatalErrorException' with message 'Class 'MisterPhilip\MaintenanceMode\MaintenanceModeServiceProvider' not found' in C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\ProviderRepository.php:146 Stack trace:

0 {main}

[2016-08-24 09:18:37] production.ERROR: exception 'Symfony\Component\Debug\Exception\FatalErrorException' with message 'Class 'MisterPhilip\MaintenanceMode\MaintenanceModeServiceProvider' not found' in C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\ProviderRepository.php:146 Stack trace:

0 {main}

[snipe]

Did you run composer install?

[mattgann]

This? Yes php composer.phar install --no-dev --prefer-source php composer.phar dump-autoload php artisan migrate php artisan config:clear

[mattgann]

OK nevermind I am new to IIS and was doing this wrong. so I created a bat file and put it in my wwwroot folder. bat file below::

@ECHO OFF PUSHD %~dp0

CD snipe-it

ECHO Updating Composer. Please wait... composer install --no-dev --prefer-source

ECHO. ECHO Clearing Composer cache. Please wait... composer dump-autoload

ECHO. ECHO Updating MySQL Databse. Please wait... php artisan migrate

ECHO. ECHO Clearing configuration cache. Please wait... php artisan config:clear

ECHO. ECHO Update complete. ECHO Press any key to exit... Pause >Nul

[mattgann]

Every time I upgrade the new database columns are not created for example just now I received this larval error: Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ldap_pw_sync' in 'field list' (SQL: update settings set updated_at = 2016-08-24 10:22:21, ldap_server_cert_ignore = , ldap_pw_sync = 1 where id = 1)' in C:\inetpub\wwwroot\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php:729 Stack trace:

At what point during upgrade should this have been created?

[snipe]

Did you run migrations?

[mattgann]

No I guess I have been missing an important step. where can I find the steps for that?

[mattgann]

I get this ? C:\inetpub\wwwroot\snipe-it>php artisan migrate

---

• Application In Production!     *

  ---

  Do you really wish to run this command? (yes/no) [no]:

  y

  [Illuminate\Database\QueryException] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_ad' (SQL: alter table settings add is_ad tinyint(1) not null default '0')

  [PDOException] SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_ad'

[snipe]

Looks like your migrations table is a little messed up :(

[snipe]

Can you show me the contents of your migrations table?

[mattgann]

I just wiped it and started over, the updates went fine. Just can't figure out what my base bind ldap string was