I try different way for insert data in custom table but is not work and there are not errors.

Sometimes is save, but most of the time is not.

I check around the web, but no solution is working for me.

my last method is: 

 

    $sql = $wpdb->prepare("INSERT INTO `$table_name` 
    (`name`, `email`, `phone`, `address`, `message`, `rq`, `url`) 
    values 
    (%s, %s, %s, %s, %s, %d, %s)",
    $name, $email, $phone, $address, $msg, 1, $url);
    
    $wpdb->query($sql);

I print $sql and paste on phpmyadmin SQL and save it, so the query doesn't have any problem, but still not save.

Why this happen? 

I already try with array and $wpdb->insert(), same problem.

**EDIT:**
**it is solved. it was an integer passed like string, thanks to everybody**