Integrity constraint violation: 1048 Column 'ip' cannot be null (SQL: insert into `users` (`name`, `steamid`, `avatar`, `token`, `ip`) - Phpmyadmin

Sloobotv2
February 3, 2021
172 views
0 votes
2 Answers

So i am trying to login to my site via steam api and this error pops up SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘ip’ cannot be null. SQL:

insert into `users` (`name`, `steamid`, `avatar`, `token`, `ip`)

i use laravel php7.0 and phpmyadmin on a ubuntu 16.04 server vmware

This is the structure of my database

And this is the users one where i have problems

If you could help me out it would be amazing thanks

code:

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `steamid` varchar(17) NOT NULL,
  `wagered` int(11) NOT NULL,
  `wags` int(11) NOT NULL,
  `wwags` int(11) NOT NULL,
  `deps` int(11) NOT NULL,
  `depamount` int(11) NOT NULL,
  `withs` int(11) NOT NULL,
  `withamount` int(11) NOT NULL,
  `can_withdraw` int(11) NOT NULL DEFAULT '0',
  `available` int(11) NOT NULL,
  `aff` varchar(17) NOT NULL,
  `affs` int(11) NOT NULL DEFAULT '0',
  `affamount` int(11) NOT NULL,
  `affcollected` int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `balance` int(11) NOT NULL,
  `rank` int(11) NOT NULL,
  `steam_level` int(11) DEFAULT '-1',
  `mute` int(11) NOT NULL,
  `ban` int(11) NOT NULL,
  `avatar` text NOT NULL,
  `dailygift` int(11) NOT NULL,
  `hourlygift` int(11) NOT NULL,
  `redeemed_code` text NOT NULL,
  `disabled_send` int(11) NOT NULL,
  `disabled_withdraw` int(11) NOT NULL,
  `token` varchar(128) NOT NULL,
  `last` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Answers

- tadman
- February 3, 2021 at 12:43 am
- 0 votes
0
The definition for this column is:
```
`ip` text NOT NULL,
```
Which is both egregiously huge, as TEXT is intended to support up to 64K of data, and also strictly "NOT NULL" which means it must be populated.

You probably want to alter it to be:
```
ip VARCHAR(255) NULL,
```
Which you can do with a Laravel migration.
Login or Signup to reply.

- Aaron_Actu
- February 3, 2021 at 12:44 am
- 0 votes
0
You must gives us more information and revelant code parts, you should avoid external links.

Nevertheless, with the informations in your post you do not have the value part in your request.
```
INSERT INTO `users` (`name`, `steamid`, `avatar`, `token`, `ip`)  VALUES ($name, $steamid, $avatar, $token, $ip);
```
because as mentionned in your SQL file you force your values to be non-null.
Login or Signup to reply.