I am not sure what is this error!

    #1292 - Truncated incorrect DOUBLE value: 
I don&#39;t have double value field or data!


I have wasted a whole hour trying to figure this out!

here is my query

    INSERT INTO call_managment_system.contact_numbers 
        (account_id, contact_number, contact_extension, main_number, created_by)
    SELECT
        ac.account_id,
        REPLACE(REPLACE(REPLACE(REPLACE(ta.phone_number, &#39;-&#39;, &#39;&#39;), &#39; &#39;, &#39;&#39;), &#39;)&#39;, &#39;&#39;),&#39;(&#39;,&#39;&#39;) AS Phone,
        IFNULL(ta.ext, &#39;&#39;) AS extention,
        &#39;1&#39; AS MainNumber,
        &#39;2&#39; AS created_by
    FROM 
        cvsnumbers AS ta
        INNER JOIN accounts AS ac ON ac.company_code = ta.company_code
    WHERE 
        LENGTH(REPLACE(REPLACE(REPLACE(REPLACE(ta.phone_number, &#39;-&#39;, &#39;&#39;), &#39; &#39;, &#39;&#39;), &#39;)&#39;, &#39;&#39;),&#39;(&#39;,&#39;&#39;) ) = 10




here is my show create table for the table which the results are going into

    CREATE TABLE `contact_numbers` ( &#160;
        `number_id` int(10) unsigned NOT NULL AUTO_INCREMENT, &#160;
        `account_id` int(10) unsigned NOT NULL DEFAULT &#39;0&#39;, &#160;
        `person_id` int(11) NOT NULL DEFAULT &#39;0&#39;, &#160;
        `contact_number` char(15) NOT NULL, &#160;
        `contact_extension` char(10) NOT NULL DEFAULT &#39;&#39;, &#160;
        `contact_type` enum(&#39;Primary&#39;,&#39;Direct&#39;,&#39;Cell&#39;,&#39;Fax&#39;,&#39;Home&#39;,&#39;Reception&#39;,&#39;Office&#39;,&#39;TollFree&#39;) NOT NULL DEFAULT &#39;Primary&#39;, &#160;
        `contact_link` enum(&#39;Account&#39;,&#39;PDM&#39;,&#39;Other&#39;) NOT NULL DEFAULT &#39;Account&#39;, &#160;
        `status` tinyint(1) NOT NULL DEFAULT &#39;1&#39; COMMENT &#39;0 = inactive, 1=active&#39;, 
       &#160;`main_number` tinyint(1) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;1 = main phone number&#39;, &#160;
        `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, &#160;
        `created_by` int(11) NOT NULL, &#160;
        `modified_on` datetime DEFAULT NULL, &#160;
        `modified_by` int(11) NOT NULL DEFAULT &#39;0&#39;, &#160;
        PRIMARY KEY (`number_id`), &#160;
        KEY `account_id` (`account_id`), &#160;
        KEY `person_id` (`person_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=534 DEFAULT CHARSET=utf8

All Mysql Error-1292 Solutions on Gang of Coders

Total of 1 Mysql Error-1292 Solutions

Error Code 1292 - Truncated incorrect DOUBLE value - Mysql