mysql - Err 1292 - Truncated incorrect DOUBLE value -



mysql - Err 1292 - Truncated incorrect DOUBLE value -

i have 2 tables:

old:

create table `users` ( `id` int(11) not null auto_increment, `crdate` int(11) default null, `fb_id` text, `email` varchar(64) default null, `fb_access_token` varchar(256) default null, `display_name` varchar(128) default null, `first_name` varchar(128) default null, `middle_name` varchar(128) default null, `last_name` varchar(128) default null, `gender` varchar(128) default null, `timezone` tinyint(4) default null, `locale` varchar(16) default null, `fb_profile_url` text, `balanced_id` text, `token` varchar(100) default null, `address_id` int(11) default null, `admin` tinyint(1) default '0', `zip` int(11) default null, primary key (`id`) ) engine=innodb default charset=latin1;

new:

create table if not exists `friendzy`.`users_new` ( `id` int(11) not null auto_increment, `email` varchar(64) null default null, `display_name` varchar(128) null default null, `first_name` varchar(128) null default null, `middle_name` varchar(128) null default null, `last_name` varchar(128) null default null, `gender` varchar(128) null default null, `redis_token` varchar(100) null default null, `admin` tinyint(1) null default '0', `api_token` varchar(255) null default null, `password` varchar(255) not null, `salt` varchar(255) not null, `enabled` tinyint(1) not null default '0', `last_login` timestamp null default null, `locked` tinyint(1) null default null, `expired` tinyint(1) not null default '0', `expired_at` timestamp null default null, `confirmation_token` varchar(255) null default null, `password_requested_at` timestamp null default null, `credentials_expired` tinyint(1) null default null, `credentials_expire_at` timestamp null default null, `created` timestamp not null default current_timestamp on update current_timestamp, `modified` timestamp null default null, `modified_by` varchar(255) null default null, `deleted_at` timestamp null default null, primary key (`id`)) engine = innodb auto_increment = 164 default character set = latin1;

and im trying yo re-create info old 1 new 1 sentence:

insert `users_new` (`id`, `email`, `display_name`, `first_name`, `middle_name`, `last_name`, `gender`, `redis_token`, `admin`, `api_token`, `password`, `salt`, `enabled`, `last_login`, `locked`, `expired`, `expired_at`, `confirmation_token`, `password_requested_at`, `credentials_expired`, `credentials_expire_at`, `created`, `modified`, `modified_by`, `deleted_at`) select `users`.`id`, `users`.`email`, `users`.`display_name`, `users`.`first_name`, `users`.`middle_name`, `users`.`last_name`, `users`.`gender`, if(`users`.`token`, `users`.`token`, md5(1)), `users`.`admin`, md5(1), md5(1), md5(1), 1, null, 0, 0, null, md5(1), null, 0, null, now(), now(), 'update script', null users;

but error:

[err] 1292 - truncated wrong double value: '4043a809f18ffc8be824064934797d3a'

this 1 of crappy errors gets thrown might not have actual problem. suggestion alter

if(`users`.`token`, `users`.`token`, md5(1))

to

coalesce(`users`.`token`, md5(1))

and see if doesn't prepare itself.

mysql sql insert

Comments

Post a Comment

Popular posts from this blog

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* -

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* - i've inherited doc publishing process takes docbook , builds html , pdf output, using apache fop both. project had been started, never completed. lots of tweaking, i've able of doc sets build (20+), except handful, , fail severe code 1 of these 2 conditions: "fo:flow" missing kid elements. required content model: marker* "fo:block" not valid kid of "fo:root" the xml output comes out of docbook , docbook-fop checks out well-formed. the fop error in 1 book, "endecagloss", example, points end of string: <fo:flow flow-name="xsl-region-body" start-indent="4pc" end-indent="0pt"/> here’s log output in case: [java] severe: javax.xml.transform.transformerexception: file:/scratch/publishing/hudson/jobs/build-main-endeca-documentation/workspace/serverdoc/w...
Read more

mediawiki - How do I insert tables inside infoboxes on Wikia pages? -

mediawiki - How do I insert tables inside infoboxes on Wikia pages? - i want insert tables in infoboxes. example, have proteinbox i've developed using infobox template (http://health-and-medicine.wikia.com/wiki/template:proteinbox), , fasta field big fit comfortably in proteinbox. hence collapsible table within box. this tried: {{infobox | row 1 = {| class = "mw-collapsible mw-collapsed wikitable" |- | <!-- table content --> |} }} your problem is, putting nested table within template. pipe characters ( | ) in table syntax collides pipe usage in templates. the commonly used hack around create template called template:! , containing pipe character, , utilize when need set tables, parser functions or other stuff using pipe characters, within templates. table (with every | replaced {{!}} ): {{{!}} {{!}}- {{!}} a1 {{!}} b1 {{!}}- {{!}} a2 {{!}} b2 {{!}}} ...the equivalent of {| |- | a1 | b1 |- | a2 | b2 |} furthermore, hav...
Read more

Local Service User Logged into Windows -

Local Service User Logged into Windows - i created windows service tracks app server user connected through load balancer. it retrieves user logged windows on machine, cross references active directory (ad) business relationship homecoming first name, lastly name , e-mail (for notification through website created project) there 1 scheme on network users remote system, vista system, reason returning values "local service" logged machine, it's weird , security guys impossible "local service" business relationship logged windows. here how user logged windows managementscope ms = new managementscope("\\\\.\\root\\cimv2"); objectquery query = new objectquery("select * win32_computersystem"); managementobjectsearcher searcher = new managementobjectsearcher(ms, query); foreach (managementobject mo in searcher.get()) { _username = mo["username"].tostring(); } // remove domain part username string[] usernameparts = _...
Read more