REPLACE INTO tbl_lookup_vin (`vin`, `cleanMake`, `Make`, `MakeId`, `Manufacturer`, `ManufacturerId`, `cleanModel`, `Model`, `ModelID`, `ModelYear`, `NCSABodyType`, `cleanNCSAMake`, `NCSAMake`, `cleanNCSAModel`, `NCSAModel`, `Note`, `VehicleType`, `PlantCity`, `PlantCountry`, `PlantState`, `DriveType`, `user`) VALUES (:vin, :cleanMake, :Make, :MakeId, :Manufacturer, :ManufacturerId, :cleanModel, :Model, :ModelID, :ModelYear, :NCSABodyType, :cleanNCSAMake, :NCSAMake, :cleanNCSAModel, :NCSAModel, :Note, :VehicleType, :PlantCity, :PlantCountry, :PlantState, :DriveType, :user)
Array ( [vin] => 112HGS352FT500009 [cleanMake] => eager beaver [Make] => EAGER BEAVER [MakeId] => 6198 [Manufacturer] => GENERAL ENGINES CO., INC [ManufacturerId] => 15467 [cleanModel] => 25ghg s 35ghg 15gs 35ghg 20ss 35ghg 15gs3 35ghg 20ss 3 40ghg 15gs 40ghg 20ss 40ghg 15gs3 40ghg 20ss 3 50ghg 15gs 50ghg 20ss [Model] => 25GHG-S/35GHG-15GS/35GHG-20SS/35GHG-15GS3/35GHG-20SS-3/40GHG-15GS/40GHG-20SS/40GHG-15GS3/40GHG-20SS-3/50GHG-15GS/50GHG-20SS [ModelID] => 20762 [ModelYear] => 2015 [NCSABodyType] => Not Reported [cleanNCSAMake] => not reported [NCSAMake] => Not Reported [cleanNCSAModel] => not reported [NCSAModel] => Not Reported [Note] => 0= standard length , 2= 2ft 0" longer than standard etc and letters will represent shorter deck length i.e A= 1 ft 0" shorter, B = 2 ft shorter etc [VehicleType] => TRAILER [PlantCity] => THOROFARE [PlantCountry] => UNITED STATES (USA) [PlantState] => NEW JERSEY [DriveType] => Not Applicable [user] => 3 )
PDOException Object ( [message:protected] => SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'cleanModel' at row 1 [string:Exception:private] => [code:protected] => 22001 [file:protected] => /var/www/html/scripts/php/lib/Scrape.php [line:protected] => 419 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/html/scripts/php/lib/Scrape.php [line] => 419 [function] => execute [class] => PDOStatement [type] => -> ) [1] => Array ( [file] => /var/www/html/scripts/vinflat.php [line] => 74 [function] => InsertDb [class] => Scrape [type] => -> ) [2] => Array ( [file] => /var/www/html/vin.php [line] => 166 [args] => Array ( [0] => /var/www/html/scripts/vinflat.php ) [function] => include ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 22001 [1] => 1406 [2] => Data too long for column 'cleanModel' at row 1 ) )