{"id":3058495,"date":"2012-09-20T10:36:30","date_gmt":"2012-09-20T10:36:30","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/wpdb-insert-problem-not-inserting-string\/"},"modified":"2016-08-20T15:48:38","modified_gmt":"2016-08-20T15:48:38","slug":"wpdb-insert-problem-not-inserting-string","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/wpdb-insert-problem-not-inserting-string\/","title":{"rendered":"$wpdb insert problem – not inserting string"},"content":{"rendered":"

I am trying to insert a new record into a table, and for the most part it’s working except for one string. Here’s my insert statement;<\/p>\n

$wpdb->insert($wpdb->uam_accessgroup_to_object, array('object_id' => $userID, 'object_type' => 'user', 'group_id' => $entry['7']), array('%s', '%d'));<\/code><\/p>\n

It’s creating a new record and inserting the correct values into ‘object_id’ and ‘group_id’, however ‘object_type’ which should be ‘user’ is saved in the db as ‘0’. The field type is varchar(255).<\/p>\n

Is there something wrong with my insert statement?<\/p>\n","protected":false},"template":"","class_list":["post-3058495","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/3058495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/3058495\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=3058495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}