DBStandardCommand::getTableSize(): Return value must be of type string

[abewartech]

php artisan db:audit

  Please Select feature which would you like to do: [SUMMARY]
  STANDARD ................................................................................................................... 0  
  CONSTRAINT ................................................................................................................. 1  
  SUMMARY .................................................................................................................... 2  
  TRACK ...................................................................................................................... 3  
❯ 0
0


   TypeError 

  Vcian\LaravelDBAuditor\Commands\DBStandardCommand::getTableSize(): Return value must be of type string, null returned

  at vendor\vcian\laravel-db-auditor\src\Traits\DBConnection.php:107
    103▕                     ORDER BY
    104▕                         (DATA_LENGTH + INDEX_LENGTH) DESC';
    105▕             $result = DB::select($query);
    106▕             if ($result) {
  ➜ 107▕                 return $result[0]->size;
    108▕             }
    109▕
    110▕         } catch (Exception $exception) {
    111▕             Log::error($exception->getMessage());

  1   vendor\vcian\laravel-db-auditor\src\Traits\Rules.php:31
      Vcian\LaravelDBAuditor\Commands\DBStandardCommand::getTableSize("report_sopbuntut")

  2   vendor\vcian\laravel-db-auditor\src\Commands\DBStandardCommand.php:32
      Vcian\LaravelDBAuditor\Commands\DBStandardCommand::tablesRule()

[vc-urvin]

Hi @abewartech,

Thank you for sharing this issue with us. We appreciate your patience. Our contributors will check and work on this in their free time.

We will update you as soon as we have a fix.

[koupisbean]

Referring to pull request #49

Hi,

I tried your fix locally and still it doesn't fix that.

The problem is in VIEWS, its trying to read size of view and it returns null.

The problem is in the same file you have tried to fix but on line 107, the fix should be something like:

return $result[0]->size ?? Constant::DASH;

Please look at this and try to fix it that others won't have the same problem.

@vc-dhavaljoshi @ruchit288

[vc-dhavaljoshi]

Hello @koupisbean

Thank you for sharing. we will look it and fix it. :)