Torann/laravel-currency

SQLSTATE[01000]: Warning: 1265 Data truncated for column 'value' at row 1

kwab opened this issue · 1 comments

kwab commented

Using:

  • Laravel Framework version 4.2.11
  • PHP Version => 5.6.1 (on Windows)
  • MYSQL 5.6.21 (on Windows)
  • "torann/currency": "dev-master"

Resolved by converting value to a number on line 103

// Update each rate
foreach ($lines as $line)
{
   $code = substr($line, 4, 3);
   $value = substr($line, 11, 6) * 1.00; //force conversion to number

   if ($value)
        {
            $this->app['db']->table($this->table_name)
                ->where('code', $code)
                ->update(array(
                    'value'         => $value,
                    'updated_at'    => new \DateTime('now'),
                ));
        }
}

Added 5749a59