$wpdb->insert query changes to SHOW COLUMNS query Output

Question

I am writing a query for inserting data in to database but when I am printing query at output it turns into "SHOW COLUMNS from tbl_name" query. I am writing below query . But it executes like shown in image

$table_name1 = $wpdb->prefix . 'fullcontact';
    $sql1=$wpdb->insert( $table_name1, array(
        'status' => $status,
        'request_id' => $req_id,
        'likelihood' => $likelihood,
        'photos' => $photos,
        'chats' => $chats,
        'websites' => $websites,
        'fullname' => $fullname,
        'familyname' => $familyname,
        'givenname' => $givenname,
        'organisation' => $organisation,
        'normalizedlocation' => $normalizedlocation,
        'city' => $city,
        'state' => $state,
        'country' => $country,
        'age' => $age,
        'agerange' => $agerange,
        'gender' => $gender,
        'locationgeneral' => $locationgeneral,
        'socialprofiles' => $socialprofiles,
        'scores' => $scores,
        'topics' => $topics
    ) );

    //exit( var_dump( $wpdb->last_query ) );
    $wpdb->show_errors();
    $wpdb->print_error($sql1);

Please elaborate on "printing query". What exactly are you doing and in what order? — Rarst
– Rarst, Commented Jun 6, 2017 at 7:55
$table_name1 = $wpdb->prefix . 'fullcontact'; $sql1=$wpdb->insert( $table_name1, array( 'status' => $status, 'request_id' => $req_id, 'likelihood' => $likelihood ) ); $wpdb->show_errors(); $wpdb->print_error($sql1); — compoholic
– compoholic, Commented Jun 6, 2017 at 8:56
i am printing this query by show_error() and print_error() function — compoholic
– compoholic, Commented Jun 6, 2017 at 8:56
I don't quite follow what you are trying to do there. Why explicit print_error() with result of your query? — Rarst
– Rarst, Commented Jun 6, 2017 at 9:05
can I mail you the pics plz ? I am hard stuck at this..it wud be kind if you help me. — compoholic
– compoholic, Commented Jun 6, 2017 at 9:10

Sumurai8 · Accepted Answer · 2017-07-20 09:27:31Z

5

For anyone else finding this question. Wordpress seems to do a SHOW FULL COLUMNS query before executing the INSERT query. If it determines that the INSERT query would fail/store bad data, for example because the given data types would not fit in the column, it does not execute the insert query at all and return false.

Check:

Have you filled all fields that can not be null and do not have a default value
Does the data type for every field match the data type in the database
Does the data passed to the function violate any constraints? A string cannot be longer than the maximum length of the field you are trying to put it into. An integer field has a minimum and maximum value. Unsigned integers cannot contain negative values.

answered Jul 20, 2017 at 9:27

Sumurai8

1514 bronze badges

Exactly.. I had did this in past and it worked..!

compoholic
– compoholic

2017-07-20 12:48:37 +00:00
Commented Jul 20, 2017 at 12:48
Appreciate this note, very helpful

Kender
– Kender

2023-02-13 18:13:10 +00:00
Commented Feb 13, 2023 at 18:13

Add a comment |

Roger Bücker · Accepted Answer · 2017-06-06 10:42:53Z

0

Just had the same Problem, the fix was i tried to add varchar longer than the database field can hold. When changed the DB it workled again

answered Jun 6, 2017 at 10:42

Roger Bücker

11

thank You but it did'nt worked for me..anything else please ?

compoholic
– compoholic

2017-06-06 11:08:58 +00:00
Commented Jun 6, 2017 at 11:08

Add a comment |

Stack Exchange Network

$wpdb->insert query changes to SHOW COLUMNS query Output

2 Answers 2

Your Answer

Hot Network Questions

$wpdb->insert query changes to SHOW COLUMNS query Output

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions